Wednesday, August 26, 2015

You receive "Could'n retrieve the list of available databases: The connection attempt failed" error when updating Management Reporter 2012


Hi everyone! I'm on the tail-end of upgrading a client to Microsoft Dynamics GP 2015 R2 and came up on an interesting issue when attempting to update Management Reporter 2012 CU6 to CU9.

Background

In order to create my client's test environment for this upgrade, we cloned their production VMWare environment and went through all the usual server renames, static IP changes, SQL Server renaming, and so forth.

For the Management Reporter 2012 database server, we followed the applicable entries outlined in How to move Microsoft Management Reporter 2012 to a new server (CustomerSource access required), and in particular we removed the Application and Process services then ran the T-SQL script to re-create the certificate and symmetric key.

Once these portions of the configuration were in place, we proceeded to install Management Reporter 2012 CU9, first installing the Application and Process services - which also performed the overall ManagementReporter database update.

Next was to create the Data Mart database.

When we tried to connect to the Dynamics GP server to retrieve a list of the available databases to select the system database, we stumbled upon the following error: "Couldn't retrieve the list of available databases. The connection attempt failed."

Configuration Console - Dynamics GP Connection information error when clicking on the Database drop-down list

When I checked the Event Viewer, the following entry could be seen:

The encrypted setting, Password, could not be decrypted.
--- Exception Dump --- 
Caught Exception: [System.Security.Cryptography.CryptographicException] Encrypted data was invalid and cannot be decrypted.
Stack trace:
   at Microsoft.Dynamics.Integration.DataAccessLayer.DataProtection.Decrypt(Byte[] data)
   at Microsoft.Dynamics.Integration.DataAccessLayer.DataProtection.DecryptSettings(XElement settings)

User: Domain\MRAdmin
Machine: GPTOOLSTEST

Solution

Clearly, the data source information to the Dynamics GP database server wasn't being adequately validated somewhere by the installer. Furthermore, the installer was attempting to decrypt the password I was passing in via Microsoft.Dynamics.Integration.DataAccessLayer.DataProtection.Decrypt() method which happens to be a part of the Dexterity Shared Components.

I then recalled that the Management Reporter Server installation process uses the Dexterity Shared Components to validate the connection to the system database. In reviewing the Dexterity Shared Components on the server, I found out that version 14 was installed -- version 14 corresponds to the Dexterity Shared Components installed by Dynamics GP 2015. So, I was a bit puzzled. However, further analyzing this issue, I realized that CU9 predates the days of Dynamics GP 2015, so the version of the Dexterity Shared Components it must be looking for were those of Dynamics GP 2013 or earlier. It was a long shot, but I installed the Dexterity Shared Components version 12 from the Dynamics GP 2013 CD.

Once I fired up Configuration Console and attempted the configuration of Data Mart, I was then able to choose the system database from the Dynamics GP server and complete the process just fine.

Additional Notes

In doing some poking around into the ManagementReporter database tables, searching for a potential answer to this issue, I found that the dbo.ControlCompany table contains the GLEntityConnectionInformation column, which stores an XML document with some connection information. If your test environment is a result of cloning a VMWare or Hyper-V image, chances are the data stored in this column will contain the original server information and will need to be edited to reflect the current test environment server information. By simply right-clicking on the table and choosing to Edit the Top 200 rows option, you can edit the server name. The content of the XML document stored in this column looks something like this (server name in red):

