Page 1 of 7512345678910...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: 56

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: 59

CBM Cash Receipt Customer GL Posting Account Error

A user reported this issue when he tried to enter a cash receipt in CBM module. Following error message prevented him from continuing further.

Screen Shot 2015-02-23 at 3.10.24 PM

This error was confirmed to be happening only for one particular customer record. For all other customers, it worked.

We basically do not have posting accounts setup for each customer or customer class. So it is absolutely no way due to missing posting accounts. Several minutes later, decided to compare customer records between this particular customer and one other customer that’s working.

REASON: Customer Class ID for this customer record was wrong and was not part of the list of customer classes that we have setup on our company. Because this class ID was wrong, posting accounts validation stopped right there and threw a message that was totally irrelevant to actual reason.

RESOLUTION: I changed the customer class ID for this customer with an existing one. User could then enter a cash receipt in CBM.

Troubleshooting issues successfully is probably the best way to end a business day!

VAIDY

Filed under: #MSDYNGP, Cashbook, CBM, Troubleshooting

Continue reading here:
CBM Cash Receipt Customer GL Posting Account Error

February 23, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 96

Announcement: Blog consolidation

The Microsoft Dynamics GP Support team is pleased to announce that we’ll be consolidating our two blogs: Developing for Dynamics GP and Dynamics GP Support and Services Blog, into a single location.

 

Moving forward all content from the Microsoft Dynamics GP Support Team will be posted to the Dynamics GP Support and Services Blog.  The content in the Developing for Dynamics GP blog will remain at its current location for your future reference, but be sure to check the Dynamics GP Support and Services Blog for all newly published content from the Microsoft team!  Specifically, the upcoming Service Based Architecture blog series that will introduce you to this exciting new functionality in Microsoft Dynamics GP 2015.

More:
Announcement: Blog consolidation

February 16, 2015 · Lucas Miller · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 96

Microsoft Super Bowl XLIX Commercials: #Empowering

Super Bowl XLIX is now over and congratulations are in order for the now 4-time champion, the New England Patriots organization led by head coach Bill Belichick and quarterback Tom Brady. I must also extend congrats to the Seattle Seahawks who put up quite the fight until the end, and simply could not complete the rare feat of a back-to-back championship.

You can catch the game highlights below:

And speaking of winners, how about those touchy Microsoft #Empowering Super Bowl commercials (remember Super Bowl XLVIII ones?) Microsoft came up with two real life examples showing where their technology is being applied to improve the lives of people. You be the judge of these two ads.

Braylon O’Neill’s story

Microsoft Super Bowl Commercial 2015: Braylon O’Neill   

Braylon was born with a strong sense of determination. He was also born without the two bones that make up the lower leg: the tibia and the fibula.

At just 11 months old, Braylon was fitted with his first prosthesis. His doctors use technology to track his gait mechanics and make adjustments that maximize his strength and performance. Braylon is now an unstoppable speed demon – in races with CAF (Challenged Athletes Foundation) he has taken home medals and inspires others to reach beyond their limits

Estella Pyfrom’s story

Microsoft Super Bowl Commercial 2015: Estella’s Brilliant Bus

Estella Pyfrom could have chosen to enjoy a nice quiet retirement. Instead, she had an idea that would change her life and the lives of thousands of families.

At the age of 71, Estella decided to spend her life savings and build a bus to bring technology to underserved communities. Today, Estella’s Brilliant Bus has helped more than 60,000 children gain access to technology and envision a bigger, brighter future for themselves.

Click to find out more about Microsoft #Empowering. Catch more Super Bowl XLIX videos on the NFL’s YouTube Channel.

Until next post!

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

Follow this link:
Microsoft Super Bowl XLIX Commercials: #Empowering

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

SOP Quick Print feature does not work when window ribbons are enabled

Happy New Year!! Hope all of you had a great time with family and friends and that you are back getting used to the daily grind once more.

Today, I want to kick off the year with an issue in Sales Transaction Entry window related to the cool ribbons implemented since Microsoft Dynamics GP 2013 R2. By now, you are probably getting used to the absolutely gorgeous user interface which features Microsoft Office style ribbons on every window. Furthermore, you probably already know that the use of such ribbons is actually customizable and in many ways optional – albeit being the default configuration – as described by fellow Microsoft Dynamics GP MVP, Leslie Vail in her article GP 2013 R2 Ribbons. As it turns out, there’s a Dex.ini switch, EnableWCRibbons=FALSE, that controls whether ribbons are enabled within Microsoft Dynamics GP or not. When ribbons are enabled, users can further customize the appearance of the action pane or return to the traditional menu bar for each window.

User Preferences window

Yesteryear (2009), I wrote an article talking about The wonders of CTRL+Q: saving and printing SOP documents in one step and how the Quick Print feature made life easier to the poor souls out there who needed a quick shortcut to printing SOP documents from the Sales Transaction Entry window. In that article I detailed the mechanics behind the feature, written by my good friend David Musgrave.

As fortune would have it, when ribbons are enabled and you are either using the Action Pane or the Action Pane Strip layouts, the Quick Print feature does not work. However, if the User Preference is returned to Menu Bar (you will need to exit Dynamics GP and re-launch for the changes to take effect), the Quick Print option (and CTRL+Q keyboard combination) works just fine.

While clearly an inconvenience, this can hardly be labeled a bug since the feature is still present within the application when the Window Command Display setting is set to Menu Bar as part of the user preferences. It would be nice, however, to have this fixed for Dynamics GP in desktop client mode. I can see how this may or may not work under web client mode as the browser keyboard shortcut combinations take precedence over the application’s shortcuts.

Until next post!

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

Read more here:
SOP Quick Print feature does not work when window ribbons are enabled

January 7, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 83

Tech Tuesday: Setting Timeout for SmartView Internal and SmartView External

Each week we like to give you a bit of technical news that could benefit you now or in the future with our products! This week’s Tech Tuesday is from our Quality Assurance, Jared Dux, on timeout errors within SmartView Internal and External.

If you are reporting a large number of records and fields you may have ran into a timeout error as seen below.

More:
Tech Tuesday: Setting Timeout for SmartView Internal and SmartView External

January 7, 2015 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 75