Support Article

Migrate script failing in 7.1.8

SA-11860

Summary



Upgrading to 7.1.8 split schema on SQL Server database. Running the migrate script to migrate the rules tables to a new schema and it is failing during setup.


Error Messages



BUILD FAILED
PEGA_7_SOFTWARE\114819_Pega718\scripts\migrateSystem.xml:501: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'null'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteCursored(SQLServerStatement.java:1853)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:749)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:611)
at com.pega.pegarules.util.anttasks.CheckForUncommittedHotfixes.execute(CheckForUncommittedHotfixes.java:43)


Steps to Reproduce



Run migrate script on sql server db

Root Cause



The root cause of this problem is software use/operation error.  The migrateSystem.properties file is not set correctly.  The property pega.move.admin.table is set to false when it needs to be set to true when migrating the rules tables to a new schema for upgrading.

Resolution



This issue is resolved by making the following change to the operating environment: 

Correct
pega.move.admin.table property in migrateSystem.properties and set its value to true and then run the migrate script again.

    pega.move.admin.table=true

 
Suggest Edit

Published July 6, 2015 - 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.