Situation: some SQL views were discovered to be missing from a database
Proposed solution: add another ACTDIAG utlity to check for SQL database integrity. Things like triggers, views, stored procedures. It would help explain why things are not working. The check would be to determine if everything is in place so that ACT works as designed. You might consider doing a phased approach with ACTDIAG: first to identify what might be missing, second to repair it.
Some samples of why this would be a good thing:
* A user reported that he did not have any secondary contacts while a colleague of his did. This was traced to a missing view.
* Some data was "disappearing" after being entered. This came from experienced ACT users. There was some event that happened removing or damaging the views.
* "hoping" that a database is OK is not a good strategy.