FAILED: File GMIG3MIB.sql While Running Patch 6678700

Posted by Vasudev Seeram on September 26, 2013 Leave a comment (0) Go to comments

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

FAILED: file GMIG3MIB.sql on worker  1.

Solution: If OPM is not used, the script is not relevant and can be skipped.

If the table IC_LOCT_INV doesn’t exist or the query below returns no rows, the script can be ignored.

select whse_code,migrated_ind,count(*) from
ic_locT_inv
where loct_onhand <>0 or
loct_onhand2 <>0
group by whse_code,migrated_ind;

Use adctrl option 8 to skip and restart.

Reference: GMIG3MIB.sql Is Stuck While Applying 12.1.1 Upgrade Patch 6678700 (Doc ID 1550457.1)

TriniDBA