How to fix a Corrupted XER file

From the Oracle Support desk download the PATTLNK_782008_1412-xerFileParserBuilder.xls file.  It’s also available on the drive: \\ap-fs-02\data\EPF\BSG\Downloads\Primavera\Fix XER files.  Copy the Excel sheet to your local machine.
Open the Spread sheet
Enable all content
Click “Load XER file…”
If you get an error message; the reason is that you are missing the “Comdlg32.ocx” file on your machine.  Copy the file \\ap-fs-02\data\EPF\BSG\Downloads\Primavera\Fix XER files\Comdlg32.ocx file to your C:\Windows\System32 directory and try again.
Select the file you want to check and click OK, the Spread sheet with populate with all the information you need.  This can take a long time depending on the size of the export.

On the front page click the “Diagnostics” button.
On the dialogue select “cross check FK”; Task and task_id; TASKRSRC and task_id.

Click “Run Diagnostic”

You will then be shown all the “Task Resources” which have been assigned to “Tasks” that no longer exist.
Note the Row number in the results.

Go to the TASKRSRC tab and remove these rows from the Spread sheet.. Feel free to run the Diagnostics a few times to make sure you have everything covered.

Eventually you should see that no errors are displayed.
Go back to the front page and click the “Build XER File…” button.
Save the fixed XER file to another file and try the Import again.