Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Serial number in context file contains lower value than that of database copy.
After a brief search on Oracle Support we found that there is a bug which causes the context file session id's to be not synchronized between RUN and Patch file systems.
Therefore according to the support document (Doc ID 1916658.1), we changed the context file session id of the Patch file system to the same value with the context file of the Run file system.
The variable to be changed is "s_contextserial".
First of all we read the s_contextserial value of the context file of the RUN File System.
. /u01/install/APPS/EBSapps.env RUN
more $CONTEXT_FILE | grep s_contextserial
Then the value which is read can be put into the context file of PATCH File System:
. /u01/install/APPS/EBSapps.env PATCH
vi $CONTEXT_FILE
Full Text of the Error:
[applmgr@T1VSTEBSAPP01 admin]$ adop phase=abort
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Please wait. Validating credentials...
RUN file system context file: /u01/install/APPS/fs1/inst/apps/IKYSDEV_T1VSTEBSAPP01/appl/admin/IKYSDEV_T1VSTEBSAPP01.xml
PATCH file system context file: /u01/install/APPS/fs2/inst/apps/IKYSDEV_T1VSTEBSAPP01/appl/admin/IKYSDEV_T1VSTEBSAPP01.xml
Execute SYSTEM command : df /u01/install/APPS/fs2
Worker count determination...
Validation successful. All expected nodes are listed in ADOP_VALID_NODES table.
[EVENT] [START 2015/01/09 04:19:14] Performing database sanity checks
[EVENT] [END 2015/01/09 04:19:16] Finished performing database sanity checks
There is already a session which is incomplete. Details are:
Session Id : 29
Prepare phase status : COMPLETED
Apply phase status : ATLEAST ONE PATCH IS ALREADY APPLIED
Cutover phase status : NOT COMPLETED
Abort phase status : RUNNING
Session status : FAILED
The above session would be aborted/rolled back. Do you want to continue [Y/N]? Y
[START 2015/01/09 04:19:37] adzdoptl.pl run
ADOP Session ID: 29
Phase: abort
Log file: /u01/install/APPS/fs_ne/EBSapps/log/adop/29/adop_20150109_041858.log
Abort status: R
[START 2015/01/09 04:19:38] abort phase
ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Serial number in context file contains lower value than that of database copy.
Cause: Context file editing through Oracle Applications Manager did not complete file system syncronization. Please correct the errors that caused during editing and then run this program again. (FILE=/u01/install/APPS/fs2/inst/apps/IKYSDEV_T1VSTEBSAPP01/appl/admin/IKYSDEV_T1VSTEBSAPP01.xml)
oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Serial number in context file contains lower value than that of database copy.
Cause: Context file editing through Oracle Applications Manager did not complete file system syncronization. Please correct the errors that caused during editing and then run this program again. (FILE=/u01/install/APPS/fs2/inst/apps/IKYSDEV_T1VSTEBSAPP01/appl/admin/IKYSDEV_T1VSTEBSAPP01.xml)
at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:281)
at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:332)
at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.main(CtxSynchronizer.java:845)
Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Serial number in context file contains lower value than that of database copy.
Cause: Context file editing through Oracle Applications Manager did not complete file system syncronization. Please correct the errors that caused during editing and then run this program again. (FILE=/u01/install/APPS/fs2/inst/apps/IKYSDEV_T1VSTEBSAPP01/appl/admin/IKYSDEV_T1VSTEBSAPP01.xml)
oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Serial number in context file contains lower value than that of database copy.
Cause: Context file editing through Oracle Applications Manager did not complete file system syncronization. Please correct the errors that caused during editing and then run this program again. (FILE=/u01/install/APPS/fs2/inst/apps/IKYSDEV_T1VSTEBSAPP01/appl/admin/IKYSDEV_T1VSTEBSAPP01.xml)
at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:297)
at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:332)
at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.main(CtxSynchronizer.java:845)
*******FATAL ERROR*******
PROGRAM : (/u01/install/APPS/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME : Fri Jan 9 04:19:44 2015
FUNCTION: ADOP::CommonBusinessRoutines::uploadCtxFile [ Level 1 ]
ERRORMSG: Upload of context file failed
[STATEMENT] Please run adopscanlog utility, using the command
"adopscanlog -latest=yes"
to get the list of the log files along with snippet of the error message corresponding to each log file.
adop exiting with status = 2 (Fail)
[applmgr@T1VSTEBSAPP01 admin]$
References:
1- adop phase=abort causes "Serial number in context file contains lower value than that of database copy." (Doc ID 1916658.1)
Hiç yorum yok:
Yorum Gönder