Question
Acel Solutions
IN
Last activity: 29 Aug 2018 15:02 EDT
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
Pegasystems Inc.
FR
Hello,
Maybe you have tried to run the script multiple times and few tables are already existing.
Acel Solutions
IN
@MarcLasserre_GCS - Thanks a Lot for your quick response.
Before Upgrading Data Schema I have performed the previous step i.e
Migrating Rules schema from TempDB to MainDB, and this I have performed twice as in first attempt i wasn't went successful.
So, if this could be the cause, then what could be the possible solution.
Regards
Harsh
Pegasystems Inc.
FR
You should always have a drop procedure to cleanup.
Pegasystems Inc.
US
What steps have you done up to this point? You need to run migrate script to migrate rules tables and data_admin table to new rules schema, run the upgrade of the new rules schema, run migrate script again to make rules schema objects and connections between rules and data schema and then finally the data schema upgrade. Assuming that you have done all of the previous steps successfully then we would need to see what you have set the properties to in setupDatabase.properties with regards to the rules and data schema names and also the database user that is running the upgrade. The log file with the error would also be helpful.
Acel Solutions
IN
Dear All
Thank you very much for your support and response, I have resolved the issue now its working fine.
Regards
Harsh
Updated: 29 Aug 2018 15:01 EDT
Pegasystems Inc.
US
Hey @Harsh_Kumar! That's great to hear! Could you share your resolution with us as it may help others who have the same question in the future?
Thanks!