OBIEE 12c: Admin Server Log Has Datasource Profile Entry Repeatedly "weblogic.jdbc.common.internal.ConnectionPoolProfiler.addStmtUsageData"

(Doc ID 2402085.1)

Last updated on MAY 31, 2018

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.2.171017 and later
Information in this document applies to any platform.

Symptoms

On OBIEE 12.2.1.2.171017, there seems to be an exception in datasource.log in the same folder as the Adminserver.log. This message repeats very often.

> <select ID, STYPE, ENDPOINT, LASTUPDATED, PROMOTED, VALID from SERVICETABLE where ID=?> <[partition-id: 0] [partition-name: DOMAIN] >
####<LocalSvcTblDataSource> <WEBLOGIC.JDBC.STMT.USAGE> <0> <java.lang.Exception
at weblogic.jdbc.common.internal.ConnectionPoolProfiler.addStmtUsageData(ConnectionPoolProfiler.java:305)
at weblogic.jdbc.wrapper.Statement.finishStatementProfiling(Statement.java:312)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:147)
at com.oracle.cie.servicetable.dao.impl.OracleServiceTableDAOImpl.getServiceTableEntry(OracleServiceTableDAOImpl.java:73)
at com.oracle.cie.servicetable.impl.ServiceTableImpl.lookup(ServiceTableImpl.java:290)
at com.oracle.cie.servicetable.impl.ServiceTableImpl.lookup(ServiceTableImpl.java:267)
at oracle.as.ccw.jmx.CCWInfo.getPublishedEndPoint(CCWInfo.java:897)
at oracle.as.ccw.jmx.CCWInfo.validateService(CCWInfo.java:880)
at oracle.as.ccw.jmx.CCWInfo.access$400(CCWInfo.java:53)
at oracle.as.ccw.jmx.CCWInfo$ApplicationInfo.validateService(CCWInfo.java:346)
at oracle.as.ccw.jmx.CCWServicesMXBeanImpl.validateService(CCWServicesMXBeanImpl.java:83)
at oracle.as.ccw.jmx.CCWServicesMXBeanImpl.validateService(CCWServicesMXBeanImpl.java:89)
at sun.reflect.GeneratedMethodAccessor654.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at oracle.as.jmx.framework.standardmbeans.spi.OracleStandardEmitterMBean.doInvoke(OracleStandardEmitterMBean.java:918)
at oracle.adf.mbean.share.AdfMBeanInterceptor.internalInvoke(AdfMBeanInterceptor.java:102)
at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
at oracle.as.jmx.framework.generic.spi.security.AbstractMBeanSecurityInterceptor.i

There is no issue with the application.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms