Question

1
Replies
57
Views
Close popover
Sirisha Manne (mannl)
PEGA
Associate Architect - Test & Quality
Pegasystems Inc.
IN
mannl Member since 2013 1 post
PEGA
Posted: September 6, 2017
Last activity: July 19, 2018
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.