AnsweredAssumed Answered

Installation issue with Clarity 15.4 with SQL server 2012

Question asked by KarimD on Apr 5, 2018
Latest reply on Apr 12, 2018 by KarimD

Hi all,

 

I am performing an install of Clarity 15.4 on Windows, SQL server 2012 using a new database. After installing, configuring database tab in CSA which did work, and also checking ODBC configuration( it did work properly) but Calrity application is not working. Checking CA again, I found the message "installation incomplete" and Database not connected in CSA installation view page.

 

These are the erros found on the app-ca.log file:

SYS   2018-04-05 18:19:11,520 [localhost-startStop-1] niku.union (none:none:none:none) Clarity 15.4.0.270 initializing...
WARN  2018-04-05 18:19:12,692 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) [CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid object name 'CMN_INSTALL_HISTORY'.
WARN  2018-04-05 18:19:12,692 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Could not verify database connection for Local TenantInstance with id = clarity marking as an invalid configuration.
SYS   2018-04-05 18:19:12,692 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) ==================================================================
SYS   2018-04-05 18:19:12,692 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) ==================================================================
SYS   2018-04-05 18:19:12,692 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) CLARITY

SYS   2018-04-05 18:19:12,692 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: id: clarity
SYS   2018-04-05 18:19:12,692 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: appId: app
SYS   2018-04-05 18:19:12,692 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: bgId: bg
SYS   2018-04-05 18:19:12,692 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: fileDirectory: tenantDirectory
SYS   2018-04-05 18:19:12,692 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Tenants: TenantInstance: status: invalid
SYS   2018-04-05 18:19:12,692 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/Database: id: clarity
SYS   2018-04-05 18:19:12,692 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/Database: serviceId: niku1
SYS   2018-04-05 18:19:12,692 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/Database: driver: com.ca.clarity.jdbc.sqlserver.SQLServerDriver
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/Database: url: jdbc:clarity:sqlserver://10.202.32.8:1433;DatabaseName=niku1;InsensitiveResultSetBufferSize=0;ProgramName=Clarity
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/Database: username: niku
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/Database: schemaName: niku1
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/Database: serviceName: niku
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/Database: vendor: mssql
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/Database: largeIndex: INDX_LARGE
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/Database: smallIndex: INDX_SMALL
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/Database: largeTables: USERS_LARGE
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/Database: smallTables: USERS_SMALL
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/dwhDatabaseServer/Database: id: clarity_dwh
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/dwhDatabaseServer/Database: serviceId: niku
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/dwhDatabaseServer/Database: driver: com.ca.clarity.jdbc.oracle.OracleDriver
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/dwhDatabaseServer/Database: url: jdbc:clarity:oracle://localhost:1521;SID=niku;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/dwhDatabaseServer/Database: username: ppm_dwh
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/dwhDatabaseServer/Database: schemaName: ppm_dwh
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/dwhDatabaseServer/Database: serviceName: niku
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/dwhDatabaseServer/Database: vendor: oracle
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/dwhDatabaseServer/Database: clarityDBLink: PPMDBLINK
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/dwhDatabaseServer/Database: factIndex: DWH_PPM_INDX_FACT
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/dwhDatabaseServer/Database: dimensionIndex: DWH_PPM_INDX_DIM
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/dwhDatabaseServer/Database: factTables: DWH_PPM_DATA_FACT
SYS   2018-04-05 18:19:12,707 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Properties/dwhDatabaseServer/Database: dimensionTables: DWH_PPM_DATA_DIM
SYS   2018-04-05 18:19:12,723 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) ==================================================================
SYS   2018-04-05 18:19:12,723 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Tenants for this Application with instance id = app :
SYS   2018-04-05 18:19:12,723 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) ==================================================================
SYS   2018-04-05 18:19:12,723 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) Active Tenants:
SYS   2018-04-05 18:19:12,723 [localhost-startStop-1] config.TenantConfigurationManager (none:none:none:none) ==================================================================
ERROR 2018-04-05 18:19:12,723 [localhost-startStop-1] niku.union (none:none:none:none) Clarity 15.4.0.270 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:4097)
 at com.niku.union.config.ConfigurationManager.initAppServerIntern(ConfigurationManager.java:4030)
 at com.niku.union.config.ConfigurationManager.initAppServer(ConfigurationManager.java:4009)
 at com.niku.union.web.WebControlServlet.init(WebControlServlet.java:154)
 at javax.servlet.GenericServlet.init(GenericServlet.java:158)
 at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)
 at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)
 at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)
 at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)
 at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)
 at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
 at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1419)
 at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1409)
 at java.util.concurrent.FutureTask.run(FutureTask.java:266)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
 at java.lang.Thread.run(Thread.java:748)

 

 

Thank you for your help or guidance to resolve this issue.

 

Regards,

Karim

Outcomes