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

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Amjad Ali Changezi 35 on at

Like (0)

Report
Copy link

Link copied!

Thanks, I have updated the DNS and it worked !

Was this reply helpful? Yes No