<?xml version="1.0" encoding="utf-16"?>
<ArrayOfEntitySetting xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <EntitySetting Name="DummyUserControl">
    <Value xsi:type="xsd:string" />
  </EntitySetting>
  <EntitySetting Name="SQL Server">
    <Value xsi:type="xsd:string">GPTOOLSTEST</Value>
  </EntitySetting>
  <EntitySetting Name="DDM Database">
    <Value xsi:type="xsd:string">DDM</Value>
  </EntitySetting>
  <EntitySetting Name="Organization">
    <Value xsi:type="xsd:string">TWO</Value>
  </EntitySetting>
  <EntitySetting Name="Windows Authentication">
    <Value xsi:type="xsd:boolean">false</Value>
  </EntitySetting>
  <EntitySetting Name="SQL User">
    <Value xsi:type="xsd:string">sa</Value>
  </EntitySetting>
  <EntitySetting Name="SQL Password">
    <Value xsi:type="xsd:base64Binary">AOaPHTA9VkmLvkUcyA053AEAAABurN19cbBVL3sfs/UoYU4o3YPglXB4SSrzLzXjlavUpC+uSNKdDYDDEjS9MfKKlao=</Value>
  </EntitySetting>
  <EntitySetting Name="Enable SSL">
    <Value xsi:type="xsd:boolean">false</Value>
  </EntitySetting>
</ArrayOfEntitySetting>

So you maybe asking, "why not update from CU6 to CU13+Hotfix directly?". As it turned out, I found out that this while technically possible, causes some very undesired results with very complex reports. More on this in a follow up post.

Until next post!

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

Wednesday, August 12, 2015

You experience slow performance exiting Microsoft Dynamics GP 2015 on Windows 10

Today I ran across a very interesting partner forum post, in which the consultant described a slow performance issue when closing (exiting) Microsoft Dynamics GP 2015, which started happenning after his client upgraded their Windows workstations to the newly minted Windows 10 operating system.

A Microsoft support engineer acknowledge that "there have been a few people experiencing this issue". The recommendation to bypass the slow application closing is to change or add the following Dex.ini setting to see if it resolves the issue on exit. The setting changes a Microsoft Dynamics GP global variable and avoids the pause that seems to be occurring during the exiting process.

OLEClose=FALSE

This Dex.ini setting controls whether the Microsoft Dynamics GP application checks for the OLE Container application being opened at the time of shutdown -- a "shutdown" can occur if the user legitimately exits Dynamics GP or simply chooses to open either the Report Writer or Modifier tools. If the Container is open during the shutdown operation, Dynamics GP will attempt a graceful closure of it.

The default value of this setting is TRUE, whether the setting is present in the Dex.ini with a value of true or empty, or simply not present at all. This indicates to GP that it should always attempt to close down the Container if it is found to be open.

Given the fact that most customers are now taking advantage of Document Attachment (Doc Attach) and moving away from the Container application, there should be less and less dependency on Container, which would almost require that the default value for our flag is set to FALSE, rather than it's current state.

As usual, you must apply these changes to your environment only if you are experiencing this issue.

Until next post!

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

Monday, July 27, 2015

New #MSDYNGP Certification Process

Hi everyone! I know, it's been a while since you've heard from me, but my contributions to the Microsoft Dynamics GP community go beyond just blogging and attending events. I've been involved with the development of the next generation of Microsoft Dynamics GP exams and certification process, which is been quite a rewarding experience and certainly a time consuming one. I have always been a firm believer that certifications are an important part of a professional career development, whether you are a partners, a consultant, or a customer, hence, I've spent quite some time over the past few months working with the good folks of the Association of Dynamics Professionals in a counseling capacity to bring new guidelines and a certification process that will be industry worthy.

But as many of you already know, this is the kind of stuff I really enjoy, but we cannot do this by ourselves, so here is where you come in: I NEED YOUR HELP!

The main goal is to build a set of exams that will lead up to a master certification, which will show various degrees of professional development to prospective employers, whether you choose to work for a Microsoft Dynamics GP customer, partner, ISV, or remain an independent consultants. The first iteration of the exam building process is to source questions from the general public. If you are interested in submitting one or more questions for the exam, we would love to hear from you and your help is greatly appreciated.

We have so far invested quite some time into building a solid certification process and need you to think about what questions you would like to see in the exams that will be administered down the road. This will require you to THINK and put some effort into coming up with the questions you submit.

