Unable to commit on external table

Hello All,

We have recently upgraded the platform from 7.3 to 8.4.2. Post upgrade we have identified below issue.

We are inserting records to external table non pega DB from Pega. The issue observed is the save and commit failing on external table but record is getting inserted.

We have observed the below error message along with other observation where we have tried to save the DB instance rule and found the issue that the primary keys of external table are not matching with class keys which is [RECORD_ID]

“The External handle is not valid A-B-C-Work”.

Appreciate your help

Thanks

Prem K

Edited by Moderator: Pallavi to change content type from Discussion to Question

Hello,

Do you mind sharing a log file? Can you see this error on your PegaRULES logs?

Is the class key the primary key of the table?

The issue is resolved. By Pass History is selected as “True” on Advanced tab of class rule form. Post upgrade it is set to “false” which causing the issue since we are not writing history data of external table classes.

Thanks

Prem K