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.

During the upgrade process the installation fails with an import error

book

Article ID: 88810

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

During the upgrade process the installation fails with an import error

Environment

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

Resolution

Detailed Description and Symptoms


During the upgrade process the installation fails with the following error:



ERROR at line 1:
   ORA-01400: cannot insert NULL into ("AWPROD1"."AW_AUDIT_REPORTS_TABLE"."KEY1")
   ORA-06512: at "AWPROD1.AUDIT_SO_ROLE_DETAIL", line 52
   ORA-04088: error during execution of trigger 'AWPROD1.AUDIT_SO_ROLE_DETAIL'



 IMPORT Failed?



Investigation


In the aw_install.log? the following error is found:



   *
   ERROR at line 1:
   ORA-01400: cannot insert NULL into ("AWPROD1"."AW_AUDIT_REPORTS_TABLE"."KEY1")
   ORA-06512: at "AWPROD1.AUDIT_SO_ROLE_DETAIL", line 52
   ORA-04088: error during execution of trigger 'AWPROD1.AUDIT_SO_ROLE_DETAIL'
   ORA-06512: at "AWPROD1.AW_IMPORT", line 3454
   ORA-06512: at "AWPROD1.AW_IMPORT", line 4370
   ORA-06512: at "AWPROD1.AW_IMPORT", line 4504
   ORA-06512: at line 5
  
  
   IMPORT Failed
*************** Import Failed **********************



Solution


Resolved with v8.0 SP 15 and v9.0.