12.2 - The ademusr.sql Script Fails Applying E-Business Suite Patch 18491990 With Message 'AD Worker error: AD Worker does not support the command BEGIN; Error occurred in file PATH/ademusr.sql
(Doc ID 2099429.1)
Last updated on FEBRUARY 24, 2024
Applies to:
Oracle Applications DBA - Version 12.2 to 12.2.5 [Release 12.2Cloud to 12.2]Information in this document applies to any platform.
Symptoms
E-Business Suite 12.2.4, Upgrade related issues
Installation of <Patch 18491990> errors running SQL and EXEC commands in parallel. The patch logs contain the following error messages:
ERROR
-----------------------
1. File Name = u18491990.log
=========================================
ATTENTION: All workers either have failed or are waiting:
FAILED: file ademusr.sql on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Current time is: Fri Jan 22 2016 04:34:17
2. File Name = adwork001.log
=========================================
**** Reseting package states in the current session ****
sql <EBS_BASE>/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/ademusr.sql &systempwd &un_fnd &pw_fnd &un_apps &pw_apps
Set the Module name & Client id successfully for file 'ademusr.sql'
Start time for statement below is: Fri Jan 22 2016 04:34:16
CONNECT SYSTEM/*****
Connecting to SYSTEM......Connected successfully.
AD Worker error:
AD Worker does not support the command BEGIN
Error occurred in file
<EBS_BASE>/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/ademusr.sql
with arguments '&systempwd &un_fnd &pw_fnd &un_apps &pw_apps'.
Time when worker failed: Fri Jan 22 2016 04:34:17
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply <Patch 18491990
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |