SAP Knowledge Base Article - Preview

1977118 - No trend metrics are written to the audit database and viewing historical metrics throws error: "An error occurred while retrieving the trend data from the database (MON00009)"

Symptom

  • The Monitoring service has been configured to use the Auditing data source (ADS) however no data is written into the MOT_* tables
  • Viewing history in the monitoring application gives the following exception:

    An error occurred while retrieving the trend data from the database (MON00009)

    Get metric history from trending database failed.

    com.businessobjects.sdk.monitoring.exception.MonitoringException: java.lang.NullPointerException

    com.businessobjects.monitoring.actions.RetriveGraphData.executeAction(RetriveGraphData.java:127) 
    com.businessobjects.monitoring.actions.AbstractMonitoringAction.perform(AbstractMonitoringAction.java:82) 
    org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1787) 
    org.apache.struts.action.ActionServlet.process(ActionServlet.java:1586) 
    com.businessobjects.webutil.struts.CrystalUTF8InputActionServlet.process(CrystalUTF8InputActionServlet.java:21)
    org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510) 
    javax.servlet.http.HttpServlet.service(HttpServlet.java:641) javax.servlet.http.HttpServlet.service(HttpServlet.java:722) 
    com.businessobjects.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:110) 
    com.businessobjects.http.servlet.internal.ServletLastFilterChainElement.service(ServletLastFilterChainElement.java:30) 
    com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:46) 
    com.businessobjects.bip.core.web.boetrustguard.BOETrustPrepareFilter.doFilter(BOETrustPrepareFilter.java:35) 
    com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72) 
    com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43) 
    com.businessobjects.bip.core.web.supportabilty.TraceLogScopeFilter.doFilter(TraceLogScopeFilter.java:38) 
    com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72) 
    com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43) 
    com.businessobjects.sdk.actionfilter.WorkflowFilter.doFilter(WorkflowFilter.java:45) 
    com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72) 
    com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43) 
    com.businessobjects.bip.core.web.appcontext.RequestInitFilter.doFilter(RequestInitFilter.java:26) 
    com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72) 
    com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43) 
    com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.serviceHelper(BundlePathAwareServiceHandler.java:235) 
    com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.service(BundlePathAwareServiceHandler.java:197) 
    com.businessobjects.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:248) 
    javax.servlet.http.HttpServlet.service(HttpServlet.java:722) 
    org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:220) 
    javax.servlet.http.HttpServlet.service(HttpServlet.java:722) 
    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) 
    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) 
    com.businessobjects.pinger.TimeoutManagerFilter.doFilter(TimeoutManagerFilter.java:168) 
    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) 
    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) 
    org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) 
    org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) 
    org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) 
    org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) 
    org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) 
    org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) 
    org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) 
    org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002) 
    org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585) 
    org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) 
    java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) 
    java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) 
    java.lang.Thread.run(Thread.java:743)

  • Enabling HIGH tracelog for the monitoring service reveals the following exception in the Adaptive Processing Server (APS) GLF trace:
    java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.x (BI 4.0 / 4.1 / 4.2)
  • Windows
  • Linux / Unix 

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.0, feature pack 3 ; SAP BusinessObjects Business Intelligence platform 4.1

Keywords

MON00009, trending, monitor, diagnostics, history, historical, tns, tnsnames.ora, service, name, client, Oracle11g, Oracle10g , KBA , BI-BIP-MON , BI platform monitoring , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , 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.