Error code 17447: OALL8 is in an inconsistent state: prod env
SummaryUser have suddenly started facing inconsistency errors caused by SQL exceptions. User cannot reproduce the issue but seeing this error frequently in logs.
Error Messagescom.pega.pegarules.pub.database.DatabaseException: Database-General There was a problem getting a list 17447 99999 OALL8 is in an inconsistent state From: (B8922ED2CF7E860938579F626AA1F5421) Caused by SQL Problems. Problem #1, SQLState 99999, Error code 17447: java.sql.SQLException: OALL8 is in an inconsistent state
Steps to ReproduceUnknown
Root CauseA third-party product issue.
User was using an outdated driver .
This exception "OALL8 is in an inconsistent state" is a generic exception that occurs in JDBC 10.1, 10.2, and 11.1.
It indicates that an internal inconsistency has been detected in the JDBC connection but it does not provide information on what caused the inconsistency.
This exception no longer occurs in JDBC 11.2.
ResolutionUser's environment was on Oracle Database 11g Enterprise Edition Release 126.96.36.199.0.
User is suggested to upgrade the JDBC driver to 11.2.
Published May 29, 2017 - Updated August 3, 2017