Page 1 of 13212345678910...2025303540...Last »

DBMS: 12 Microsoft Dynamics GP: 0 error when updating to Microsoft Dynamics GP 2013 R2

Hello all! It’s been quite a while since I’ve actually written anything of remote interest to anyone who follows my blog, but at the same time, you will be pleased to know that I’ve been quite busy in the consulting front, with upgrades, server migrations, complex multi-instance postings involving 10’s of thousands of transactions, wrapping up some Field Service Automation projects, and the list goes on and on.


This time around I want to bring to the forefront, an issue I encountered updating from Microsoft Dynamics GP 2013 SP2 to Microsoft Dynamics GP 2013 R2 plus the latest service pack.

Background

My client requested a server migration to a new environment where they wanted to deploy Dynamics GP 2013 R2 web client (plus the latest service pack) and upgrade their relational database management system to Microsoft SQL Server 2014. This is something I’m absolutely comfortable with (for the most part) given also that my client was sitting at Microsoft Dynamics GP 2013 with Service Pack 2.

As it is customary with these types of request involving a server migration, I followed the very clear instructions outlined in KB article 878449How to transfer an existing Microsoft Dynamics GP, Microsoft Small Business Financials, or Microsoft Small Business Manager installation to a new server that is running Microsoft SQL Server. I have walked through this article more times than I care to mention and can pretty much recite the steps by heart.

During the Dynamics GP Utilities process on the system database, I kept receiving the error message:

“Microsoft Dynamics Utilities Install/Upgrade failed”

This seemed to be a recurring problem on the sySrsReports table during the system database update. Upon further inspection, I noticed the temp table created for the sySrsReports (sySrsReport_T) was still present and that dropping this table would allow Dynamics GP Utilities to continue processing the system database update to completion.

However, the company database updates were failing with the following error messages:

“The stored procedure GetBD_UpgradeStatus() of form duSQL Pass Through SQL returned the following results: DBMS: 12, Microsoft Dynamics GP: 0.”

Upon clicking the OK button, the following error message would appear:

“The stored procedure UpdateDB_Upgrade() of form duSQL Pass Through SQL returned the following result: DMBS: 12, Microsoft Dynamics GP: 0.”

The above two errors would reiterate a few times (5 or 6 to be exact) to finally produce the following error:

“The stored procedure getCompanyID() of form duSQLInstall Pass Trough SQL returned the following results: DBMS: 12, Microsoft Dynamics GP: 0.”

And would come to rest with the error described at first. Now, I’ve done myriads of upgrades in my lifetime, but this one put me on a cliff for a while. The DEXSQL.LOG clearly did not show anything specific and the duinstall.log just showed execution messages (“Message encountered” messages) happening where the problem occurred.

In all fairness, the DEXSQL.LOG kept showing a “[Microsoft][SQL Server Native Client 10.0]Communication link failure” error which lead me to check the version of SQL Server Native Client I was running, which was version 10. I then upgraded to SQL Server Native Client 11.0 and nothing really changed.

I also realized the update was failing while attempting to create the table auto procedures for the wkPostingValidationState table. I then drop this table and its auto procedures and restarted the update in the hopes it would recreate the objects once more, but was not successful.

Suffice to say, I restored the system database and company databases in order to devise a different strategy.

The Solution

After tinkering with the installation, I decided to retrace my steps and realized that during the installation process, I chose to install Web Client Runtime Engine – after all this machine was the web server and would be running a Single Machine instance of Dynamics GP. I then decided to install the Dynamics GP client on the database server without the Web Client Runtime Engine and launch GP Utilities once more. The update process ran flawlessly without any errors!

I still cannot understand why the presence of Web Client Runtime Engine would have caused an error while updating a service pack, however I have to remind everyone of the official Microsoft stance: “the session host must only be used to perform very little administrative work”.

It was good to finally get pass these issues and complete the update process for my client.

Please take a look at my GPUG webinar on upgrades at:

Mariano’s Toolbox: Upgrading to Microsoft Dynamics GP 2015 for dummies 

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

See original article:
DBMS: 12 Microsoft Dynamics GP: 0 error when updating to Microsoft Dynamics GP 2013 R2

May 24, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 8

Updating Dynamics CRM OnPremise to work with Microsoft Dynamics Marketing 2015

If you have Dynamics CRM OnPremise and it is integrated with Dynamics Marketing this post is for you. This post will focus on the steps to you need to perform to allow your integration to continue to work after Dynamics Marketing is upgraded to 2015. Download the Dynamics Marketing resources: http://www.microsoft.com/en-us/download/details.aspx?id=43108 Install the Microsoft Dynamics Marketing 17.0.3711 – CRM Connector.msi file on the server you had the previous version installed on.

Continued here:
Updating Dynamics CRM OnPremise to work with Microsoft Dynamics Marketing 2015

April 24, 2015 · Corey Hanson · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 29

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 1 Continued

