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 "
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.