Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Hector Melara (HectorM2364)
Rulesware LLC
Rulesware LLC
Rulesware LLC
SV
HectorM2364 Member since 2015 9 posts
Rulesware LLC
Posted: Jul 13, 2020
Last activity: Jun 14, 2021
Posted: 13 Jul 2020 18:02 EDT
Last activity: 14 Jun 2021 7:38 EDT
Closed
Solved

Activity - Code-.RecreateIndexesForClass returning error

Good day, I'm using PEGA Infinity 8.1.8 And I'm trying to use ACTIVITY "RecreateIndexesForClass ", However I'm receiving an error and I am getting error:

Problems were encountered when regenerating indexes--see log for details: code: <none> SQLState: <none> Message: <none>

I saw this post:

https://collaborate.pega.com/question/recreateindexesforclass-fails-while-running

And I would like to confirm if I will need to do same approach or any other advice.

Thank you in advance.

***Edited by Moderator: Pooja Gadige to add platform capability tag***
To see attachments, please log in.
Pega Customer Service for Financial Services 8.1
Case Management

Accepted Solution

Posted: 4 years ago
Updated: 3 years ago
Posted: 14 Jul 2020 0:24 EDT
Updated: 14 Jun 2021 7:38 EDT
Pavan Kalyan Kanaparthi (kanap2)
PEGA
Senior System Architect
Pegasystems Inc.
IN

I could reproduce the issue and from the logs, seems it could not acquire the lock for the class instances.

In the activity RecreateIndexesForClass, in the Obj-Open-By-Handle step, if I check Lock and ReleaseOnCommit, it's working fine.

Please find the below screenshot for more details.

RecreateIndexesForClass

To see attachments, please log in.

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

Pega Collaboration Center 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