Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) We are facing error &q...

We are facing error "other users are using Microsoft Dynamics GP" when upgrading GP 10.0.1061 to GP 10 SP5

(0) Share

Report

Posted on by Amjad Ali Changezi

We have run a patch to upgrade GP 10.0.1061 to GP 10 sp5. After running a patch we had to run GP utilities to upgrade DB but it doesn't allow us to proceed due to an error "other users are using Microsoft Dynamics GP".

We have cleared data from following tables but it did not work out. Please advise.

DYNAMICS..ACTIVITY
DYNAMICS..SY00800
DYNAMICS..SY00801
tempdb..DEX_LOCK
tempdb..DEX_SESSION

*This post is locked for comments

All responses (2)

Answers (1)

Amjad Ali Changezi 35 on at

Like (0)

Report

Re: We are facing error "other users are using Microsoft Dynamics GP" when upgrading GP 10.0.1061 to GP 10 SP5

Thanks, I have updated the DNS and it worked !
Verified answer

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Re: We are facing error "other users are using Microsoft Dynamics GP" when upgrading GP 10.0.1061 to GP 10 SP5

Please confirm that those tables are indeed empty. If not, reset SQL, perhaps there was a lock on them and they did not clear. Also make sure your DSN is pointing to the correct instance of GP. Those are the tables to check.