Troubleshooting - Migration

Troubleshooting - Migration

Q1:Database Migration Issue

Description

Prolaborate schema error while trying to perform a backup via Prolaborate service manager. 

Resolution

- If you are getting this error, check the database table. 
- The Migration might not work properly if tables are added manually directly to the database. 

Troubleshooting steps

Step 1: Stop the Prolaborate service 
Step 2: Go to the Prolaborate logs folder - C:\Program Files (x86)\Prolaborate\Prolaborate Logs and delete the log files from all the folders 
Step 3: Go to the Prolaborate Service Management folder - C:\Program Files (x86)\Prolaborate\Prolaborate Logs\Service Management Logs and delete the log file. 
Step 4: Set the logging level to “info” in Prolaborate Service Management
Step 5: Try to take the backup in Prolaborate Management 
Step 6: Go back to the above folders again and share the log files that are created

Tags
schema error

Q2 We are considering migrating from MS SQL to Postgre. Regarding the t_diagram table, we need to decide whether the CHANGE TRACKING option should be turned on or off

 
 










Description

The customer wanted to migrate from MS SQL to Postgre and also enquired weather change tracing option in  t_diagrams table should made true or false

Troubleshooting steps

Please follow the mentioned steps below:

1. Turn off the 'Change Tracking' option.

2. Apply the necessary schema changes.

3. Turn the 'Change Tracking' option back on.


Note This approach should allow you to apply the schema changes without any interference. Moreover, it's important to note that this option does not impact Prolaborate or the Prolaborate Cloud Server (PCS).

Reference

#6708

Subject: CHANGE TRACKING mode turned on for t_diagram table

Department: Prolaborate Support

URL: https://desk.zoho.com/agent/sixthforcesolutions/prolaborate-support/tickets/details/759413000025188087


Tags

MsSql , change tracking

 


    • Related Articles

    • Troubleshooting – Database Migration Issue

      Description Prolaborate schema error while trying to perform a backup via Prolaborate service manager. Resolution - If you are getting this error, check the database table. - The Migration might not work properly if tables are added manually directly ...

    • Known Issues - Migration

      Q1: "Invalid License" or "License Missing" error after migrating Prolaborate to a new server Description The Prolaborate and Pro Cloud Server is migrated to a new Server setup. After logging into Prolaborate, an error message appears saying "Invalid ...

    • Troubleshooting - Repository Migration

      Q1:Cloud connection issue while trying to connect using Enterprise Architect Description The customer has reported database connection error while trying to connect to the cloud using Enterprise Architect. Resolution - End EA by clicking on 'Exit ...

    • Troubleshooting: Unexpected Error Occurred in Sections

      Description "Unexpected Error occurred" when configuring sections in Prolaborate. Possible Reason Unexpected errors may occur if the EA Schema is not executed properly in the EA database. First, we need to check the EA database tables to see whether ...

    • Troubleshooting - XML/XMI

      Q1:Error While adding Diagram image. Description Customer reported error while add an diagram image. Possible Reasons This reported issue may be related to the import of diagram images via XML while copying the diagrams Troubleshooting steps To ...