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]"
