CA Workload Automation AE - Business Agents (AutoSys)CA Workload Automation AE - System Agent (AutoSys)CA Workload Automation AE - Scheduler (AutoSys)Workload Automation AgentCA Workload Automation AE
Issue/Introduction
After installing WCC and logging in, no content is displayed on the WCC page.
The following error is seen in the $CA_WCC_INSTALLATION_LOCATION/log/wcc.log file:
Exception Description: Error preallocating sequence numbers. The sequence table information is not complete. INFO | jvm 1 | 20xx/xx/xx 12:54:22 | 194 | at org.eclipse.persistence.exceptions.DatabaseException.errorPreallocatingSequenceNumbers(DatabaseException.java:143)
Cause
The WCC database user did not have CREATE SEQUENCE permissions while creating DB for WCC.
Environment
Release : 11.3.6
Component : CA Workload Automation AE (AutoSys)
Release: R11.4 SP*
Resolution
Grant the WCC DB user CREATE SEQUENCE permissions and then reinstall WCC to repair the instance:
1. Uninstall WCC 2. Use the below sql (create wcc user and password with privileges)
CREATE USER wccuser IDENTIFIED BY 'password' DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP; grant CONNECT, CREATE TABLE, CREATE SEQUENCE to wccuser; ALTER USER wccuser QUOTA UNLIMITED ON USERS;
3. Install WCC and While installing when it prompts for user and password for DB creation provide those you have created.
Note: Above Query is an example query changes with different DBs. Need to work with your DBAs to get exact query.