Question

1
Replies
54
Views
mannl Member since 2013 1 post
PEGA
Posted: 3 years ago
Last activity: 3 years 1 month ago
Closed
Solved

Error while importing PegaKM_7.31

SUMMARY

Error while importing PegaKM_7.31 on Postgresql 9.6

ERROR MESSAGES

Encountered an issue applying DDL: CREATE INDEX pr_history_idx2 ON pega_data.pr_History ( "pxtimecreated" ASC, "pxobjclass" ASC ): Database-General Problem executing SQL to update database schema 0 42P07 ERROR: relation "pr_history_idx2" already exists DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: relation "pr_history_idx2" already exists | SQL Code: 0 | SQL State: 42P07 -- See the log for additional information.

STEPS TO REPRODUCE

Import PegaKM_7.31

ROOT CAUSE

Index creation failing while import.

***Edited by Moderator Marissa to update platform capability tags***

Pega Knowledge Reporting
Moderation Team has archived post
Share this page LinkedIn