Page 1 of 82412345678910...2025303540...Last »

Archive for the ‘Blogs I Follow’ Category

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

Microsoft Convergence Atlanta 2015 (#CONV15) – Wrap Up

Hey, not that this concerns anyone, but finally here is the wrap up post for the Convergence 2015 event. It’s really been a busy couple of seasons for this writer (not that I’m complaining!), so I have had to opt for work instead of blogging which I’m sure you will understand as a reader.

Microsoft Convergence Atlanta 2015: GPPC PreGame

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 1

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

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 2

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 3

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 4

Other entries on the event, from my good friend David Musgrave:

#CONV15 – Convergence 2015 Atlanta – Day 0 – PreGame

#CONV15 – Convergence 2015 Atlanta – Day 1 – Opening Keynote

#CONV15 – Convergence 2015 Atlanta – Day 1 – Dynamics GP Session

#CONV15 – Convergence 2015 Atlanta – Day 1 – Continued

#CONV15 – Convergence 2015 Atlanta – Day 2

#CONV15 – Convergence 2015 Atlanta – Day 3

#CONV15 – Convergence 2015 Atlanta – Day 4

#CONV15 – Convergence 2015 Atlanta – Post Conference and Getting Home

At the time of this writing, I’m preparing myself for the GPUG Summit conference in Reno, Nevada. Things are continuing to be hectic

Until next post!

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

Read More:
Microsoft Convergence Atlanta 2015 (#CONV15) – Wrap Up

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

MDGP 2015 R2 Feature of the Day: Purchasing All in … – azurecurve

… Ian Grieve’s profile on LinkedIn View azurecurve’s Feed on Twitter MVP Profile View azurecurve’s facebook page View azurecurve’s Google+ View azurecurve’s Summary RSS Feed View azurecurve’s Detailed RSS Feed …

View article:
MDGP 2015 R2 Feature of the Day: Purchasing All in … – azurecurve

May 24, 2015 · Ian Grieve · No Comments
Posted in: Blogs I Follow Total Views: 2

MDGP 2015 R2 Feature of the Day: Scriptable … – azurecurve

… Ian Grieve’s profile on LinkedIn View azurecurve’s Feed on Twitter MVP Profile View azurecurve’s facebook page View azurecurve’s Google+ View azurecurve’s Summary RSS Feed View azurecurve’s Detailed RSS Feed …

See the original post:
MDGP 2015 R2 Feature of the Day: Scriptable … – azurecurve

May 24, 2015 · Ian Grieve · No Comments
Posted in: Blogs I Follow Total Views: 4

MDGP 2015 R2 Feature of the Day: Employee Self … – azurecurve

… and print their own W2. W2 – Wage and Tax Statement · W2. I said I would accompany these posts with some commentary, but the Payroll module is US and Canada only which, being based in the UK, I have nothing to add.

Continued here:
MDGP 2015 R2 Feature of the Day: Employee Self … – azurecurve

May 24, 2015 · Ian Grieve · No Comments
Posted in: Blogs I Follow Total Views: 3

Security Views For Use In SmartList Designer: Security … – azurecurve

Security Views For Use In SmartList Designer: Series Index · Security Views For Use In SmartList Designer: User Access · SQL View To Select User, Company and Security Role Assignment · Using SmartList Designer To …

See the original article here:
Security Views For Use In SmartList Designer: Security … – azurecurve

May 22, 2015 · Ian Grieve · No Comments
Tags:  · Posted in: Blogs I Follow Total Views: 3

Friday Funny: Finally…. The correct way to eat Vegemite

David Meego - Click for blog homepageIn recent years when I have come to conferences in the US, I have been bringing a stash of goodies with me.

Usually, this includes Arnott’s Tim Tams and Allen’s Chicos*, which are liked by almost everyone who tries them. And then there is the Aussie Icon, Vegemite.

The reaction I get from most people is one of abject terror, completely horrified when I suggest they try some vegemite. They will tell me how they have seen other Americans try it and that it is horrible, disgusting and compared to vomit.

US TV Hosts try Vegemite for the first time live on-air to celebrate Australia Day (direct link)

 

The problem is that those people who have tried it (including celebrities and TV show hosts) usually have tried it wrong. Usually very wrong. To quote one of my favourite TV comedies:

Wrong, wrong, brimming over with wrongability – Rimmer, Red Dwarf.

The problem is that Vegemite is very (read VERY) concentrated. Imagine an extremely salty beef and vegetable stock boiled down to a thick paste. Would you eat a spoonful neat? You just can’t spread it thick like peanut butter or Nutella and expect it to taste anything but disgusting.

It was first made as a by-product from another Australian favourite, beer. It is a dark brown food paste made from leftover brewers’ yeast extract with various vegetable and spice additives developed by Cyril P. Callister in Melbourne, Victoria, in 1922.

Here is another reaction from a recent episode of Jimmy Fallon’s Tonight show:

Jimmy Fallon and Steve Higgins try Vegemite (direct link)

 

So, finally it takes a famous Australian actor (and X-Man) Hugh Jackman to show Jimmy how to really eat Vegemite:

Hugh Jackman Shows Jimmy How to Really Eat Vegemite (direct link)

 

Hint: The butter (not margarine) should melt into the hot toast and the vegemite should be spread extremely thinly. If you can’t see the surface of the bread, you have it spread too thick and need to scrape some off.

That little 150g (5oz) jar should last a good 5 to 10 years. You can ignore the use by date. It never goes off and does not need refrigeration.

Go find some Vegemite and enjoy.

David

* While Allen’s is a Nestle brand, it seems they are too embarrassed to include Chicos in the product list.

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Fun, Public Service Announcement Tagged: Friday Funny, Fun

View article:
Friday Funny: Finally…. The correct way to eat Vegemite

May 22, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 17