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

Last updated on AUGUST 15, 2019

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.