Unknown Error, Error returned: 0x80010105. The server threw an exception
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 "
More support for:
Sterling Gentran:Server for Microsoft Windows
Data management - Audit
Software version: 5.1, 5.2, 5.3, 5.3.1
Operating system(s): Windows
Reference #: 1613618
Modified date: 2012-10-17