Management Reporter 2012 CU15 Is Now Available

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPThe Dynamics Financial Reporting for Microsoft Dynamics GP has announced the availability of CU15 for Management Reporter 2012. This cumulative up-date contains a few bug fixes as well as some enhancements.

Here’s a summary of the new Management Reporter CU15 features:

  • Improved responsiveness in the Web Viewer.
  • A search bar has been added to search through the current level of the report as in-browser search functions may not always return all results because of the performance changes to improve responsiveness.
  • Printing in the Web Viewer through XPS download.
  • PowerShell module to enable reset of data mart.
  • Added a Turkish (tr-tr) localization.
  • Additional fixes for product defects.
  • The Dynamics Financial Reporting for Microsoft Dynamics GP team will be blogging about the new features in detail soon.

    There are a few new prerequisites which are required for this cumulative update:

    • SQL Server 2012 or higher.
    • Microsoft .NET Framework 4.6.1 is also required (when installed this may require a reboot).

    Management Reporter CU15 Release is version 2.12.15000.56; make sure your ERP version is supported by checking the compatibility list.

    The EN-US download for Management Reporter CU15 is here and localised versions will be coming soon.

● Categories: Dynamics, Management Reporter, 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 ●

Error Configuring The Management Reporter 2012 Legacy Connector

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPWhile trying to configure the legacy connector in Management Reporter 2012 recently I received an error message while the entered settings were being validated:

Validation Messages - Database configuration: The master password could not be validated against the password policy
Validation Messages - Database configuration: The master password could not be validated against the password policy

Continue reading → Error Configuring The Management Reporter 2012 Legacy Connector

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

Management Reporter Error: The Length Of The Value Is Invalid

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPA client recently logged an issue with Management Reporter producing an error when they tried generating a report. As is commonly the case, the error in the Queue Status window wasn’t terribly informative, but we did get a more detailed error when looking in the Windows Event Log:

Microsoft.Dynamics.Performance.DataProvider.Core.RequestException: The source system request did not complete successfully. ---> System.ArgumentOutOfRangeException: The length of the value is invalid.  \r\nMinimum supported length: 1 \r\nMaximum supported length: 512
Microsoft.Dynamics.Performance.DataProvider.Core.RequestException: The source system request did not complete successfully. ---> System.ArgumentOutOfRangeException: The length of the value is invalid.  \r\nMinimum supported length: 1 \r\nMaximum supported length: 512

From the error message, we have an item which is the wrong length. I took a shot and guessed that the problem might be down to the budgets as I have seen corruption in client’s systems before which has caused problems with Management Reporter.

One quick select later confirmed that there was a corrupt record in the Budget Master (GL00200) table. I deleted this entry using the below code:


DELETE FROM
	GL00200
WHERE
	BUDGETID = ''

After which the client confirmed Management Reporter was able to generate the report successfully.

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

MDGP 2015 Feature of the Day: Management Reporter Data Integration

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The thirty third Feature of the Day is Management Reporter Data Integration. In Microsoft Dynamics GP 2015, the user can determine the data that is available to the Microsoft Dynamics Management Reporter DataMart, improving the performance and giving the user control over the data selected.

The user can choose per company (including sample company) if they want the General Ledger data available for reporting.

The user also has the ability to include or exclude Analytical Accounting data for each company:

Company Setup Options

I am slightly puzzled by this feature of the day as you can simply not import a company into Management Reporter if you don;t want to report on it. While I steer clients away from AA where possible, I am not entirely opposed to it, but I do wonder who would want to report on AA without also wanting to be able to report on the GL.

The roles targeted by this feature are:

  • All

Click to show/hide MDGP 2015 Feature of the Day Series Index

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

MDGP 2015 Feature of the Day: Management Reporter in Business Analyzer

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The twenty sixth Feature of the Day is Management Reporter in Business Analyzer.This features enables users to add Management Reporter content to the Microsoft Dynamics Business Analyzer app:

Companion Application Services Configurator

Continue reading → MDGP 2015 Feature of the Day: Management Reporter in Business Analyzer

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