Tuesday, December 9, 2008

Error during Upgrade to Enhancement Pack 3 for ERP 6.0...

When Upgrading to Enhancement Package 3 for ERP 6.0, you may run into an error during the DD Activation Phase for EA_APPL. The objects that my upgrade kept failing on were the table EMMA_BPC and the view V_EMMA_BPC. The problem is that the view is built with a field that no longer exists in the source table. A quick consistency check in SE11 will tell you that.

The solution is to register V_EMMA_BPC, remove the erroneous field (CLASSJOB), and activate both the view and the table.

Then just restart your upgrade from where you left off.

You have no idea how much of a headache this was causing me the past few days.

UPDATE: This may occur on several different views on tables changed by Enhancement Pack 3. I recently ran into this same problem with view J_1AVEBRCH which had 2 erroneous fields.

Hope this helps...