OBIEE 12c: Installation Fails at Config Step: "Failed to build JDBC Connection object"

(Doc ID 2319596.1)

Last updated on NOVEMBER 10, 2017

Applies to:

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

Symptoms

On Business Intelligence Suite Enterprise Edition : 12.2.1.3.0 version, Analytics.

Configuration of version 12.2.1.3.0.

MS Windows OS for BIEE server.

From wlst_biee.log:
===============
2017-10-18 15:35:58,936 SEVERE [1] com.oracle.cie.domain.jdbc.CommonDBHelper - Failed to build JDBC Connection object:
java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME
at weblogic.jdbc.sqlserverbase.ddcw.b(Unknown Source)

From biee.log:
============
Extending domain with BIEE Suite template
Configuring datasources ...
Setting JDBC url to jdbc:weblogic:sqlserver://OBIX-SQL:1433 databaseName BI_RCU_OBI
Deleting old user of type Property
Creating user of type Property at /JDBCSystemResource/LocalSvcTblDataSource/JdbcResource/LocalSvcTblDataSource/JDBCDriverParams/NO_NAME_0/Properties/NO_NAME_0
Master STB data source defined
Error: getDatabaseDefaults() failed. Do dumpStack() to see details.
Error: runCmd() failed. Do dumpStack() to see details.
Failed to build JDBC Connection object:


From install2017-10-18_03-32-18PM.log
================================
[2017-10-18T15:34:16.191+02:00] [bi] [NOTIFICATION] [] [oracle.bi.exec] [tid: 50] [ecid: 0000LwjgHTYC^qWFLzMMOA1PtpVd000004,0] Logging script stderr and stdout to C:\Program Files\Oracle\Inventory\logs\config2017-10-18_03-32-18PM\createExpandedDomain.log
[2017-10-18T15:35:04.220+02:00] [bi] [NOTIFICATION] [] [oracle.bi.install.config.basesteps] [tid: 50] [ecid: 0000LwjgHTYC^qWFLzMMOA1PtpVd000004,0] Executing Step: BIEE
[2017-10-18T15:35:04.221+02:00] [bi] [NOTIFICATION] [] [oracle.bi.install.config.basesteps] [tid: 50] [ecid: 0000LwjgHTYC^qWFLzMMOA1PtpVd000004,0] See log file: C:\Program Files\Oracle\Inventory\logs\config2017-10-18_03-32-18PM\biee.log
[2017-10-18T15:35:04.228+02:00] [bi] [NOTIFICATION] [] [oracle.bi.exec] [tid: 50] [ecid: 0000LwjgHTYC^qWFLzMMOA1PtpVd000004,0] Executing: [cmd, /c, D:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\oracle_common\common\bin\wlst.cmd, D:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\bi\modules\oracle.bi.configassistant\biee.py, D:\Oracle\Middleware\Oracle_Home\bi\bin\..\.., D:\Oracle\user_projects\domains\bi, weblogic, Expanded, OBIX, 9502, 9503, SQLSERVER, weblogic.jdbc.sqlserver.SQLServerDriver, "jdbc:weblogic:sqlserver://OBIX-SQL:1433;databaseName=BI_RCU_OBI", PRD, "jdbc:weblogic:sqlserver://OBIX-SQL:1433;databaseName=BI_RCU_OBI", ]
[2017-10-18T15:35:04.228+02:00] [bi] [NOTIFICATION] [] [oracle.bi.exec] [tid: 50] [ecid: 0000LwjgHTYC^qWFLzMMOA1PtpVd000004,0] Logging script stderr and stdout to C:\Program Files\Oracle\Inventory\logs\config2017-10-18_03-32-18PM\biee.log
[2017-10-18T15:35:59.078+02:00] [bi] [NOTIFICATION] [] [oracle.bi.install.config.basesteps] [tid: 50] [ecid: 0000LwjgHTYC^qWFLzMMOA1PtpVd000004,0] Failed single shot step: BIEE with: Execution of [cmd, /c, D:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\oracle_common\common\bin\wlst.cmd, D:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\bi\modules\oracle.bi.configassistant\biee.py, D:\Oracle\Middleware\Oracle_Home\bi\bin\..\.., D:\Oracle\user_projects\domains\bi, weblogic, Expanded, OBIX, 9502, 9503, SQLSERVER, weblogic.jdbc.sqlserver.SQLServerDriver, "jdbc:weblogic:sqlserver://OBIX-SQL:1433;databaseName=BI_RCU_OBI", PRD, "jdbc:weblogic:sqlserver://OBIX-SQL:1433;databaseName=BI_RCU_OBI", ] failed with exit value 1
[2017-10-18T15:35:59.079+02:00] [bi] [ERROR] [] [oracle.bi.install.config.actions] [tid: 50] [ecid: 0000LwjgHTYC^qWFLzMMOA1PtpVd000004,0] Non-skipped failure during configuration action: Execution of [cmd, /c, D:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\oracle_common\common\bin\wlst.cmd, D:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\bi\modules\oracle.bi.configassistant\biee.py, D:\Oracle\Middleware\Oracle_Home\bi\bin\..\.., D:\Oracle\user_projects\domains\bi, weblogic, Expanded, OBIX, 9502, 9503, SQLSERVER, weblogic.jdbc.sqlserver.SQLServerDriver, "jdbc:weblogic:sqlserver://OBIX-SQL:1433;databaseName=BI_RCU_OBI", PRD, "jdbc:weblogic:sqlserver://OBIX-SQL:1433;databaseName=BI_RCU_OBI", ] failed with exit value 1[[
oracle.bi.exec.ExecutionStatusException: Execution of [cmd, /c, D:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\oracle_common\common\bin\wlst.cmd, D:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\bi\modules\oracle.bi.configassistant\biee.py, D:\Oracle\Middleware\Oracle_Home\bi\bin\..\.., D:\Oracle\user_projects\domains\bi, weblogic, Expanded, OBIX, 9502, 9503, SQLSERVER, weblogic.jdbc.sqlserver.SQLServerDriver, "jdbc:weblogic:sqlserver://OBIX-SQL:1433;databaseName=BI_RCU_OBI", PRD, "jdbc:weblogic:sqlserver://OBIX-SQL:1433;databaseName=BI_RCU_OBI", ] failed with exit value 1
at oracle.bi.exec.StdinProcess.runProcess(StdinProcess.java:99)

 

 

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