Kbase P164421: Truncating an Audit Area fails with error 13683
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/3/2010 |
|
Status: Verified
SYMPTOM(s):
Truncating an Audit Area fails with error 13683
ERROR: The area you are attempting to truncate contains a schema <tbl/idx>: <name>. You must move this <tbl/idx> to another area first before truncating. (13683)
ERROR: The area you are attempting to truncate contains a schema table : _aud-file-policy. You must move this table to another area first before truncating. (13683)
ERROR: The area you are attempting to truncate contains a schema table : _aud-field-policy. You must move this table to another area first before truncating. (13683)
ERROR: The area you are attempting to truncate contains a schema table : _aud-event-policy. You must move this table to another area first before truncating. (13683)
ERROR: The area you are attempting to truncate contains a schema table : _aud-event. You must move this table to another area first before truncating. (13683)
ERROR: The area you are attempting to truncate contains a schema table : _aud-audit-policy. You must move this table to another area first before truncating. (13683)
ERROR: The area you are attempting to truncate contains a schema table : _aud-audit-data-value. You must move this table to another area first before truncating. (13683)
ERROR: The area you are attempting to truncate contains a schema table : _aud-audit-data. You must move this table to another area first before truncating. (13683)
The contents of LOB "_Old-blob-value" will be deleted.
The contents of LOB "_New-blob-value" will be deleted.
The contents of LOB "_Old-clob-value" will be deleted.
The contents of LOB "_New-clob-value" will be deleted.
User aborted truncation of storage area "Audit Data Area"
Tablemove Audit schema fails error 8605
ERROR - moving table, _aud-audit-data [-300]. (8605)
FACT(s) (Environment):
OpenEdge 10.1B
OpenEdge 10.2x
User truncating audit area with Audit Archiver privillege
After disabling auditing the audit area still cannot be truncated
All Supported Operating Systems
OpenEdge 10.1C
OpenEdge 10.2x
CAUSE:
Documentation Bug# OE00195192
CAUSE:
Bug# OE00195194
CAUSE:
The audit tables are classified internally by the database as 'metaschema' tables like _file, _field for example. The utilities will not allow you to truncate areas holding schema tables nor move schema tables to another area. Similar to the fact that the Schema Area cannot be truncated, because it (also) contains meta schema tables. While non metaschema tables can be tablemoved from the Schema Area, metaschema tables cannot. So, once in place, the auditing structure cannot be deleted and truncation of an audit area is not allowed.
Additionally, there is no utility to delete auditing schema completely. Once enabled, Auditing may be disabled but the auditing schema will remain.
FIX:
Workaround:
To prevent the audit areas from growing disproportionately, run audit archive regularly.
Should the audit area grow unexpectedly, the only way to recover this space is to dump and load the entire database.