Error: "Run time error 2147467259 (80004005)..." when performing the Roll Forward at Practice Level in Reporter

This support note applies to:

AE Reporter (NZ)
AE Reporter (AU)

Article ID: 33126

These instructions require technical expertise

Make sure you know what you're doing and are using one of the products listed. If you're not sure, ask your IT professional or MYOB.

In MYOB Accountants Enterprise Reporter (AE Reporter) you may experience the following error when performing the Roll Forward at a Practice Level in Reporter:

"Run time error 2147467259 (80004005). The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."

To resolve this error, run the RepMastersCheck.zip utility to correct the mm.nrw file.

If you use Reporter with Accounts, you need to run this utility on the 000000.nrm file.

MYOB is investigating this issue.

To run the RepMastersCheck utility

Double-click the file RepMastersCheck.zip. A File Download window is displayed.
Click Save. A Save As window is displayed.
Navigate to your X:\SOL64\Reporter\Modified. Where X:\ is the Installed Location and click Save. The file is saved to your Modified folder.
Right-click on the RepMastersCheck.zip file and select Open. The file RepMastersCheck.zip will appear in the Windows Explorer pane.
Right-click on the RepMastersCheck.exe file and select Copy. The file is copied to the clipboard.
Navigate to the location X:\SOL64\Reporter\Modified, where X:\ is the Installed Location and right-click and select Paste. The file appears in this location.

If the file already exists in this location, the Confirm File Replace window appears, click Yes.
From the Windows Desktop, click Start and select Run. The Run window appears.
In the Open field, type X:\SOL64\Reporter\Modified\RepMastersCheck.exe /UI, where X:\ is the Installed Location. The Reporter Masters Check window appears.
Under Files to check select the mm.nrw file and click Check Files. The utility will scan the mm.nrw file and give the message Scan Complete to advise that the issue is now resolved.

If you are using Reporter with Accounts you need to select the 000000.nrm file.