TriniDBA

Problem:

ERROR: While running patch 6678700, the following error occurs:

FAILED: file igipayup.sql on worker  1.

Check adworker log in D:\ORACLE\MFGPR12\apps\apps_st\appl\admin\MFGP\log.

Solution:

To implement the solution, please execute the following steps:

1. The error message you are seeing indicates that the table IGI_UPGRADE_LOG does not exist. Verify this is true by running the following command:

SELECT COUNT(*) FROM IGI_UPGRADE_LOG;

2. Assuming that the table does not exist, look in %IGI_TOP%/patch/115/odf and see if you have a file called ‘igiupg.odf’ in there.

3. If the file exists, use the utility ‘adodfcmp’ to create the missing table.

4. If the file does not exist, download and unzip the patch:10074551:R12.IGI.B and copy ‘igiupg.odf’ into directory $IGI_TOP/patch/115/odf

5. To create the missing object(s) use the following commands:

adodfcmp userid=IGI/igi touser=APPS/apps priv_schema=SYSTEM/manager changedb=YES odffile=%IGI_TOP%\patch\115\odf\igiupg.odf mode=sequences
adodfcmp userid=IGI/igi touser=APPS/apps priv_schema=SYSTEM/manager changedb=YES odffile=%IGI_TOP%\patch\115\odf\igiupg.odf mode=tables

6. Use adctrl (option 2) to continue patch 6678700 from the point of failure and run the script IGIPAYUP.sql.

Reference: R12 Upgrade Patch 6678700 Failed In IGIPAYUP.sql With INSERT INTO IGI_UPGRADE_LOG ORA-00942 Table Or View Does Not Exist (Doc ID 1489757.1)