Tuesday, July 14, 2009

Restart discrepancy in aidrrl3() error while applying a Patch

While applying an E-Business Suite patch, a worker fails with an error similar to this :
AD Worker error:
aiurcl(): Discrepancy detected in restart file:
$APPL_TOP/admin/restart/adwork004.rf9

Line 2 from file = '1ExecuteDriverLine bin fnd FNDLOAD.exe APPS/APPS 0 Y UPLOAD
Line to compare = '1ExecuteDriverLine bin fnd FNDLOAD.exe APPS/APPS 0 Y UPLOAD

ERROR : Restart discrepancy in aidrrl3()

Adpatch updates the restart file corresponding to a worker after each worker is complete. This allows adpatch to restart from that a point onwards in case it is aborted. If the restart file can not be updated then a synchronization problem will occur between the AutoPatch session and the particular restart file. The restart file will then be deemed as corrupt. The worker would fail and AutoPatch will not be able to continue.

A file permission problem, disk space exhausted or an operating system process with exclusive lock on the file are just few examples of why adpatch will encounter errors when updating a restart file.

This is the best solution to ensure a correct and clean patch application if this error is encountered :


1. Abort the current AutoPatch session.

2. Take a backup copy of the contents of the $APPL_TOP/admin//restart directory. Once the patch is complete, this back up directory may be deleted.


3. Delete the contents of the $APPL_TOP/admin//restart directory. Do not delete the directory itself.

4. Login to SQL*Plus as the APPLSYS user and drop the FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS tables.

5. Reapply the failing patch. Run AutoPatch as follows:
$ adpatch options=nocopyportion

Note the following:(A) Since an earlier iteration of the patch already copied the required files, the copy phase of the patch may be skipped. The nocopyportion parameter specified with adpatch will only perform the database and generate portions of the patch. The copy portion is complete as the worker processes are not used by this part of the patch application.

No comments: