cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1741
Views
0
Helpful
7
Replies

CVP/ICM vxml app (sql select and insert) works on ucce 9, not in 11.6!

ilrobbby
Level 1
Level 1

Hello Community!

 

I've a simple vxml app that query a mssql db to check if a certain ANI has called today and, if false, it plays a message and makes an insert into db, if true, it doesn't plays message but route the call back to icm and do something else...

 

The flow works on ucce 9.1 (same actors in the infrastructure) but cannot works on CVP 11.6...

 

The first query is:

 

select COUNT(*) as num_rows_processed
from ANI_today_list
where ANI = {CallData.ANI} and DateTime = CONVERT(Date, getdate())


but I've tried also:


select COUNT(*) as num_rows_processed
from ANI_today_list
where ANI = {Data.Session.ANI} and DateTime = CONVERT(Date, getdate())

*where {Data.Session.ANI} is a variable defined and passed by icm;


Or:


select COUNT(*) as num_rows_processed
from ANI_today_list
where ANI = {CallData.ANI}


and:


select COUNT(*) as num_rows_processed
from ANI_today_list
where ANI = 3311564234


The error (element error) is always:


"A built-in element encountered an exception of type java.lang.NumberFormatException. The root cause was: java.lang.NumberFormatException: null"
(the complete output is in attached txt)

 
I've tried sql jdbc4.0 (the one that works on CVP 9.1), 4.1, 6.4jre7, nothing to do, same output in the error.log of application...


This is the Tomcat context.xml:


<Resource name="jdbc/cvpdb"
   auth="Container"

   factory="org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory"

   <!-- factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" -->


       <!-- Commented Factory cause error on Catalina logs -->

   type="javax.sql.DataSource"
   driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
   url="jdbc:sqlserver://10.31.196.126:1433;databaseName=cvpdb;user=******;password=********"
   />
</Context>


I've tried a telnet from cvp cmd prompt to dbs:1433 and connection was established...


Honestly, now, I don't know what I can try to verify again..!

 

Please, help me!

Bye,
Roberto.

 

7 Replies 7

Mukesh Singh
Level 1
Level 1

Hi,

 

looks like hitting Bug CSCvg20831.

Symptom:
After upgrading to CVP 11.6 and SQL 2014 SP2, JNDI database connection fails all SQL queries on CVP Call Studio script

Conditions:
CVP 11.6 upgrade with SQL 2014SP2

Workaround:
Change below settings in the VXML server.

Under "HKEY_LOCAL_MACHINE -> SOFTWARE -> Wow6432Node -> Apache Software Foundation -> Procrun 2.0 -> VXMLServer -> Parameters -> Java -> Options"

Add "-Djdk.tls.client.protocols=TLSv1.2"

 

regards,

Mukesh

Hi Mukesh,

 

thanks for your reply!

 

I'd seen this bug, but I'd thinked that my issue seems not relative to a problem of secure protocol...

 

But, I'm in a test environment and, If my boss allows me, I can try that change!

I'll let you know!

Hi Mukesh.

 

added option to the Options reg. key, restarted tomcat but, unfortunately that mod doesn't solve the problem. Same errors...

 

Thanks anyway!

Did id you resolve the issue?We upgraded to 11.6 and getting below error.Same code is working fine in 11.0.1 and we are using DataBase element.Application connecting to same DB with Java code is working and connecting to same DB using Database element having problem.

 

The error was: A built-in element encountered an exception of type com.audium.server.AudiumException. Connection reset by peer: socket write error The root cause was: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset by peer: socket write error

 

Anynhelp is appreciated.

You can go into the CVP server and perform the following

 

- Go to Cisco\CVP\VXMLServer\Tomcat\bin

- tomcat8w //ES//VXMLServer 

- This will open JVM settings

- Go to the Java Tab

- Scroll all the way down to the bottom of the page that has content in them

- Add the following "-Djdk.tls.client.protocols=TLSv1.2" Ensure you do not add the quotation in that.

You can go into the CVP server and perform the following

 

- Go to Cisco\CVP\VXMLServer\Tomcat\bin

- tomcat8w //ES//VXMLServer 

- This will open JVM settings

- Go to the Java Tab

- Scroll all the way down to the bottom of the page that has content in them

- Add the following "-Djdk.tls.client.protocols=TLSv1.2" Ensure you do not add the quotation in that.

 

- Restart the Cisco VXML Service

joebaumer
Level 1
Level 1

Try putting single quotes around the search string like this:

select COUNT(*) as NumCallsByANI 
from ANI_today_list
where ANI = '{CallData.ANI}' and DateTime = CONVERT(Date, getdate())

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: