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 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.