Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- 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
