ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 88534

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

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

Environment

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

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