Page 1 of 16612345678910...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: 62

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 3

Ok, I’m officially tired! Day 2 did not leave much room to sleep with a presentation, expo, dinner, and Rock-n-Rave (even though I did not stay long).

However, today I had to gut it out for our repeat session, CS15G024-R2 Microsoft Dynamics GP 2015: Customizing the user interface, which was scheduled for 11:00 AM.

CS15G024-R2 Microsoft Dynamics GP 2015: Customizing the user interface
Mariano Gomez and David Musgrave

We had 64 people in our session and really had an enthusiastic crowd despite the Rock-n-Rave precedent. The session went on as planned and we feel we had a bit more organization in our delivery.

Once our session finished, I ran off to Kevin and Dan’s session, CS15G014 – Leveraging Microsoft Dynamics GP 2015: Service Based Architecture for better integrations.

Kevin Racer and Dan Lothspeich

This session was truly informative as Kevin and Dan walked through the evolution of the work environment and how it has been impacted by the ever increasing hours we spend working, the ever decreasing workforce age, our own understanding of the Internet, the increasing workload many of us are challenged with, and the endless ways to communicate. This all has led companies to seek increased computing resources to process massive amounts of data which cloud computing seems to deliver well via a service oriented architecture model. This service model has driven the appification of software functionality, a technique by which software functions are exposed as services to be consumed by other software applications.

This brings us to the Microsoft Dynamics GP Service Based Architecture model, which seeks to expose parts of Dynamics GP as services to be consumed by other applications, also allowing Dynamics GP to consume services.

Microsoft Dynamics GP Service Based Architecture

The key to this technology evolution has been the enhanced interoperability with Microsoft .NET built within the Microsoft Dexterity toolset and leveraged via the Dynamics GP application. Kevin then went on to conduct a short demo on the endpoint URI structure and patterns to access the Dynamics GP services and showed off some of the cool discovery tools available, while detailing the security flow and authentication mechanisms required to access the Dynamics GP services.

Then we had eOne demoing their latest product, Service Builder which allows users and developers to expose any part of GP as a service, similar to how SmartList Builder exposes GP data. In fact, the idea is to also allow users to expose smart lists as services. Other applications include being able to expose Microsoft Dynamics GP windows and the underlying Dexterity scripts as services, conceivably allowing any function within GP to be consumed by other applications.

Well, I could go on and on, but hopefully you get the point. Kevin and Dan’s session is available on the Virtual Convergence site, here.


I returned to the Expo to try and catch up with David who had attended another session, but decided to go visit some folks I hadn’t seen yet. After saying hi and catching up with David, we returned to the Omni Hotel in preparation for the OneRepublic concert and to decompress from the day. I had invited a good friend of mine and I left to pick her up and return to the Phillips Arena.

The OneRepublic concert motto: “One Believable Convergence Celebration”

Once inside the arena, we quickly head to the floor area to get a good view of the group for the opening. In the meantime, we were enjoying some of the cool music being played. The group came on stage with their song Light it Up to open the concert.

The concert got progressively better with the group artists hitting some solos.

Well, the night was really a good one, but it was time to wrap up and get home.

Until next post!

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

