Question

6
Replies
263
Views
Close popover
Harsh Kumar (Harsh_Kumar)
Acel Solutions
Harsh Kumar
Acel Solutions
IN
Harsh_Kumar Member since 2016 15 posts
Acel Solutions
Posted: August 29, 2018
Last activity: August 29, 2018
Closed

Upgrade Data Schema

Dear Members

I am facing issue while Upgrading Data Schema, below are the steps:-

Step1: I have updated setupDatabse.properties file with valid values.

Note: Before performing above step all the Step I have followed and it has been successfully completed.

Step2: After setting up all the required values saved the file and run the process from Batch with the below command :-

CMD > “upgrade.bat –dataOnly true”

This will run the batch process after few minute m getting the issue after few minutes like below :-

[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: There is already an object named 'pc_index_flowref' in the database.

My queries is why this happen and what is the cause and how to fix.

I have tried by dropping the table then the same exception occurred with different Table.

Your valuable response is highly appriciated.

Thanks

Harsh

System Administration Installation and Deployment Upgrades Data Integration
Moderation Team has archived post