Windows 10 Creator Update & Dynamics GP

Posted on May 3, 2017 by Vaidhy Mohan

An interesting issue/question was posted on our community forum regarding an error message popping up while exiting GP2015 R2 & GP2016 R2.

Specifically, GP2015/2016 R2 on Windows 10 Creator Update is what seems to be throwing this error while exiting.

Link to original forum post: Windows 10 Creator and GP2015 R2

One member, Ron Koendrink, figured out that it’s Mekorma MICR that’s causing this issue on his environment. Per his update, Mekorma had confirmed that it’s an issue for which a fix was available.

Anyone out there who use Mekorma MICR and planning to upgrade your OS to Windows 10 Creator Update, please contact them and get the fix.

A note of thanks to Ron.

Vaidy

GP Upgrade – “Please Select a Company” Message

Posted on November 24, 2015 by Vaidhy Mohan

This one’s quite simple, yet intriguing.

I am working on a test upgrade; from GP2010 to GP 2015 R2. I decided to only take production company databases and left all test companies, for all logical reasons.

After applying GP 2010 SP4, I decided to perform a unit testing. After logging in to GP, I received following message, without having any issues later on. It was just this message:

Company Message

(Above screenshot courtesy: Ugan)

As a thumb rule, I searched on GP community and stumbled across two most relevant forum questions and suggestions.

None of them is answered.

I had a suspicion that this must be something to do with “Remember this company” option on “User and Company” window. I decided to use GP Power Tools (previously Support Debugging Tool – SDT) and SQL profiler to study this message in depth.

As suspected, results pointed to the option “Remember this company”. Now, if you remember what I said earlier, I took only the production companies for test upgrade and not the test companies. Previous consultant who was working with this client had selected a test company as his (SA’s) default company.

Now, you must also recollect that we have a SQL script to clean up missing companies’ affiliation across DYNAMICS database.

I ran the above script on the test environment and logged on to GP. This time, I was required to select a company and the message never appeared back.

Happy troubleshooting!

VAIDY

GP 2015 R2 Upgrade Issues & Possible Solutions

Posted on June 4, 2015 by Vaidhy Mohan

There is a GP community forum question that discuss about GP 2015 R2 upgrade errors. As always, contributors have poured in their thoughts and possible solutions to fix these issues.

Read the question here: GP 2015 R2 errors during update & Fixes

I recommend this post to everyone who are planning to upgrade to GP2015 R2 soon. This may save a lot of time.

Thank you GP community for being selfless, informative and helpful.

Vaidy

GP 2015 Web Client Uninstall – Issue & Resolution

Posted on January 6, 2015 by Vaidhy Mohan

In my earlier post, I discussed about an issue that I came across while installing web client. This one’s while uninstalling the web client.

My VM is added to my work domain and when I installed web client, my VM was connected to my work network. Back at home, in my holidays, I was experimenting with various stuff. Got my VM web client corrupted and decided to uninstall it.

Running the web client uninstall started off properly but threw the following error soon after:

You may see the point in time at which the uninstall process stopped: ConfigureUsers.

Tried various things, as usual, but could not fix it. Every time I tried to uninstall, it stopped exactly at ConfigureUsers.

My instinct was telling me that it was something to do with domain network issue. As I was trying this at home, it could probably be something related to that.

I connected to my work VPN and then restarted the uninstall process. This time around, the process went on smoothly and completed.

Remember. If your machine (or a VM) is affiliated to your work domain when you installed the web client, make sure that your machine (or a VM) is connected to your work domain when you try to uninstall.

This makes a world of difference. You do know what that difference is, by now.

VAIDY

GP 2015 DYNAMICS DB Upgrade – Issue & Resolution

Posted on January 5, 2015 by Vaidhy Mohan

This issue is probably remote and may not be faced by many of you out there. But I thought I would share this information with you all, just in case.

Issue: I was upgrading my GP 2013 to GP 2015. By the time, GP Utilities (almost) finished, it got stuck with an error while updating the table SY_Company_MSTR (Company Master) as shown below. I have tried to capture the entire error details on one screen:

Error Explanation on Table Error Details had more information that I could not capture above. Below is that additional information. I’d rather say, that’s the exact error message:

While that greyed portion denotes a company DB name.

Reason: I copied one company database (out of 8) backup from my production environment, restored it on my test machine and ran the utilities to upgrade to GP 2015. When Utilities tried to update Company Master table (SY01500, SY_Company_MSTR), it found records pertaining to companies other than one that’s existing on my test machine while it could not find the respective databases physically.

Resolution: If you are going to have less companies on your upgrade scheme than what’s there on your original GP environment, then you must run Clear Companies script. This script will clear all records pertaining to companies that are not physically available on your SQL instance.

Once I cleaned up the company records, my upgrade process went on successfully.

VAIDY

UPDATED: Microsoft Dynamics GP 2015 Documentation & Resources

Posted on January 4, 2015 by Vaidhy Mohan

In my opinion, Microsoft Dynamics GP team might have hurried the release of GP 2015 RTM.

Think about this. You install GP 2015 and the user manuals that comes with that are GP 2013 R2 manuals. For instance, Visual Studio Tools manual that we get after installing the tool is of version GP2013 R2, as shown below:

Not just this manual, there are also other manuals that are basically for GP 2013 R2 but somehow got shipped with GP 2015 installation media.

Where can we get the latest manuals then? Answer is this link: Documentation and resources for Microsoft Dynamics GP 2015 and 2013.

First section on this post would be directing you to GP 2015 manuals.

QUICK UPDATE #1: I was wrong. Even this link seems to be not having *all* manuals. So probably the new ones are still under construction.

UPDATE #2: More relevant link, shared by Beat, is as follows: http://www.microsoft.com/en-us/download/details.aspx?id=45025

UPDATE #3: Microsoft would probably never update user manuals with each version of GP. This link apparently has got the word on this: http://blogs.msdn.com/b/developingfordynamicsgp/archive/2014/08/08/printable-manuals-for-microsoft-dynamics-gp.aspx

VAIDY

GP 2015 Web Client Installation – Port Conflict Issue & Resolution

Posted on January 2, 2015 by Vaidhy Mohan

I have been doing some R&D with GP2015 (Desktop & Web Client) on my virtual machine for almost a week now. On that note, let me share with you one particular issue, that’s a bit silly, yet possible to be faced by many of you out there.

I had a working instance of GP 2015 Web Client on my VM (that’s connected to my work domain). I uninstalled it due to an SSL conflict with local web site. Uninstall went on smoothly.

I worked on that local web site stuff and decided to install web client back. When I began the installation, following error message happened:

I had no idea about this port, as this port number was never used while setting up the web client installation. I am not an expert in networking either. So googled this error and got this link on Microsoft Support KB: How to determine which program uses or blocks specific transmission control protocol ports in Windows.

I used the command netstat -ano to figure out which process is using the port 48665. Below is the list that I got:

Highlighted on RED box is the one that was using the port 48665. This process was System Process, as found through Task Manager:

Well, only to that extent could I proceed. My instinct asked me to restart the VM once and see if that clears this port. And it did.

And my web client installation went on well and completed without any issues.

Reason: After uninstalling my Web Client earlier, I did not restart my machine. I continued with the local web site task and tried to install Web Client again. Previous installation would have held that port (just my assumption) and did not release it till I restarted my VM.

Resolution: If you are going to install Web Client, just make sure that you restart the server.

On my next post, I shall discuss about an issue that I faced while uninstalling my web client and the resolution to the same.

VAIDY