Error when making changes in GUI

Document ID : KB000090408
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error when making changes in GUI
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. ?