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) / Login Problem: A get/c...
Microsoft Dynamics GP (Archived)

Login Problem: A get/change first operation on table 'SY_Users_MSTR'...

(0) ShareShare
ReportReport
Posted on by scplimited 5

Suddenly I am having a problem logging into the GP, I get the following error: 

A get/change first operation on table 'SY_Users_MSTR' failed accessing SQL data

More Info: Number of results columns doesnt match table definition.

 

I just got back from vacation and haven't made any changes. This is a hosted system with a separate SQL Server. One odd thing was that initially we (any user) were not able to log into (RDP) into the server. I reset my domain password via their web portal and I was able to get in, but I can't log into the GP Application itself. 

 

Version 12.00.1295 SQL Server 2008R2 10.50.4276

Any Ideas?

*This post is locked for comments

  • scplimited Profile Picture
    scplimited 5 on at
    RE: Login Problem: A get/change first operation on table 'SY_Users_MSTR'...

    *sighs* yep it's an old snapshot of the VM as Snipping Tool isn't installed either as that was something I installed 4ish months ago.

    Thanks for the help guys.

  • scplimited Profile Picture
    scplimited 5 on at
    RE: Login Problem: A get/change first operation on table 'SY_Users_MSTR'...

    I reinstalled the R2 service pack and I can now get into the companies.

    It looks like Management Reporter is no longer configured... they must have had some kind of problem and put me on an old VM Snapshot. I don't think there's any other way for this to happen.

  • scplimited Profile Picture
    scplimited 5 on at
    RE: Login Problem: A get/change first operation on table 'SY_Users_MSTR'...

    *sighs* I had this in the back of my mind that this might be what the problem, but it's rather mind blowing how that would even happen.

    None of the computers in the Office run GP. We all remote desktop into the hosted GP server and run the client there. The SQL server is a separate machine. 

    However, I installed the R2 12.00.1745 service pack mid last year so we had been running on R2 for quite some time which is why the database reflects that as it should. Somehow the server we all log into got reverted back to RTM 1295... no idea how unless for some reason they reverted to an old snapshot of the VM but I don't know why they would go to one so old or even one at all. I can't think of any other reason how it would have reverted back to RTM unless it's just some glitch. 

    So I guess I need to go through and install12.00.1745 R2 on the server again...?

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell on at
    RE: Login Problem: A get/change first operation on table 'SY_Users_MSTR'...

    Reading this data tells me that the database server (your company databases) and your workstation client code are not on the same version.

    When you were away is it possible that the HOST did any updates and might have forgotten to tell you?

    I can see that the Database version 12.0.1745 and the CODE 12.0.1295 are two different levels - two different Service Packs are at work here.

    Until you get the workstation that has the CODE 12.0.1295 patched with the same Service Pack as on the server, you will continue to encounter this problem.

    Does your HOST partner support your updates on the workstations in your office?

    Let me know.

  • scplimited Profile Picture
    scplimited 5 on at
    RE: Login Problem: A get/change first operation on table 'SY_Users_MSTR'...

    "There was a problem ascertaining product version information. Microsoft Dynamics GP Utilities will now exit. Please check the duinstall.log file for more information."

    duinstall.log contains (small sample):

    Failure encountered ON 7/6/2015 at 4:35:06 PM.  Error:  You are attempting to configure an older version of product 0.  Database 12.0.1745 Code 12.0.1295.

    Failure encountered ON 7/6/2015 at 4:35:06 PM.  Error:  You are attempting to configure an older version of product 346.  Database 12.0.1728 Code 12.0.1289.

    Failure encountered ON 7/6/2015 at 4:35:06 PM.  Error:  You are attempting to configure an older version of product 949.  Database 12.0.1679 Code 12.0.1289.

    and

    Failure encountered ON 7/6/2015 at 4:35:09 PM.  Error:  Product 0 does not support upgrading from version 12.0.1745.

    Failure encountered ON 7/6/2015 at 4:35:09 PM.  Error:  Product 346 does not support upgrading from version 12.0.1728.

    Failure encountered ON 7/6/2015 at 4:35:09 PM.  Error:  Product 949 does not support upgrading from version 12.0.1679.

    Failure encountered ON 7/6/2015 at 4:35:09 PM.  Error:  Product 1042 does not support upgrading from version 12.0.1603.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: Login Problem: A get/change first operation on table 'SY_Users_MSTR'...

    I would first try going into your DEX.INI file and set SYNCHRONIZE to try and then launch GP. You will be forwarded to GP Utilities and make sure you see the synchronize window pop up for a second. Then launch GP and see if it works. Does GP work on the server?

  • scplimited Profile Picture
    scplimited 5 on at
    RE: Login Problem: A get/change first operation on table 'SY_Users_MSTR'...

    We are pretty much remote desktop-ing into the host and running it there.  The only thing I can see is 12.00.1295 on the login window.

    It is possible that they could have updated something, but not anything related to GP itself as it's not something they would touch. They would update anything OS or SQL related though.

  • Bill Campbell Profile Picture
    Bill Campbell on at
    RE: Login Problem: A get/change first operation on table 'SY_Users_MSTR'...

    What version of GP are you running on your client?

    What version of GP is the HOST running?

    Do you know if there is a chance there was an update done on the system and they did not do the update on your workstation?

  • scplimited Profile Picture
    scplimited 5 on at
    RE: Login Problem: A get/change first operation on table 'SY_Users_MSTR'...

    I entered the SA credentials, it connected and saved, however I still get the same error message when i try to log into GP.

  • Bill Campbell Profile Picture
    Bill Campbell on at
    RE: Login Problem: A get/change first operation on table 'SY_Users_MSTR'...

    You might find that you need to reset the user ID and password on the ODBC configuration window.

    Do you have an Administrator there that has the SA ( System Admin) SQL Password?

    If so, that is what we use.  If not, use your GP User ID and password.

    You can not use Window Authentication - it will fail.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans