Support Article

Error code 17447: OALL8 is in an inconsistent state: prod env

SA-38667

Summary



User have suddenly started facing inconsistency errors caused by SQL exceptions. User cannot reproduce the issue but seeing this error frequently in logs.


Error Messages



com.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 Reproduce



Unknown


Root Cause



A 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.

Resolution



User's environment was on Oracle Database 11g Enterprise Edition Release 11.2.0.2.0.

User is suggested to upgrade the JDBC driver to 11.2.

Published May 29, 2017 - Updated August 3, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.