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.
