Question
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
Hello,
Maybe you have tried to run the script multiple times and few tables are already existing.