Symptom
Massive Object Deletion event 65543 recorded in BusinessObjects audit database.
Environment
- BusinessObjects Enterprise (BOE) XI 3.1
Reproducing the Issue
With SQL statement below massive Object Deletion events are recorded.
-----
SELECT
AUDIT_EVENT.EVENT_ID, AUDIT_EVENT.User_Name, AUDIT_EVENT.Start_Timestamp, AUDIT_EVENT.Event_type_id, AUDIT_EVENT.Object_CUID, AUDIT_EVENT.Object_type, AUDIT_DETAIL.Detail_id, AUDIT_DETAIL.Detail_type_id, AUDIT_DETAIL.Detail_text
FROM
AUDIT_EVENT, AUDIT_DETAIL
WHERE
AUDIT_EVENT.EVENT_ID = AUDIT_DETAIL.event_ID
-----
SQL result example:
EVENT_ID | User_Name | Start_Timestamp | Event_type_id | Object_CUID | Object_type | Detail_id | Detail_type_id | Detail_text | ||
3809290756264034507 | System Account | 6/28/2013 | 65543 | AQpuSPH045xEo0JZbENHRPc | Excel | 1 | 42 | Everyone | ||
System Account | 6/28/2013 | 65543 | AQpuSPH045xEo0JZbENHRPc | Excel | 2 | 3 | WebI_eFashion_Test01 | |||
System Account | 6/28/2013 | 65543 | AQpuSPH045xEo0JZbENHRPc | Excel | 3 | 43 | /TestFolder01/WebI_eFashion_Test01/ | |||
System Account | 6/28/2013 | 65543 | AQpuSPH045xEo0JZbENHRPc | Excel | 4 | 45 | 0 | |||
System Account | 6/28/2013 | 65543 | AQpuSPH045xEo0JZbENHRPc | Excel | 5 | 50 | Excel | |||
System Account | 6/28/2013 | 65543 | AQpuSPH045xEo0JZbENHRPc | Excel | 6 | 52 | 8868 | |||
System Account | 6/28/2013 | 65543 | AQpuSPH045xEo0JZbENHRPc | Excel | 7 | 90 | 1 | |||
System Account | 6/28/2013 | 65543 | AQpuSPH045xEo0JZbENHRPc | Excel | 8 | 92 | AQpuSPH045xEo0JZbENHRPc | |||
System Account | 6/28/2013 | 65543 | AQpuSPH045xEo0JZbENHRPc | Excel | 9 | 91 | ARfgz3i2s4FAufefad8quuU | |||
3809290756264034507 |
Sometimes audit database size grows up remarkably because of these event records.
Cause
"Limits of Instance" is set for particular report or folder which leads to excess instances to be deleted by System Account automatically.
Please refer to "To set limits for instances" statement in Administrator guide.
Resolution
This is a standard product behavior.
Keywords
excess, instance, instances, schedule, scheduling, 65543, Object deleted, system, account , KBA , BI-BIP-PUB , Publishing and scheduling in InfoView/BI launch pad , Problem