I would like a routine for ACTDIAG to check for all the "under the covers" stuff: sql triggers, functions, views, etc.
I recently spent a bunch of hours trying to diagnose a customer's issues with ACT only to discover that there were no views or functions in that database. No wonder Act was having trouble working as designed.
I also recently upgraded someone to 16.1 and got a schema update failure:
Rebuild sync table order 2014-06-03 17:38:34.627Rebuild table relation 2014-06-03 17:38:36.420
*********** Schema Update failed **************
*********** Exception message follows *********
TBL_SYSTABLEKEY_SYNC_TRI: Processing error occurred in Sync Trigger TBL_SYSTABLEKEY_SYNC_TRI, Table TBL_SYSTABLEKEY - No LUIDID value in CTL_SYNCTABLE.
The transaction ended in the trigger. The batch has been aborted.
Rebuild table keys for foreign keys2014-06-03 17:38:37.617
Keep in mind that Ben said this kind of stuff could be developed outside of the products update schedule.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.