Error when making changes in GUI

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Error when making changes in GUI

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

Symptoms

?Error Code ORA-12801 thrown when user tries to change nearly anything in the GUI. Sometimes followed by many more error codes, as seen in this example:

 
java.sql.SQLException: ORA-12801: error signaled in parallel query server P004,

ORA-01460: unimplemented or unreasonable conversion requested
ORA-06512: at "APPWORX.SO_CHAIN_ARGS_SUBVAR_REF_STMT", line 26
ORA-04088: error during execution of trigger 'APPWORX.SO_CHAIN_ARGS_SUBVAR_REF_STMT'
ORA-06512: at "APPWORX.AWAPI", line 2824
ORA-06512: at "APPWORX.AWAPI", line 2746
ORA-06512: at "APPWORX.AWAPI3", line 2000
ORA-06512: at "APPWORX.AWAPI3", line 2101
ORA-06512: at "APPWORX.AW_WEB_API", line 2711
ORA-06512: at line 1

Cause

?This error code is generally thrown when the database has too many parallel processes working at once and trying to update the same thing, however this is a fairly generic message. This is a an Oracle issue.

Solution

Generally the DBA or Oracle Admin will have to review this issue for a fix. ?