Our BIEE agent jobs failed frequently. But the jobs may be successful by manually running. The error occurrence is uncertain. Below is the error log.
Global Error: [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Odbc driver returned an error (SQLDriverConnectW).
Error Codes: OPR4ONWY:U9IM8TAC
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
[nQSError: 73006] Cannot obtain Oracle BI Servers from either the primary Cluster Controller (server1.localdomain) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)
.
Error Codes: AGEGTYVF
...Trying main loop again.... Sleeping for 4 seconds.Global Error: [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Odbc driver returned an error (SQLDriverConnectW).
Error Codes: OPR4ONWY:U9IM8TAC
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
[nQSError: 73006] Cannot obtain Oracle BI Servers from either the primary Cluster Controller (server1.localdomain) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)
.
Error Codes: AGEGTYVF
Terminal Error: Exceeded number of retries.
BTW, BIEE version is 11.1.1.7.0.