Unable to validate Credential and Server Configuration no space for WCC storage
Article ID: 228204
Updated On:
Products
Issue/Introduction
We have two scheduler server version 1136SP8 CUM1 running on a HA mode. Recently, we found out that we had an issue with the WCC :-
E139012 Autosys error response:E180011 Login failed using: User=autosys Password= <hidden>
E131003 Error loading the job: E180010 Could not establish a connection to CA Workload Automation AE; invalid server context.
We tried to update the user ID in both credential tab and Configuration tab. But we encountered failure.
We had checked the log, and we found out that the WCC Database was full. We want to know, what was stored in the sysaux01.dbf
Environment
Release :R12
Component : UWCC Workload Control Center
Resolution
Exception:
Internal Exception: java.sql.BatchUpdateException: ORA-01653: unable to extend table WCCDBO.CFG_USER_PREF by 8 in tablespace WCCTS
Internal Exception: java.sql.BatchUpdateException: ORA-01654: unable to extend index WCCDBO.INDEX_MON_JOB_OWNER by 128 in tablespace WCCTS
Tablespace issue for WCCTS, because it reached its allotted space.
Solution needs to be performed by DBA to autoextend tthe maxsize
Additional Information
https://stackoverflow.com/questions/27129376/ora-01653-unable-to-extend-table-by-in-tablespace-ora-06512
Feedback
