Page 1 of 3112345678910...202530...Last »

Dexterity Training in Mexico – Part 3 of 3

David Meego - Click for blog homepageNow it was Sunday and Mariano Arias and José Ramírez had planned another day of sightseeing.

They wanted to make sure I got to see lots of Mexico while I was in the country and once the Dexterity training started, there would be very limited time.

The day started a little later, which was good after such a busy day yesterday. José and I walked from the hotel to the park in front of Chapultepec Castle where we met Mariano. We then walked through the park and up to the castle which is situated on a hill.

Chapultepec Castle from below

The castle is the only royal castle in North America that was actually used as the residence of a sovereign: the Mexican Emperor Maximilian I, and his consort Empress Carlota, lived there during the Second Mexican Empire.

Chapultepec Castle Grounds

It is now the National History Museum and contains lots of artefacts and information about the turbulent history of Mexico.

Upper Gardens of Chapultepec Castle

Just a quick side note, if you saw Baz Luhrmann’s movie version of William Shakespeare’s Romeo and Juliet you might recognise this beautiful building as the Capulet Mansion.

Lower Gardens of Chapultepec Castle

After viewing the castle we walked along the wide avenue which runs from the castle through the city, the Paseo de la Reforma. This took us to the stunning Angel of Independence monument which was created to celebrate the centenary of Mexican Independence. There is a mausoleum at its base which we were able to walk through to pay our respects. It is possible to get to the view platform at the top, just below the golden angel, but that must be organised in advance with the authorities.

Angel of Independence

That completed another day of sightseeing and now it was time to get some rest before the Dexterity training started on Monday.

On Tuesday night, after the training, José decided to take me and a couple of the out of town attendees from the training course to soak up some real Mexican culture…. in the form of Mexican Wrestling. My prior “experience” of Mexican Wrestling was entirely based on the Jack Black movie from 2006, Nacho Libre. This was not the best movie ever, but at least I knew a hint of what to expect.

I had seen Mexican Wrestling masks for sale and I knew that the character portrayed by the wrestlers is probably more important than their technical skills in the ring (which is a boxing type square).

Mexcian Wrestling Masks

To give you a taste of the mayhem and noise that makes up Mexican Wrestling here is a video from the night. There was a lot of acting and some fantastic choreographed sequences in what was a fun night.

Mexican Wresting in Mexico City (direct link)


On Wednesday night we had a change of pace and visited Coyoacán. This is an historic town which has a very strong Spanish heritage. It actually felt like you were walking through the streets of Barcelona (except for the odd Mexican flag).

Drinking Coyotes Fountain in Coyoacán

The fountain and the park in the centre of town depicts two drinking Coyotes, which is what gave the town its name. While there we went to a food hall area where there was a gentleman making pancakes. The difference was that you could ask for him to make anything with the pancake.

Kangaroo Koala
Pancakes in the shape of a Kangaroo and Koala

Check out the video of the pancakes being made:

Fancy Pancakes at Coyoacán in Mexico City (direct link)


On Thursday night (1st October), we visited Tlatelolco in the north of México City. We went to an area called Plaza de las Tres Culturas. The square is flanked by three cultures: Aztec, Spanish and modern Mexico. There are the remains of Aztec temples on one side, with the Catholic church of Santiago de Tlatelolco on another and a modern era housing complex on a third side. The church looks like it was built to match the Aztec temples as it is built from the same stones…. exactly the same stones. Sadly, much of the Aztec ruins where dismantled to built the church.

Catholic church of Santiago de Tlatelolco at night

This area also has significance in modern history as it was the site of a student demonstration in 1968 which ended in a massacre by the authorities which hundreds killed and injured. There is a memorial on the south side of the plaza, to commemorate the 25th Anniversary of the events of 2nd October 1968.

On Friday, we finished the class materials and had time for questions and answers and also to review any topics the attendees wanted.  We also took a photo of the attendees outside the office building.

Attendees from the Dexterity training.
From left: Julian Olave, Alberto Rodriguez, Gilberto Sosa, Marcos Cristales, Mariano Arias*, Karina Zapata, David Musgrave, Deneb Ortega, Jose Ramirez, Mario Rodriguez.
Absent: Horacio Tena

