Hi,

we are upgrading the pega 7.2.2 to 8.3. we are getting the below error while running the migrate.bat file.

please help me if you have any idea on this.

[java]     at com.pega.pegarules.install.SQLLoaderInternal.readAndExecuteSQLStatements(SQLLoaderInternal.java:151)

     [java]     at com.pega.pegarules.install.SQLLoaderInternal.load(SQLLoaderInternal.java:110)

     [java]     at com.pega.pegarules.install.SQLLoader.loadInner(SQLLoader.java:98)

     [java]     at com.pega.pegarules.install.SQLLoader.load(SQLLoader.java:77)

     [java]     at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:65)

     [java] 2020-04-03 10:46:38,362 (                  SQLLoaderInternal) WARNING - Statement: CREATE INDEX rules.indexref_idx01

     [java] ON pegaRULES_1.pr_index_reference

     [java] (

     [java]     "pxRuleFamilyName" asc,"pxRuleClassName" asc,"pxInsIndexedKey" asc,"pxIndexPurpose" asc,"pxObjClass" asc

     [java] )

     [java] 2020-04-03 10:46:38,362 (                  SQLLoaderInternal) WARNING -

     [java] ********************************************************************************

     [java]

     [java] Encountered a SQL Exception, clean schema before running again.

     [java]

     [java] ********************************************************************************

     [java] Exception in thread "main" com.pega.pegarules.install.SQLLoaderException: Error executing SQL statements

     [java]     at com.pega.pegarules.install.SQLLoader.load(SQLLoader.java:80)

     [java]     at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:65)

     [java] Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '.'.

     [java]     at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)

     [java]     at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)

     [java]     at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792)

     [java]     at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)

     [java]     at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)

     [java]     at com.microsoft.sqlserver.jdbc.SQLServerCon

BUILD FAILED

D:\Pega_8_Extract\116466_Pega8.3_16102019\scripts\migrateSystem.xml:603: Java returned: 1

Total time: 51 seconds

Exiting with Error