Categories
- All Categories
- 150 Oracle Analytics News
- 28 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
ADW Data Connection | Error | Failed to Retrieve Data

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 ☺
Best Answer
-
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.
1
Answers
-
@Vismay Barot Could you verify if the connection service name is selected as low service and verify.
0 -
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.
0 -
@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
0 -
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.0