An error occurred in the Microsoft .NET Framework while trying to load assembly id 65626. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE

Error while submitting workflow on GP 2016R2 -

An error occurred in the Microsoft .NET Framework while trying to load assembly id 65626. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE

We have installed and upgraded the GP from lower version to the upper version of the GP. We have restored the SQL server on the new installed SQL server. Once we upgraded the GP2010 to GP 2016R2 without any error and while testing the workflow it was giving an error. To solve this error you need to run the one store procedure against DYNAMICS Database and this error will be solved.

 EXEC DYNAMICS.dbo.wfDeployClrAssemblies

Execution of user code in the .Net Framework is disabled. Enable “clr enabled” configuration option

GP Error while email testing – GP 2016R2

Error – Execution of user code in the .Net Framework is disabled. Enable “clr enabled” configuration option.

The above error is related to the SQL server, the clr enabled is not enable. For this need to enable the clr on SQL server. Use the below query to enable to clr .

USE master;
GO
EXEC sp_configure 'show advanced option', '1';
GO
RECONFIGURE;
GO
EXEC sp_configure 'CLR Enabled', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'show advanced option', '0';
GO
RECONFIGURE;
GO

GP Web Client Installation - GP 2016 R2

Web client runtime components installation –

1. Go to the setup file folder and double click on the setup or right click on click open on the setup.
2. Click on install – Microsoft Dynamics GP.
3. Select the instance name and click next.

4. Click on add/remove features.

5. Select web client runtime and click next.

6. Click on install and the installation process will start. Once the installation process is finished click on exit.

Creation of Security groups –

1. Open Server Manager. Click Tool in the right corner of Server Manager and then select Computer Management.
2. In the Computer Management windows, expand Local Users and Groups and select Groups. Right click on it and click on New Group.

3. Enter the Group name for Web client users.

4. Create new group for the web client admins using the same steps as users.

5. After you create two groups you will see the both groups on the groups on Local Users and Groups section.

Internet Information Services (IIS) and ASP.NET -

Internet Information Services (IIS) and ASP.NET Internet Information Services (IIS) and ASP.NET must be installed on the web server on which you will be installing the Microsoft Dynamics GP web client.

1. Open Server Manager. Click Manage in the right corner of Server Manager and then select Add roles and features.

2. Click on next once you see the below page.

3. Choose Role-based or feature-based installation, and then click next.

4. Select your server from the server pool, and then click Next.

5. Mark Web Server (IIS) and then click Next.

6. Click on Add features.

7. Select the features to install. Select ASP.NET 4.5 In the WCF Services group under .NET Framework 4.5 Features, select HTTP Activation.

8. The screen for the Web Server Role (IIS) is displayed. Click Next.

9. Select the role services to install for the web server.

In Common HTTP Features:

• Static Content

• Default Document

In Security:

• Windows Authentication

In Application Development:

• ASP.NET 4.5

Other role services will already be marked. Some are marked by default. Click Next.

10. Click Install. The roles, features, and role services will be added.

11. Once the installation is finished click on close.

Creation of security certificates –

1. Open Internet Information Services (IIS) Manager.
2. In the left pane, select the computer name.
3. In the IIS group, open Server Certificates.

4. Click on Create self-Signed Certificate from the right side.

5. Specify the certificate name and click on ok, new self-signed certificate will be created.

6. In the left pane, expand the Sites group. Within the Sites group, select the site that you are configuring to use SSL. For example, select the Default Web Site.
7. In the Actions pane, click Bindings.
8. In the Site Binding window, click Add.
9. In the Add Site Bindings window, select https for the type, and then choose an SSL certificate that you created and click on ok.

10. Click on close.

Web client installation –

1. Go to the setup file folder and double click on the setup or right click on click open on the setup.
2. Click on web client from Additional products.

3. Accept the License Agreement.

4. Click on custom.

5. Select the features that you want to install. On the web server machine, you will typically install the Web Server, Session Central, Web Site, and the Web Management Console and click on next.

6. Enter the SQL server instance name and keep the database name as default.

Specify the SQL server credentials.

7. Select the authentication type as windows account and click on next.

8. Select the web client users group and the web client management  console users, which we have created earlier.

9. Click on next.

10. Enter the sa user id and password and specify the Dex.ini and dynamics.set path. Keep default if you have not specified any path.

