web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Number of result colum...
Microsoft Dynamics GP (Archived)

Number of result columns dosent match table definition

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

I have PDK installed on the server and on other client system. But anytime we want to post timesheet from PDK it gives this error 'A get/change operation on table UPR_MSTR_TAX_INF failed accessing SQL data'. If i click on more on the dialog bos that the display the error it show this message'Number of result columns dosent match the table definition'. But if we post the timesheet from dynamics GP 2010 we wont get this error.

I need help on how to fix this issue urgently.

Thank you and God bless

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    L Vail 65,271 on at

    Hello Funmilayo,

    First, which build are you on? This kind of error usually means the table in your system does not match the Dynamics table definition. Perhaps the post process of the PDK accessing this table, but the post from within GP does not. I do not have the tools to look right now.

    To find out which column (field) is missing - take a look at the table in SQL and compare it to the table in Dynamics Resources.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member on at

    Hello Leslie,

    Thanks for your reply.

    I working on Microsoft Dynamics GP 2010.

    Kindly give me the table ID if know it. I have search for the table but i couldnt get it.

    Thank you for your responce.God bless

  • Community Member Profile Picture
    Community Member on at

    Hi I had the same error when I was trying to do client update.  I setup the client update for GP 2010 SP2 on the server.  When I started up GP 2010 sp1 on a client machine and log in, it gave me the error "A get/change operation on table 'SY_Company_MSTR' failed accessing SQL data.'  When I clicked more info, it says "Number of results columns doesnt match table definition."  Please help

  • Community Member Profile Picture
    Community Member on at

    I compared our SY_COMPANY_MSTR (SY01500) to GP 2010 SDK.  We have all the columns up to DEX_ROW_ID and we are missing those columns after DEX_ROW_ID like CURNCYID,MACHINE_ID,PRNCODE,....

    Please help.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    I just happened to have that same error, in my case, my server was updated from another station to GP R2 and the remaining clients were using a previous version, we solve that by installing the latest R2 client on all the other computers and the error went away,

  • Community Member Profile Picture
    Community Member on at

    Does it mean that I can't use automatic client update for GP2010 SP2?

  • Community Member Profile Picture
    Community Member on at

    I personally dont use automatic updates, for some strange reason on the different environments users have tried they fail, and I have removed the record on SYUPDATE and run the installs on their computers.

    But Im not sure if this will not allow you tu use automatic updates.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans