OBIEE 11G - Error encountered

Question

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

[Deleted User] · Answer

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.

2925291 · Answer

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] · Answer

Strange. Are you sure that his is set properly?

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