Page 1 of 21412345678910...2025303540...Last »

Changing the Microsoft Edge home page on Windows 10

David Meego - Click for blog homepageHere is a quick bit of help for those of you new to Windows 10 and the Microsoft Edge browser.

I have already had to help a few people through these steps, so I thought I would post them online for others to see and use.

Most people know how to change the home page(s) in Internet Explorer, but the process for Microsoft Edge is different and has a few steps.

If you want to change the home page for Microsoft Edge, follow the steps below:

  1. Click … in the top right of the Microsoft Edge window.
  2. Click Settings

Once settings is open:

  1. Select Open with A specific page or pages
  2. On drop down list select Custom
  3. Enter the web address you want
  4. Click + sign to add the address
  5. Click X to remove about:start

See the screenshot below for the steps in visual form:

Edge_HomePage

You can repeat steps 3 and 4 if you want more than one home page.

That’s all folks….

David

PS: If you want to import your favourites, click on the 3 lines button and click on the star for favourites. Then click on Import favourites. Once imported, you can drag the folders back up to the top if that is what you prefer.

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Microsoft, Public Service Announcement, Windows Tagged: Microsoft Edge, Windows, Windows 10

More here:
Changing the Microsoft Edge home page on Windows 10

August 28, 2015 · WinthropDC · No Comments
Tags: , , , , ,  · Posted in: Blogs I Follow Total Views: 8

Get involved: Enter the GPUG Summit “AppOFF” Competition

David Meego - Click for blog homepageWith the release of Microsoft Dynamics GP 2015, developers were provided with additional Service Based Architecture (SBA) functionality built into the application and development environment.

Service Based Architecture is primarily comprised of two features: Service Enabled Procedures and the .Net Interop.

These two features blur the line of distinction between Dexterity and the .Net development world. Previously tools like Continuum and Visual Studio Tools allowed external developers to interface with Dexterity based applications, but Dexterity itself was unaware of these tools and their integrations.

With Service Based Architecture, Dexterity is now able to get in on the party. It can create code in the form of Service Enabled Procedures which are exposed to the outside world as REST based web services. It can also now use .Net objects, methods, properties and datatypes directly in Dexterity’s sanScript language.

GPUGSummit_Logo

To promote the use of this technology, at the upcoming GPUG Summit confence in Reno, Nevada, USA on the 13-16 October 2015, the Dynamics GP User Group (GPUG) will be hosting an “AppOFF” competition.

The competition is inviting GPUG members to design and create a Dynamics GP related App which can either leverage the default web services included with Microsoft Dynamics GP 2015 or use custom developed Dexterity service enabled procedures to provide additional web services.

The aim is to edcuate members on the tools that can be used to create Apps and so providing some GP related Apps for the community to use, while having some fun with a contest between members.

If you saw the development tools session that Mariano and I presented at Convergence, we showed you can use the Project Siena tool in conjunction with standard GP web services to create functional App in only a few minutes.

For more information on the objectives and guidelines, see Kim Peterson’s blog post

Get involved, enter now.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Conference, Development, GPUG, News Tagged: Conference, GPUG, GPUG Summit 2015, News

Read the article:
Get involved: Enter the GPUG Summit “AppOFF” Competition

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

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: DomainMRAdmin
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):







GPTOOLSTEST


DDM


TWO


false


sa


AOaPHTA9VkmLvkUcyA053AEAAABurN19cbBVL3sfs/UoYU4o3YPglXB4SSrzLzXjlavUpC+uSNKdDYDDEjS9MfKKlao=


false


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/

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

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

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: DomainMRAdmin
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):







GPTOOLSTEST


DDM


TWO


false


sa


AOaPHTA9VkmLvkUcyA053AEAAABurN19cbBVL3sfs/UoYU4o3YPglXB4SSrzLzXjlavUpC+uSNKdDYDDEjS9MfKKlao=


false


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/

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

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

#GPPT Installing GP Power Tools (Upgrading from SDT, Silent Installs and more)

David Meego - Click for blog homepageNow that GP Power Tools has been out for a little while and I have recently released a hotfix that improves the installer as well as fixes some issues found with the tool, it is time to explain how the installer works and answer some frequently asked questions.

Please note that some of the information in this article only relates to the build 20 hotfix (Last Modified: 19-Aug-2015) or later. If you are unsure what build you have, just go and download the latest installer from the Mekorma website. If you look at the installer’s properties, the File Version will show as XX.0.20.4 or later.

Below are the questions and their answers:

Do I have to uninstall the Support Debugging Tool before installing GP Power Tools?

No, there is no need to uninstall the Support Debugging Tool from Microsoft Dynamics GP if you already have it installed. GP Power Tools and its installer have special code built in for handling the upgrade from the Support Debugging Tool to GP Power Tools.

What happens when upgrading from the Support Debugging Tool to GP Power Tools?

