Eserver or Aserver will not reconnect to the SQL DB after a DB restart
Originally Published: 2009-03-24
Article Number
Applies To
SQL datastore
Issue
An exception similar to the following is appearing in the eserver/aserver debug log:
sirrus.da.exception.DataStoreException: SQLException : Code:08006;TextAn I/O
error occured while sending to the backend.
Cause
An exception similar to the following would appear in the server's debug logs.
20:44:55:960 [*] [APIClientProxy-0] - Thread requesting stream.
sirrus.da.exception.DataStoreException: SQLException : Code:08006;TextAn I/O error occured while sending to the backend
at
sirrus.da.sql.util.SQLEntityHelper.getUsers(SQLEntityHelper.java:669)
at
sirrus.da.sql.util.SQLConnectionImpl.searchUsers(SQLConnectionImpl.java:702)
sirrus.da.exception.DataStoreException: SQLException : Code:08006;TextAn I/O error occured while sending to the backend
at
sirrus.da.sql.util.SQLEntityHelper.getUsers(SQLEntityHelper.java:669)
at
sirrus.da.sql.util.SQLConnectionImpl.searchUsers(SQLConnectionImpl.java:702)
Resolution
cleartrust.data.sql.server.postgresql.databasefatalcodes :08006
Then restart your AxM server for the change to take effect.
Failed DB connection will then be removed from the DB connection pool as the error code above is encountered. It might take a few SQL queries for all failed DB connections to be flushed from the connection pool.
Related Articles
On RSA Via Lifecycle and Governance the aveksa_server start returns message: Cannot connect to the database, but the DB is up Number of Views On database startup for RSA Identity Governance and Lifecycle the following error is seen: CRS-2501: Resource 'ora.avdb.d… Number of Views Microsoft SQL Server Collectors can no longer connect to the SQL Server database after upgrade to Microsoft SQL Server 201… Number of Views RSA Identity Governance and Lifecycle error when using the IBM DB2 driver: "Unable to load database driver" Number of Views How to overcome database connection failure for Postgres DB collectors in RSA Via Lifecycle and Governance Number of Views
Trending Articles
Unable to login to RSA Authentication Manager Security Console as super admin Authentication Manager Administration Server with operations console service Fails to Start with "No config.xml Was Found"… Authentication Manager Security Console and Operations Console Inaccessible After Certificate Update RSA Authentication Manager Upgrade Process RSA SecurID Software Token Distribution to Android from RSA Authentication Manager 8.1
Don't see what you're looking for?
