During the upgrade process the installation fails with an import error

Document ID : KB000088810
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
During the upgrade process the installation fails with an import error
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

Please contact Support for a proper diagnosis and a resolution to this issue.?