Support Article
Index update failed because of a database problem
SA-20792
Summary
User is getting the below exception in the PegaRULES log file:
2016-02-19 21:25:02,159 [.PRPCWorkManager : 3] [ STANDARD] [ PegaRULES:07.10] ( search.internal.RuleIndexer) ERROR - Index update failed because of a database problem - Database-General There was a problem opening a database instance RULE-HTML-SECTION ORG-FW-TESTFW-DATA-MYCLASS TESTSECTION #20151125T100351.124 GMT 17002 08006 IO Error: Size Data Unit (SDU) mismatch
Error Messages
2016-02-19 21:25:02,159 [.PRPCWorkManager : 3] [ STANDARD] [ PegaRULES:07.10] ( internal.access.Opener) ERROR - There was a problem opening a database instance RULE-HTML-SECTION ORG-FW-TESTFW-DATA-MYCLASS TESTSECTION #20151125T100351.124 GMT
com.pega.pegarules.pub.database.ConnectionException: Database-General There was a problem opening a database instance RULE-HTML-SECTION ORG-FW-TESTFW-DATA-MYCLASS TESTSECTION #20151125T100351.124 GMT 17002 08006 IO Error: Size Data Unit (SDU) mismatch
From: (B8E223FA24F1180131C6FA55658AD9DA0)
SQL: select pzPVStream from <rule schema>.pr4_rule where pzInsKey = ?
SQL Inserts: <RULE-HTML-SECTION ORG-FW-TESTFW-DATA-MYCLASS TESTSECTION #20151125T100351.124 GMT>
Caused by SQL Problems.
Problem #1, SQLState 08006, Error code 17002: java.sql.SQLRecoverableException: IO Error: Size Data Unit (SDU) mismatch
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:163)
at com.pega.pegarules.data.internal.access.Opener.openData(Opener.java:816)
at com.pega.pegarules.data.internal.access.Opener.openData(Opener.java:413)
at com.pega.pegarules.data.internal.access.DatabaseImpl.open(DatabaseImpl.java:4693)
at com.pega.pegarules.data.internal.access.DatabaseImpl.open(DatabaseImpl.java:4511)
at com.pega.pegarules.search.internal.RuleIndexer.addToIndex(RuleIndexer.java:1689)
at com.pega.pegarules.search.internal.RuleIndexer.updateIndex(RuleIndexer.java:1509)
at com.pega.pegarules.search.internal.RuleIndexer.updateIndex(RuleIndexer.java:1342)
at com.pega.pegarules.session.internal.mgmt.Executable.updateIndex(Executable.java:7189)
at com.pegarules.generated.activity.ra_action_systemindexer_e9bb95a86a643fb648babf3085010547.step2_circum0(ra_action_systemindexer_e9bb95a86a643fb648babf3085010547.java:364)
at com.pegarules.generated.activity.ra_action_systemindexer_e9bb95a86a643fb648babf3085010547.perform(ra_action_systemindexer_e9bb95a86a643fb648babf3085010547.java:86)
2016-02-19 21:25:02,159 [.PRPCWorkManager : 3] [ STANDARD] [ PegaRULES:07.10] ( search.internal.RuleIndexer) ERROR - Index update failed because of a database problem - Database-General There was a problem opening a database instance RULE-HTML-SECTION ORG-FW-TESTFW-DATA-MYCLASS TESTSECTION #20151125T100351.124 GMT 17002 08006 IO Error: Size Data Unit (SDU) mismatch
Steps to Reproduce
Issue is sporadic in nature.
Root Cause
A defect or configuration issue in the user's operating environment is identified as the root cause of the reported error.
Using incompatible or older database driver versions with Oracle 12c database can cause such errors.
Resolution
Make the following change to the operating environment:
Use a compatible database driver version (ojdbc7) or higher with Oracle 12c Database.
Published March 12, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.