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)"

• 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

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

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