OBDC Driver Returned an Error (SQLExecDirectW)

Question

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

Federico Venturin - Oracle · Answer

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?

Steve F-2 · Answer

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:

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

Other comments, welcomed.