Splunk AppDynamics

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

Basit_Amjad
New Member

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?

Labels (1)
0 Karma

iamryan
Community Manager
Community Manager

Hi @Basit.Amjad,

Sounds good. Please do followup and let me know. 

0 Karma

Basit_Amjad
New Member

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

0 Karma

iamryan
Community Manager
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.

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud's AI Assistant in Action Series: Auditing Compliance and ...

This is the third post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...