When the GP Power Tools installer detects the Debugger.dic file, it will install an additional Debugger.cnk file and automatically unchunk the file. The now extracted Debugger.dic dictionary will then run some upgrade code. The purpose of this code is to update the product name and file paths in the Dynamics.set launch file so they refer to GP Power Tools instead of the Support Debugging Tool.

The step to update the launch file is needed because the Support Debugging Tool and GP Power Tools share the same product ID 5261, and the Dynamics.set is not updated when installing a chunk for a product ID that already exists in the launch file.

Before you ask, I needed to re-use the same product ID to avoid breaking all the scripts that use Helper Functions that call with name “” in dictionary 5261. Also, it would be unwise to have both products installed at the same time as they would clash.

Next, the installer will install and unchunk the GPPTools.cnk as well as installing the DLL files needed for the .Net scripting functionality. The now extracted GPPTools.dic dictionary also runs some upgrade code. This code will adjust the Dynamics.set to ensure that the Mekorma Product Manager is listed before GP Power Tools in the file. It will also remove the now redundent Support Debugging Tool files.

What happens to all the data and settings I had in the Support Debugging Tool?

All the Support Debugging Tool’s settings are stored in a Debugger.xml file which will be located in the the Data folder or in a shared location if that has been set up.

After GP Power Tools installs and creates its tables in the System Database, it will look for the Debugger.xml file and import it to restore the data and settings.

You can restore a different Debugger.xml or backup to a Debugger.xml file at any time from the Setup Backup and Restore window in GP Power Tools.

Do I have to uninstall when installing a later build of GP Power Tools?

No, You can just install the later build over the top to update the existing instance. You can also use this feature to reinstall or repair an existing instance.

How can I uninstall a specific instance of GP Power Tools?

You can either run the installer and select the instance to be removed from the list of existing instances, or you can select the specific instance from the Control Panel >> Programs and Feature and uninstall it.

Why does the installer stop me uninstalling GP Power Tools when it is still installed in Microsoft Dynamics GP?

The GP Power Tools installer does not want to break your Microsoft Dynamics GP application. If the GP Power Tools files were removed before the product was removed from the Dynamics.set launch file, you will would get missing dictionary errors next time you launched GP.

You must uninstall GP Power Tools from inside the application using the About GP Power Tools window first. This will also remove the security and navigation entries it added and give you the option to remove the SQL objects created. Before removing the tables, GP Power Tools will back up their data to the Debugger.xml file.

Once, the GP Power Tools dictionary is removed from the Dynamics.set launch file and the addin DLLs have been renamed, your Microsoft Dynamics GP system can restart without issues. Now you can run the installer to complete the uninstall.

Can I do a Silent Install of GP Power Tools?

Yes, you can. From build 20 hotfix onwards, the installer supports performing a silent install from a command line with administrator privileges. You can specify the Microsoft Dynamics GP Instance and path to install to.

Below are examples of the syntax:

Installing to default instance of Microsoft Dynamics GP
GPPowerTools_14.00.0020.exe /s INSTALL=TRUE TARGETDIR="C:Program Files (x86)Microsoft DynamicsGP2015"
Installing to default instance of Microsoft Dynamics GP specifying instance name
GPPowerTools_14.00.0020.exe /s INSTALL=TRUE TARGETDIR=" C:Program Files (x86)Microsoft DynamicsGP2015" DYNINSTDESC="(Default)"
Installing to a specified instance of Miicrosoft Dynamics GP
GPPowerTools_14.00.0020.exe /s INSTALL=TRUE TARGETDIR=" C:Program Files (x86)Microsoft DynamicsGP2015R2" DYNINSTDESC="GP2015-R2"

Notes:

  • The top two examples are essentially the same, if using the default instance of Microsoft Dynamics GP, then you don’t need to specify the instance name. If you do wish to specify the instance name then use “(Default)” for default instance.
  • When specifying the instance, it must match an existing GP instance as it will be checked in the registry.
  • When specifying the path, it must contain a Dynamics.exe of the same version as it will also be checked.

I have multiple installation instances on my system, can I install GP Power Tools for the other instances?

Yes, just run the installer again and select the option to create or update an instance. Then when asked to select the instance, just select a different instance from the list. You can also perform a silent install to a different instance.

The list of instances is read from the registry and so will only contain instances actually installed using the Microsoft Dynamics GP installer.

I have manually created additional application folders, can I install GP Power Tools to the additional folders?

There are times were you might have additional Microsoft Dynamics GP application folders with different products or customisations installed. These folders are often created by manually copying the application folder and editing the paths in the Dynamics.set and Dex.ini files.

These additional folders will not show up as instances in the installer. So use the installer for the actual instance instances first. Then you can copy the files from the installed instance to the additional folders. You will need to locate the chunk files in the appropriate C:Program FilesCommon FilesMicrosoft Dynamics GPGUID folder.

Hint: Use right click >> Properties >> Dictionary tab to confirm the versions of the chunk files.

