Page 1 of 11912345678910...2025303540...Last »

[Microsoft][SQL Server Native Client 10.0][SQL Server]A.NET Framework error occurred during execution of user-defined routine or aggregate…

 

Yesterday I have upgraded one of my customers SQL Server from SQL 2008 R2 to SQL 2012, the upgrade went smoothly with now issues, however this morning one of the user reported that they are getting an issue upon using the Requisitions module, below the error:

image

Few researches over the internet returned this community discussion and this one as well about several errors finally turned to be an issue with the SQL Assemblies and in my case was “outdated” assemblies, answered by Jonathan Fear to use the command below against DYNAMICS database and it worked:

exec wfDeployClrAssemblies

Hope that helps other users!


Regards,


Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
http://www.di.jo

See the original article here:
[Microsoft][SQL Server Native Client 10.0][SQL Server]A.NET Framework error occurred during execution of user-defined routine or aggregate…

April 6, 2015 ·  · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 30

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.

Specimen Box – Live Mode


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/

Read more here:
Microsoft Convergence Atlanta 2015 (#CONV15) – Day 4

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

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 1

Keynote and General Session

I know, it’s been over a week since Microsoft Convergence 2015 closed its doors, however, I did not want the time to go by without reliving some of the things I personally experienced throughout the event. With early mornings and late evenings it became impossible to write blog posts as things were happening, considering my own involvement with quite a few of the activities and presentations at Convergence.

Day 1 started out with David and I rushing through Atlanta’s traffic to get to the Georgia World Congress Center. From there we would head over to the Phillips Arena for the Opening Keynote Speech. We got there at the tail end of the presentation of Dance 411. The Dance 411 Foundation’s mission is to foster the well-being of urban youth and young adults through self-expression. They provide a quality education and exposure to the discipline of dance, drama and music. Judson Althoff, President Microsoft North America was in the middle of interviewing JJ Crampton and Sindy Scheider, both directors of the Foundation and requesting everyone filled out the Convergence event evals, for which Microsoft would make a donation to the Foundation.

Dance 411

Once the dance group completed their presentation, Althoff was once on stage to talk about the Atlanta Youth Project and Truly Living Well Center for Natural Urban Agriculture and the volunteering work done in conjunction with the Convergence attendees who signed up for community outreach, now a staple of these events. The community outreach video was accompanied by an original song by The Groove Merchants.

Upon the conclusion of the community outreach video, Althoff was back on stage to describe the upcoming days at Convergence and some of the guest speakers that attendees would have a chance to experience. He also alluded to the fact that the event itself, Convergence, is also evolving and changing, just like the businesses present at the event. He also noted that Convergence used to be a Dynamics only event. Microsoft has expanded the event and evolved it to actually incorporate all of its innovations. Convergence has become the Premier Business Event.

Without further due, Satya Nadella was on stage to talk about how Microsoft is empowering every person and every organization on the planet to achieve more, via the “systems on intelligence”.

Satya Nadella on Microsoft’s Vision

The systems of intelligence interact with the systems of record to make sense of the data collected. Microsoft is focusing on the automation of the systems of intelligence, with the richness of its cloud infrastructure. To further talk about how other industries are taking advantage of the technologies that drive the systems of intelligence, Satya welcomed Seattle Seahawks’ Russell Wilson.

Seattle Seahawks Russell Wilson

Russell described how he uses OneNote to track all his activities on and off the field and how the National Football League (NFL) leverages Microsoft Surface during the games to analyze team formations, plays, and players in near real time – Microsoft is a sponsor of the NFL.

The rest of the presentation focused around the use of other technologies such as Yammer within Microsoft itself. Also there was a cool case study on how AccuWeather is leveraging Microsoft Azure to deliver custom and personalized weather to both consumers and businesses.

AccuWeather

After the case studies, it was time for Mark, Belinda, and I to head over to the GWCC to wire up for the Microsoft Dynamics GP General Session, to be held at the Sydney Marcus Auditorium. Upon arrival, I went back stage to check in and had a chance to capture this picture with the engineering team at work.

Video and Audio Engineering Room

This year, the Microsoft Dynamics GP General Session featured a number of info-bites showing what each of the presenters were doing at different stages during the 90’s and various terminologies born from that time.

Little bits of information before session

This year’s Dynamics GP General Session would focus on product strategy and roadmap, and as customary, it began with with Errol Schoenfish welcoming all attendees and discussing the Microsoft Cloud for Business strategy, which features Office 365, Azure, and the business applications, including Microsoft Dynamics GP. Errol went on to demo a Time Management app (#IfErrolCanDoIt) showing how it would work on various device platforms.

Then came the highlight of the event (ehem!): The MVP Duel featuring Mark Polino and I, with a special guest, Belinda Allen. Our presentation, showcasing a number of new features in Microsoft Dynamics GP 2015, went very smooth and features were well received by the audience.

The MVP Duel – From left to right: MVPs Mark Polino, Belinda Allen, and Mariano Gomez

Up next was the customer story featuring Rural Renewable Energy Alliance (RREAL), a non-profit dedicated to make solar energy available to low income families.

Next up was Jennifer Ranz to demo a day in the life of a RREAL employee. Jenn showed the dashboards released for Office 365 and PowerBI. Jason Edens from RREAL came on stage to talk about how their company is leveraging Microsoft Dynamics GP to run their business.

The session went on with other demos and a glimpse into the future of Microsoft Dynamics GP. First up was Jeff Trosen to talk about the evolution of the Microsoft Dynamics GP roadmap. Chad Sogge came up next to talk about the new HTML 5 interface and provide a demo of how this new web client technology will allow for a better user experience across browsers and devices.

Errol Schoenfish and Chad Sogge on the Future of Microsoft Dynamics GP Web Client

I had to finally get a shot of the audience.

Microsoft Dynamics GP General Session Attendance

Well, in my next post, I will talk about the sessions we delivered throughout the rest of the event.

Until next post!

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

See more here:
Microsoft Convergence Atlanta 2015 (#CONV15) – Day 1

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

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: https://mbs.microsoft.com/partnersource/northamerica/support/hot-topics/HOT_TOPIC_MDGP2013Upgrade#UpgradePaths.

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 www.Standardprocess.com, for suggesting this to me.

Enjoy!

Leslie

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

Dynamics GP hosting – a great experience with RoseASP

I recently had a great experience that I would like to share. We have a client that was on a very old version of Dynamics GP (8.0), very old version of SQL (2000) a very, very old server (going on 10 years), and outsourced IT. Long story short, their server went down, they lost 2 out of the 3 […]

Read this article:
Dynamics GP hosting – a great experience with RoseASP

March 16, 2015 · Victoria Yudin · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 41

Workflow Engine in GP 2013 R2 and GP 2015

I’ve seen a lot of activity recently on the Dynamics GP Forum, indicating confusion over what version of SharePoint works with the new GP Workflow 1.0 and 2.0.  Quick answer – none of them.  GP 2013 R2 and GP 2015 both have a native workflow engine built in, eliminating the need for SharePoint altogether.

 
Additionally, Reviewers and Approvers need not be GP users to Review and Approve workflow steps if Email Actions  is enabled.  Approval can be initiated from within email notifications generated by the workflow.

Read More:
Workflow Engine in GP 2013 R2 and GP 2015

March 11, 2015 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 39

Silverlight "ArgumentException: An item with the same key has already been added" when attempting to print a report

It’s been about 3 months now since working with Microsoft Dynamics GP 2015 in our production environment. To recap, at Intelligent Partnerships we run all our information technology infrastructure on Microsoft Azure. A big reason for this, of course, is the high degree of mobility required by our consulting staff and the ability to access demo environments and be able to enter timesheets and expenses from anywhere in the world they happen to be. In addition, we need to be able to run our business and access our financials and analytics without being constrained to a particular geographical location. As such we rely heavily on Dynamics GP’s Web Client and Business Analyzer to achieve these goals.

One of the issues we started noticing with Web Client recently is, when you attempt to print a report – Standard or Template – but cancel out the printing on the Report Destination window, then attempt to print the report once more, we would receive the following Silverlight error message:

Severity: Critical Summary: A server side exception of type “ArgumentException” has occurred. Details: ArgumentException: An item with the same key has already been added. at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource) at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add) at Microsoft.Dynamics.GP.Web.Services.Runtime.Dexterity.Hierarchy`1.Add(T ancestor, T item) at Microsoft.Dynamics.GP.Web.Services.Runtime.Dexterity.Implementation.WCDexRuntimeStateResourceManager.Register(DexUri parentId, IWCDexWindow window) at Microsoft.Dynamics.GP.Web.Services.Runtime.Dexterity.Implementation.Adapters.WCDexFormOpenStateChangedNotificationAdapter.Notifications_FormOpenStateChanged(Object sender, DexUriEventArgs`1 e) at System.EventHandler`1.Invoke(Object sender, TEventArgs e) at Microsoft.Dexterity.Runtime.Interop.DexNotification.OnFormOpenStateChanged(DexUri uri, DexFormOpenState value) at Microsoft.Dexterity.Runtime.Interop.Win32.NativeMethods.MsaCommandExec(Int16 tag) at Microsoft.Dexterity.Runtime.Interop.Win32.NativeMethods.<>c__DisplayClass26.b__25() at Microsoft.Dexterity.Runtime.Interop.Win32.NativeMethods.ExecuteMsaAction(Func`1 interopAction, String entryPoint) at Microsoft.Dexterity.Runtime.Interop.Win32.NativeMethods.MacroSystemCommandExecute(Int16 tag) at Microsoft.Dexterity.Runtime.Interop.DexMacroSystem.CommandExecute(Int16 tag) at Microsoft.Dynamics.GP.Web.Services.Runtime.Dexterity.Implementation.WCDexMessageProcessor.ProcessCommandExecuteInstanceResourceMessage(IWCDexMessage msg) at Microsoft.Dynamics.GP.Web.Services.Runtime.Dexterity.Implementation.WCDexMessageProcessor.Process(IWCDexMessage message) at Microsoft.Dynamics.GP.Web.Services.Runtime.Dexterity.DexRuntimeStateManager.SendMessage(IWCDexMessage message) at Microsoft.Dynamics.GP.Web.Services.Runtime.Dexterity.DexRuntimeStateManager.MainEventLoop()

This particular error was received attempting to print a sales order processing quote, but we have been able to reproduce from other windows. While I don’t claim to understand all these exceptions, this particular one seems to refer to an issue caused by a “key” being added twice to the same “Generic.Dictionary” collection. Since the action causing the error seems to be a second attempt at printing a report – the same report it seems – somewhere along the lines it would appear that some value isn’t being cleared out from the collection of reports being printed which would cause a duplicate key. Again, pure speculation.

Nonetheless, in speaking to the Dynamics GP development team, it seems to be this issue has been written up and may be solved in the upcoming hotfix release. This issue can be reproduced in Microsoft Dynamics GP 2015 build 14.00.0619 (January Hotfix).

Until next post!

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

Read the article:
Silverlight "ArgumentException: An item with the same key has already been added" when attempting to print a report

March 11, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 37