SAP Knowledge Base Article - Preview

1733310 - BI 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.x

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 , Webapp Deployment, Networking, Vulnerabilities, Webservices , Problem

About this page

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

Search for additional results

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