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

Indexing not running after upgrading to Oracle 12c



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

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 r
unning Oracle 12c with an earlier version of the Oracle JDBC driver.


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.

Published November 8, 2017 - 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