Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OBDC Driver Returned an Error (SQLExecDirectW)

Received Response
61
Views
2
Comments
User_C4E8V
User_C4E8V Rank 1 - Community Starter
edited Aug 13, 2024 7:20PM in Oracle Analytics Cloud and Server

We recently made adjustment to our domain name for Oracle BIEE and shortly after doing so all of our reports are now showing the same display error when attempting to run a result.

We have changed our Domain name back but unfortunately this hasn't fixed the issue. Has anyone else by chance ran into this problem?


Capture1.PNG


Answers

  • SteveF-Oracle
    SteveF-Oracle Mod
    edited Oct 17, 2023 1:38PM

    Moderators, please move this to the OBIEE community

    https://community.oracle.com/products/oracleanalytics/categories/obiee

    @User_C4E8V

    Welcome to the Oracle Analytics Online Forum!

    We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.


    Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!

    As for the error

    We recently made adjustment to our domain name 

    Can you detail the steps that you undertook to "adjust your domain name"?

    Have you checked the obis1-diagnostic.log(s) for additional details?

    It may make it easier to diagnose if you:

    1. stop.sh|.cmd -i obis1
    2. clear (move/delete/rename) the obis1*.log* and obis1*.out*
    3. start.sh|.cmd -i obis1
    4. execute your analysis
    5. check the diagnostic log(s)

    Other comments, welcomed.

  • Federico Venturin - Oracle
    Federico Venturin - Oracle Mod

    Hi @User_C4E8V ,

    Which version of OBIEE are currently using?

    Did you restart the full stack after changing the domain name? As @SteveF-Oracle suggested, it would be great if you can share the procedure adopted to change the domain name.

    I noticed that the UID session variable has no value definition. Has it been defined as a security sensitive session variable? Are you still able to reach the database server used to initialize it from the OBIEE server?