KB Article 878449 Capture Login script gets a much needed rehaul

We live by it, we die by it. 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 (KB 878449), is perhaps one of the most visited articles in the Microsoft Dynamics GP world, especially around upgrades. The article contains a script that, under normal circumstances, retrieves all the security principals and encrypted passwords on an existing Microsoft SQL Server. The result is a T-SQL script that allows you to restore those security principals on another Microsoft SQL Server.

Months aback I had seen numerous posts on the partner forum and the Microsoft Dynamics GP community where folks expressed having issues with the Capture Logins script on SQL Server 2012. Now David Musgrave over at the Developing for Dynamics GP blog has a definitive and answer and a solution to the problem and explains in great detail the issue experienced by many in his article Capture Logins Script from KB 878449 generates Invalid object name error.

Don’t miss out on this article.

Until next post!

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

Read the original post:
KB Article 878449 Capture Login script gets a much needed rehaul

May 2, 2014 · Mariano Gomez · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 1,029

Wennsoft Compatibility with GP 2013 R2

This is true as of May 1, 2014

WennSoft Signature Non-Compatibility Notice: 

Microsoft Dynamics GP 2013 R2 and Microsoft SQL Server 2014

Microsoft has announced the following new releases:

· Microsoft Dynamics GP 2013 R2 – coming in May 2014

· SQL Server 2014 – available since April 1, 2014

o GP 2013 R2 will be compatible with SQL 2014 at release in May

o GP 2010 will not be made compatible with SQL Server 2014

WennSoft Signature is NOT compatible with GP 2013 R2 or SQL Server 2014 at this time.  Please do not download the above new versions from Microsoft until we announce compatibility with our current release, Signature 2013.  Please note that compatibility with GP 2013 R2 and SQL Server 2014 will not be tested against earlier releases of Signature.  

View article:
Wennsoft Compatibility with GP 2013 R2

May 1, 2014 · Jivtesh Singh · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 373

How Can I Sell Services with SmartView?

I was talking with some resellers this week who were excited about how easy it was to sell SmartView into their customer base. The problem was, they said, that it was difficult to include services in the software quote because SmartView was just too easy to set up.

Now I took the ‘real easy’ part as a compliment – but I also understand the VAR’s need to

‘Add Value’ to the software they sell to their customers. It is an interesting movement in 2014 that the software should just install and work with no setup or effort. While this can be true I really feel that it is dumbing software down and often giving a less satisfactory experience. If all software is treated as a ‘app’ then we will end up with some oversimplified single function that won’t do much for software solutions.

So to add the value back to a SmartView purchase there are a number of things that can and should be done (by an end user or their VAR) to provide a better overall solution.

Here are some of the consulting/implementation tasks that should form part of a SmartView roll out: 

1. Task to Convert Favorites from SmartList: Review existing favorites, clean them up, rename them, delete old ones and only bring ‘good’ favorites into SmartView. I am yet to meet a company that has remained completely on top of all their Smartlist favorites.

2. Security: Use this as a chance to review SmartList/SmartView security. People seeing things they should not is often missed in SmartList/SLB. Even yesterday I found people at eOne looking at sales and margin numbers I would have preferred them not to see.

3. End User Training: While it is very self-explanatory there are a number of little tricks and tips you will only learn by receiving some training. Running tailored training to users will ensure they get the most out of SmartView for their specific role. With SmartView External you are exposing GP data to people that have often never seen it before. So training those people to understand what they are seeing is important.

4. Optimization: For anyone with a large data volume there are a number of things that can be looked at: 

a.       Care on setting the number of initial records returned e.g. 1000, or 10,000 etc. 
b.      Optimizing views and tables through SQL indexing on large lists.
c.       Using SLB to restrict the data in the base query (exclude those years people will never look at). Then using these lists in SV.

So as a VAR it becomes relatively easy to include somewhere between 8 and 24 hours of services with your SmartView quotation. By doing so you are undoubtedly offering a better solution to your customer. For end user customers it would make sense to set aside this time to complete these tasks if you are not engaging your reseller. 

Interested to learn more about how to sell services with SmartView or any of our other products? Please reach out to us at sales@eonesolutions.com and we’ll be happy to assist you! 

Continued here:
How Can I Sell Services with SmartView?

May 1, 2014 · Martin · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 305

reIMAGINE 2014 Announced: The November Not Stampede Fall/Autumn/Spring Partner Event in Fargo

David Meego - Click for blog homepagePam Misialek from the Inside Microsoft Dynamics GP blog has posted the final name for the November 10-13 Partner Event in Fargo, ND, USA.

So it is not Stampede and not the Fall/Autumn (or spring for Southern Hemisphere) conference…. It is reIMAGINE 2014.

For all the details on how the name was decided and what the plan is for the conference, please have a read of Pam’s post.

Hope to see you there 

David

