Payroll table failing to upgrade for GP 2015 year-end?

Posted by Tyler Boswell
​

With the Year-End updates for Microsoft Dynamics GP 2013 and 2015 going live in late November, a lot of you have probably either started planning, or actually performing your year-end updates.
​
For those of you that are already on GP 2015 RTM or R2, this won't be an issue, but for those of you that are on version 12.01801 or earlier, you may be having problems updating your ‘Payroll Master Employee ACA’ table (UPR00905).

The issue, in short, is that the temporary table is not being removed as it should be. Luckily, this can be quickly resolved with a couple of simple scripts that you will run against your ‘DYNAMICS’ database.

I’m going to stop and add a quick disclaimer before going any farther. You should ALWAYS run a backup before running any scripts. If you are not comfortable performing a backup or running SQL scripts, it is best to contact your partner or Microsoft directly. Every environment is different so these scripts are provided as is, without warranty.

Once you have made your backup, run the following scripts:

Delete DU000010 where PRODID = 0 and fileOSName = 'UPR00905' and conversionScript = 'convertUPR00905forGP14TX2'
-and-
Delete DU000030 WHERE (Status <> 0 or errornum <> 0) and Status <>15

After running these scripts you can re-launch Microsoft Dynamics GP Utilities and continue the upgrade.

If you have yet to begin running Utilities, you can proactively avoid the error by running the first script against the ‘DYNAMICS’ database and you will be able to execute the upgrade without any UPR00905 errors.
​
 If you have any additional questions, contact InterDyn Artis.
​