Support Article

Rule Search Index doesn't finish

SA-29354

Summary



The user starts indexing from the Pega menu option System > Settings > Search landing page. Although the process completes for Work and Data instances, it stops for Rules at around 65,000 records.

The search landing page and PegaRULES log file have no error reported.


Error Messages



Records of pxObjClass type Log-Cluster-FTSIndex in pr_log_cluster table show the following error:

caught exception during autocommit check


Steps to Reproduce

  1. Go to Search Landing page
  2. Select Rules Reindex


Root Cause



A defect in Pegasystems’ code or rules.

The indexing process adds rows to pr_log_cluster table as instances of Log-Cluster-FTSIndex when an error is encountered while indexing. These entries from the time when issue was reported reveal that indexing is failing due to "caught exception during autocommit check" error.

This error occurs when Pega returns a database Connection back to the jdbc connection pool once the current request processing is complete. Pega checks if auto commit is marked to the appropriate value before returning the connection back to the pool. This error occurs when it gets the auto commit value on a closed connection.

Resolution



Apply SE-29978. JVM needs to be restarted for the engine code change to take effect. The code now handles the Connection Closed Exception and removes the bad connection from the pool when appropriate.

Published October 19, 2016 - Updated November 2, 2016

Have a question? Get answers now.

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