cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

ORA-00942: table or view does not exist when creating custom metric on a database

Basit.Amjad
Wanderer

I am trying to create a custom metric on the database. i have selected the database but when I add a query it gives me the ORA-00942: table or view does not exist error

The query returns just one value when it is run against the database.

Can you advise why this error is being thrown?

 

3 REPLIES 3

Ryan.Paredez
Community Manager

Hi @Basit.Amjad,

I found an existing post where someone had the same error. It's a few years old now, bt might help - https://community.appdynamics.com/t5/Java-Java-Agent-Installation-JVM/DB-Collector-error-ORA-00942-t...

That post links to an AppD Docs page; here is a more recent version of that same Doc https://docs.appdynamics.com/appd/22.x/latest/en/database-visibility/add-database-collectors/configu...

Please let me know if it helps.


Thanks,
Ryan, AppDynamics Community Manager



Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.

Basit.Amjad
Wanderer

Thank you Ryan, I will investigate this further and see if I can resolve it

Ryan.Paredez
Community Manager

Hi @Basit.Amjad,

Sounds good. Please do followup and let me know. 


Thanks,
Ryan, AppDynamics Community Manager



Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.