Clarity

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

Is your db available in CSA?

Hi Urmas,

Yes the DB is available in CSA.

Hi Karim - do all the tables exist?  Did the DB import complete successfully?

Hi Jon,

Yes all the tables exist and the DB import did complete successfully. I can query any table in the database.

Regards,

Karim

At first you say
Checking CA again, I found the message "installation incomplete" and Database not connected in CSA installation view page. Not like these

but then you say db is available in CSA.

Looking at your screenshot:

Did you use the recommended collation for the SQL server and

what was you Windows language setting when you did the install?

Can you stop ans start the CSA service, login to CSA and then go to database tab and save the details you will see database showing unavailable. 

I have a SQL server and it works perfectly. You can follow the install and upgrade guide Installing and Upgrading - CA PPM - 15.4 - CA Technologies Documentation 

Hi KarimD

I have the same problem.

Look if your database user set as sysadmin, uncheck this option and try again. (SQL Server -> Security -> login -> niku -> Properties)

Installation issue with Clarity 13.2 w/ SQL Server 2012 

Thank you all,

I have fixed this issue by deleting and recreating the database.

Regards,

Karim