Question

3
Replies
36
Views
Janakiram Bonthala (janakiram)
Incessant

Incessant
IN
janakiram Member since 2015 17 posts
Incessant
Posted: April 3, 2020
Last activity: April 3, 2020
Posted: 3 Apr 2020 0:58 EDT
Last activity: 3 Apr 2020 9:53 EDT
Closed

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] )

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
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.