PS: Don’t forget to wish Pam Happy Birthday on Tuesday.

Continue reading here:
reIMAGINE 2014 Announced: The November Not Stampede Fall/Autumn/Spring Partner Event in Fargo

April 28, 2014 · David Musgrave · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 278

Getting started with a new report: How detail levels … – MSDN Blogs

You may be familiar with the different detail levels in Management Reporter. The detail level is used as the determining factor for whether a report is a high level summary, a report where you can view sales or expenses by …

Read the original:
Getting started with a new report: How detail levels … – MSDN Blogs

April 25, 2014 · Ryan Sandness · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 219

Why you need technical consultants involved in the sales process

David Meego - Click for blog homepageWhen I worked in the partner channel, I decided it was very wise to have a technical consultant present in all sales meetings.

Or better still make sure that your sales consultant has a technical background with the application.

At least then you are less likely to end up with the problem where the sales consultant has oversold what the application can do or what customisations are possible.

Many people in the Dexterity Development world know me for my work as a pioneer of Cross Dictionary Dexterity Development. The driving force behind the development of the techniques involved was over selling of customisations.

 

Recently, this video was released which shows the commercial pressures placed on the technical expert.

The Expert (Short Comedy Sketch) (Direct Link)

(Please visit the site to view this video)

 

Enjoy

David

Read More:
Why you need technical consultants involved in the sales process

April 25, 2014 · David Musgrave · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 250

More on SQL Server Connection issues with Microsoft Dynamics GP

David Meego - Click for blog homepageI have been working on a recent support case that had a situation that makes me want to raise this topic again.

In the past, I have posted a number of articles discussing reasons for connections to SQL Server to be lost. When Microsoft Dynamics GP loses its connection to SQL Server, the Dexterity Runtime automatically creates a new connection to minimise disruption. However, this reconnection has a new SPID and is not linked in any way to the previous connection.

This means that any SQL temporary tables created in the original connection will not be available in the new connection. When Microsoft Dynamics GP attempts to access or close the temporary tables it believes exists, you will get errors.

Below are some example errors (all screenshots from the same case):


A remove range operation on table ‘XXX’ cannot find the table.

 


A save operation on table ‘XXX’ cannot find the table.

 

 
FP: Couldn’t close table!

 

It is important to note that once a Dexterity Script generates an error, the script will abort and whatever tasks were later in the script will not be completed.

Sometimes these table errors can cause other errors to be generated.


All call stacks are in use. Cannot start script.

 

Please note that ignoring any error in Microsoft Dynamics GP is a risk (see my blog articles on the Importance of Reporting Errors below). 


 

What stood out as different with this case was the following error dialog, which I had never seen before:


 A SQL network connection error occurred and your connection was cleared.
This probably occurred because all available connections to the server are in use. Please try again later.

 

This error message made me wonder what was happening with the connections to the SQL Server. The customer’s System Administrator obtained graphs of the connections, below is an example showing how the connections keep increasing during the day until the server forcibly closes connections.


Connections increasing to a maximum of 2303 connections during half a day

 

So, what could cause Microsoft Dynamics GP to continuously use more and more connections?

I had one idea about what could be the cause, so I asked the question to the partner: “Does the site have VBA code that uses ADO to access SQL Server data?”

The answer was “Yes”.

So then I asked about how the ADO (ActiveX Data Objects) connection was being closed at the end of the VBA (Visual Basic for Applications) code (when exiting the form or report). We looked at the VBA project and the code used to clean up looked something like:

     ‘ Close ADO Connection
    Set cn = Nothing
    Set rst = Nothing
    Set cmd = Nothing

When the code should look something like the following example:

     ‘ Close ADO Connection
    If rst.State = adStateOpen Then rst.Close
    If cn.State = adStateOpen Then cn.Close
    Set cn = Nothing
    Set rst = Nothing
    Set cmd = Nothing

The problem is that code was destroying the connection object “cn” before actually closing the connection, thus leaving the connection to the SQL Server open with no way to close it anymore. 

Best practice for VBA used in reports and forms when using ADO is to close the result set and connection before destroying the objects. Please see the blog posts below for details of the best practice methods for using VBA with ADO on Forms and Reports.

After a code review and making the changes needed, the connections on the customer’s system levelled out, with a maximum of 539 connections. 

 
Connections rising a small amount as users log in, but staying fairly constant throughout the day

 

So the lessons learned here are: 

  1. Always make sure you close any SQL Server connections you open (regardless of the development tool being used: Dexterity, VBA, or VSTools).
     
  2. Never ignore an error dialog (as it means code has not completed executing and the data could be in an unknown state).
     
  3. Always report the first error received as any errors that follow are usually the result of that first error.

 

For more information see the following blog posts:

 

I hope you find this information useful. 

David

More:
More on SQL Server Connection issues with Microsoft Dynamics GP

April 23, 2014 · David Musgrave · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 1,288