Microsoft Dynamics GP "12" Named System Database Architecture

May 23, 2011

I received a lot of feedback from the community as a whole on the 3-part series of articles on Microsoft Dynamics GP “12” Web Client Architecture and I was pleased to know that many of you are embracing the fact that there will be a Web client version of the product and are asking numerous questions about readiness.

While these articles addressed the client portion of the solution, I really did not mention anything about changes in the database architecture and how these will impact the future deployment options. So, I have released a new architecture article on Microsoft Dynamics Community, this time addressing Microsoft Dynamics GP “12” Named System Database Architecture.

In this article I look at the named system database capabilities to be released in GP “12”. This is, the ability to set any name to the traditional, hardcoded DYNAMICS database. Hope you enjoy the article and if you have any comments or questions please feel free to post back.

For convenience sake, I will be adding a new link to the architecture series.

Until next post!

Mariano Gomez, MVP
IntellPartners, LLC


06/06/2011 – Changed article title to fit instructions provided by Microsoft Escalation team and current developments out of Fargo.


Upgrade Strategies for Microsoft SQL Server 2008

May 20, 2011

Back in June of last year, I talked about Microsoft SQL Server 2008 Upgrade Advisor and how it can help in identifying potential upgrade issues when moving from earlier versions of SQL Server – see Microsoft SQL Server 2008 Upgrade Advisor.

Bottom line, upgrading your database server requires careful planning. If you are still in the process of considering upgrading to SQL Server 2008 and are trying to workout whether to do an In-Place Upgrade versus a Side-by-Side Upgrade, then you will want to read Arshad Ali‘s article on the subject over at SQL Server Central.

Upgrade Strategies for SQL Server 2008

Arshad outlines why you should upgrade, the different strategies available, how to choose an upgrade method, putting a risk mitigation plan in place for your upgrade, the sequence of events, and much, much more, including how to read the results of the Microsoft SQL Server 2008 Upgrade Advisor tool. Go and take a look.

Until next post!

Mariano Gomez, MVP
IntellPartners, LLC

Microsoft Dynamics GP Database Installation and Upgrade Statuses

May 18, 2011

I have to admit that to deliver this post I had to dig deep into the bowels of the Microsoft Dynamics GP Utilities. Installation and upgrade statuses don’t seem to be anywhere (that I could find anyways) handy and can be very important when looking at a DEXSQL.LOG file for reasons of a failure during any of these processes.

Status Constant Storage Value

During the installation or upgrade of a database, status codes are recorded in the DYNAMICS..DB_Upgrade table for each Microsoft Dynamics GP dictionary being updated.

Until next post!

Mariano Gomez, MVP
IntellPartners, LLC

Unhandled script exception: Illegal address for field ‘[Not Found]’ in script ‘Unregister_Triggers’

May 17, 2011

If you have recently upgraded to Microsoft Dynamics GP 2010 R2, a few days aback, a partner reported receiving the following errors when returning from Report Writer:

Unhandled script exception:
Illegal address for field ‘[Not Found]’ in script ‘Unregister_Triggers’. Script terminated.


Unhandled script exception: Illegal address for field ‘[Not Found]’

The error is followed closely by:

Unhandled script exception:
Object has no reference.


Upon review, the error appears to be an issue with Extender and also happens when returning from Modifier. This issue has been written up as a bug and is scheduled to be fixed. To workaround the issue, exit Microsoft Dynamics GP 2010 R2 and log back into the system.

Until next post!

Mariano Gomez, MVP
IntellPartners, LLC

Microsoft Dynamics Most Influential People: Popularity vs Influence

May 16, 2011

Now that the Microsoft Dynamics Most Influential People Top 100 list is out I wanted to first congratulate everyone of my fellow MVPs and bloggers whose names appeared somewhere on the list and continue to wish everyone success. However, I also wanted to address those of you who were nominated (or not) and clearly not part of this list – see  David Musgrave‘s article Microsoft Dynamics Top 100 Most Influential People for 2011 published, and Mark Polino‘s article Top 100–Who’s Missing? for more information on the latter.

Still, I feel compelled to write this article because I believe that being “influential” has nothing to do with being “popular”. Though one could argue that these two words are used interchangeably, the bottom line is that they do stand their own ground. Being influential allows you to affect outcomes, to drive people to do things because you ask them to do so or because you are doing them and they follow suit, whereas popularity is nice and clearly something my teenage daughters are concerned with – not a seasoned professional who blogs and deliver quality content to the Microsoft Dynamics ERP community and industry as a whole.

Unfortunately, measuring influence is a difficult proposition, so to say that I am influential, or that other person is influential is a mouthful. Influence clearly sounds better, however popularity is much, much easier to measure. Hence nominations and voting are at hand when it comes to select who’s most influential – though most people do so thinking of popularity.

So, is it even possible to measure influence? I personally think influence is more a qualitative than quantitative element of blogging, social media, or any other influence mechanism used in the process and as such I would have to say it’s difficult, if not impossible, to accurately measure. And what about people who work behind the scenes? What about someone like Kirill Tatarinov, Corporate VP at Microsoft for example? How can you measure his influence in the community? How can you tell if he influenced your decision to buy Microsoft Dynamics GP, or CRM, or any other product in the Dynamics ERP family? After all, he is not a blogger and you sure don’t see him directly advertising anything, do you? Of course, he gets to do all these things at conferences, but this is every once in a while. So the question still lingers… how do you measure influence?

