2368988 - Monitoring data not written on Oracle Audit Database if the monitoring tables are created manually in SAP Business Intelligence Platform 4.x | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2368988 - Monitoring data not written on Oracle Audit Database if the monitoring tables are created manually in SAP Business Intelligence Platform 4.x

Symptom

  • Following error observed: "An error occurred while retrieving the trend data from the database (MON00009)" in Monitoring Dashboard when user disables a watch.
  • Monitoring trending tables are not created in the Audit repository.
  • Upon manually creating the monitoring tables, no data is inserted into Monitoring tables.
  • In APS Logs we will find  the below errors:
    "ABB5314139254D72807C6347C21855C42d|2016 09 02 12:04:28.361|+0100|Error| |==|E| |aps_BOREP_DEV.AdaptiveProcessingServerMonitoring| 6104| 257|Thread-13||||||||||||||||||CS||EXCEPTION [JDBC|Oracle 11|ID:dd183c9]oracle.jdbc.driver.OracleStatementWrapper@6a583d7{java.sql.Statement}.execute : [java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object"

Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform (BI) 4.x
  • All supported Oracle Databases

Product

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

Keywords

Monitoring tables,oracle monitoring,monitoring database oracle,ORA-00955,joy, oracle jdbc monitoring,oracle monitoring bi,oracle monitoring tables ,oracle jdbc monitoring manually sequence data not insert writen write BI 4.x 4.0 4.1 4.2 , KBA , bimon , BI-BIP-MON , BI platform monitoring , BI-BIP-ADM , BI Servers, security & CrystalReports viewing in BI platform , 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.