ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 198762


Updated On:


CA Application Performance Management SaaS


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(
 at oracle.jdbc.driver.T4CTTIoer11.processError(
 at oracle.jdbc.driver.T4C8Oall.processError(
 at oracle.jdbc.driver.T4CTTIfun.receive(
 at oracle.jdbc.driver.T4CTTIfun.doRPC(
 at oracle.jdbc.driver.T4C8Oall.doOALL(
 at oracle.jdbc.driver.T4CStatement.doOall8(
 at oracle.jdbc.driver.T4CStatement.doOall8(
 at oracle.jdbc.driver.T4CStatement.executeForDescribe(
 at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
 at oracle.jdbc.driver.OracleStatement.executeQuery(
 at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(
 at java.util.concurrent.ThreadPoolExecutor.runWorker(
 at java.util.concurrent.ThreadPoolExecutor$


Most likely is related Oracle Database credential / permission. 



Release : SAAS

Component : MOBILE API


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

Configure Oracle Database Monitoring in DX APM Infrastructure Agent



Additional Information

Here is an Oracle Community post: