0
We have a JAVA application where we connect to SAP HANA and get the data. Facing an issue of SAP Hana cancelling the connection as shown in the below IndexServer logs. And in the java application we have UI Tabs, hence multiple calls are happening. sometimes only few tabs are failing with below error and other tabs are success. Somehow the HANA has a limit of connections or so and not allowing for new connections.
On the java side we are getting the error as " com.sap.db.jdbc.exceptions.jdbc40.SQLNonTransientConnectionException: Connection to database server lost; check server and network status [System error: Socket closed]"
IndexServer Logs
18144]{-1}[-1/-1] 2018-09-19 10:41:01.335210 i SQLSessionCmd Connection.cc(08190) : cancel requested for 312203 (logical connection id is 312203) [10943]{-1}[-1/-1] 2018-09-19 10:41:01.335240 i SQLSessionCmd Connection.cc(08190) : cancel requested for 312202 (logical connection id is 312202) [14796]{-1}[-1/-1] 2018-09-19 10:41:01.335753 i SQLSessionCmd Connection.cc(08190) : cancel requested for 312201 (logical connection id is 312201) [18144]{-1}[-1/-1] 2018-09-19 10:41:03.384314 i SQLSessionCmd Connection.cc(08190) : cancel requested for 312198 (logical connection id is 312198)
We have a JAVA application where we connect to SAP HANA and get the data. Facing an issue of SAP Hana cancelling the connection as shown in the below IndexServer logs. And in the java application we have UI Tabs, hence multiple calls are happening. sometimes only few tabs are failing with below error and other tabs are success. Somehow the HANA has a limit of connections or so and not allowing for new connections.
On the java side we are getting the error as " com.sap.db.jdbc.exceptions.jdbc40.SQLNonTransientConnectionException: Connection to database server lost; check server and network status [System error: Socket closed]"
IndexServer Logs
18144]{-1}[-1/-1] 2018-09-19 10:41:01.335210 i SQLSessionCmd Connection.cc(08190) : cancel requested for 312203 (logical connection id is 312203) [10943]{-1}[-1/-1] 2018-09-19 10:41:01.335240 i SQLSessionCmd Connection.cc(08190) : cancel requested for 312202 (logical connection id is 312202) [14796]{-1}[-1/-1] 2018-09-19 10:41:01.335753 i SQLSessionCmd Connection.cc(08190) : cancel requested for 312201 (logical connection id is 312201) [18144]{-1}[-1/-1] 2018-09-19 10:41:03.384314 i SQLSessionCmd Connection.cc(08190) : cancel requested for 312198 (logical connection id is 312198)