Customer is facing an issue with the applicaiton develop in DD 5... Please find the snap shot from the application log below:

03/07/2012 13:00:20:793 INFO - 8EBCAFFF6A9E3150A6C4825AB7D7C654:/HMC_Appointment_Reminder : Capturing exception [javax.servlet.ServletException]. Message [ EXCEPTION>
com.microsoft.sqlserver.jdbc.SQLServerException: Connection timed out
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1352)
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1339)
   at com.microsoft.sqlserver.jdbc.TDSChannel.write(IOBuffer.java:1670)
   at com.microsoft.sqlserver.jdbc.TDSWriter.flush(IOBuffer.java:2486)
   at com.microsoft.sqlserver.jdbc.TDSWriter.writePacket(IOBuffer.java:2388)
   at com.microsoft.sqlserver.jdbc.TDSWriter.endMessage(IOBuffer.java:1995)
   at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:4992)
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
   at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)
   at com.avaya.sce.runtime.connectivity.db.DbQuery.executeStatement(DbQuery.java:294)
   at com.avaya.sce.runtime.connectivity.db.DbQuery.executeSQL(DbQuery.java:197)
   at com.avaya.sce.runtime.connectivity.db.DbQuery.execute(DbQuery.java:133)
   at com.avaya.sce.runtime.Data.evaluateActions(Data.java:165)
   at flow.SetData.executeDataActions(SetData.java:123)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:81)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:266)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1272)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:266)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
   at java.lang.Thread.run(Thread.java:662)
]
03/07/2012 13:00:20:794 ERROR - 8EBCAFFF6A9E3150A6C4825AB7D7C654:/HMC_Appointment_Reminder : session id:HMGOYAVP-2012185100009-16 | Error processing request
EXCEPTION>
java.lang.Exception: javax.servlet.ServletException: EXCEPTION>
com.microsoft.sqlserver.jdbc.SQLServerException: Connection timed out
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1352)
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1339)
   at com.microsoft.sqlserver.jdbc.TDSChannel.write(IOBuffer.java:1670)
   at com.microsoft.sqlserver.jdbc.TDSWriter.flush(IOBuffer.java:2486)
   at com.microsoft.sqlserver.jdbc.TDSWriter.writePacket(IOBuffer.java:2388)
   at com.microsoft.sqlserver.jdbc.TDSWriter.endMessage(IOBuffer.java:1995)
   at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:4992)
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
   at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)
   at com.avaya.sce.runtime.connectivity.db.DbQuery.executeStatement(DbQuery.java:294)
   at com.avaya.sce.runtime.connectivity.db.DbQuery.executeSQL(DbQuery.java:197)
   at com.avaya.sce.runtime.connectivity.db.DbQuery.execute(DbQuery.java:133)
   at com.avaya.sce.runtime.Data.evaluateActions(Data.java:165)
   at flow.SetData.executeDataActions(SetData.java:123)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:81)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:266)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1272)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:266)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
   at java.lang.Thread.run(Thread.java:662)

   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:112)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:266)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1272)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:266)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
   at java.lang.Thread.run(Thread.java:662)
Caused by: javax.servlet.ServletException: EXCEPTION>
com.microsoft.sqlserver.jdbc.SQLServerException: Connection timed out
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1352)
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1339)
   at com.microsoft.sqlserver.jdbc.TDSChannel.write(IOBuffer.java:1670)
   at com.microsoft.sqlserver.jdbc.TDSWriter.flush(IOBuffer.java:2486)
   at com.microsoft.sqlserver.jdbc.TDSWriter.writePacket(IOBuffer.java:2388)
   at com.microsoft.sqlserver.jdbc.TDSWriter.endMessage(IOBuffer.java:1995)
   at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:4992)
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
   at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)
   at com.avaya.sce.runtime.connectivity.db.DbQuery.executeStatement(DbQuery.java:294)
   at com.avaya.sce.runtime.connectivity.db.DbQuery.executeSQL(DbQuery.java:197)
   at com.avaya.sce.runtime.connectivity.db.DbQuery.execute(DbQuery.java:133)
   at com.avaya.sce.runtime.Data.evaluateActions(Data.java:165)
   at flow.SetData.executeDataActions(SetData.java:123)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:81)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:266)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1272)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:266)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
   at java.lang.Thread.run(Thread.java:662)

   at com.avaya.sce.runtime.Data.handleRequest(Data.java:91)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   ... 30 more

Joshi, we need trace.log file. Can you find any log in the app's data/logs/trace.log file? Try to change the settings as the following in the data/logs/ddrt.properties to capture more data in the trace.log:

localddtrace=enabled
localapptrace=enabled
showxml=enabled

Hello Michael,

I have uploaded the application and catalina logs at FTP location:

/incoming/guests/ITACsupport/Krishan/1-3638584372

Please find the FTP details below:
ftp://ftp.avaya.com
login: ITACsupport
password: ITAC4me

I checked the logs. It seems that the connection to the database was broken all of the sudden. I think it was caused by network issue. I can't find other causes in the logs.

Hello Wilson,
Thanks for your response, From the logs i can also see the following exception :

