Error Registering Table GL_Account_MSTR

● Ian Grieve ●  ● 3 Comments  ● 

Microsoft Dynamics GPWhile ding an upgrade of a client to Microsoft Dynamics GP I suddenly started getting an error when navigating the system; for example, when opening the General Journal Entry window:

Microsoft Dynamics GP: Error Registering Table GL_Account_MSTR

Microsoft Dynamics GP

Error Registering Table GL_Account_MSTR

Continue reading → Error Registering Table GL_Account_MSTR

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

eConnect Incoming Queue In Microsoft Dynamics GP 2015 Does Not Work

● Ian Grieve ●  ● 3 Comments  ● 

Microsoft Dynamics GPI did an upgrade of a client from Microsoft Dynamics GP 2010 R2 to Dynamics GP2015 recently and encountered a problem with eConnect.

This particular client uses the eConnect incoming queue to integrate journals and payables invoices into Dynamics GP from a housing management system.

After installing eConnect and configuring the incoming queue I set about doing a test to ensure it was working.

Unfortunately, it didn’t.

Continue reading → eConnect Incoming Queue In Microsoft Dynamics GP 2015 Does Not Work

● Categories: Dynamics, eConnect, GP, Microsoft ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Messages Submitted To eConnect Disappearing

● Ian Grieve ●  ● 1 Comment  ● 

Microsoft Dynamics GPI had an issue to deal with for a client recently where messages submitted to eConnect were no longer appearing in Microsoft Dynamics GP. I did the usual things of checking the Windows Event Log and ensuring that the two eConnect services were running.

One item I tried was to submit a test message to eConnect which worked fine; so it worked for the perfectimage user I was logged in as, but no-one else. I eventually found the answer in the Properties of the econnect_incoming queue:

eConnect_incoming Properties

The permissions for the perfectimage account (Full) were still configured correctly, but, somehow, the Send Message permission on Everyone had been removed. Once this setting had been added back, people were able to submit messages to the queue without further problem.

● Categories: Dynamics, eConnect, GP, Microsoft ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Management Reporter Client Crash During Import of Building Blocks

● Ian Grieve ●  ● 7 Comments  ● 

Microsoft Dynamics GPI’m in the middle of an upgrade of a client to Microsoft Dynamics GP 2015 R2 and am also upgrading Management Reporter to CU12 (I’m not entirely happy with CU13 and am avoiding it for now). We initially had problems with the upgrade as the server ran out of HDD space due to the size of the database and the changes made during the upgrade.

After discussing it with the client, we agreed to re-implement Management Reporter and migrate all of the building blocks from the old server to the new one.

It was while doing the import into Management Reporter 2012 CU12 that I ran into a problem; a persistent crashing:

Management Reporter for Microsoft Dynamics ERP has stopped working

I’d already imported the Report Definitions without any problem and was looking to make sure all of the building blocks were imported when it crashed with the above error message. I restarted it and tried again and it again crashed on me.

I did a little playing round and found that it only seemed to crash if the house moved over the top of the Report Definitions in the scrolling window; if I moved the cursor around the outside of the scrolling window and selected the tab of any of the other building blocks, such as the Column Definitions, I could move the mouse over the top of them and make selections. Just not over the top of the Report Definitions.

I headed online to see if I could find anyone else talking about the same issue and came across a post from Stoneridge Software had found something very similar, although they reported it was only the left most column whereas for me it was all of the columns.

Stoneridge also report that the fix for this was in CU13.

● Categories: Dynamics, GP, Management Reporter, Microsoft ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

Management Reporter Error: An Error Occurred While Configuring ‘Management Reporter Application Service’ Part 4 – Log Space

● Ian Grieve ●  ● 2 Comments  ● 

Microsoft Dynamics GPAs mentioned in the last post, I’ve been having some fun with Management Reporter recently. Unfortunately, Integration Manager the errors it produces are often less than useful. After resolving the issues with the schema owner, SQL Timeout and SQL Login, the attempt to upgrade Management Reporter produced another generic error message:

Management Reporter 2012: An error occurred while configuring 'Management Reporter Application Service'. Check the deployment log for details.

Management Reporter 2012

An error occurred while configuring 'Management Reporter Application Service'. Check the deployment log for details.

Continue reading → Management Reporter Error: An Error Occurred While Configuring ‘Management Reporter Application Service’ Part 4 – Log Space

● Categories: Dynamics, GP, Management Reporter, Microsoft ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

Management Reporter Error: An Error Occurred While Configuring ‘Management Reporter Application Service’ Part 3 – SQL Login

● Ian Grieve ●  ● 3 Comments  ● 

Microsoft Dynamics GPOver the last couple of postrs, I have discussed the first two error messages I encountered recently (schema owner and SQL Timeout) doing an upgrade of Management Reporter for a client.

After resolving the issue with the SQL Timeout error, the attempt to upgrade Management Reporter produced an error message at the validation stage:

Validation Messages: Database configuration: Unable to connect to the specified database server with the Management Reporter service account. Make sure the database server is correct and that the service account has a SQL Server Login.

