Troubleshooting

• Transactions. Each use case – Transfer Out, Transfer In, Merge Data Dictionary – runs as a single database transaction. This means that if any transfer operation fails for any reason (such as missing or locked data transfer file), the database will roll back all database changes made up to this moment. The system administrator can then correct the problem and start the transfer operation from the beginning. If the database rollback itself fails, the recommended action is to restore the database from backup. Schema Change Wizard job runs SQL commands that manipulates schema structure. Those SQL commands cannot be rolled back.
• Re-create Structures. Executes commands from a SQL file line by line. If an SQL command fails, you will see it in the \WEB-INF\config\archibus.log file. You can open the specific SQL file and edit it. Then, run the process again.

• Decreasing the size of unique keys. Suppose you want to change the size of a unique key, such as ac_id, from 32 to 16. Since the Schema Change Wizard allows truncating of unique keys, the operation succeeds but the wizard generates errors of duplicate keys in the log file. The result is the corruption of primary keys, making them unusable. In a situation such as this, you will need to export the data in the table, then delete the data in the table.