11. Re-enter the sa password again.

12. Select the certificate which we have created earlier and enter the domain user is and password.

13. Select the website name and enter the domain credentials and click next.

14. Click on next.

15. Select the website name and enter the domain credentials and click next.

16. Select the certificate which we have created earlier and enter the domain user is and password and click next.

17. Select the certificate which we have created earlier and click next.

18. Select the certificate which we have created earlier and enter the domain user is and password.

19. Select the certificate which we have created earlier and enter the domain user is and password.

20. Click on install and the installation process will start.

21. At the Welcome screen, click next.
22. Specify the type of authentication you want to use to connect to the SQL Server where the database for the Session Central Service database is located. Click Next to continue.
23. Review the configuration actions that will be performed. Click Next to continue.
24. Click Exit.
25. Restart the Session Central Service for the Microsoft Dynamics GP web client installation. You must do this on the machine where you installed the SessionCentral Service, typically the machine that is hosting the web site. This step is necessary to allow the Session Central Service to establish communication with the session host machine.

Deployment of Business Analyser on azure service bus – Dynamics GP2016 R2

Deployment of Business Analyser on azure service bus –Dynamics GP2016 R2

Business Analyser will be able to show you the graphical representation of your business information as well as the reports on your screen. The business analyser with azure bus service will let you to access it from anywhere using your windows 8 computers. Before start on this you will need the azure subscription credentials. Below are the steps using this you can install the GP companion App Services with azure service bus.

Creation of azure service bus -

1. Download Azure PowerShell – http://go.microsoft.com/fwlink/p/?linkid=320376&clcid=0x409 and install and configure it.
2. Run the command "Add-AzureAccount" and provide Azure ID user name/password to connect to a default Azure subscription.
3.  Create a new Azure Service Bus namespace using the command –  
   New-AzureSBNamespace -Name mynamespace -Location "East US" -CreateACSNamespace $true -NamespaceType Messaging 

Once you run the above command you will get the AcsManagementEndpoint,  ServiceBusEndpoint, ConnectionString, SharedSecretIssuer save it as it will be use during the GP companion App Services installation.

Create self-signed certificate on IIS –

1. Open IIS, click on server name and click on server certificates.
2. From the right side click on create self-signed certificate and enter the name and click ok.

Installation of GP companion App Services -

1. Go to Dynamics GP installation folder and open the setup file.
2. From the Dynamics GP Installation, click on companion application Services and select install on Additional products section.
3. If it will ask for installation of run time libraries install it.
4. Accept the license agreement and click on next.
5. Click on install and installation process will start once the installation process is finished click on exit.
6. Go to the path C:\Program Files\Microsoft Dynamics\GP Companion App Services and open the configuration.

7. You will see the companion application services configurator then click on next.

8. Enter the Service name, issuer name and issuer key which you have got during the creation of azure servicebus, this will be available on SharedSecretIssuer section and the issuer name will be owner and service name will be the same which you have given at the time of the creation.

9. From the certificate dropdown select the certificate you have created on IIS and click on next.

10. You will see the business analyser on the companion application services and that should be enabled and click on next.

11. Select the report which you want to enable on the business analyser.

Note – The reports should be deployed on the GP whichever you want to see on the Business analyser.

How to deploy Excel reports - http://dynamicsgpguide.blogspot.in/2017/02/deploy-excel-reports-dynamics-gp-2016-r2.html

How to deploy SSRS reports - http://dynamicsgpguide.blogspot.in/2017/02/ssrs-reports-deployment-dynamics-gp.html

12. If you have selected the excel report it will ask you the shared path on which the reports are deployed enter the shared path location and click next.

13. If you have selected the SSRS reports then it will ask the web service URL, enter the web service URL. If you have deployed the report on specific folder on SSRS then you have to give the folder name also and click on next. It will start the process of configuration.

14. Once the process is finished you will see the connection information, save the connection information on notepad for the use it and click on exit.

15. You will have to install the business analyser on windows 8 from windows store and open it.
16. Take you mouse on left side bottom you will see the settings, click on settings. Once you click on settings you will see the configuration option, click on configuration.
17. Click on off the sample report mode.
18. Enter the domain user id and password and enter the service connection which you got when companion configuration completed and click on connect.

19. Once the connection is completed you will see the nice look of the business analyser reports.