Last activity: 29 Aug 2018 15:02 EDT
Upgrade Data Schema
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.