[javax.servlet.ServletException]. Message [ EXCEPTION>
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ''.

Do you think this also is caused by Network down, or is this a application related issue ... Please confirm.

03/07/2012 13:00:22:728 INFO - 191EDA3B01D09103EC4B8FF625FD9B6F:/HMC_Appointment_Reminder : Assigning [AM] to [General:AppAMPM]
03/07/2012 13:00:22:728 INFO - 191EDA3B01D09103EC4B8FF625FD9B6F:/HMC_Appointment_Reminder : Assigning [A] to [General:StatusInDB]
03/07/2012 13:00:22:728 DEBUG - 191EDA3B01D09103EC4B8FF625FD9B6F:/HMC_Appointment_Reminder : Executing DB statement : [UPDATE dbo.TAB_AppointmentConfirmation SET Status = ? WHERE ( TAB_AppointmentConfirmation.AppointmentNo = ? )]
03/07/2012 13:00:22:735 INFO - 191EDA3B01D09103EC4B8FF625FD9B6F:/HMC_Appointment_Reminder : Capturing exception [javax.servlet.ServletException]. Message [ EXCEPTION>
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ''.
   at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
   at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)
   at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2529)
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1905)
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
   at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1893)
   at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1045)
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
   at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
   at java.sql.DriverManager.getConnection(DriverManager.java:582)
   at java.sql.DriverManager.getConnection(DriverManager.java:185)
   at org.apache.tomcat.dbcp.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:177)
   at org.apache.tomcat.dbcp.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:132)
   at org.apache.tomcat.dbcp.dbcp.datasources.InstanceKeyDataSource.testCPDS(InstanceKeyDataSource.java:749)
   at org.apache.tomcat.dbcp.dbcp.datasources.PerUserPoolDataSource.registerPool(PerUserPoolDataSource.java:460)
   at org.apache.tomcat.dbcp.dbcp.datasources.PerUserPoolDataSource.getPooledConnectionAndInfo(PerUserPoolDataSource.java:373)
   at org.apache.tomcat.dbcp.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:669)
   at org.apache.tomcat.dbcp.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:653)
   at com.avaya.sce.runtime.jdbc.Database.open(Database.java:61)
   at com.avaya.sce.runtime.jdbc.Database.open(Database.java:99)
   at com.avaya.sce.runtime.connectivity.db.DbQuery.executeSQL(DbQuery.java:190)
   at com.avaya.sce.runtime.connectivity.db.DbQuery.execute(DbQuery.java:133)
   at com.avaya.sce.runtime.Data.evaluateActions(Data.java:165)
   at flow.SetData.executeDataActions(SetData.java:123)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:81)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:266)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1272)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:266)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
   at java.lang.Thread.run(Thread.java:662)
]

It's caused by same network issue. It had problem creating a connection.

Hello Wilson,

Customer further have following concerns to isolate the cause of this issue further..

1.   If it's a network issue, why isn't rectified when the network is UP? During the period when the problem persists, there is network connectivity and we can successfully connect to database from IVR machine using database client software.
2.   Why is userID passed as '' or NULL from Dialog Designer application?
3.   Why is it resolved after a reboot of Application Server?

could you please help me to clarify further concerns of customer.

thanks!

Actaully the main reason why BP is expecting some other issues apart from network, since as per them :

Customer has a very stable network. And if we assume there was some network intervention. The Application should work normally when the network is stable again. The scenario is when the issue happens , we find the network to be perfect and the only issue we find is that the application is unable to connect to database. And strangely the issue is resolved by a restart (so it's sure network has nothing to do with it)...

Could you please help further to identify further.... Thanks!

Krishan,

This does not seem to an issue with the app.

Refer to the below thread and suggest those settings to the customer.
https://devconnect.avaya.com/public/forum/d_forum_3.jsp?t=8432&f=6

Since this is MS SQL, you can also have the customer to refer the below settings as well

http://support.microsoft.com/kb/313225

http://connect.microsoft.com/SQLServer/feedback/details/676337/com-microsoft-sqlserver-jdbc-sqlserverexception-connection-reset

====================
Posted by Microsoft on 19/09/2011 at 17:54
Also, when connecting to SQL Azure, idle connections may be terminated by a network component (such as a firewall) after a period of inactivity. To avoid dropping idle connections by a network component, the following registry settings (or their non-Windows equivalents) should be set on the operating system where the driver is loaded:

Registry Setting Recommended value
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\KeepAliveTime 30000 (30 seconds)
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\KeepAliveInterval 1000 (1 second)
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\TcpMaxDataRetransmission 10

For your reference, the non-windows equivalents can be found at http://www.starquest.com/Supportdocs/techStarLicense/SL002_TCPKeepAlive.shtml

Hello Poornima,

Thanks for your post!

You mention, this is not a issue related to app, i checked the post reference you made, but these post talks more about the settings in the SQLServer...

Can you confirm that, this issues are something related to the configuration at SQLServer...

Thanks!

Poornima, thanks for helping.

Krishan,

if network is not the issue, you would have to look into the sql server stability. The sql server might got overwhelmed. Nothing in the app suggests problem. As to your question why the connection can only be re-established after restarting the app server, you have to look into the extra configuration on the app server as suggested in the post as Poornima pointed out.

https://devconnect.avaya.com/public/forum/d_forum_3.jsp?t=8432&f=6

Ignore the error UserID null error. It is caused by 2nd attempt that DD tried when the first one failed with the user and password.