Unable to Sign into OBIEE 11g Analytics - NQSConfig Syntax Error

When you try to log into Analytics, it throws an error stating - "An error occurred during Authentication. Try again later or contact your system administrator".

Log into Enterprise Manager and see if all the OPMN services are up and running.

One of the services has failed. Check the Presentation Server Log - SAWLOG0.LOG file in the below directory:

/Middleware/instances/instance1/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1

Output from SAWLOG0.LOG:

________________________________

[OBIPS] [ERROR:31] [] [saw.security.odbcuserpopulationimpl.searchidentities] [ecid: 0054nnkvcrx5uXSpICc9yf0004nW000000,0:14470] [tid: 3127040] Error retrieving user/group data from Oracle BI Server's User Population API.

Unable to create a system user connection to BI Server while running user population queries

Odbc driver returned an error (SQLDriverConnectW).

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 () or the secondary Cluster Controller () specified for the clustered DSN. (HY000)[[

File:odbcuserpoploaderimpl.cpp

Line:731

Location:

        saw.security.odbcuserpopulationimpl.searchidentities

        saw.security.userpopulationmanagerimpl.searchidentities

        saw.catalog.dirCache.getAllSharedFolders

        saw.CatalogAttributes.cache.cleanup

        saw.taskScheduler.processJob

        taskscheduler

        saw.threads

ecid: 0054nnkvcrx5uXSpICc9yf0004nW000000,0:14470

ThreadID: 3127040

task: Cache/CatalogAttributes

_______________________________________

Check the NQServer.log file in the following link:

/Middleware/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

Output from NQServer.log:

________________________________________

[OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: aeb55720]  [nQSError: 26009] File /Middleware/instances/instance1/config/OracleBIServerComponent/coreapplication_obis1/NQSConfig.INI Near Line 311, Near <">: new line in string.

[OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: bb0b720]  [47012] Syntax error in NQSConfig.ini file.

________________________________________

There is some change done in the NQSConfig file and it is not saved properly.

Make changes in the NQSConfig.INI file in the following directory:

/Middleware/instances/instance1/config/OracleBIServerComponent/coreapplication_obis1

coreapplication_obis1]$ vi NQSConfig.ini

Go to the line number mentioned in the error, in this case Line 311. Check if the correct tags are applied. If not, make the changes, Save and Close the file.

Now, start the OPMN services, it should start. Go to 

/Middleware/instances/instance/bin

bin]$ ./opmnctl  startall