Is there a way to compare OBIEE settings on different servers

Jerry S. · Jun 12, 2017 11:23AM

Oracle Business Intelligence Product Version 11.1.1.7.141014 (Build 140916.0744 64-bit)

We have an RPD that runs perfectly fine on our development server, but when we move it to our test server, we get the following

ODBC error message when referencing a specific field in an analysis:

Odbc driver returned an error (SQLExecDirectW).

Error Details

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 59140] The evaluation of the index 1 expression on row count -1 failed. [nQSError: 59021] CASE conditional expressions have mismatching data types. (HY000)

Both servers have the identical OBIEE version and build information shown above.

Both servers are Linux and are pointing to the same database.

All fields can be reported on without any problems except for the one specific field.

The field that appears to be causing the issue is retrieved from a lookup table using a SPARSE LOOKUP.

We are at a loss to explain why it works on the development server, but does not work on the Test server

At this time, we feel the only thing that could account for this is some type of setting or configuration difference.

I would like to know if there is some utility or method available to view the specific setup for OBIEE on each of the servers.

and

Does anyone have any thoughts or suggestions as to what is going on here?

[Deleted User] · Jun 12, 2017 11:33AM

Hi Jerry,

First and foremost I'd verify that webcat, RPD and physical DB are 100% the same though. And then verify it a second time because those are the core components governing this.

Edit: Great my muppet colleagues made me doubt and delete my joke about Andrew being on holidays...

Jerry S. · Jun 12, 2017 11:51AM

Physical DB only exists in one place. (Confirmed)

Same RPD is being uploaded to both servers. (Confirmed).

Webcat is correct (Confirmed)

Thank you for the suggestions.

Sherry George · Jun 12, 2017 12:38PM

Saw this blog, may be you have already read it.

Using Oracle Technology Products: Oracle BI 11g. nQSError: 59021

https://translate.google.com/translate?hl=en&sl=ru&u=http://ehcap71.blogspot.com/2012/09/oracle-bi-11g-nqserror-59021.ht…

Jerry S. · Jun 13, 2017 2:23PM

This is exactly the information I needed to help solve my issues. Although it does not provide an answer to my original question about comparing settings, and it does not provide a concrete explanation of why this is happening, it does offer suggestions on how to deal with the issue. This allowed me to get the look-ups working correctly on all servers.

[Deleted User] · Jun 14, 2017 4:28AM

Would be nice to know the root cause though.

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

Is there a way to compare OBIEE settings on different servers

Answers