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

ERROR_GETTING_REPORT_DATA

Received Response
553
Views
4
Comments
Mark Hamilton-43486
Mark Hamilton-43486 Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

Summary

ERROR_GETTING_REPORT_DATA

Content

Hi everyone. I hope you are all well.

I have another problem with BI Publisher in OBIEE. I have setup a BI Data Model (with a bursting definition) and a Report. I have then attempted to run a report job using the Use bursting definition option selected. I know the email services work as if I don't select "User Bursting Option" I receive an email successfully. I get an error message that looks like this. I have removed URLs for security. I don't have full administration rights. Please could anyone help? Thanks

Error Message

Job Name : 4th Test POC BIPB

Job Executed Date : June 28, 2017 1:55:15 PM BST Status :
Job was failed.

View History :

Detail Message:

::JOB_PROCESSOR_EXCEPTION::[INSTANCE_ID=xxxx.net.xxxx]
[INSTANCE_JOB_ID=2608]::::ERROR_GETTING_REPORT_DATA::[INSTANCE_ID=xxxx.net.xxxx]  INSTANCE_JOB_ID=[xxxx]
oracle.xdo.XDOException: java.sql.SQLException: java.io.IOException: prepare
query failed[nQSError: 43113] Message returned from OBIS.

[nQSError: 27002] Near <Body>: Syntax error [nQSError:
26012] .

  • oracle.xdo.XDOException: oracle.xdo.XDOException:
    java.sql.SQLException: java.io.IOE

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    When I copied the above code to notepad++ I see something weird with the single quotes for PARAMETER4, could you remove the quote and apply again to see if it makes a difference. I know it's silly, but since I'm not able to test anything from my end right now, just a suggestion.

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Post bursting definition.

  • Mark Hamilton-43486
    Mark Hamilton-43486 Rank 4 - Community Specialist

    Here is the data definition.

    We have referenced a subject area, rather htan a physical table, which has worked from a different area already.

    select   "Employee Expenses"."Cost Center"."Cost Center Number" "KEY", 

    'Layout 1' TEMPLATE, 

    'en-US' LOCALE, 

    'PDF' OUTPUT_FORMAT, 

    'EMAIL' DEL_CHANNEL,  

    "Employee Expenses"."Cost Center"."CC Manager Email" PARAMETER1, 

    'Alan.Walsh@networkrail.co.uk' PARAMETER2, 

    'BusinessAnalytics@networkrail.co.uk' PARAMETER3, 

    'SUBJECT: Financial Opex Adherence to Budget and Forecast - Performance for Px’ PARAMETER4,

      'BODY: Example Body Text' PARAMETER5,   'true'

    PARAMETER6,   'BusinessAnalytics@networkrail.co.uk'

    PARAMETER7

    FROM "Employee Expenses"."Cost Center"

  • Mark Hamilton-43486
    Mark Hamilton-43486 Rank 4 - Community Specialist

    Hi Sherry. Thank you again . I should have used an SQL editor and I would have noticed.