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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

"A previous version of Microsoft GP is detected.To proceed you need to upgrade your database. Other users are currently using Microsoft GP. You cannot update tables...."

(0) ShareShare
ReportReport
Posted on by

I am getting an error message when trying to install the year end update.

When opening GP Utilities I am getting the attached message "A previous version of Microsoft GP is detected.To proceed you need to upgrade your database.  Other users are currently using Microsoft GP. You cannot update tables...."

 

I have verified that there are no other users in GP. Please let me know what i can do to solve this problem.

I am working remotely today so I'm not reachable on my work phone number.

Thank you.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Richard Wheeler Profile Picture
    75,850 Moderator on at

    SELECT * FROM DYNAMICS..ACTIVITY will confirm who GP thinks is in GP. That table must be emptied before the upgrade process will continue. DELETE DYNAMICS..ACTIVITY will empty this table. Then you will first perform the upgrade on your server and then all the workstations. Remember to load the latest tax tables after you have created your year-end wage file.

  • Community Member Profile Picture
    on at

    This corrected our issue! Thank you!

  • KirkLivermont Profile Picture
    5,985 on at

    Richard,

    Slightly funny story from my last upgrade (2013 R2-2015 R2). During my test upgrade the backup I restored still had a user "logged in". The upgrade succeeded and everything was fine up until I needed to add new reg keys. I ended up having to delete dynamics..activity so I could get the one concurrent license back in order to login, enter the keys and get our 23 seats back.

    Kirk

  • Richard Wheeler Profile Picture
    75,850 Moderator on at

    Yes, I have run into that as well. Sometimes you get rushed and forget to empty the activity table.

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…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans