WCC Quick Edit Tab does not work - 404 Not Found Error

Products

• Autosys Workload Automation

Issue/Introduction

The Quick Edit tab in the Workload Automation WebUI (WCC) is not working, displaying a 404 Not Found error.

 

Below error is seen in /opt/CA/WorkloadAutomationAE/wcc/log/application/quickedit/quickedit.log 

2025-05-17 22:12:15,766 @quickedit <Catalina-utility-4> [] ERROR #EditorInitializationUtils          #(73) Cannot initialize dynamic object types javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.10.v20211216-fe64cd39c3): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Error Code: 942
Call: SELECT CATEGORY, DESCRIPTION, IMAGE16, IMAGE32, LAST_IMPORT_TIME, META_DATA, NAME, SERVER_META_VERSION, UI_META_VERSION, UI_TREE_PATH, TYPE, OBJECT_TYPE FROM DYN_OBJ_TYPE ORDER BY UI_TREE_PATH ASC, LOWER(NAME) ASC
Query: ReadAllQuery(name="DynamicObject.getAll" referenceClass=DynamicObject sql="SELECT CATEGORY, DESCRIPTION, IMAGE16, IMAGE32, LAST_IMPORT_TIME, META_DATA, NAME, SERVER_META_VERSION, UI_META_VERSION, UI_TREE_PATH, TYPE, OBJECT_TYPE FROM DYN_OBJ_TYPE ORDER BY UI_TREE_PATH ASC, LOWER(NAME) ASC")
        at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:391)
        at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:264)
        at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:482)
        at com.ca.wcc.integration.dao.DynamicObjectDaoImpl.getAll(Unknown Source)
 

Environment

Workload Automation AutoSys

Cause

The issue is caused by missing database grants for the WCC user (wcc) on the DYN_OBJ_TYPE table within the wccadmin schema.

Resolution

Grant access to the WCC user by executing the following SQL statement against the database (as the wccadmin database user) :

GRANT SELECT, INSERT, UPDATE, DELETE, ALTER ON wccadmin.DYNOBJTYPE TO wcc;

Note: While not required, restarting the WCC is recommended to ensure the changes take effect and the Quick Edit tab functions correctly.