OBIEE 11.1.1.7.150120 Query Failed: [nQSError: 59140] The evaluation of the index 3 expression on ro

3031522

Hi

I am new to OBIEE and using version 11.1.1.7.150120.  Any help would be really appreciated. One of the report(analysis) is giving below error:

"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 3 expression on row count -1 failed. [nQSError: 59021] CASE conditional expressions have mismatching data types. (HY000)"

I have tried to use elimination process to find out where the issue is.

1)  When I use the Physical SQL (from the same analysis) and execute in Database, it works fine and it provides the output <-- SQL/DB may not be an issue

2) I have used an older version RPD, it still gives an error <-- RPD may not be an issue

3) When I turn off the caching within the analysis by putting "SET VARIABLE DISABLE_CACHE_HIT=1;" in advance tab->Prefix, and apply it, works fine. <-- Issue may be with the way it is caching.

I can provide more information if needed. Has anyone come across the same issue ? or anyone knows how to debug it?

Regards

Rajat

2682943

Hi,

Try this link might work for you OBIEE 11.1.1.5 IFNULL