Sequence of Scripts Execution
In Business Model Upload, if the option to Update the Database Schema with Model
Changes is set as No, or <runscriptsFlag>
is set as FALSE, you must execute the SQL scripts generated
during model upload in the exact sequence. This ensures the Infodom Schema is
consistent with the JSON Files persisted in the database.
The following table lists the execution Squence of Scripts.
Table 7-2 Sequence of Scripts Execution
| Action | Folder Name | Rollback Folder Name |
|---|---|---|
| Drop indexes | droppedindex | r_droppedindex |
| Drop foreign keys | alterdropfkey | r_ alterdropfkey |
| Drop primary keys | droppkey | r_droppkey |
| Drop tables | dropoldtable | r_dropoldtable |
| Create new tables | newtables | Droptable |
| Alter columns | altercolumn | r_altercolumn |
| Add primary keys | addpkey | r_addpkey |
| Add foreign keys | addfkey | r_addfkey |
| Add foreign keys for new tables | newfkeys | dropfkey |
| Create indexes | createdindexes | r_createdindexes |
Note:
The folders are available atftpshare/<INFODOM>/json/scripts/altertable
location.
You must execute the Rollback Scripts in case of failures in the reverse order. If the 4th step has caused roll back, then Rollback Scripts from 4 to 1 must be executed in sequence. Rollback Scripts are available in the same path with the file name prefixed with r_.