How to simulate Query Error to be shown in OAC?

Question

Summary:

I want to simulate Query Error to be shown in OAC dv.

Content (required):

I want to simulate Query Error to be shown in OAC dv, so that the charts are broken

Version (include the version you are using, if applicable):

v6.2

Code Snippet (add any code snippets that support your topic, if applicable):

Wayne Van Sluys · Answer

One way to force an error in query is to change the select statement to an invalid column name.  Or you can temporarily change the column name in the ADW table.

Chethana Kumari-Oracle · Answer

Datasource is Oracle ADW

Dataset is an external table in ADW

Purpose of simulating query error is to ensure the "usage tracking" table (utlogical) provides me details of 'query error' . I want to ensure that, its field success_flg returns a value=3 and its field saw_src_path  returns the project/canvas name.  I need this information to automate OAC health check status.

Thanks, Chethana

Wayne Van Sluys · Answer

What is the data source?

What is used to create data set?

What is you are hoping to show / what is purpose?