Possible Resolution 1: Note: This is unsupported code provided as a convenience by Automic's PST. Run the following sql statement to update the existing custom function. **There should be no expectation of this code working in future upgrades or that future updates will be provided.
Login to sqlplus with your App Mgr schema owner to run the script: CREATE OR REPLACE Function GetRAXMLAttr ( rowid_in IN rowid, table_in IN varchar2, attr_in IN varchar2 ) RETURN varchar2ISpragma autonomous_transaction;xmll long;AttrStart number;AttrValue varchar2(2048);BEGIN CASE upper(table_in) WHEN 'AW_CHAIN_DETAIL_XML' THEN select EXTRACTVALUE(xmltype(aw_comp_xml_clob), '/data/job/@'||attr_in) into xmll from AW_CHAIN_DETAIL_XML where rowid = rowid_in; WHEN 'AW_JOB_QUEUE_XML' THEN select EXTRACTVALUE(xmltype(aw_job_xml_clob), '/data/job/@'||attr_in) into xmll from AW_JOB_QUEUE_XML where rowid = rowid_in; WHEN 'AW_MODULE_XML' THEN select EXTRACTVALUE(xmltype(aw_job_xml_clob), '/data/job/@'||attr_in) into xmll from AW_MODULE_XML where rowid = rowid_in; WHEN 'SO_OPERATORS' THEN select EXTRACTVALUE(xmltype(so_xml_clob), '/data/job/@'||attr_in) into xmll from SO_OPERATORS where rowid = rowid_in; ELSE select EXTRACTVALUE(xmltype(aw_job_xml_clob), '/data/job/@'||attr_in) into xmll from AW_MODULE_XML where rowid = rowid_in; END CASE; AttrValue := xmll; RETURN AttrValue;EXCEPTIONWHEN OTHERS THEN raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM);END;/
Possible Resolution 2. If a custom runtime extension script exists, check the script to see if it calls awprint. If so, rename the custom script so that it won't be used. To determine if you are using a custom script that calls awprint, look in the Banner Agent working directory for files named RA.COMPLETION*
ls -l RA.COMPLETION*
If any are found, review them for code that includes awprint, similar to this:
# Update return code in so_job_queue table
$AW_HOME/c/awexe gso_upd_so_rc var_value=$exitCode so_jobid=$jobid
# Start Output Registration
################################################################################
echo ${5}
if [ "$awprint_registration" = "TRUE" ]
then
. $AW_HOME/site/sosite
echo Output Files
ls $HOME/*_${5}*
ls $HOME/*_${5}*|while read file
do
$AW_HOME/c/awprint PRINT -n $file -d $HOME -j $jobid
done
fi
# End Output Registration
################################################################################
-Rename the files that contain awprint
-Edit Banner jobs/process flow components - go to Banner tab. If the Output Search Pattern field is null, click the 'Reset Defaults' button to populate the field with the delivered value. Say OK to save changes.
Note: If you are working with job capture, then edit your capture template to confirm these values.