Day 1 – Afternoon

After the Keynote and General Session, it was time for lunch and trying to catch up with friends. It never ceases to amaze me the logistics required to sit and feed 12,000 people at any giving time. Just making sure everyone has a place to sit or even the kind of food they like is got to be an incredible task.

Crowd heading for lunch at the Meal Hall

After getting my food, I went to sit at the table with some very distinguished folks in the community – in the meantime, David was off trying to get something that won’t upset his tummy. As you may or may not know, my good friend troubles with MSG intolerance (and associated flavor enhancing glutamates), which makes his daily food intake an exercise in patience and careful negotiation with restaurant staff and chefs.

From left to right: Beat Bucher (Forensic Technology), Kim Peterson (GPUG), Mark Huff 

From left to right: ?, Frank Heslin, and MVP Belinda Allen

After lunch, it was time to go visit some of my ISV friends. I had really been looking forward to get out to the Expo and pass by some of the booths to talk to some of the folks I normally run into at these events. Their work also serves to improve the lives of the Microsoft Dynamics GP community of users at large.

Rockton Software (Caption: Can’t you count? I only have 2, Beat!)

Ethotech: Stephanie Rasmussen, John Stulak, Kevin Rasmussen

FieldOne Systems (CRM Global ISV)

After walking around the Expo, it was time to go and work on last minute refinements for my upcoming CS15G002-R1: Microsoft Dynamics GP 2015: Upgrading and Deploying session. I had the 5:00 PM slot, so I knew by that time I would get a weary crowd.

Tim, Therese Jardine, and Ace Martin

All presenters are usually working on last minute deck improvements and catching up on emails before their sessions. Not to mention, the room is well equipped with coffee, snacks, and lunch for those choosing to avoid the crowd in the Meal Hall.

The Presenters’ Room

It was time to go and locate room A305. I arrived about 30 minutes before to do the customary tech check. As the crowd began to arrive, I figured I would begin asking random questions and entertain the group a bit before the 5:00 PM kickoff. I also managed to capture this picture (on David’s camera).

CS15G002-R1 Microsoft Dynamics GP 2015: Upgrading and deploying

My session had over 201 attendees and received the highest mark for any Dynamics GP session presented. The session also came in at 29 among the 265 delivered throughout Convergence.  Once the session was over, it was back to the Expo for a quick bite to eat and a drink while walking around saying hi to all friends.

Back at the Expo

 David and I decided to stop at the Microsoft Dynamics GP booth to say hi to our Microsoft friends.

Brian Roney, David Musgrave, and Alice Newsam

It was time to put this day away and get ready for another which would bring the Rock & Rave event and David and I delivering the first of our two sessions together.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

