APMIA with Oracle extension - java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Products

• CA Application Performance Management SaaS

Issue/Introduction

Configured APMIA with Oracle extension and seeing lot of errors like below in IntroscopeAgent.log.

What is the cause of these errors ? 

java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
 at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)
 at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)
 at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733)
 at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
 at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1276)
 at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366)
 at com.ca.agent.extensions.dbmon.commands.DBMonExecuteQueryCommand.fireAndUpdateMetric(DBMonExecuteQueryCommand.java:158)
 at com.ca.agent.extensions.dbmon.commands.DBMonExecuteQueryCommand.execute(DBMonExecuteQueryCommand.java:123)
 at com.ca.agent.extensions.dbmon.DBMonChain.run(DBMonChain.java:66)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
 at java.lang.Thread.run(Thread.java:821)

Environment

Release : SAAS

Component : MOBILE API

Cause

Most likely is related Oracle Database credential / permission. 

 

Resolution

Make sure the db1 username and password is correct and have appropriate permission

introscope.agent.dbmonitor.oracle.profiles.db1.userName=

introscope.agent.dbmonitor.oracle.profiles.db1.password=

Configure Oracle Database Monitoring in DX APM Infrastructure Agent

 

 

Additional Information

Here is an Oracle Community post:

https://community.oracle.com/thread/4179860