AnsweredAssumed Answered

Installation issue with Clarity 13.2 w/ SQL Server 2012

Question asked by amrahman on May 29, 2013
Latest reply on Apr 4, 2014 by Kumu002
Hi everyone,

I'm performing a clean install of Clarity 13.2 on Win2008r2 with SQL Server 2012 sp1.

I've been able to run the install.bat file, but now at CSA, I'm getting db connection issues and I'm unable to install the database.
I'm getting the following errors as per the log file:
SYS   2013-05-29 11:12:16,293 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) ==================================================================
SYS   2013-05-29 11:12:16,293 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Tenants for this Application with instance id = nsa :
SYS   2013-05-29 11:12:16,309 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) ==================================================================
SYS   2013-05-29 11:12:16,309 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) ==================================================================
SYS   2013-05-29 11:12:16,309 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) CLARITY

SYS   2013-05-29 11:12:16,309 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: id: clarity
SYS   2013-05-29 11:12:16,309 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: appId: app
SYS   2013-05-29 11:12:16,309 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: bgId: bg
SYS   2013-05-29 11:12:16,309 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: fileDirectory: tenantDirectory
SYS   2013-05-29 11:12:16,309 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: status: valid
SYS   2013-05-29 11:12:16,309 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Properties/Database: id: clarity
SYS   2013-05-29 11:12:16,309 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Properties/Database: serviceId: niku
SYS   2013-05-29 11:12:16,309 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Properties/Database: driver: com.ca.clarity.jdbc.sqlserver.SQLServerDriver
SYS   2013-05-29 11:12:16,309 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Properties/Database: url: jdbc:clarity:sqlserver://W2003CLARITY:1433;DatabaseName=niku;InsensitiveResultSetBufferSize=0;ProgramName=Clarity
SYS   2013-05-29 11:12:16,309 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Properties/Database: username: testuser
SYS   2013-05-29 11:12:16,309 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Properties/Database: schemaName: niku
SYS   2013-05-29 11:12:16,309 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Properties/Database: serviceName: clarity
SYS   2013-05-29 11:12:16,325 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Properties/Database: vendor: mssql
SYS   2013-05-29 11:12:16,325 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Properties/Database: largeIndex: INDX_LARGE
SYS   2013-05-29 11:12:16,325 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Properties/Database: smallIndex: INDX_SMALL
SYS   2013-05-29 11:12:16,325 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Properties/Database: largeTables: USERS_LARGE
SYS   2013-05-29 11:12:16,325 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Properties/Database: smallTables: USERS_SMALL
SYS   2013-05-29 11:12:16,325 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) ==================================================================
SYS   2013-05-29 11:12:16,325 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Active Tenants: clarity
SYS   2013-05-29 11:12:16,325 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) ==================================================================
WARN  2013-05-29 11:12:16,340 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Found invalid database connection for local tenant clarity
WARN  2013-05-29 11:14:16,346 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Found invalid database connection for local tenant clarity
WARN  2013-05-29 11:15:11,838 [http-bio-8090-exec-30] niku.nsa (clarity:sa:eyj32BvXL+MXVXfh1aXnP1RJJneDNvjMtjA/9ODMN2I0:nsa.properties.database.save) Unable to persist configuration properties to database. Likely cause is database properties are not yet set or misconfigured.
Logs indicate there is a misconfigured entry in the Database Properties in the Admin section.
I've added a login in SQL Server 2012 called "niku" along with a password, and I've also created a System DSN entry and am able to connect via the DSN.
I've also imported the provided mssql_base.db from the install media and associated the role with my newly created SQL Server login.

To my knowledge, I've checked & cross-checked the values and can't find out why it's not connecting or if I've missed out any steps.

Appreciate any help - thanks!

Outcomes