Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 42015] Cannot function ship t

Received Response
26
Views
3
Comments
2844292
2844292 Rank 4 - Community Specialist
edited Aug 13, 2024 7:02PM in Oracle Analytics Cloud and Server

Hi Experts,

I want to create a report with two oracle databases. Imported the tables from two databases and modeled properly in the RPD. One of the Logical column derived with the Evaluate expression.This expression is valid and its working fine. When we created the report with Evaluate expression and some other logical columns, report is functioning correctly and giving correct results .

When i tried to create a report using columns from two tables (which are ideally from two different databases) and report is gives the correct results. But with same criteria when i applied the Evaluate logical column either as filter or criteria column then am getting error as

View Display Error

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: 42015] Cannot function ship the following expression: Evaluate( %1,'Name of the DBfunction') . (HY000)

Can some one please help me how to fix this error.

I already verified the DB features properties and IN_SUPPORTED is selected . Apart from this change what all changes i need to make inorder to solve this error.


Please suggest  and Thank you for your help.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    2844292 wrote:

Hi Experts,


I want to create a report with two oracle databases. Imported the tables from two databases and modeled properly in the RPD. One of the Logical column derived with the Evaluate expression.This expression is valid and its working fine. When we created the report with Evaluate expression and some other logical columns, report is functioning correctly and giving correct results .

When i tried to create a report using columns from two tables (which are ideally from two different databases) and report is gives the correct results. But with same criteria when i applied the Evaluate logical column either as filter or criteria column then am getting error as



View Display Error






Odbc driver returned an error (SQLExecDirectW).

    http://dev.tmlcanalytics.com:9704/analytics/res/sk_blafp/common/errorminus.gif  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: 42015] Cannot function ship the following expression: Evaluate( %1,'Name of the DBfunction') . (HY000)

    Can some one please help me how to fix this error.

    I already verified the DB features properties and IN_SUPPORTED is selected . Apart from this change what all changes i need to make inorder to solve this error.


    Please suggest  and Thank you for your help.

    Looking at this: " Cannot function ship the following expression: Evaluate( %1,'Name of the DBfunction')"

    The syntax is the other way around: EVALUATE ('DB_FUNCTION_GOES__HERE', %1)

    pastedImage_1.png

  • 2844292
    2844292 Rank 4 - Community Specialist

    Hi Christian  thank you for prompt response,

    This is my Evaluate expression formula

    Evaluate( NVL(%1,%2),Evaluate( DB function,) , D904.c13)

    and BI server log says

    [2016-04-12T22:55:28.000-07:00] [OracleBIServerComponent] [TRACE:7] [USER-34] [] [ecid: 08b36aff96406675:75e2d056:1538086e548:-8000-0000000000243fc5,0:1:9:5] [tid: c7228940] [requestid: 283a001c] [sessionid: 283a0000] [username: weblogic] -------------------- Query Status: [nQSError: 42015] Cannot function ship the following expression:

    [nQSError: 42015] Cannot function ship the following expression: Evaluate( NVL(%1,%2),Evaluate( APPS.SECURITY.ORGID,) , D904.c13) . (HY000)

    Reply • Like Show 0 Likes(0)

    My Evaluate expression is valid and its working fine for other reports in both filter as well as criteria columns.

    Could you please suggest what all i need to do inorder to solve this issue .

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Next time best post the actual error message and not an obfuscation of it. That just produces confusion and helps no one in resolving your issue.