• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1123
  • Last Modified:

Get Change error changing from one company to next GP 2010

a get/change operation on table SY_End_Routines_Check_MSTR failed accessing SQL data when changinf from one company to the next.
0
raybar111
Asked:
raybar111
  • 3
1 Solution
 
Abdulmalek_HamshoCommented:
Does it show everytime you change company or sometimes?
0
 
Abdulmalek_HamshoCommented:
Does it show everytime you change company or sometimes?
0
 
Abdulmalek_HamshoCommented:
Does it show everytime you change company or sometimes?
0
 
Steve EndowMicrosoft MVP - Dynamics GPCommented:
Hi,

One possible cause of this error is that there is an 'orphaned' GP user / login records in the ACTIVITY table.

Please see CustomerSource KB Article 856551 for full information.

If that is the cause, the solution is to delete the orphaned record from the ACTIVITY table.  

If you know the user that is orphaned, you can login as that user and you should be prompted:  "User ID is already logged in to company. Would you like to view your current logins?"  Click on Yes and then click Delete.

If you don't know the user, you can check the Activity table:

SELECT * FROM DYNAMICS..ACTIVITY

Review the user list, verify who is actually logged in, and delete any user activity records that you have confirmed are inaccurate.

DELETE DYNAMICS..ACTIVITY where USERID= 'XXXX'

Another approach is to have all users log out of GP and close the GP application.  In theory, there shouldn't be any users left in the Activity table.  Any remaining records can be deleted.


Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now