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

 Sirisha Manne (mannl) Associate Architect - Test & Quality
Pegasystems Inc.
IN
mannl Member since 2013 1 post
Posted: Sep 6, 2017
Last activity: Jul 19, 2018
Posted: 6 Sep 2017 5:23 EDT
Last activity: 19 Jul 2018 15:21 EDT
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***

To see attachments, please log in.
Pega Knowledge
Reporting

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