More:
Microsoft Convergence Atlanta 2015 (#CONV15) – Day 1 Continued

March 31, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 35

Free Windows 10, IoT and Azure Technet event by Microsoft in Sydney

Microsoft is running Technet Update at Australian Ballroom and Exhibition Room 14 Carrington Street, Sydney on the 16th of April, 2015. Register for this event here, should be worth your time.

 

Agenda

9:00am – 10:00am

Keynote – Getting to the value of the Internet of Things

Lee Hickin – IoT Commercial Lead, Microsoft Australia 

The Internet of Everything has become a catch-all phrase to describe adding connectivity and intelligence to just about every device in order to give them special functions, from tiny devices that might travel in our bloodstream to fully automated large scale mining operations. Billions of sensors will be shipped each year and the possibilities are endless. But what should be connected? and Why? Come along to this session and hear why businesses should care about the internet of things…….and learn where the real value lies. Microsoft will lay out its vision for how businesses can best take advantage of this growing trend and how it’s cloud and Windows technologies will offer a complete end to end solution

10:00am – 10:30am

Break

Stream 1 – Windows 10

Stream 2 – Microsoft Cloud OS

10:30am – 11:30am

Windows 10 – What does the new OS mean for Enterprises?

Foundation for the Software Defined Datacenter

11:40am – 12:40pm

Windows 10 Security – What’s new?

Extending Enterprise Networks to Azure using ExpressRoute

12:40pm – 1:30pm

Lunch

1:30pm – 2:30pm

Windows 10 – Deployment

Windows Azure Pack Overview

2:40pm – 3:40pm

Windows 10 for Mobile Devices: What’s Next?

Getting started with Microsoft Azure IaaS

3:40pm – 4:00pm

Break  (Close and Prize Draw)

4:00pm – 5:00pm

Networking drinks

See the article here:
Free Windows 10, IoT and Azure Technet event by Microsoft in Sydney

March 17, 2015 · Jivtesh Singh · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 43

Workflow Engine in GP 2013 R2 and GP 2015

I’ve seen a lot of activity recently on the Dynamics GP Forum, indicating confusion over what version of SharePoint works with the new GP Workflow 1.0 and 2.0.  Quick answer – none of them.  GP 2013 R2 and GP 2015 both have a native workflow engine built in, eliminating the need for SharePoint altogether.

 
Additionally, Reviewers and Approvers need not be GP users to Review and Approve workflow steps if Email Actions  is enabled.  Approval can be initiated from within email notifications generated by the workflow.

Read More:
Workflow Engine in GP 2013 R2 and GP 2015

March 11, 2015 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 53

Silverlight "ArgumentException: An item with the same key has already been added" when attempting to print a report

It’s been about 3 months now since working with Microsoft Dynamics GP 2015 in our production environment. To recap, at Intelligent Partnerships we run all our information technology infrastructure on Microsoft Azure. A big reason for this, of course, is the high degree of mobility required by our consulting staff and the ability to access demo environments and be able to enter timesheets and expenses from anywhere in the world they happen to be. In addition, we need to be able to run our business and access our financials and analytics without being constrained to a particular geographical location. As such we rely heavily on Dynamics GP’s Web Client and Business Analyzer to achieve these goals.

One of the issues we started noticing with Web Client recently is, when you attempt to print a report – Standard or Template – but cancel out the printing on the Report Destination window, then attempt to print the report once more, we would receive the following Silverlight error message:

Severity: Critical Summary: A server side exception of type “ArgumentException” has occurred. Details: ArgumentException: An item with the same key has already been added. at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource) at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add) at Microsoft.Dynamics.GP.Web.Services.Runtime.Dexterity.Hierarchy`1.Add(T ancestor, T item) at Microsoft.Dynamics.GP.Web.Services.Runtime.Dexterity.Implementation.WCDexRuntimeStateResourceManager.Register(DexUri parentId, IWCDexWindow window) at Microsoft.Dynamics.GP.Web.Services.Runtime.Dexterity.Implementation.Adapters.WCDexFormOpenStateChangedNotificationAdapter.Notifications_FormOpenStateChanged(Object sender, DexUriEventArgs`1 e) at System.EventHandler`1.Invoke(Object sender, TEventArgs e) at Microsoft.Dexterity.Runtime.Interop.DexNotification.OnFormOpenStateChanged(DexUri uri, DexFormOpenState value) at Microsoft.Dexterity.Runtime.Interop.Win32.NativeMethods.MsaCommandExec(Int16 tag) at Microsoft.Dexterity.Runtime.Interop.Win32.NativeMethods.<>c__DisplayClass26.b__25() at Microsoft.Dexterity.Runtime.Interop.Win32.NativeMethods.ExecuteMsaAction(Func`1 interopAction, String entryPoint) at Microsoft.Dexterity.Runtime.Interop.Win32.NativeMethods.MacroSystemCommandExecute(Int16 tag) at Microsoft.Dexterity.Runtime.Interop.DexMacroSystem.CommandExecute(Int16 tag) at Microsoft.Dynamics.GP.Web.Services.Runtime.Dexterity.Implementation.WCDexMessageProcessor.ProcessCommandExecuteInstanceResourceMessage(IWCDexMessage msg) at Microsoft.Dynamics.GP.Web.Services.Runtime.Dexterity.Implementation.WCDexMessageProcessor.Process(IWCDexMessage message) at Microsoft.Dynamics.GP.Web.Services.Runtime.Dexterity.DexRuntimeStateManager.SendMessage(IWCDexMessage message) at Microsoft.Dynamics.GP.Web.Services.Runtime.Dexterity.DexRuntimeStateManager.MainEventLoop()

This particular error was received attempting to print a sales order processing quote, but we have been able to reproduce from other windows. While I don’t claim to understand all these exceptions, this particular one seems to refer to an issue caused by a “key” being added twice to the same “Generic.Dictionary” collection. Since the action causing the error seems to be a second attempt at printing a report – the same report it seems – somewhere along the lines it would appear that some value isn’t being cleared out from the collection of reports being printed which would cause a duplicate key. Again, pure speculation.

Nonetheless, in speaking to the Dynamics GP development team, it seems to be this issue has been written up and may be solved in the upcoming hotfix release. This issue can be reproduced in Microsoft Dynamics GP 2015 build 14.00.0619 (January Hotfix).

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

Read the article:
Silverlight "ArgumentException: An item with the same key has already been added" when attempting to print a report

March 11, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 56

Chance to Fix a Bad Name

David Musgrave has just announced that he has completed the exclusive agreement with Microsoft to obtain the Support Debugging Tool source code.

He’s now looking at community feedback to fix the horrible name which always took a few tries to explain to people. “Why do I need a debugging tool ?” – most people I recommended the tool to asked me.

Go Vote for a new name that makes sense here – Where is the Support Debugging Tool for Microsoft Dynamics GP 2015?

PS – It was a good thing the tool was named the support debugging tool. With a slightly better name, and consequently even more popularity David would have had much more difficulty getting the source code !

More here:
Chance to Fix a Bad Name

March 11, 2015 · Jivtesh Singh · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 47