OBIEE 11.1.1.7.150120 ODBC driver returned an error Cannot Function Ship Error

Oracle Business Intelligence

OBIEE Patch 11.1.1.7.150120 ODBC driver returned an error

After patching to 11.1.1.7.150120 it so happens that where Total Rows are used, there may be possibilities that you get “ODBC driver returned an error…..Cannot function ship the following expression…”.

Yes, 11.1.1.7.141014 also has the same problem described previously in this post here. Actually, a interim fix has been issued for a few weeks now but I wanted to do deep dive tests before I tell everyone that this works. It works!!!

Download the Patch 19599154 here. Alternatively, search in Oracle Support for Patch Number 19599154 Windows x64 yourself to get this patch. You have options of fixing 141014 or 150120.

For more details of the original bug issue, please view below.

Error_Message

The way to fix it is to edit the fact columns and change the “Aggregate Rule (Total Rows)” to “Sum” instead of Default. The strange thing is that the first fact column can be left as default from my current observations. Hope this helps everyone who encounter this error.

Update 25-November-2014: For row totals, when percentage is present, changing to SUM will cause percentage to add up which is wrong. Temporarily may need to change report based aggregation methodology to none so that incorrect figures are not displayed. I am still working on how to fix this issue.

Advertisements

Author: Steve Yeung

Being in the EPM & BI field for more than 8 years, it's about time I contribute to newcomers! As a founder of MondayBI.com I wish to give you all the help I can. Feel free to give any suggestions or questions. Hope you will all enjoy this blog! William Wong Essbase Certified Specialist OBIEE Certified Specialist

4 thoughts on “OBIEE 11.1.1.7.150120 ODBC driver returned an error Cannot Function Ship Error”

  1. I am contacting you because I’m a BI engineer,and now I have some trouble of OBIEE and you must be an export of OBIEE.
    Please give me some suggestion if you know about following issue.
    I think my issue is similar to your article.

    1.Error message

    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: 22020] Function Concat does not support non-text types. (HY000)

    2.About our apprication

    We use concatenate function in our apprication.
    The following is the sample code.

    CAST(“MONTH”.”FY” AS CHAR(3)) || ‘FY’ || SUBSTRING(“MONTH”.”FROM”,5,2) || ‘MONTH’

    3.Environment

    Our apprication worked on OBIEE 11.1.1.7.1 (Build 130605.1002 64-bit).
    But after we applied Bundle patch 141014, out apprications don’t work correctly.

    We are still struggling to solve our problem about that.
    I hope you give us some useful suggestion.

    Like

      1. I could solve my probrem. The reason was the parameter OBIEE_COMPILER_LOCK_OPTIMIZATION_LEVEL on opmn.xml. When I set the parameter on opmn.xml, I have the error on my apprication. Thank you for your assistance.

        Liked by 1 person

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