Advertisements

Data type related error in OBIEE 11g – Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

If you receive an error like this in OBIEE 11g, this post may help you resolve the problem.  This is an error that you may get after upgrading from OBIEE 10g to 11g.

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 11 expression on row count -1 failed. [nQSError: 59001] Binary Logical operation is not permitted on VARBINARY, INTEGER operand(s). (HY000)

DataTypeError

OBIEE 10g is a lot more forgiving than 11g.  So what worked in 10g may not work in 11g – such as data type mismatches.  For this error, you need to check the data types of your columns and the data types of the values being used in your column calculations.

For example, you may have a column formula like this …

sum(case when “Table”.”Column”=3 then 1 else 0 end)

Note the column is being used like an INTEGER. This worked in 10g, but does not in 11g.

When you check the data type in your RPD, it may show that the column is a VARCHAR.  You then will need to put quotes around the value (the ‘3’) … like this …

sum(case when “Table”.”Column”=’3’ then 1 else 0 end)

This should hopefully solve the problem.

Advertisements

5 Responses to Data type related error in OBIEE 11g – Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

  1. Prasad says:

    Hi,
    I am also getting similar issue but not related data type after upgrading 10g to 11g.
    Below is the error..please help me to resolve.
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119].Oracle Error Code :600, message:ORA-00600:Internal code arguments:

  2. obieepedia says:

    Hello Prasad, have you always been getting this error or was the report running fine before and now started to throw this error?
    Was the report created directly in 11g or did it go through an upgrade?
    What are the columns selected and what columns are used in the filter?

    Norm

  3. srinath reddy says:

    I am getting same error below the column..
    “Time”.”Month” If i remove this column report works fine….
    Please help me on this……

    • obieepedia says:

      Do you have a custom formula in the column definition? If yes, please check it to make sure everything is correct.
      Also, check the data type setting for the column – try different settings.
      Another thing you try is … converting the column to different data type using the cast function.
      If you still have issues, please reply with more details about your report — all columns being selected, filter criteria, any aggregations, etc. – as much info as possible.

  4. Sheila says:

    Hi Prasad
    I’m getting similar error, I’m practicing with BISAMPLE and the SampleApp Files. It looks like the report is not sourcing the data from the same path as the data I uploaded in Enterprise Manager. How do I direct Analytics to source data from the correct file? This is the error message and the correct file path below.:
    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: 64023] cannot access c:\Oracle\Middleware\instances\instance3\bifoundation\OracleBIServerComponent\coreapplication_obis1/sample/SampleAppFiles/Data/SAMP_PRODUCTS_D.xml: No such file or directory for table SAMP_PRODUCTS_D (HY000)

    SQL Issued: SELECT 0 s_0, “Sample Sales Lite”.”Products”.”Product” s_1, DESCRIPTOR_IDOF(“Sample Sales Lite”.”Products”.”Product”) s_2, SORTKEY(“Sample Sales Lite”.”Products”.”Product”) s_3 FROM “Sample Sales Lite” FETCH FIRST 65001 ROWS ONLY

    Correct file path should be:”…..instance2: bifoundation: OracleBIServerComponent: Coreapplication_obis1: repository: SampleAppLite_BI0001.rpd

    Thanks.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: