Unknown Error, Error returned: 0x80010105. The server threw an exception

Technote (troubleshooting)


Problem(Abstract)

Unable to open the Gentran audit log. Error appears after several minutes: Unknown Error, Error returned: 0x80010105. The server threw an exception.

Cause

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

Notes:
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 "

Product Alias/Synonym

GSW

Rate this page:

(0 users)Average rating

Document information


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

Translate my page

Machine Translation

Content navigation