AnsweredAssumed Answered

Clarity 13.2 upgrade on multiple servers: LocalTenant instance issue

Question asked by whole_milk on Oct 4, 2013
Latest reply on Apr 17, 2016 by Robert Ensinger
Team,

We have app servers 1, 2 and 3.

App 1 has the nsa and is the main in the cluster.

All three have been upgraded to 13.2 and they look good in NSA.

App 1 URL is working and App 3 is working. App 2 does not.

It says:
[color]HTTP Status 500 -

Message

Description

The server encountered an internal error that prevented it from fulfilling this request.[color]

On reviewing the app ca and system logs, the message it has is as follows (and DB says available in app server 2 on nsa) and I'm at my wit's end :*) Any thoughts?


SYS 2013-10-04 16:36:40,658 [http-bio-80-exec-2] niku.union (none:none:none:none) Clarity 13.2.0.472 initializing...
WARN 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none)
WARN 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Could not verify database connection for Local TenantInstance with id = clarity marking as an invalid configuration.
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) ==================================================================
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) ==================================================================
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) CLARITY

SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: id: clarity
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: appId: app
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: bgId: bg
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: fileDirectory: tenantDirectory
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: status: invalid
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Properties/Database: id: clarity
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Properties/Database: serviceId: ORAU36
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Properties/Database: driver: com.ca.clarity.jdbc.oracle.OracleDriver
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Properties/Database: url: jdbc:clarity:oracle://ORAU36:1521;SID=ORAU36;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Properties/Database: username: WARM01
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Properties/Database: schemaName: WARM01
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Properties/Database: serviceName: ORAU36
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Properties/Database: vendor: oracle
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Properties/Database: largeIndex: WARM01_I001
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Properties/Database: smallIndex: WARM01_I001
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Properties/Database: largeTables: WARM01_D001
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Properties/Database: smallTables: WARM01_D001
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) ==================================================================
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Tenants for this Application with instance id = app :
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) ==================================================================
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) Active Tenants:
SYS 2013-10-04 16:36:40,720 [http-bio-80-exec-2] config.TenantConfigurationManager (none:none:none:none) ==================================================================
ERROR 2013-10-04 16:36:40,720 [http-bio-80-exec-2] niku.union (none:none:none:none) Clarity 13.2.0.472 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.

Outcomes