The next day was Saturday morning and time for me to leave Mexico and return to the United States for the next part of my trip. After being dropped off at the airport by a taxi, I caught a flight to San Francisco.

Thanks to everyone who made me feel welcome in Mexico and especially my hosts, Mariano Arias and José Ramírez from Axentit.


* Mariano did not actually do the training, but wanted to be in the photo. :-)

This article was originally posted on

Filed under: Development, Dexterity, Training Tagged: Development, Dexterity, Training

Read More:
Dexterity Training in Mexico – Part 3 of 3

October 12, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 6

#reIMAGINE2015 – Day 2

David Meego - Click for blog homepagereIMAGINE2015_Logo

Tuesday started again with breakfast in the Grand Ballroom at t Hilton Garden Inn. Mariano had some things to deal with so I headed over to the Microsoft Campus for the day’s sessions.

The first session for me was an Expert 1-on-1 Workroom with Leslie Vail. We had about 10 people join us in the room, but there were not many developer related questions. So I let Leslie drive the session and discuss various application level topics.

Later, I sat in on Mariano’s Expert 1-on-1 Workroom with Windi Epperson and relaxed a little as the others discussed a variety of topics, including options for Web Client deployment and Azure clouds vs other cloud services vs hosted services.

Then it was time for lunch in the Microsoft Cafe and Chef Kevin looked after me as he always does when I am in town. He ensured that the food I selected had no Flavour Enhancers (like MSG and its buddies) which have nasty effects on me :-(.

We then left the Microsoft campus and headed back to the Hilton Garden Inn. I had a meeting and so was unable to attend the Rapid Fire Partner Solution session, but the meeting went well.

Then it was time to get on a coach and go “Downtown, things will be great when you’re Downtown” to the Fargo Theatre.

The evening of the Fargo Downtown Experience started with a networking reception at the “Art Deco” Fargo Theatre (built in 1926 and restored in 1999). While the reception was in progress, we had some drinks (& popcorn) and listened to the organist who rose up from below the stage and played a great range of show tunes.



Then, as the organist disappeared back into the ground, it was time for Keynote Speakers. The first speaker was Wayne Morris from Microsoft (who originally hails from Brisbane, Australia). He reiterated Microsofts commitment to Dynamics and the small and medium market.

The rest of the speakers were all from the Fargo region and were introduced by our MC for the night Greg Tehven. We heard from Clint Howitz, CEO of DogIDs, who explained how an idea with one employee working from home has grown into large business with many employees. We also heard from Max Kringen, CEO of TellWell. TellWell is an organisation which helps other businesses with guidance and planning for social media strategies and design.

The final speaker was Mark Lindquist, who is a former United States Air Force Sergeant who now works as an actor, entertainer and motivational speaker. Mark was incredibly dynamic (no pun intended) and challenged everyone to get out of their comfort zones and do something that makes you uncomfortable as once you have done it a few times it will become normal.


To demonstrate he asked the audience to clasp their hands and then open their arms and do “Jazz” hands and then clasp them again. We repeated this three times and then he asked us to notice which thumb was on top. The point is that people always clasp their hands the same way ever since they were babies. Changing the clasp to the other way just feels wrong. Try it right now….. See what I mean?

We then tried the same process with crossing the arms and again one way feels natural and the other feels uncomfortable. Go on try it now…. no one is watching. The moral of the story was to get out of the comfort zone and reIMAGINE what you can do, soon it what was hard or felt wrong will be normal and you can move on to the next challenge.

After the session was over, we noticed that the first challenge for the evening was spelling related. :-) 


After the keynote speakers, many of the attendees started with the “Downtown Experience” which was a sponsored pub crawl with each of the conference sponsors taking over one of the local drinking establishments.

I skipped the pub crawl and instead had dinner with the teams from NexTec and Mekoma as well as some friends. We had a lovely meal at Mezzaluna, which is situated behind the Fargo Theatre (number 14 on the map below).

Mezzaluna Clockwise: Angel Blum, Mark Wiley, David Musgrave, Leslie Vail, Jen Kuntz, Craig Klapman, Corey Clay, Sheila Jefferson-Ross, Mike Davis, Belinda Allen, Mike McDowell, & Elsa Williams.

