Question

3
Replies
36
Views
janakiram Member since 2015 17 posts
Incessant
Posted: April 3, 2020
Last activity: April 3, 2020

Error while running the migrate.bat file . upgrading from 7.2.2 to 8.3

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

Pega Customer Service 7.22 Case Management Government
Share this page LinkedIn