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.1860 Canadian 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

Comments (4)

Cancel reply

  1. hh says:

    I tried PDK installation …but still it is showing the same error

  2. Pam Peterson says:

    If you have followed the installation instructions fully, then you may want to open a support case or use the Communities page to troubleshoot further.

  3. OV says:

    Hi, We do not use PDK and still get this error message. GP 2010, moving the database to the new server. What else can that be?

    Thank you.

  4. Sorry. The blog post isn't used for support. Would you open a support case or post your issue on the Communities page for further assistance? Thanks!

Skip to main content