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)
Environment
Release : 11.3.6
Component : CA Workload Automation AE (AutoSys)
Release: R11.4 SP*
Cause
The WCC database user did not have CREATE SEQUENCE permissions while creating DB for WCC.
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.