Background. Changes were made to some classes that resulted in one table being dropped and having to re-populated and for 5 other tables being added to the RPS mapping and having to be populated. The 'tableAlter' script was generated and executed. This contained:
- the commands to drop the original table
- the commands to define the revised table and its procedures as well as the definitions for the new tables and their procedures
The execution of this script meant that the JADE RPS database and SQL server database are now 'schema consistent' . Then the RPS node went into the extract phase creating the 'autoBulkInsert' script and extracting the information to be used to BULK INSERT the table information.
When the RPS node was restarted, the JADE RPS node and SQL server database were 'schema consistent', therefore the datapump started and processed data changes to the SQL server database. However, the two databases were NOT 'data consistent'.