Oracle Communities

Oracle Analytics and AI

Child Item

ADW Data Connection | Error | Failed to Retrieve Data

Vismay Barot

Greetings Community, I’ve encountered an error in ADW Connection on OAC Console:

I would believe this would be the Primary Reason:

Just so everybody knows, ADW Connection is setup by NSAW Implementation Team for fetching data from NSAW Tables.

Please guide me with the correct solution and I appreciate your time and efforts.

Thank You ☺

Find more posts tagged with

Error

ADW

Accepted answers

Vismay Barot

Greetings @Ram-Oracle , apologies but this has been figured out, it was Password Expiry that was causing the issue.

Thank You So Much for looking into it.

All comments

Ram-Oracle

@Vismay Barot Could you verify if the connection service name is selected as low service and verify.

Vismay Barot

Thank You @Ram-Oracle for the Prompt Response.

Can you please guide me on where to verify the same? I am sorry I wasn't part of the Implementation and might be unaware of the fundamentals.

Ram-Oracle

@Vismay Barot Please access hamburger icon from left hand side from oac home page ,from connection tab you would see adw connection ,click on action menu (3dots) and inspect .

Also from the screenshot shared earlier ,there is an enter sql option ,please click on enter sql and share the screenshot. or without passing any sql query it gives failed with invalid sql statement error

Vismay Barot

Are we talking about this screen? I don't see anything as "Low Service"

As asked, in first screenshot, the error pops if I :
Click on "Select Columns"
OR
Enter any Valid SQL Query and hit Run.

Vismay Barot

Greetings @Ram-Oracle , apologies but this has been figured out, it was Password Expiry that was causing the issue.

Thank You So Much for looking into it.