Error While Trying To Open The Repository Online: "No ODBC system Data Source is defined for Oracle BI Server. Please set it up first." (Doc ID 2162700.1)

Last updated on SEPTEMBER 20, 2016

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When opening the BI admin tool online and clicking on the open a Repository online button,  getting the following error:
"No ODBC system Data Source is defined for Oracle BI Server. Please set it up first."

If go to System DSN and put in the details there it throws the below give error:

"[nQsError:46215] The ODBC DSN is centrally managed but the environment variables DOMAIN_HOME or ORACLE_BI_CONFIG_DIR are not set"

At the same time able to connect via DSN from other server where OBIEE Client Admin tool is installed.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms