Number of results columns doesn't match table definition errors in Personal Data Keeper
Hi everyone,
If you are using Personal Data Keeper (PDK) you have probably seen a Get/Change message whose More Info button displays the error “Number of results columns doesnt match table definition.” There are a number of errors that can cause that More Info message such as:
A get/change operation on table 'UPR_MSTR_Tax_Info failed accessing SQL data
A get/change operation on 'GL_Account_MSTR' failed accessing SQL Data
A get/change operation on table 'UPR_MSTR' failed accessing SQL data
A get/change first operation on table 'MC_Currency_SETP' failed accessing SQL data
A get/change first operation on table 'PDK_Employee_Expense_HDR' failed accessing SQL data
A get/change operation on table ‘P_CPY_SETP_Income’ failed accessing SQL data
A get/change first operation on table ‘P_CPY_MSTR’ failed accessing SQL data
But what they all mean is that the version of Microsoft Dynamics GP and the version of PDK being used are not compatible.
What is compatible?
Here is a cheat sheet I created for my team that I wanted to share so you can use it to verify that the versions you are using play nicely together.
GP 10.0
GP version |
PDK version |
10.0.774 – 10.0.872 |
10.00.19 |
10.0.903 – 10.0.991 |
10.00.20 |
10.0.1061 – 10.0.1129 |
10.00.23 or 24 or 26 |
10.0.1061 (SP3) Canadian Payroll users |
10.00.26 |
10.0.1193 – 10.0.1328 |
10.00.24 or 26 |
10.0.1368 (SP4) - 10.0.1502 |
10.00.27 |
10.0.1579 (SP5) or 10.0.1634 |
10.00.31 |
10.0.1685 or 10.0.1757 |
10.00.32 |
10.0.1779 – current |
10.00.1809 or 10.00.1837 |
10.0.1779 Canadian Payroll users |
10.00.1837 |
GP 2010
GP version |
PDK version |
11.00.1307 – 11.00.1524 |
11.00.1315 |
11.0.1585 |
11.00.1525 |
11.0.1667 |
11.00.1662 |
11.0.1752 – 11.00.1799 |
11.00.1719 or 11.00.1806 |
11.0.1860 – current |
11.00.1863 or 11.00.1920 |
11.0.1860Canadian Payroll users |
11.00.1920 |
It is always a good idea when upgrading your version of GP to make sure that a new version of PDK has not also been released.
If you determine you need to update your version of PDK, you can find the latest patches here for GP 10 and here for GP 2010. Note that these are typically not full installs of PDK, so you will need to make sure to have the RTM or SP2 version installed first.
Thanks for reading!
Pam Peterson | Sr. Technical Lead | Microsoft Dynamics GP