SAP Knowledge Base Article - Public

1880145 - Massive Object Deletion event 65543 recorded in BusinessObjects audit database.

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

Product

SAP BusinessObjects Xcelsius Enterprise 2008