Unable to open the Gentran audit log. Error appears after several minutes: Unknown Error, Error returned: 0x80010105. The server threw an exception.
Audit had not been purged in a long time. ProcAuditLog_tb was over one million records.
Resolving the problem
Clearing Audit Logs from within SQL server
1. These commands should be run by a database administrator
2. 1 million is always too much
First determine the size of the tables with these queries:
select count(*) as 'ProcAuditLog_tb' from "ProcAuditLog_tb"
select count(*) as 'DataAuditLog_tb' from "DataAuditLog_tb"
select count(*) as 'NotifyLog_tb' from "NotifyLog_tb"
Use these queries to purge the tables:
truncate table "ProcAuditLog_tb"
truncate table "DataAuditLog_tb "
truncate table "NotifyLog_tb "