Support Article
Unable to Install PMF 7.2.on Pega 7.2 stack Tomcat 8 PostgresSQL
SA-30993
Summary
Issue in exporting Project Management Framework(PMF) 7.2 application product rule was exported from Pega 7.2.1 on PostgreSQL 9.1 database.
Error Messages
DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: syntax error at or near "]"
2016-12-01 15:39:42,355 [ PegaRULES-Batch-5] [ STANDARD] [ ] [ PegaRULES:07.10] (ternal.util.SchemaImporterTool) ERROR - Database-General Problem executing SQL to update database schema 0 42601 ERROR: syntax error at or near "]"
Position: 830
DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: syntax error at or near "]"
Position: 830
| SQL Code: 0 | SQL State: 42601
Steps to Reproduce
Import PMF product rule into Pega 7.2.1.
Root Cause
A defect in Pegasystems’ code generating extra [] in database schema script causing the issue.
Resolution
Apply HFix-30581.
Published January 2, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.