You can go to credentialing.dynamicspro.org and follow the instructions there to submit your questions. You’ll have to watch a video on what makes a good or bad exam question and there is a process to follow. Be patient and work your way through. There's no limit as to how many questions you can submit, but we want your best effort.

This is something that's going to benefit the community as a whole and will allow you to follow your career path in the Dynamics GP world.

Until next post!

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

Friday, May 29, 2015

"A SQL Server login already exists for . Delete the user and create a new user" error when switching a user ID from web client only to mixed mode access

I'm completing the deployment of Microsoft Dynamics GP 2013 R2's Project Accounting and Time Entry approval workflow for a customer in Alabama who is currently deploying web client for extranet access (and timesheet entry) and desktop client for intranet access.

As a result, since time entry employees are remote, we decided to setup these user accounts as web client only. However, the customer wanted to provide an alternative to the web client in case it became unavailable. This meant that these users would needed the ability to access the Microsoft Dynamics GP desktop client via a Terminal Server provisioned (albeit temporarily) to support this goal.

The Problem

To meet this requirement, we needed to adjust the user accounts in Dynamics GP to also support SQL Server authentication (in addition to web client access), by deselecting the Web Client user only check mark and completing the SQL Login credentials information. Upon attempting to save the changes we received the following error:

A SQL Server login already exists for userID. Delete the user and create a new user.


As it so turns out with most application errors, you cannot just follow the instructions literally to fix the problem. In this case, we had more than 85 web client only user accounts created so "Delete the user and create a new user" wasn't an option and I don't know why I had a gut instinct this recommendation would not work anyways.

It also turns out that I tested this in Microsoft Dynamics GP 2015 and had no issues switching a user account from Web Client user only to a mixed mode access user account.

NOTE: "mixed mode access" user is a terminology I came up with to identify a Microsoft Dynamics GP user account with access capabilities from both the web client and desktop client.

The Solution

In troubleshooting this problem, the first thing is to focus on the first part of the error message, "A SQL Server login already exists". If a login already exists on SQL Server, then it should be visible under Management Studio - bear in mind that each Dynamics GP user account was setup as a web client only account to begin with. In principle, there should be no SQL Server security principal for these type of accounts.

Management Studio did not show any account created for the Dynamics GP under the Security folder. So the next logical thing would be to run a statement to check for a SID for the account in question:

SELECT suser_sid('TheUserID');

This statement returned an actual SID number (a long hexadecimal set of characters), confirming at least there was a corresponding SID for the account, even though we could not see the actual account in Management Studio.

Next was to verify then, what account was assigned to that SID. In order to do this, I ran the following SQL statement:

SELECT name FROM sys.server_principals where sid = (SELECT suser_sid('TheUserID'));

As it turned out, this statement returned no results. So here's the conundrum... GP thinks there's a SQL login for a user account that doesn't really exists on SQL, but has a SID.

Now, because there wasn't an actual SQL login for the user ID in question, I went ahead and setup a new SQL login with the user account by running the following statement:

sp_addlogin('TheUserID', 'somePassword');

The statement was successful and I could now see the SQL login under the security folder.

The next thing was to then reset the Dynamics GP web client user flag and assign the SQL login to the user account:

UPDATE SY01400 SET WCUser = 0,  SQLLoginID = 'TheUserID' WHERE USERID = 'TheUserID';

Since Microsoft Dynamics GP passwords are encrypted on SQL Server, you will now need to log into Dynamics GP, pull up the user account under the User Maintenance window, and change the password in the SQL login credentials section.

I cannot assess whether this is a bug or not, but suffice to say the same behavior is not present in GP 2015, so I must lean towards it being a bug.

I hope you find these troubleshooting steps useful.

Until next post!

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

Sunday, May 24, 2015

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 878449 - How 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 and 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". An update is certainly everything but a "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/

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


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


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/

Thursday, April 2, 2015

