This discussion is archived
4 Replies Latest reply: Apr 21, 2013 8:45 PM by Rajesh Gurram - BI RSS

Extended Subject Area is throwing error

971954 Newbie
Currently Being Moderated
Hi All,

I am working on consolidation of OBIEE reports and create single RPD.
We have OBIA as primary repository. One plant is on legacy system. We have created a new schema in EBS database and loaded data to this new schema.
I created a new Physical layer, BMM and Subject area in RPD.
I can see this extended subject area in the RPD.
Whenever I am trying to run a report, I get following 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. Please have your System Administrator look at the log for more details on this error. (HY000)

But at the same time the standard Subject area work fine and give output.
Did anyone face such issue? Request help from the group on this.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points