SAP Knowledge Base Article - Preview

1733310 - BI 4.0: Auditing files are not empty and removed

Symptom

  1. Audit files are not empty and removed from the <BOE_Install>\SAP BusinessObjects Enterprise XI 4.0\Auditing folder
  2. Central Management Server (CMS) full logs show errors like:

For Oracle:

Oracle error found: ErrorMessage(ORA-00001: unique constraint (BOAUDIT.ADS_EVENT_1) violated

For DB2:

DB2  error found:  ErrorMessage([IBM][CLI Driver][DB2/LINUXX8664]  SQL0803N   One or more values 
in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are
not valid because the primary key, unique constraint or unique index identified by "1" constrains table
"BOAUDIT.ADS_EVENT" from having duplicate values for the index key.  SQLSTATE=23505

For MS SQL:

SQLServer  error found: ErrorMessage([Microsoft][SQL Server Native Client   12.0][SQL Server]Cannot 
insert duplicate key row in object 'dbo.ADS_EVENT' with unique index 'ADS_EVENT_1'.

For Sybase:

[ODBC Sybase Wire Protocol driver][SQL Server]Attempt to insert duplicate key row in object 'ADS_EVENT' with unique index 'ADS_EVENT_1'

For MySQL:

tbd

 

This problem might also happen on the following indexes and tables:AUDIT_EVENT_1 on table AUDIT_EVENT

  • ADS_EVENT_1 on table ADS_EVENT
  • ADS_EVENT_DELETES_1 on table ADS_EVENT_DELETES
  • ADS_SUPPORTED_EVENTS_1 on table ADS_SUPPORTED_EVENT
  • ADS_CLUSTER_1 on table ADS_CLUSTER
  • ADS_AUDITEE_2 on table ADS_AUDITEE
  • ADS_SERVER_NAME_STR_1 on table ADS_SERVER_NAME_STR
  • ADS_STATUS_STR_1 on table ADS_STATUS_STR
  • ADS_EVENT_TYPE_STR_1 on table ADS_EVENT_TYPE_STR
  • ADS_EVENT_DETAIL_TYPE_STR_1 on table ADS_EVENT_DETAIL
  • ADS_EVENT_CATEGORY_STR_1 on table ADS_EVENT_CATEGORY_STR
  • ADS_OBJECT_TYPE_STR_1 on table ADS_OBJECT_TYPE_STR
  • ADS_APPLICATION_TYPE_STR_1 on table ADS_APPLICATION_TYPE_STR
  • ADS_SERVICE_TYPE_STR_1 on table ADS_SERVICE_TYPE_STR
  • ADS_CLUSTER_STR_1 on table ADS_CLUSTER_STR
  • ADS_SERVER_TYPE_STR_1 on table ADS_SERVER_TYPE_STR

Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.0
  • SAP BusinessObjects Business Intelligence Platform 4.1

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1

Keywords

Violation of PRIMARY KEY constraint Cannot insert duplicate key in object , KBA , BI-BIP-DEP , SBOP Web Application Deployment, Wdeploy , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.