Hi,
Our one of the ARIS Server is having a issue. After every 1 or 2 weeks the users are not able to log on to any of the databases hosted on the ARIS server. It says "Incorrect User Name or Password". We can add the server is ARIS BA, but cannot log in to any of the databases. The database server we use is MS SQL server which is hosted on some different machine. The database login is authenticated using LDAP server. So after every 1 or 2 weeks we had to restart ARIS service.
When we investigated the issue from the server logs, it shows an internal error saying "The connection was closed". Snapshot of the error
"com.idsscheer.aris.server.CannotBe - cannot be
com.idsscheer.aris.server.arisldap.AExternalIdentityServiceFactory.createExternalIdentityServiceAccess
DLException: Invalid state, the Connection object is closed."
Restarting the ARIS server service solves the problem. Does anyone knows what could be the cause for the Connection closed, and what kind of connection is getting closed?
Hi Amol,
We had this issue with Oracle. For that reason we use to restart the server everyday at the morning by a scheduled task. In our new setup with MS-SQL server it happened once in one month of operation.
I was advised it is because ARIS does tend to create lots of cache which puts the memory usage to 98% or more and as a result the server refuses connection.
Probably the best solution is to put a scheduled task to restart the server sometime when the user is not connected.
Any other solution from ARIS community I would love to hear.
Abhijit Das
Hi Abhijit,
This can be done, but some of our servers are accessed globally, so it is difficult to find out the time when the server could be free, and moreover, on some identified less load times we have automated processes running on server. So restarting the server once a week is not much of good for us.
Investigating the cache and the memory for the connection is something we should look.
Thanks,
Amol Patil
