No tabs displaying after fresh installing WCC

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - System Agent (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent
• CA 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.
         
         Wccuser and password are given as example.

Additional Information

Please look into Database Consideration:

http://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/intelligent-automation/workload-automation-ae-and-workload-control-center/11-3-
6-SP8/installing/ca-wcc-installation/install-the-ca-wcc-server-on-unix.html