Dynamics GP Company Data Archive Error
Posted by Mike Giuffre on November 3, 2016
Recently, we had a client who encountered some errors trying to archive their Microsoft Dynamics GP 2015 R2 system. They have been using the Company Data Archive (CDA) tool; and we don't usually see errors when running it.
It had been awhile since this client last ran an archive, and they've never run into any errors in the past. So, they were surprised to receive the following errors (in sequence) as they tried to archive their Master File data.
Dynamics GP Company Data Archive Errors:
- GPS Error: 54
- SQL Error: 2601
- ODBC Error: 23000
- All_CopyTableSQL-Update, GL00100 2601
- All_CopyTableSQL-Update, GL00105 2601
Additionally, Check Links on the Financial Account Master in the archive company showed a number of errors stating: “The account number for ACTINDX ## needs to be recreated”.
The accounts existed for these indexes and Check Links could not clear these errors. Check Links in the “From” company showed no issues in the Account Master, so the problem was isolated to the archive company.
The Simple Fix
Fixing all these errors was easy, thanks to the CDA tool. All they had to do was “Clear Data” in the Account Master in the archive company. Then CDA added the accounts again with then next run of the Master File. It worked perfectly.
What do you use to clear out old Dynamics GP data and speed up your system? If you'd like to find out more about this archive tool or you have further questions, email us at Support@Crestwood.com.