Question

6
Replies
254
Views
Harsh_Kumar Member since 2016 15 posts
Acel Solutions
Posted: 2 years ago
Last activity: 2 years 1 month ago
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 Low-Code App Development Installation and Deployment Data Integration Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn