SELECT b.fileOSName, a.fileNumber, a.PRODID, a.Status, a.errornum, a.errordes, c.CMPANYID, c.INTERID
FROM DYNAMICS.dbo.DU000030 a
ON a.fileNumber = b.fileNumber
AND a.PRODID = b.PRODID
ON a.companyID = c.CMPANYID
WHERE (a.Status <> 0 or a.errornum <> 0) and a.Status <>15
You receive the following error message in the errordesc column:
You receive this error message when one or more of the following tables fail to update:
CauseNote Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.
The primary key changed with Microsoft Dynamics GP 2010 and the records in the table are violating the new key. Records should not exist in the payroll work tables following a payroll check run. To fix this problem, remove the records.
To have us fix this problem for you, go to the "Fix it for me" section. If you would rather fix this problem yourself, go to the "Let me fix it myself" section.
Note This wizard may be in English only; however, the automatic fix also works for other language versions of Windows.
Note If you are not on the computer that has the problem, you can save the automatic fix to a flash drive or to a CD, and then you can run it on the computer that has the problem.
To fix this problem yourself, follow these steps:
- Do not restore the company database. This problem can be resolved at the point of failure during the update to Microsoft Dynamics GP 2010.
- Start the SQL Server Management Studio. To do this, use one of the following methods depending on the program that you are using.
Method 1: For SQL Server 2005If you are using SQL Server 2005, start SQL Server Management Studio. To do this, click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
Method 2: For SQL Server 2008If you are using SQL Server 2008, start SQL Server Management Studio. To do this, click Start, point to All Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.
- Run the following scripts against the company database that is failing:
- Run the following script to clear the failed records:
Delete DYNAMICS..DU000030 where Status = 135 and fileNumber in (424, 425, 426, 427, 428, 429, 385, 386)
- Start Microsoft Dynamics GP 2010 Utilities and update the company again.
Artikelnummer: 2564486 – Letzte Überarbeitung: 18.01.2012 – Revision: 1