Workpoint adapter not responding

Document ID : KB000072832
Last Modified Date : 09/03/2018
Show Technical Document Details
Issue:
The import progress to create a universe stuck at "0% in progress". An error "The Workpoint adapter is not responding, perform a Workpoint Checkup" if the universe is opened.

User-added image


User-added image

Performing those below actions throws some more errors:

- Running Workpoint Checkup gives a lot of errors "missing essential workpoint process [xxxx]"
- Running the “Update” function for the Workpoint DB Administration fails with error "Import has failed. Exception is: Invalid TableID. TableID cannot be null!"

User-added image


User-added image

Eurekify logs show:

17:29:40,265 INFO  [stdout] (default task-34) 2018-03-05 17:29:40,265 [default task-34] ERROR com.workpoint.server.pojo.UniqueIDUpdatePvtBean  - spWP_GET_NEW_ID returned null Database value, probably because it cannot find row in WP_INI table for SECTION_NAME='Database' and KEY_NAME='ID', so cannot construct TableID.
..............
..............
17:38:30,140 INFO  [stdout] (Query_actionq#ActionQ1#WPDS) 2018-03-05 17:38:30,140 [Query_actionq#ActionQ1#WPDS] ERROR com.workpoint.server.pojo.GenericServerBean  - Could not find stored procedure 'SPWP_ASSIGN_SCRIPT_MON_ROWS'.
17:38:30,143 ERROR [org.jboss.as.ejb3.invocation] (Query_actionq#ActionQ1#WPDS) JBAS014134: EJB Invocation failed on component MonitorPvt_EJB for method public abstract com.workpoint.common.data.table.ScriptMonitorTable[] com.workpoint.server.pojo.MonitorPvt.queryScriptQMonitors(java.lang.String,java.lang.String,java.math.BigDecimal,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String[],java.lang.String,boolean,java.lang.String,boolean,int,boolean) throws com.workpoint.server.ejb.WorkPointEJBException: com.workpoint.server.ejb.WorkPointEJBException: An SQL Exception has occurred. Please see the server logs for details.
Environment:
Virtual Appliance version 14.1
OS: V-app
External Database: MS SQL 2014
Cause:
XA transaction is enabled and Workpoint DB user has sufficient permission and roles to manipulate the DB. However, the Vapp startup does not seem to be able to create tables, populate rows and stored procedures properly. There are a few Workpoint stored procedures and rows in table WP_INI missing in Workpoint database. The cause of the problem is due to the DB collation is configured incorrectly as Latin1_General_CS_AI
Resolution:
Identity Governance Guide R14.1 stated:

* eurekify_sdb—case-sensitive

* eurekify_ticket—case-sensitive 

* WPDS (Workpoint)—case-insensitive 

* Data Warehouse—case-sensitive 

https://docops.ca.com/ca-identity-governance/14-1/EN/installing/system-requirements 

Dropping and re-creating the Workpoint DB with Latin1_General_CI_AI fixes the issue.

Important note: Depending on business requirement about how data should be sorted and compared, the DB Collation might need to be configured differently to accommodate that. 
The default collation when a standalone IG installation creates the Workpoint database automatically is: SQL_Latin1_General_CP1250_CI_AS