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
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.