Validation Messages

Database configuration: Unable to connect to the specified database server with the Management Reporter service account. Make sure the database server is correct and that the service account has a SQL Server Login.

After clicking Close I launched Management Studio and loaded the properties for the user account used for the Management Reporter services:

Login Properties

After clicking on User Mapping I was able to see that the Management Reporter database was not selected. I marked the checkbox next to it and clicked OK.

I was able to click the Proceed button and continue the deployment. With the extended timeout from the last post, I left the upgrade running in the back ground.

Unfortunately, the story was far from over.

● Categories: Dynamics, GP, Management Reporter, Microsoft ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

Management Reporter Error: An Error Occurred While Configuring ‘Management Reporter Application Service’ Part 2 – SQL Timeout

● Ian Grieve ●  ● 3 Comments  ● 

Microsoft Dynamics GPAs mentioned in the last post, I’ve been having some fun with Management Reporter recently. Unfortunately, Integration Manager the errors it produces are often less than useful. After resolving the issue with the schema owner, the attempt to upgrade Management Reporter produced another generic error message:

Management Reporter 2012: An error occurred while configuring 'Management Reporter Application Service'. Check the deployment log for details.

Management Reporter 2012

An error occurred while configuring 'Management Reporter Application Service'. Check the deployment log for details.

Continue reading → Management Reporter Error: An Error Occurred While Configuring ‘Management Reporter Application Service’ Part 2 – SQL Timeout

● Categories: Dynamics, GP, Management Reporter, Microsoft ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

Management Reporter Error: An Error Occurred While Configuring ‘Management Reporter Application Service’ Part 1 – Database Principal

● Ian Grieve ●  ● 9 Comments  ● 

Microsoft Dynamics GPI’ve had some right good fun with Management Reporter recently, actually not so much fun, but the bane of my life (in the course of pretty much one day). And over the new few posts I’m going to share the trials and tribulations I have undergone.

A recent upgrade of Management Reporter resulted in a fairly generic error message being displayed while trying to configure the legacy connector (the connector type is not important for this error):

Management Reporter 2012: An error occurred while configuring 'Management Reporter Application Service'. Check the deployment log for details.

Management Reporter 2012

An error occurred while configuring 'Management Reporter Application Service'. Check the deployment log for details.

Continue reading → Management Reporter Error: An Error Occurred While Configuring ‘Management Reporter Application Service’ Part 1 – Database Principal

● Categories: Dynamics, GP, Management Reporter, Microsoft ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

hMailServer: hMailServer Administrator Configuration

● Ian Grieve ●  ● 1 Comment  ● 

Microsoft Dynamics GPIf you followed the last post you should have the Connect window on screen. If not start the hMailServer Administrator from the start menu.

Select the server you want to connect to and click Connect

Connect

Continue reading → hMailServer: hMailServer Administrator Configuration

● Categories: Dynamics, GP, hMailServer, Microsoft, Workflow ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

hMailServer: Database Configuration

● Ian Grieve ●  ● 0 Comments  ● 

Microsoft Dynamics GPIn the last post I showed the installation of hMailServer; in this one I’m going to cover the database setup.

If you followed the last post you should have the hMailServer password window on screen. If not start the hMailServer Database Setup utility from the start menu.

Enter the admin password configured during the installation and click OK:

hMailServer password

on the Welcome step, click Next:

hMailServer Database Setup - Step 1 of 7: Welcome

Choose the database server Owner; as I am installing this on a Dynamics GP test system which has a full SQL Server installation, I have selected the Use external database engine (MSSQL, MySQL or PostgreSQL) radion button. Click Next:

Setup - hMailServer: Select database server Owner

This is a new installation of hMailServer so leave the Create a new hMailServer database and click Next:

hMailServer Database Setup - Step 2 of 7: Select option

Leave the Microsoft SQL Server option selected and click Next:

hMailServer Database Setup - Step 3 of 7: Select database server Owner

Enter the Database server address (this can be either the Server Name or IP Adress), enter a Database name and choose your Authentication method.

During an installation, I typically select Use server authentication and enter the sa username and password. I do this to ensure the user I am using has all of the necessary permissions to create a database and all objects.

Click Next to proceed:

hMailServer Database Setup - Step 4 of 7: Enter sever connection information

You can then configure the hMailServer service dependency if the mail server is the same machine as the SQL Server (which in this example it is not).

Click NMext to proceed:

hMailServer Database Setup - Step 5 of 7: Set hMailServer service dependency

On the Finish stage, click Next to start the installation:

hMailServer Database Setup - Step 6 of 7: Finish

Once the installation is complete, click Close:

hMailServer Database Setup - Step 7 of 7: Completed

A final step allowing the hMailServer to be run will be displayed:

Setup - hMailServer Database Setup: Completing the hMailServer Setup Wizard

I’ll be covering the hMailServer Administrator in the next post in this series.

Click to show/hide the hMailServer Series Index

● Categories: Dynamics, GP, hMailServer, Microsoft, Workflow ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●