Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us