Support Article
Upgrade to Pega 7.4 fails when generating DDL
SA-62750
Summary
Upgrade to Pega 7.4 fails when generating DDL.
Error Messages
Getting database metadata
[java] (install) INF
O - Reading views from schema "PEGA_DATA"
[java] Exception in thread "main" java.lang.RuntimeException: Error during
execution of upgrade on platform mssql using schemas PEGA_RULES, PEGA_DATA, PEGA
_DATA
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenera
tor.java:1569)
[java] Caused by: com.pega.pegarules.data.ddl.DatabaseException: com.micros
oft.sqlserver.jdbc.SQLServerException: Invalid column name 'CreateDate'.
[java] at com.pega.pegarules.data.ddl.SchemaManager.<init>(SchemaManage
r.java:439)
[java] at com.pega.pegarules.data.ddl.SchemaManager.<init>(SchemaManage
r.java:480)
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.saveCurrentSchema
State(SchemaGenerator.java:496)
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenera
tor.java:1395)
[java] Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid
column name 'CreateDate'.
Steps to Reproduce
Run generateDDL.
Root Cause
A defect or configuration issue in the operating environment.
A custom view was present in the data schema. This caused problems when generating the DDL.
Resolution
Make the following change to the operating environment:
- Drop the view
- Generate the DDL to complete the upgrade.
Published August 24, 2018 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.