Oracle BI Scheduler Error: [nqSError:76015]

Oracle BI Scheduler Error: [nqSError:76015]. The active Oracle BI Scheduler instance in the cluster could not be determined

This solution applies to Oracle Business Intelligence Server Enterprise Edition - Version 11.1.1.7 and later

The above error appears when a user is unable to save and edit an iBOT/Agent job

This is because the data source details are incorrect and not matching with the data connection from tnsnames.ora file

To resolve the error,

1.       Log in to Enterprise Manager

2.       Navigate to coreapplication

3.       Open the Deployment tab and navigate to scheduler

4.       Lock and Edit configuration

5.       Copy connection details from tnsnames.ora file
NB Don’t include the TNS alias, only copy the connection string after the equal (=) sign. Spaces are OK:
For example:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server.domain)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))
Paste it under data source under scheduler tab

6.      Activate changes and then restart services to make changes visible.