Upgrades/new install of clarity 16.03 fails to start when using JDBC URL under Database in CSA
STEPS TO REPRODUCE:
Expected Results: The upgrade should be successful
Actual Results: The upgrades fails with below error in the install.log
(ExecTask) java.sql.SQLException: Driver:oracle.jdbc.driver.OracleDriver@151335cb returned null for URL:jdbc:clarity:oracle://example.com:1521;SID=CLARITY;
BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true;ConnectionRetryCount=400;ConnectionRetryDelay=3;
Expected Results: Clarity app services should start successfully
Actual Results: Clarity app services fails to start and below error is seen in app ca log
SYS 2022-08-05 12:29:40,902 [WrapperStartStopAppMain] niku.union (none:none:none:none) Clarity 16.0.3.1009 initializing...
WARN 2022-08-05 12:29:41,016 [WrapperStartStopAppMain] config.TenantConfigurationManager (none:none:none:none) null
WARN 2022-08-05 12:29:41,016 [WrapperStartStopAppMain] config.TenantConfigurationManager (none:none:none:none) Could not verify database connection for Local TenantInstance with id = clarity marking as an invalid configuration.
SYS 2022-08-05 12:29:41,017 [WrapperStartStopAppMain] config.TenantConfigurationManager (none:none:none:none) ==================================================================
SYS 2022-08-05 12:29:41,017 [WrapperStartStopAppMain] config.TenantConfigurationManager (none:none:none:none) ==================================================================
SYS 2022-08-05 12:29:41,017 [WrapperStartStopAppMain] config.TenantConfigurationManager (none:none:none:none) CLARITY
SYS 2022-08-05 12:29:41,017 [WrapperStartStopAppMain] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: id: clarity
SYS 2022-08-05 12:29:41,018 [WrapperStartStopAppMain] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: appId: app
SYS 2022-08-05 12:29:41,018 [WrapperStartStopAppMain] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: bgId: bg
SYS 2022-08-05 12:29:41,018 [WrapperStartStopAppMain] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: fileDirectory: tenantDirectory
SYS 2022-08-05 12:29:41,018 [WrapperStartStopAppMain] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: status: invalid
SYS 2022-08-05 12:29:41,029 [WrapperStartStopAppMain] config.TenantConfigurationManager (none:none:none:none) ==================================================================
SYS 2022-08-05 12:29:41,029 [WrapperStartStopAppMain] config.TenantConfigurationManager (none:none:none:none) Tenants for this Application with instance id = app :
SYS 2022-08-05 12:29:41,029 [WrapperStartStopAppMain] config.TenantConfigurationManager (none:none:none:none) ==================================================================
SYS 2022-08-05 12:29:41,029 [WrapperStartStopAppMain] config.TenantConfigurationManager (none:none:none:none) Active Tenants:
SYS 2022-08-05 12:29:41,029 [WrapperStartStopAppMain] config.TenantConfigurationManager (none:none:none:none) ==================================================================
ERROR 2022-08-05 12:29:41,030 [WrapperStartStopAppMain] niku.union (none:none:none:none) Clarity 16.0.3.1009 failed to initialize.
com.niku.union.config.ConfigurationException: The application failed to start because of a database configuration problem. Please review the application log for specific error information.
at com.niku.union.config.ConfigurationManager.initAppServerType(ConfigurationManager.java:4426)
at com.niku.union.config.ConfigurationManager.initAppServerIntern(ConfigurationManager.java:4362)
at com.niku.union.config.ConfigurationManager.initAppServer(ConfigurationManager.java:4343)
at com.niku.union.web.WebControlServlet.init(WebControlServlet.java:154)
at javax.servlet.GenericServlet.init(GenericServlet.java:158)
Release : 16.0.3
Component : Clarity Install and Upgrade
DE66146 & DE66171
URL Format for native drivers with different database vendors
Important Information: For Customer using SSL in the database parameters