Getting javax.naming.NameNotFoundException error in Database element in 11.6

[smeegada1]

I am getting below error after upgrading CVP from 11.0.1 to 11.6.I have all JAR's as expected but not sure why we are getting this error.This error is from Database element.

error was: A built-in element encountered an exception of type com.audium.server.AudiumException.

There was a problem looking up the JNDI data source 'XXXXXX'.

The root cause was: javax.naming.NameNotFoundException: Name [XXXXX] is not bound in this Context. Unable to find [XXXX].

did anything change from 11.0.1 to 11.6?

Any help is really appreciated?

[janinegraves]

Did you copy the context.xml file from your previous system? It would have been in VXMLServer/Tomcat/conf/context.xml

And you'll need the JDBC jar file from VXMLServer/Tomcat/lib

However - be forewarned that if it's SQL Server - many people are having to switch to a different JDBC driver and hence modify the context.xml file

[smeegada1]

Thanks Janine, i have copied context.xml from my previous server to VXMLServer/Tomcat/conf/context.xml and jdbc41.jar to VXMLServer/Tomcat/lib and still have the problem.

Yes we are using SQL server - do you know what changes need to be done?

[rguvvala · Accepted solution]

Try by adding this factory=”org.apache.tomcat.jdbc.pool.DataSourceFactory in your existing context.xml.

If it still not working attach your context.xml here.

FYI , TOMCAT version changed from 11.0 to 11.6. 

[smeegada1]

Thanks a lot Raghu,I have updated factory as you mentioned and it did work .

From:-

• org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory

To:-

• org.apache.tomcat.jdbc.pool.DataSourceFactory

Was there any changes in rqICM_Variable element? It is failing as below error and not printing anything in Activity/Error logs to investigate.do you have any idea?

16:06:45.503,rqICM_Variables,enter,

16:06:45.550,rqICM_Variables,custom,doDecision,Publish to ICM Failed callGuid = XXXXXXX

16:06:45.550,rqICM_Variables,data,callvar1,XXXXXX

16:06:45.550,rqICM_Variables,data,callvar2,XXXXXX

16:06:45.550,rqICM_Variables,data,callvar3,XXXXX

16:06:45.550,rqICM_Variables,data,callvar4,

16:06:45.550,rqICM_Variables,data,callvar5,

16:06:45.550,rqICM_Variables,data,callvar6,

16:06:45.550,rqICM_Variables,data,callvar7,

16:06:45.550,rqICM_Variables,data,callvar8,

16:06:45.550,rqICM_Variables,data,callvar9,

16:06:45.550,rqICM_Variables,data,callvar10,

16:06:45.550,rqICM_Variables,data,FromExtVXML0,

16:06:45.550,rqICM_Variables,data,FromExtVXML1,

16:06:45.550,rqICM_Variables,data,FromExtVXML2,

16:06:45.550,rqICM_Variables,data,FromExtVXML3,

16:06:45.550,rqICM_Variables,data,caller_input,

16:06:45.550,rqICM_Variables,exit,error

[rguvvala]

Thanks for the confirmation on the DB element.

For the second issue, you may be getting a known defect: CSCvf68615.

Install the patch ES5 on 11.6 and ES-20 for 11.5 .

[smeegada1]

Thanks for responding.We are currently on CVP 11.6(1) ES=5 Build=74 which should have already fixed, right?

[rguvvala]

Yes it should be. If not open ,  please open a ticket with TAC .

[smeegada1]

Thanks Raghu, I have opened TAC.

[smeegada1]

We are seeing following issue/Error in DataBase element after 11.6 upgrade.

- If we restart DataBase server we are getting below error.Once Database server is backup application should work fine without any issues.We are connecting to same DB in our other application with Java code and it doesn't have any problem only with the applications using DataBase element.Once we restart CVP Service then it will start working.

Any help is appreciated.

The error was: A built-in element encountered an exception of type com.audium.server.AudiumException. The connection is closed. The root cause was: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
com.audium.server.AudiumException: A built-in element encountered an exception of type com.audium.server.AudiumException.
 at com.audium.server.voiceElement.ActionElementBase.service(ActionElementBase.java:416)
 at com.audium.server.controller.Controller.goToAction(Controller.java:4394)
 at com.audium.server.controller.Controller.goToElement(Controller.java:4030)
 at com.audium.server.controller.Controller.continueCall(Controller.java:3710)
 at com.audium.server.controller.Controller.doPost(Controller.java:1124)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522)
 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095)
 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)
 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1502)
 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1458)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.lang.Thread.run(Thread.java:745)
Caused by: com.audium.server.AudiumException: The connection is closed.
 at com.audium.server.action.database.DatabaseAction.doAction(DatabaseAction.java:367)
 at com.audium.server.voiceElement.ActionElementBase.service(ActionElementBase.java:390)
 ... 26 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:389)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:2175)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:606)
 at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126)
 at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
 at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
 at com.sun.proxy.$Proxy53.prepareStatement(Unknown Source)
 at com.audium.server.action.database.DatabaseAction.doAction(DatabaseAction.java:320)