Disclaimer: I am not saying the “big boss” is not influential, just merely using him as an example to state my case.

I personally think my influence (if any!) comes from my professional network and my credentials as a Microsoft MVP. If I report a problem to Microsoft, it might be fixed much more faster instead of being buried in a mountain of bug reports and support tickets. If I identify a product feature that the community as a whole is requesting, it might actually get some consideration given my (perceived) status within the community. If I speak at a conference about a product like Support Debugging Tool, chances are people will go back to their organizations to download and test it. I don’t necessarily see how those things can be accurately or fairly measured. How do you/can you measure the effects one person’s action over another? How many minds do you have to change to be “influential”? The bottom line is you can’t measure enough of the elements needed to establish if someone is influential or not.

If you really must rank the Microsoft Dynamics most “influential” people, then clearly you do what you must to get the results, but why not call it what it is… Microsoft Dynamics Most “Popular” People – automatic voting certainly did not help the case either. However, I take issue with this process because it leaves out people who are making a real difference in the Microsoft Dynamics community.

Now, can anyone explain why Doug Burgum is still considered “influential”? Rest my case!

Until next post!

Mariano Gomez, MVP
IntellPartners, LLC

Microsoft Dynamics GP "12" Web Client Architecture – Part 3

May 16, 2011

This is article 3 of 3 from the series Microsoft Dynamics GP “12” Web Client Architecture. Some images and content reproduced with express permission from Microsoft Business Solutions, a division of Microsoft Corporation.

In Part 2 we explored the Microsoft Dynamics GP “12” Web Client’s Rendering Engine and how it had to be decoupled from the overall Dexterity Runtime Engine functions, in order to create a Generic Window Object that could be rendered as a Windows Form or a Silverlight interface.

Today this article discusses how a Generic Window Object is transformed into a Windows form or a Silverlight UI, but before, let’s remember that the Window Manager, a former part of the Dexterity Runtime Engine, is still in charge of processing the UI events while  the Rendering Engine presents the interface to the end-user.

Dynamic Form Rendering with Template Processor

Now that the Dexterity Runtime Engine has been freed of these tasks, the resulting Generic Window Object must be processed to produce either interfaces. For this, the Development team has created Template Processor.

Template Processor takes a generic representation of a window and is able to deliver an XML version of its content (fields, buttons, and events in the case of a traditional Dexterity window), called a Window Template, but as well delivers a version that the Dexterity Runtime Engine can still display in the classical client, also known as coreTemplate. The technique of processing a Generic Window Object into an XML Window Tempalte and a coreTemplate has been labeled Dynamics Form Rendering.

The XML Window Template is then delivered to Silverlight via a browser application – explicitly Internet Explorer given the use of Silverlight – where the Rendering Engine uses a Converter to serialize into a Silverlight UI. Since the Dexterity Runtime Engine retains the ability to understand the coreTemplate elements, displaying a Windows form is still a natural function.

Dynamic Form Rendering – Developer’s Experience

The result will still allow developers to create traditional Dexterity customizations against the classic client UI or the XML Window Template generated by the Template Processor.

On a closing note, GP “12” aims to provide additional deployment methods to the traditional classical client deployment, where the client is either delivered as an installation at desktop level or in a Terminal Server or Citrix environment. With the Silverlight client, users can rely on their Internet Explorer browser and the Silverlight plug-in to run their Microsoft Dynamics GP application, while retaining the feature rich functionality of the classical client.

To make things even more interesting, a deployment environment can take advantage of both the classical client and the Silverlight client at the same time. Why would you need both? I suspect certain application functions like maintenance are best executed from the classical client, however in the scheme of things, it allows for a smooth end-user transition.

Finally, I hope you enjoyed this series of articles and I will continue to work with the Microsoft Dynamics GP Product Management team to deliver information to you as it becomes available (and needless to say, not deemed a trade secret). There is more to all this than meet the eyes.

Until next post!

Mariano Gomez, MVP
IntellPartners, LLC

Free post-Microsoft Dynamics Convergence Atlanta 2011 webinar – RESCHEDULED!

May 12, 2011

By request, we have been asked to reschedule this webinar. Apparently interest was high, but schedules a bit conflicting. So, if you did not get a chance to sign-up the first time around, you now have a second chance! Come and join me and my fellow IntellPartners team members in this post Microsoft Convergence Atlanta 2011 webinar to gain an insight into some of the key topics covered at the event:

  • Microsoft Dynamics GP roadmap – presented by IntellPartners CEO, Ted Mauldin
  • Migrating FRx to Management Reporter – presented by MVP Frank Hamelly
  • Effectively Administering Microsoft Dynamics GP – presented by MVP Mariano Gomez

Join us – Wednesday May 18th, 11:00 AM – 12:00 PM, EST and you will be entered in a drawing to win a FREE one day guest pass to Microsoft Convergence Houston 2012! Don’t miss this fabulous opportunity.

Click here for more details.

Until next post!

Mariano Gomez, MVP
IntellPartners, LLC