Created On:  14 November 2011

Problem:

During verification of sources, an Oracle error is identified:

Table "HCFile": OCI error Reported: ORA-02219 : Integrity Constraint (workpsace.HCFILE_2) violated - parent key not found

How can this be resolved?

Resolution:

The reason for this is the presence of non-unique entries on the HCFILE table. This can be caused during verification if the Modernization Workbench product crashes for any reason or Oracle connectivity is lost.

The solution for those using Modernization Workbench 3.2 (onward) is:

1. Open the Modernization Workbench Administrator tool

2. From the ADMINISTER tool, choose CLEAN-UP HC SOURCES TABLE

    This process will run the necessary Oracle queries to remove any non-unique entries found and report the number removed.

3. Once this process has finished, re-verify the sources where the error was reported.


The solution for those using Modernization Workbench 3.1 is:

1. Unzip the attached HCCLEANER.zip file into a directory of your choice.

2. Open a command prompt ("AS ADMINISTRATOR") and navigate the the directory chosen in step 1.

3. Type HCCLEANER and press enter.

4. When the HCCleaner dialogue opens, click on the SELECT WORKSPACE button

5. When the "OPEN" dialogue window opens, navigate to the workspace.RWP for the workspace you are using. Highlight the workspace.RWP file and click OPEN.

    This process will run the necessary Oracle queries to remove any non-unique entries found and display the number of problem rows detected.
    Finished : nn Problems detected.

6. Once this process has finished, re-verify the sources where the error was reported.