Hi Everybody, I am hoping you could shade some light on this.
User has built a few OTBI agents.
Scheduled to run daily at 8am.
Majority of time they work fine and deliver the content to recipients.
Ocasionally, the Agent does not run at all.
Using the Oracle Analytics Web Services SOAP API (https://<cloud-pod>/analytics-ws/saw.dll?) I was able to see the history of agent runs
In the attempts the agent failed, this error is visible:
[nQSError: 77006] Oracle BI Presentation Server Error: A server error occurred. Error during query processing (SQLExecDirectW).Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PState: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: User &#39;<username>&#39; does not have the necessary BI Application Roles to execute the query. (HY000)
The user has got the required role (BI Consumer, BI Author) and this has not been changed in any way.
Also worth mentioning I am a cloud customer (no access to prem in any way)
Thank you.