Error Message ORA-01400 when trying to make changes on an Agent

Document ID : KB000088534
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message ORA-01400 when trying to make changes on an Agent
Resolution:
Detailed Description and Symptoms
 
The following behavior was seen in Applications Manager version 7.x and 8.0:
 
When trying to delete or make changes to an Agent definition, Applications Manager throws an error message like the following and the changes cannot be saved:

java.sql.SQLException: ORA-01400: cannot insert NULL into ("APPWORX"."AW_AUDIT_REPORTS_TABLE"."KEY1")  
 
 
Investigation
 
Serveral 'AwE-5001 Database Query Error'  messages can be seen in the RmiServer log file, including the one that shows the error in detail:
 
java.sql.SQLException: ORA-01400: cannot insert NULL into ("APPWORX"."AW_AUDIT_REPORTS_TABLE"."KEY1")
ORA-06512: at "APPWORX.AUDIT_SO_ROLE_DETAIL", line 52
ORA-04088: error during execution of trigger 'APPWORX.AUDIT_SO_ROLE_DETAIL'
ORA-06512: at "APPWORX.SQLOPER_SO_OPERATOR_TRIGGER", line 11
ORA-04088: error during execution of trigger 'APPWORX.SQLOPER_SO_OPERATOR_TRIGGER'
ORA-06512: at "APPWORX.AW_WEB_API", line 1550
ORA-06512: at "APPWORX.AW_WEB_API", line 1248
ORA-06512: at line 1 
 
Solution
 
There is a workaround available:
 
1. Disable Auditing
 - see chapter '4.6 Enabling Applications Manager Auditing' in the manual
2. Make the desired changes on the Agent
3. Enable Auditing