GP 2015 to 2015R2 Problem with Upgrade - GP Utilities ERROR

(0) Share

Report

Posted on by Community Member Microsoft Employee

Error Message:
Other users are currently using Microsoft Dynamics GP. You cannot update tables while anyone is using Microsoft Dynamics GP.

We are upgrading from 2015 to 2015R2 and when GP launches it states that it needs to update the dictionary files.
Error Message:
"Dexterity Runtime" Use Microsoft Dynamics GP Utilities to update your modified forms and reports.

I press OK and GP Utilities automatically pops up and goes through the Verification process no problem BUT then it fails with:

Error Message:
Other users are currently using Microsoft Dynamics GP. You cannot update tables while anyone is using Microsoft Dynamics GP.

Nobody is logged into this instance of GP. Please help I'm not sure what to do and I don't want to go deleting tables in SQL if I do not need to.

Thank you in advance for any help with this issue!

*This post is locked for comments

All responses (8)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: GP 2015 to 2015R2 Problem with Upgrade - GP Utilities ERROR

I found a solution for the error above which is running this script;

CREATE TRIGGER utr_AZRCRV_SY07240_InsteadOfInsert ON SY07240 INSTEAD OF INSERT AS

INSERT INTO SY07240

(ListDictID

,ListID

,ViewID

,CmdParentDictID

,CmdParentFormID

,CmdParentCmdID

,CmdSequence

,CmdDictID

,CmdFormID

,CmdID

,Priority

,ButtonSize

,CmdCaption

,Visible)

--VALUES

(SELECT

ListDictID

,ListID

,ViewID

,CmdParentDictID

,CmdParentFormID

,CmdParentCmdID

,ISNULL(CmdSequence, 1)

,CmdDictID

,CmdFormID

,CmdID

,Priority

,ButtonSize

,CmdCaption

,Visible

FROM

inserted)

Now GP Utilities is currently running. I will submit a new post to follow up. Thank you
Community Member Microsoft Employee on at

Like (0)

Report

RE: GP 2015 to 2015R2 Problem with Upgrade - GP Utilities ERROR

And I ran the grant.sql script - still no good.

Rebooted again after tried GP Utilities a couple times more and it failed AGAIN. Same problem. Please help I am pulling out my hair over this & I'm already bald!
Community Member Microsoft Employee on at

Like (0)

Report

RE: GP 2015 to 2015R2 Problem with Upgrade - GP Utilities ERROR

And I did find the DEX.INI file I tried the "Recommended Action" which was to edit the lines from "False" to "True" and they revert back every time I try GP Utilities over again. I even rebooted the server a few times. Please help - Thank you!
Community Member Microsoft Employee on at

Like (0)

Report

RE: GP 2015 to 2015R2 Problem with Upgrade - GP Utilities ERROR

Hey Jeffrey! I tried what you suggest "DELETE ACTIVITY" and I was able to continue further this time THANK YOU!

However, during the GP Utilities Update I got another error message this time. It seems like it's looking to update certain tables that it can not find. I took a screen shot of the errors below. Please help - Thanks guys!
Community Member Microsoft Employee on at

Like (0)

Report

RE: GP 2015 to 2015R2 Problem with Upgrade - GP Utilities ERROR

Ok I found out how to do this - It still does not work.
Suggested answer

twelvestrikes 3,657 on at

Like (0)

Report

RE: GP 2015 to 2015R2 Problem with Upgrade - GP Utilities ERROR

Hi Chris

You will want to do the following

First have a backup

In SQL management studio run the following against the DYNAMICS database

Delete ACTIVITY

this will clear any stranded users in Dynamics GP.

Next I suggest you reboot the server to clear the SQL temp tables and also if there are any locks on your reports or forms dictionaries.

Once the server is backup and running you can launch Dynamics GP utilities and upgrade your databases.

when that is finished you should be able to upgrade your modified reports and forms dictionaries.
Community Member Microsoft Employee on at

Like (0)

Report

RE: GP 2015 to 2015R2 Problem with Upgrade - GP Utilities ERROR

Hi Jothikrishnan Narasimmaraj ! Thanks for your response! Can you please provide me with details on how to do this exactly? Specific details would be very helpful thank you so much!
Jothi Krishnan N 1,865 on at

Like (0)

Report

RE: GP 2015 to 2015R2 Problem with Upgrade - GP Utilities ERROR

Have you cleared the Activity table in DYNAMICS DB?