Error: FAILED: file csrrsreg.sql on worker 1.

Issue while applying R12.1.3 upgrade patches

 

Error: 

 

FAILED: file csrrsreg.sql on worker 1.

 

Solution:

 

    1. Make the following change to the file csrrsreg.sql.
        Original:
        EXCEPTION
        WHEN OTHERS THEN
        dbms_output.put_line('Registering Scheduler Rules XML Schema failed with an error ' || SQLERRM);
        END;

        Changed to:
        EXCEPTION
        WHEN OTHERS THEN
        dbms_output.put_line(SUBSTR(('Registering Scheduler Rules XML Schema failed with an error ' || SQLERRM), 1, 250));
        END;

    2. Run the script csrrsreg.sql manually from SQL.
        Location    :$CSR_TOP/patch/115/sql/csrrsreg.sql
        Execute the script - csrrsreg.sql as done earlier to re-register the Scheduler Rules XML Schema.
        The following are the input parameters for the script:
        &1 -> apps schema user name(apps)
        &2 -> apps schema password(apps)
        &3 -> csr schema user name(csr)
        &4 -> csr schema password(csr)
        &5 -> value of $CSR_TOP(location)
 
  3. Continue with the patch to upgrade to 12.1.3