Support Article
Unable to update or upgrade existing SQL Server to 7.2.2
SA-31629
Summary
Update existing 7.2.x system on MS SQL Server to Pega 7.2.2, however the below errors occur:
Error Messages
Call DDL Generation Upgrade Utility...
[java] 2016-12-14 11:37:46,099 ( install) INFO - Initializing properties with default values
[java] 2016-12-14 11:37:46,598 ( install) INFO - Setting default Entity Value for pega_enable_nologging = true
[java] 2016-12-14 11:37:46,598 ( install) INFO - Getting database metadata
[java] 2016-12-14 11:37:54,149 ( install) INFO - Reading views from schema "dbo"
[java] 2016-12-14 11:37:54,398 ( install) INFO - Reading procedures from schema "dbo"
[java] Exception in thread "main" java.lang.RuntimeException: Error during execution of upgrade on platform mssql using schemas rules, dbo
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenerator.java:1652)
[java] Caused by: com.pega.pegarules.data.ddl.DatabaseException: com.microsoft.sqlserver.jdbc.SQLServerException: The dependencies reported for entity "dbo.sp_upgraddiagrams" might not include references to all columns. This is either because the entity references an object that does not exist or because of an error in one or more statements in the entity. Before rerunning the query, ensure that there are no errors in the entity and that all objects referenced by the entity exist.
[java] at com.pega.pegarules.data.ddl.SchemaManager.<init>(SchemaManager.java:515)
[java] at com.pega.pegarules.data.ddl.SchemaManager.<init>(SchemaManager.java:706)
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.saveCurrentSchemaState(SchemaGenerator.java:570)
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenerator.java:1475)
[java] Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The dependencies reported for entity "dbo.sp_upgraddiagrams" might not include references to all columns. This is either because the entity references an object that does not exist or because of an error in one or more statements in the entity. Before rerunning the query, ensure that there are no errors in the entity and that all objects referenced by the entity exist.
[java] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
[java] at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:4965)
[java] at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1786)
[java] at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1039)
[java] at com.pega.pegarules.data.ddl.SchemaManager.getDependentTableforRoutines(SchemaManager.java:5563)
[java] at com.pega.pegarules.data.ddl.SchemaManager.readProcedures(SchemaManager.java:2425)
[java] at com.pega.pegarules.data.ddl.SchemaManager.createDatabaseJaxbObjectByIntrospection(SchemaManager.java:574)
[java] at com.pega.pegarules.data.ddl.SchemaManager.createDomDocumentFromDbIntrospection(SchemaManager.java:531)
[java] at com.pega.pegarules.data.ddl.SchemaManager.<init>(SchemaManager.java:511)
Steps to Reproduce
Running command line version of update.bat against SQL Server DB.
Root Cause
A defect or configuration issue in the operating environment.
The diagramming facility of MS/SQL interferes with the update process.
Resolution
Perform the following local-change:
Remove the diagramming feature from the database instance and restart the update.
Published December 26, 2016 - 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.