How to simulate Query Error to be shown in OAC?

Chethana Kumari-Oracle

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

What is the data source?

What is used to create data set?

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

Chethana Kumari-Oracle

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

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.