Read more here:
Microsoft Convergence Atlanta 2015 (#CONV15) – Day 3

April 2, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 59

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 1

Keynote and General Session

I know, it’s been over a week since Microsoft Convergence 2015 closed its doors, however, I did not want the time to go by without reliving some of the things I personally experienced throughout the event. With early mornings and late evenings it became impossible to write blog posts as things were happening, considering my own involvement with quite a few of the activities and presentations at Convergence.

Day 1 started out with David and I rushing through Atlanta’s traffic to get to the Georgia World Congress Center. From there we would head over to the Phillips Arena for the Opening Keynote Speech. We got there at the tail end of the presentation of Dance 411. The Dance 411 Foundation’s mission is to foster the well-being of urban youth and young adults through self-expression. They provide a quality education and exposure to the discipline of dance, drama and music. Judson Althoff, President Microsoft North America was in the middle of interviewing JJ Crampton and Sindy Scheider, both directors of the Foundation and requesting everyone filled out the Convergence event evals, for which Microsoft would make a donation to the Foundation.

Dance 411

Once the dance group completed their presentation, Althoff was once on stage to talk about the Atlanta Youth Project and Truly Living Well Center for Natural Urban Agriculture and the volunteering work done in conjunction with the Convergence attendees who signed up for community outreach, now a staple of these events. The community outreach video was accompanied by an original song by The Groove Merchants.

Upon the conclusion of the community outreach video, Althoff was back on stage to describe the upcoming days at Convergence and some of the guest speakers that attendees would have a chance to experience. He also alluded to the fact that the event itself, Convergence, is also evolving and changing, just like the businesses present at the event. He also noted that Convergence used to be a Dynamics only event. Microsoft has expanded the event and evolved it to actually incorporate all of its innovations. Convergence has become the Premier Business Event.

Without further due, Satya Nadella was on stage to talk about how Microsoft is empowering every person and every organization on the planet to achieve more, via the “systems on intelligence”.

Satya Nadella on Microsoft’s Vision

The systems of intelligence interact with the systems of record to make sense of the data collected. Microsoft is focusing on the automation of the systems of intelligence, with the richness of its cloud infrastructure. To further talk about how other industries are taking advantage of the technologies that drive the systems of intelligence, Satya welcomed Seattle Seahawks’ Russell Wilson.

Seattle Seahawks Russell Wilson

Russell described how he uses OneNote to track all his activities on and off the field and how the National Football League (NFL) leverages Microsoft Surface during the games to analyze team formations, plays, and players in near real time – Microsoft is a sponsor of the NFL.

The rest of the presentation focused around the use of other technologies such as Yammer within Microsoft itself. Also there was a cool case study on how AccuWeather is leveraging Microsoft Azure to deliver custom and personalized weather to both consumers and businesses.

AccuWeather

After the case studies, it was time for Mark, Belinda, and I to head over to the GWCC to wire up for the Microsoft Dynamics GP General Session, to be held at the Sydney Marcus Auditorium. Upon arrival, I went back stage to check in and had a chance to capture this picture with the engineering team at work.

Video and Audio Engineering Room

This year, the Microsoft Dynamics GP General Session featured a number of info-bites showing what each of the presenters were doing at different stages during the 90’s and various terminologies born from that time.

Little bits of information before session

This year’s Dynamics GP General Session would focus on product strategy and roadmap, and as customary, it began with with Errol Schoenfish welcoming all attendees and discussing the Microsoft Cloud for Business strategy, which features Office 365, Azure, and the business applications, including Microsoft Dynamics GP. Errol went on to demo a Time Management app (#IfErrolCanDoIt) showing how it would work on various device platforms.

Then came the highlight of the event (ehem!): The MVP Duel featuring Mark Polino and I, with a special guest, Belinda Allen. Our presentation, showcasing a number of new features in Microsoft Dynamics GP 2015, went very smooth and features were well received by the audience.

The MVP Duel – From left to right: MVPs Mark Polino, Belinda Allen, and Mariano Gomez

Up next was the customer story featuring Rural Renewable Energy Alliance (RREAL), a non-profit dedicated to make solar energy available to low income families.

Next up was Jennifer Ranz to demo a day in the life of a RREAL employee. Jenn showed the dashboards released for Office 365 and PowerBI. Jason Edens from RREAL came on stage to talk about how their company is leveraging Microsoft Dynamics GP to run their business.

The session went on with other demos and a glimpse into the future of Microsoft Dynamics GP. First up was Jeff Trosen to talk about the evolution of the Microsoft Dynamics GP roadmap. Chad Sogge came up next to talk about the new HTML 5 interface and provide a demo of how this new web client technology will allow for a better user experience across browsers and devices.

Errol Schoenfish and Chad Sogge on the Future of Microsoft Dynamics GP Web Client

I had to finally get a shot of the audience.

Microsoft Dynamics GP General Session Attendance

Well, in my next post, I will talk about the sessions we delivered throughout the rest of the event.

Until next post!

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

See more here:
Microsoft Convergence Atlanta 2015 (#CONV15) – Day 1

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

Tech Tuesday: SmartList Builder, GP Web Client, and the GP January Hotfix

We wanted to make everyone aware of an issue that we have come across in recent weeks.

There is an issue in the January Hotfix for Microsoft Dynamics GP that is causing SmartList Builder issues when used in the Web Client. Because of the issues in the hotfix, the Table Finder feature in SmartList Builder cannot load and it causes GP in general to fail loading. If you remove SmartList Builder

View article:
Tech Tuesday: SmartList Builder, GP Web Client, and the GP January Hotfix

March 17, 2015 · Nicole Albertson · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 65

Meet the eOne Convergence Team!

Convergence is just a few days away. We can hardly wait to get there and see some new and old faces. Before we head into the week, we wanted to introduce the members of our team heading down to Atlanta:

Meet our Director and Manager

Martin Olsen co-founded eOne back in 2001. He has been leading the team in Australia and recently moved to Fargo, ND to help grow the US office. Apart

Read the article:
Meet the eOne Convergence Team!

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

You receive "Unable to Upgrade SBA from RTM" when attempting to apply Microsoft Dynamics GP 2015 January or March Hotfix

Well, this one for sure has bitten more than one person already. I’ve seen a lot of exchanges and fielded a number of calls from folks trying to install the January or March hot fixes of Microsoft Dynamics GP 2015. When the msp file is executed, couple seconds into the execution you receive the following error message:

Unable to upgrade SBA from RTM. Please remove the SBA feature before running this patch.

The first reaction is to try and find the feature via the Uninstall or change a program options under the Windows Control Panel. As it turns out, there’s no such option. This has led many folks to the next “obvious” option: Microsoft Dynamics GP Web Components.

When you choose to uninstall the Microsoft Dynamics GP Web Components, you will get rid of the Web Client install, but not the SBA components.

So what’s the solution?

The keyword in the error message is the word “feature”. SBA is a Microsoft Dynamics GP feature. In order to remove, you will need to right-click on Microsoft Dynamics GP 2015 and select the change option.

You will then click on the Add/Remove Features option in the Program Maintenance window, then scroll down until you see the Service Based Architecture option in the Select Features window. You can the proceed to click on the corresponding options button associated to the SBA prompt and select Not Available.

Select Features window

Once you click Next, the installer will proceed to remove the feature from your environment. When completed, you can re-run the hotfix msp to apply the updated code.

Until next post!

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

More:
You receive "Unable to Upgrade SBA from RTM" when attempting to apply Microsoft Dynamics GP 2015 January or March Hotfix

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

Convergence Question #1 – Do You Have Any Promos?

It’s almost time for Convergence 2015 and we’re ready with the
most commonly asked question eOne gets at the expo:

DO YOU HAVE ANY PROMOS?

This year, the answer is – yes, of course we do – for dedicated
Convergence attendees. 

Here are the promos so you can be ready (and know – they expire 4/30/15!): 

SmartList Builder Self-Paced Training 
Simply
tweet a picture of our roaming Bob the

Read More:
Convergence Question #1 – Do You Have Any Promos?

March 12, 2015 · Abbey · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 63