Note: Mariano was at Mezzaluna, but ended up on another table as we had too many people… more than the original booking number.

After dinner some of the group went and joined the Downtown Experience, while a few of us caught a coach and headed back to the hotel to get some rest.


Stay tuned for Day 3 and the final day of the conference.


This article was originally posted on

Filed under: Conference, Dynamics, GP, Microsoft Tagged: Conference, reIMAGINE 2015

Read the article:
#reIMAGINE2015 – Day 2

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

You receive "Exception has been thrown by the target of an invocation" when running some reports in Management Reporter 2012 CU13

In my previous post, I talked about a cryptographic exception I encountered while upgrading Management Reporter 2012 from CU6 to CU9 (on the way to CU13), while attempting to setup the Data Mart database – see You receive “Could’n retrieve the list of available databases: The connection attempt failed” error when updating Management Reporter 2012. The solution turned out to be very simple, but in the scheme of things a bit time consuming to figure out. Once we had upgraded to CU9, it was time to attempt the upgrade to CU13.

The upgrade process

Upgrading to CU13 was pretty straight forward.  However, after the upgrade, the customer attempted to generate a couple of the many reports from Report Designer with the following error being displayed in Web Viewer:

This report can’t be displayed. Make sure that your computer has an internet connection and that Management Reporter is running. If this problem continues, contact your administrator.

Management Reporter 2012 CU13 error when generating report to Web Viewer

When attempting to open the same report from Report Viewer, we obtained the following exception error, with the Report Viewer application crashing after clicking the OK button:

Exception has been thrown by the target of an invocation.


After the errors, we tried copying the columns, row definitions, and trees onto completely new report objects (rows, columns, and trees), respectively, and tried to run the reports once more, obtaining the same results. The customer relies on this report on a daily basis, so it was critical we fix whatever issue was causing these reports to crash.

After some back and forth with Microsoft Support, it was determined that with CU13 the B0 print control in the row is not working and causing the exception:

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidCastException: Specified cast is not valid.

Microsoft Support is currently working on getting the issue written up and triaged so as soon as a bug number (or a fix!) is available I will publish more about it.

As it stands, we reverted back to CU9 and upgraded to CU12 which did not display the issue described herein.

Until next post!

Mariano Gomez, MVP
Intelligent Partnerships, LLC

View the original here:
You receive "Exception has been thrown by the target of an invocation" when running some reports in Management Reporter 2012 CU13

September 1, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 77

"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…

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!

Mariano Gomez, MVP
Intelligent Partnerships, LLC

Continued here:
"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…

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

Upgrade from GP 2010 to GP 2013 R2

3d man with Q & A

Question: How do you upgrade from GP 2010 build 2390 to GP 2013 R2

Answer: The documentation from Microsoft that delineates the upgrade path from GP 2010 to GP 2013 R2 is missing the current build of GP 2010 (as of 3/16/2015). The document from Microsoft can be found here:

The line missing is how to upgrade to GP 2013 R2 from 11.00.2390. The answer is that you have to upgrade to 12.00.1826. The build numbers for both GP 2010 and GP 2013 R2 are achieved after installing the January 2015 Hotfix. Thanks go out to Paul Degneau, at Standard Process, for suggesting this to me.



Original post:
Upgrade from GP 2010 to GP 2013 R2

March 17, 2015 · Leslie Vail · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 161

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!

Mariano Gomez, MVP
Intelligent Partnerships, LLC

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

Modifier Quick Tip for Fixed Assets – Don’t check that box!


This came up recently on the forum. A user had modified the ‘Asset User Data’ window. The window previewed perfectly in Modifier, the Modified/Alternate Forms and Reports ID was correctly set, and there was even a period before the window title on the window. However, the window still looked the same as it did when before the modification. What’s going on here?

What’s going on has to do with your choices in the Company Setup window for Fixed Assets. One of the Option items is a checkbox for ‘User Data Auto Format’. If this box is checked, any Modifier changes you make are overridden by the system, and the window displays as it did before it was modified.

The moral of this story is – if you want to modify the Asset User Data window, be sure to uncheck the ‘User Data Auto Format’ checkbox.



Modifier Quick Tip for Fixed Assets – Don’t check that box!

February 10, 2015 · Leslie Vail · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 134