Skip to main content

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.

 
Suggest Edit

Published December 26, 2016 - Updated October 8, 2020

Did you find this content helpful?

50% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega Community 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
Contact us