Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

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

OBIEE 11G - Error encountered

Received Response
11
Views
5
Comments
2925291
2925291 Rank 1 - Community Starter
in Oracle Business Intelligence Applications Forum

Hi,

I am trying to create an Agent for an existing report which runs fine in the Analytics, however if I schedule it as an agent I am facing the below error and need some assistance please.

Error getting drill information: SELECT "GL Account"."GL Account Number" saw_0, "GL Account"."GL Account Name" saw_1, "Time"."Fiscal Year" saw_2, "Facts - GL Balance"."Opening Amount" saw_3, "Facts - GL Balance"."Debit Amount" saw_4, "Facts - GL Balance"."Credit Amount" saw_5, "Facts - GL Balance"."Closing Amount" saw_6 FROM "Financials - GL Balance Sheet" WHERE "GL Account"."GL Account Number" = '523013'

Error Details

Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65P

Odbc driver returned an error (SQLExecDirectW).

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27005] Unresolved column: "GL Account"."GL Account Number".Please have your System Administrator look at the log for more details on this error. (HY000)

SQL Issued: {call NQSGetLevelDrillability('SELECT "GL Account"."GL Account Number" saw_0, "GL Account"."GL Account Name" saw_1, "Time"."Fiscal Year" saw_2, "Facts - GL Balance"."Opening Amount" saw_3, "Facts - GL Balance"."Debit Amount" saw_4, "Facts - GL Balance"."Credit Amount" saw_5, "Facts - GL Balance"."Closing Amount" saw_6 FROM "Financials - GL Balance Sheet" WHERE "GL Account"."GL Account Number" = ''523013''')}

Thanks,
Raghav

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics & AI Strategist

    Setting up the agent with your own user credentials or another's?

  • 2925291
    2925291 Rank 1 - Community Starter

    This is happening to Actually a User under their credentials. I am trying to fix this issue please. Thanks!

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

    Strange. Are you sure that his is set properly?

    pastedImage_0.png

    And also: Are you sure there's nothing messed up in the XML of the Agent?

    pastedImage_2.png

  • 2925291
    2925291 Rank 1 - Community Starter

    Yes, Christian. I checked the Run As and as well as XML and both show the same. The only interesting this is if there is any discrepency then the regular report shouldnt also run in Analytics right? but if the user is running the report in Analytics the output is being displayed. Only when the user is scheduling the above message is triggering. I read on some of the Blogs regarding the coloumn level Security and some times the Anti-virus also stop the encrypting when being sent through agent, so not sure if that might be the case.

    Thanks!

    Raghav

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

    What do the logs say? Are they jacked up to 5 so you get more details? Have a look at the query that's being fired and you'll immediately see if there's sth new in the WHERE clause.