Microsoft Convergence Atlanta 2015 (#CONV15) - Day 4


Phew! How about that OneRepublic concert?

Day 4 is finally here and with it, all good things must come to an end. For a change, today David and I managed to make it down to the GWCC on time and had a fairly relaxed breakfast at the Meal Hall to then move over to the Phillips Arena for one very interesting closing keynote.

As customary, an energetic Judson Althoff, President Microsoft North America welcomed the crowd to the event and proceeded to recap the week and what will be seen from Microsoft in the coming months.

Judson Althoff, President Microsoft North America
The first thing in his opening was to remind the audience how Convergence is becoming the premier event for business and that Microsoft, at its core, is "the productivity and platform company for the mobile first, cloud first world" and how the company is thinking about innovation and technology.

Althoff then introduced the upcoming events, Microsoft Ignite which is geared to showcase innovations for IT professionals, the Dynamics User Group Summits hosted by Dynamic Communities.

Microsoft Ignite

Dynamics User Group Summits
Althoff then zeroed in on the upcoming Convergence events and announced the dates and locations for Convergence 2015 EMEA and Convergence 2016 New Orleans. The latter received a round of shouts from the audience.

Convergence next stops
Then came the topic of the day: Cyber-security and the work being conducted by Microsoft and its Digital Crime Unit to counter the effects of online criminal activity.


After a short intro video (above), David Finn, Executive Director Microsoft Digital Crimes Unit who then introduced the work of the new division opened just 16 months ago and located in Redmond, Washington. The unit fights two types of crimes: Technology-facilitated crimes which targets vulnerable population such as children and the elderly, and Malware and reduction of digital risk.

David Finn, Executive Director Microsoft Digital Crimes Unit
Finn then presented a number of grim statistics around the children victimization and introduced Microsoft PhotoDNA, a new cloud based solution that can be licensed by anyone to detect awful images and report them to law enforcement organizations around the world.

Microsoft PhotoDNA
David Finn then addressed the topic of malware and cyber criminal activity using botnets and how Microsoft assisted with the Citadel Malware case, which involved the infection of over 91 million PCs and the hijack of close to half a billion dollars ($500M). The case had a particular focus on using visualization and big data to analyze infection patterns across the world.

The Citadel Case

Citadel Infection Pattern
As a result of these efforts, Microsoft is experimenting with new visualization and sonification techniques to understand infection patterns. One such technique is dubbed the Specimen Box and was presented during the session.




After the closing session, we returned to the GWCC to do some walk around the Expo. I stopped at the booth of my friends and partners at FieldOne to congratulate them for their new achievement. Microsoft has named them a Dynamics CRM Global ISV which shows their commitment to developing the channel and producing quality products.

The FieldOne team

From the Expo, I went to Mark Polino's session CS15G003-R2 Microsoft Dynamics GP: New 50 tips in 50 minutes, a jammed pack session filled with bite size tips on Microsoft Dynamics GP functionality. Mark had a full room and as the rock star he is, he commands quite the attention from the attendees. I have to admit I picked up a few good tips for my toolbox.

Up next, I had to complete the repeat of my upgrade session, CS15G002-R2 Microsoft Dynamics GP 2015: Upgrading and deploying. I had been assigned the last slot on the last day of the event, which I have been doing for the past 6 years now. While I did not have the same amount of attendees as with my first bout at this session, 85 people were still pretty good, considering that a lot of people left to catch their flights early in the morning.

After my repeat session, it was time for some relaxation and the famous Tim Tam Slams. Earlier, I had sent out a tweet to a number of people to meet up at the Omni Hotel bar for what has become a tradition among a select few of us. Before the slams though, I managed to meet with a group of friends from Colombia to explain some good ol' fashioned Microsoft Dynamics GP architecture and deployment options for their company and how the web client and Microsoft Azure have revolutionized the way Microsoft Dynamics GP is deployed.

I then moved over to the bar with my friends Olga Acosta and Eddie Yepes to grab a drink before sitting down for Tim Tam Slams.


Olga Acosta does the Tim Tam Slam



Eddie Yepes does the Tim Tam Slam (and fails miserably!)

The final stretch of the evening would have me doing dinner with my good friends and fellow MVPs Belinda Allen, John Lowther, and of course David Musgrave at Dantanna's Downtown location, inside the CNN Center. We spent the evening chit-chatting from one thing to another and enjoying John's vicious appetite for Thousand Island dressing on his salad.

After a wonderful meal and excellent service we proceed to leave, not without running into the Njvity folks.

Chris Dobkins, Mariano Gomez, Emily Roen, and David Musgrave
The event was now over for good and it was time to leave. I really could use some sleep... but wait, still more to come.

Until next post!

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

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/

Tuesday, March 31, 2015

Microsoft Convergence Atlanta 2015 (#CONV15) - Day 2



Wow, Day 1 sure proved to be very exciting with all the big keynotes, general sessions, and presentations, not to mention the whole Expo reception. It also seemed like the night went by flying and sleeping was overrated. To add to the mix, Atlanta's Tuesday morning traffic came back with a vengeance and did not really allow David and I to make it down on time for some early sessions we had planned to attend, oh well!

As a result, we ended up going to the Speakers' Room to finalize our last bits of demo code for our upcoming session, only to discover we were not using "best practices" as noted by our Microsoft friend Rob Bernhardt. Since we are very keen to deliver best practices in our Service Based Architecture code (more on this on a separate post). This put us in a tailspin, so we went looking for Kevin Racer to offer some advise. We finally got what we were looking for, just 10 minutes before our session.

Off we went to look for our dual A313/314 room where we would host CS15G024-R1 Microsoft Dynamics GP 2015: Customizing the user interface. We walked into the room and saw a gentlemen sitting in the front row with a t-shirt that read "David Musgrave", but couldn't quite make out the entire text until he decided to unbutton his shirt. The results can be seen in the picture below.

David Musgrave and mastermind Steven Vallarian
Our session started with the traditional introductions from David and I and our work within the community and off we went into demos. We definitely tried to provide some humor to a dry subject. Development sessions tend to be that way, so I believe we only lost like 3 or 4 attendees out of the 131 who assisted. We also were able to demo the cool Service Based Architecture posting routine using Google Postman which is a Chrome application extension.

After our session, I went back to the Expo to catch up with a few folks. It's always good when I can say hi to my buddy Brian Roney, who I consider to be one of the brightest Dexterity minds in the business.

Mariano Gomez and Brian Roney
Walking around for so many hours can definitely make anyone hungry, so David and I caught up and decided to move over to the Omni Hotel's bar. After a few drinks (all on me, since David doesn't drink), we decided to have a quiet dinner evening at the Omni Hotel's Prime Meridian restaurant. After going through a good session of explaining MSG intolerance to the waiter, we were shortly joined on David's request by Cindy Reeves and Tanya Markwit from Tribridge who were on their way to be seated for dinner as well. The view from our table couldn't have been any better.


Ferris Wheel in the foreground, the Westin Atlanta in the background
After dinner in excellent company, we all jumped in my car and off we went to the Rock & Rave party, down at the Georgia Railroad Freight Depot. After a frustrating 40 minutes of trying to find this place, we made it (mind you, I'm a local)!

However, the night just got weirder and weirder from this point on as we were greeted by (gasp!) a zombie. My good friend Ora Goldman from Mekorma was manning the door in her costume, which I must say looked really awesome!

Ora Goldman (Mekorma) as a Zombie
Inside the place, music was pumping at an exaggerated loudness, rendering the place just one big noise hall. After a beer, it was simply time to leave.

Rock & Rave at the Georgia Railroad Freight Depot 
Again, on the way out, Craig, Ora, and Ora's daughter were acting the part, so we decided to snap one more pic for the evening.

Craig Klapman and Ora Goldman playing a scare tactic on Ora's daughter 
David and I got back in the car and drove to my place to get a bit of rest and recharge batteries for the next day - note I said "get a bit of rest", as it was almost 1:00 AM when we got home.

Until next post!

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

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/