EHPI Error: Phase XPRAS_UPG, DDIC_TYPE_INCONSISTENCY...

This is a fairly common error in the EHPI process. Sometimes a table will have an include field that references an invalid field from another table. That field may have one day existed and for some reason no longer does.  In order to move past this error in the phase XPRAS_UPG, you have to purge the offending field.

First, make sure to correctly identify the field. There will be detailed information about the table/field in the Short Dump in ST22. Make sure you are thorough, because you do not want to alter the wrong table. For example, the most recent one I ran into was the NETPR field in table EK08RZ.  The error in the short dump referenced table DRSEG.  The short dump references a report you can run to identify the problem field, but I won't reference here because I REALLY want you to read the short dump.

Here are the steps to correct the problem:

1. Unlock the Shadow System to allow a user to login:

 From the command line, run:
\usr\sap\<SID>\<inst>\exe\TP UNLOCKSYS <SID> PF=<profile path>

2. Set the system to allow for changes:

SE06 -> System Change Options, set the system to modifiable for both Software Components and Namespaces

SCC4, Allow changes to both client dependent and repository objects

3. Remove the field

SE11, modify the table and remove the invalid field

4. Close the system in SCC4 and set the system to Not Modifiable in SE06

5. Lock the Shadow System:
\usr\sap\<SID>\<inst>\exe\TP LOCKSYS <SID> PF=<profile path>

Resume the step in EHPI.

You may run into multiple invalid fields, so be patient with this process.

Hope this helps...