Support Article
Error on creating a case after migrating application to Postgres
SA-84482
Summary
An application is migrated from DB2 instance to a Postgres instance. Errors do not occur while importing the application. However, an error occurs on creating a case.
Error Messages
pyCommitError:** ** Batch entry 0 WITH source as <SELECT QUERY>
ERROR: column source.departmenttotalrfiadvisorduration does not exist Hint: Perhaps you meant to reference the column "source.departmenttotalrfiadvisordurat".
Steps to Reproduce
Create a case.
Root Cause
A defect in Pegasystems’ code or rules. The column name is truncated in the merge statement.
Resolution
Apply HFix-55059.
Published October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.