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

I installed OBIEE11G in my machine and I tried to login to Preseatation Services ,got the bellow error .I am somehow able to bypass the issue and able to access the Presentation Services.

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 in cmd prompt using the below link and you should be able to login .

:\Home\instances\instance1\bin\opmnctl start all

Thanks,

Raghu

Advertisements

About raghunagadasari

Working with a MNC on BI Applications 7.9.6x, OBIA 11.1.1.7.1. Having work exp on EBS, Oracle Apps, ODI, Informatica, OBIEE, Pl/sql,
This entry was posted in OBIEE. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s