ORA-04088: error during execution of trigger 'APPWORX.AUDIT_SO_USER_TABLE' ORA-04063: package body "

Document ID : KB000089312
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
ORA-04088: error during execution of trigger 'APPWORX.AUDIT_SO_USER_TABLE' ORA-04063: package body "
Resolution:
Detailed Description and Symptoms
 
We recently upgraded our dev databse to 11G. After we did this appworx didn't work anymore so we try to re-install our current version but that didn't work. So I downloaded the newest version and tried running an AWINSTALL, but I keep getting the error below. Do you know what I need to do to fix this?errors=ORA-04063: package body "APPWORX.AWAPI2" has errors ORA-06508: PL/SQL: could not find program unit being called: "APPWORX.AWAPI2" ORA-06512: at "APPWORX.AUDIT_SO_USER_TABLE", line 21 ORA-04088: error during execution of trigger 'APPWORX.AUDIT_SO_USER_TABLE' ORA-04063: package body "APPWORX.AWAPI2" has errors ORA-06508: PL/SQL: could not find program unit being called: "APPWORX.AWAPI2" ORA-06512: at line 4 ORA-04063: package body "APPWORX.AWAPI2" has errors ORA-06508: PL/SQL: could not find program unit being called: "APPWORX.AWAPI2" ORA-06512: at line 1 ORA-04063: package body "APPWORX.AWAPI2" has errors ORA-06508: PL/SQL: could not find program unit being called: "APPWORX.AWAPI2" ORA-06512: at "APPWORX.CHECK_OBJECTS", line 13 ORA-06512: at line 1 Fatal error trying to execute script aw_post_checks

Investigation

Investigation goes here


Solution

Delete the extract_file.dat file from $AW_HOME/data and run cdinst.sh again. This should recompile the packages to work correctly with 11.2.0.2