Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ADW Data Connection | Error | Failed to Retrieve Data

Accepted answer
34
Views
5
Comments

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 ☺

Tagged:

Best Answer

  • Vismay Barot
    Vismay Barot Rank 4 - Community Specialist
    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.

Answers

  • Ram-Oracle
    Ram-Oracle Rank 6 - Analytics Lead

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

  • Vismay Barot
    Vismay Barot Rank 4 - Community Specialist

    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
    Ram-Oracle Rank 6 - Analytics Lead

    @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
    Vismay Barot Rank 4 - Community Specialist

    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.