Search This Blog

Tuesday, September 20, 2011

_Rollback_ tables

When the save process occurs in Config Builder:
  1. It creates a _ROLLBACK_basetable table to hold the contents of the basetable to capture all of the data in the basetable before modification.
  2. Deletes the records from the basetable for the feed.
  3. Inserts new records into the basetable for the feed.
  4. If step 3 is successful, it deletes the ­ROLLBACK_basetable table. 
  5. If step 3 is unsuccessful, it tells you "This grid cannot be saved. Roll back in process. See table..." this means, hey, dude, something’s whack, and I can’t save – check the ROLLBACK table. If you subsequently try to save, (without addressing the ROLLBACK table), it will fail, because it can’t create the rollback table in step 1 – it already exists. You are stuck until you address the rollback table(most of the time, by dropping the table).

See attached for example error.

No comments:

Post a Comment