Saturday, December 29, 2012

Error Codes: OPR4ONWY:U9IM8TAC,nQSError: 10058,nQSError: 73006


Error Message :
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 <xxxxxxxxxxxxx> or the secondary Cluster Controller () specified for the clustered DSN. (HY000)
Solution :
Step1 : Navigate to “Control Panel\All Control Panel Items\Administrative Tools” and open the ‘Data Sources (ODBC)’ .
Step2: You can find the Datasource name like ‘coreapplication_OHxxxxxxxxxxxxx’ .Double click to open that .
Step3:Uncheck Clustered DSN .In Server IP Address, mention your Computer Name.
Then simply Click Next -> Next -> Finish.
Step4 : Restart OPMN Services and you should be able to login .