Support Article
Indexing not running after upgrading to Oracle 12c
SA-46696
Summary
After migrating PegaRULES database to Oracle 12c indexing is not working.
Error Messages
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:757)
at com.pega.pegarules.data.internal.access.Opener.openData(Opener.java:406)
at com.pega.pegarules.data.internal.access.DatabaseImpl.open(DatabaseImpl.java:4575)
at com.pega.pegarules.data.internal.access.DatabaseImpl.open(DatabaseImpl.java:4410)
at com.pega.pegarules.search.internal.RuleIndexer.addToIndex(RuleIndexer.java:1491)
at com.pega.pegarules.search.internal.RuleIndexer.updateIndex(RuleIndexer.java:1381)
Steps to Reproduce
Recycle the JVM, and then after a few days, the indexing stops.
Root Cause
A defect or configuration issue in the operating environment.
There is a known issue with running Oracle 12c with an earlier version of the Oracle JDBC driver.
Resolution
Make the following change to the operating environment:
Update the Oracle JDBC driver version from 11.x to 12.x to match Oracle database version.
There is a known issue when running with newer versions of the Oracle JDBC driver on Unix where because of the way the driver uses entropy that can results in database connections being closed randomly.Oracle's recommendation for avoiding this issue is to set the following system property.
-Djava.security.egd=file:///dev/urandom
Published November 8, 2017 - 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.