Copy these files to the application folder:

  • GPPTools.cnk
  • GPPTools.pdf
  • GPPTools.txt
  • GPPTools_License.doc
  • Application.GpPowerTools.dll
  • Application.GpPowerTools.xml
  • Application.GpPowerTools.Metadata.dll (GP 2015 or later only)
  • Application.GpPowerTools.Metadata.xml (GP 2015 or later only)
  • MEP7156.cnk
  • MPRK.dll
  • MEP.chm

Copy these files to the application/Addins folder:

  • WinthropDC.GpPowerToolsVB.dll
  • WinthropDC.GpPowerToolsVC.dll

You will need to run Microsoft Dynamics GP as Administrator once to allow the chunk files to extract.

 

Hope this answers all your questions.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: 2010, 2013, 2013 R2, 2015, 2015 R2, Dynamics, GP, GP Power Tools, Microsoft, News, Products, Support Debugging Tool Tagged: FAQ, GP 2010, GP 2013, GP 2015, GP Power Tools, GPPT, SDT, Support Debugging Tool

See more here:
#GPPT Installing GP Power Tools (Upgrading from SDT, Silent Installs and more)

August 24, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 22

Vote now for your 2015 GPUG All Stars

David Meego - Click for blog homepageEach year GPUG (Dynamics GP User Group) recognises three individuals from the Microsoft Dynamics GP community who go above and beyond to help others.

These individuals will be recognised as GPUG All Stars at the upcoming GPUG Summit in Reno, NV, USA.

GPUP All Star

Please vote now… there are only 2 weeks left before the poll closes.

OK, before we go any further, I will admit that I am one of the nominees for this year and that I would love you to vote for me.

That said, there also many other very deserving individuals from both customer and partner organisations.

For more details on the award and the link to the voting poll, please check out Kim “Mamma” Peterson’s blog post

Voting closes on the 31st August 2015, so please vote now.

Happy voting.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: GPUG, News Tagged: GPUG, News

Visit site:
Vote now for your 2015 GPUG All Stars

August 15, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 27

Solving Performance Problems with Microsoft Dynamics GP and Windows 10 – Part 2

David Meego - Click for blog homepageFollowing on from my previous post: Solving Performance Problems with Microsoft Dynamics GP and Windows 10 – Part 1, I was still not happy with the performance of Dexterity and Microsoft Dynamics GP on my newly updated Windows 10 development machine.

This article takes you through the steps to get your Dexterity and/or Dynamics system running fast on Windows 10.

I normally don’t post multiple articles in one day, but it was worth posting this one and the previous two as soon as possible to help others out there facing the same issues.

Performance Problem

After resolving the pause on exit issue discussed in the previous post, I noticed that Dexterity and Microsoft Dynamics GP where still very sluggish when running. It was taking much to long to log in and everything was like I was running through molasses.

Checking the Task Manager, I could see fairly high CPU usage. Sorting by the CPU column, the culprit was the Antimalware Service Executable. This Windows process is the real-time processing component for Windows Defender.

I have seen issues before with anti virus or malware solutions causing performance issues for Microsoft Dynamics GP and Dexterity, and the easiest way to resolve them is to add some exclusions to the settings for the application.

Part of the issue is that the Dynamics dictionary is a very large single file and the anti virus solution often wants to check the entire file when only a small part of it is being read. So you want to exclude the file type with the extension .DIC.

This is the same issue with the database and log files maintained by SQL Server. So you want to exclude the folder where SQL Server stores its .mdf and .ldf data files.

As a final step (that delivered some of the best performance improvement), I also excluded the executables for Dexterity, Dexterity Utilities and Dynamics. I have five versions of each installed, so that needed 15 entries.

Solution

To make the changes on your Windows 10 system running Windows Defender follow the steps below. If using a different anti virus or malware solution, you can add the same exclusions anyway.

  1. Select Start >> Settings
  2. Select Update & Security >> Windows Defender
  3. Under Exclusions, click Add an exclusion
  4. Under Folders, click Exclude a folder
  5. Locate the SQL Server Data folder and exclude it. On my system it was
    C:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLDATA
  6. Under File Types, click Exclude a file extension
  7. Add .dic as an exclusion
  8. Under Processes, click Exclude a .exe, .com or .scr process
  9. Navigate to the Dex.exe, Dexutils.exe for each version of Dexterity and add it
  10. Also navigate to the Dynamics.exe for each version of Microsoft Dynamics GP and add it

Now test out how fast your system runs Dexterity and/or Microsoft Dynamics GP. Zoom Zoom. :-)

Hope you are happy with your Windows 10 upgrade now.

David

PS: I know adding exclusions weakens your protection, but it does stop you pouring a liquid into the machine in the hopes of dissolving the molasses.

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Development, Dexterity, Dynamics, GP, Microsoft, Windows Tagged: Application, Development, Dexterity, GP 2010, GP 2013, GP 2015, Windows 10

Read More:
Solving Performance Problems with Microsoft Dynamics GP and Windows 10 – Part 2

August 13, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 58