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 19, 2016 - Updated December 26, 2016


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.