Management Reporter – Troubleshooting and Errors

Management Reporter Troubleshooting

1. Check out the Event Viewer (Application), and review the Management Reporter Events. This is pretty important, as Doug mentioned here
2. Search in the forums from GPWindow, and from the Management Reporter Forum here (this is not yet indexed by GPWindow) http://social.microsoft.com/Forums/en-US/managementreporterBeta/
3. Refresh the cached Financial Data - On the Tools menu, click Refresh Cached Financial Data.
4. Confirm whether or not the Application Service is running correctly is to type in the following in IE:
   http://MRservername:MRport/SecurityService.svc
5. Stop and Start the Management Reporter application pool (From IIS). Check the Event Viewer for errors.
6. Stop and Start the Management Reporter Process Service. Check the Event Viewer for errors. This is found under Control Panel | Administrative Tools | Services | Management Reporter Process Service.
7. Restart the Web Service in IIS

#6 Restarting the Process Service

Errors

If you get the following error when you launch Management Reporter -"Connection attempt failed.  User does not have appropriate permissions to connect to the server." -

You need to add their users - Add user- enter domain\username.  They can only launch if they are login to windows using their own domain account.

Check out this post from Cecile for details.

---

If you get the “Unable to connect to the specified server. Verify that the Management Reporter application service has been installed on the server and that the specified address is correct” error -

There is a great checklist by Ryan from Microsoft here.

1. Management Reporter will only function while connected to the domain it was installed on. Even if all MR server components are on one machine, that machine still needs to be connected to the domain you were on when you installed MR.

2. Confirm the Application Service application pool is running. This is found in Internet Information Services Manager and is the Management Reporter app pool.

3. Confirm the Management Reporter Process Service is running. This is found under Control Panel | Administrative Tools | Services | Management Reporter Process Service.

4. Confirm the Identity of the Application Service app pool has GeneralUser and public SQL roles to the Management Reporter SQL database.

5. Confirm the user running the Management Reporter Process Service has GeneralUser and public SQL roles to the Management Reporter SQL database.

6. Confirm the IIS machine has the port used in the MR installation set up as an exclusion on any Firewalls (Windows Firewall included).

7. Another way to test to confirm whether or not the Application Service is running correctly is to type in the following in IE:

http://MRservername:MRport/SecurityService.svc

This should return a page with code samples. If you get an HTTP error then ASP.NET 2.0 may not be enabled or the Application Service may not be running.

8. Check the Event Viewer for more information

9. Stop and Start the Management Reporter application pool. Check the Event Viewer for errors.

10. Stop and Start the Management Reporter Process Service. Check the Event Viewer for errors.

11. Windows Server 2003 – Web Service Extensions in IIS, Active Server Pages can’t be set to Prohibited.

---

Reports being stuck in Queue

Check out the Event Viewer (Application), and review the Management Reporter Events.  The error details will guide you to fixing the problem

---

Data not shown in reports

This could be due to a number of reasons. One crazy reason we found (again via the Event Viewer), was that no functional currency was set in GP.

Solution:  Set functional currency in Multicurrency Setup window (Microsoft Dynamics GP menu >> Tools >> Setup >> Financial >> Multicurrency)

FRx : Error 3617

Having used Management Reporter for a few days, I think FRx is here for few more years till MR catches on and builds on its extensive list of features.

So here’s an FRx error I received today -

"Error 3617 The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again." 

There was a related support article by Microsoft - http://support.microsoft.com/kb/964452

The article suggested - “Microsoft FRx Support will be able to assist in identifying what table contains the duplicate values that are causing the error but the GL vendor's support will need to be involved to resolve any database issues.”

Before I moved to that, I thought of researching a bit about the FRx install. The Service Packs seemed to be in place, but it turned out the FRx AA Add-In was not installed. That’s a separate install when you use AA with FRx. I have seen a lot of people miss it especially when setting up new FRx installs, so I thought I’d put it here.

 

GP Support Tip : Sending a GP Window Path in an Email ?

If you are helping somebody out with GP, sending them instructions – you often need to put in the Window Navigation Paths.

“Open up the Safe Pay Transaction Upload Window from Microsoft Dynamics GP menu >> Tools >> Routines >> Financial >> Safe Pay >> Transactions Upload”

If you have GP and the Window Open, this is easy – just click on the Help Button, and it would show you the path of the Window. You can copy it and paste it in the instructions you are writing.

However, in case you don’t have GP open, you can copy the path from the Where’s that GP Window Page. Pretty convenient, isn’t it ? 

AA Duplicate Error and a ‘House Moment’ ?

A few weeks back we got the error below when adding a dimension in Analytical Accounting.  The user was trying to add the dimension “Customer” in their test environment.

Cannot insert duplicate key row in object ‘dbo.AAG00600’ with unique index ‘AK2AAG00600’

We tried the steps in the KB Article 897280 and a related helpful article from Daoud, but they didn’t really help. We couldn’t add the “Customer” dimension.

However, when we added “Cust” it worked! We took a screenshot, and since everything else was working smoothly, thought about researching about it later .

I sent the screenshot to Rubal, and she had her “house moment”, and immediately showed me the values in the Table AAG00600. She said it seems like whenever we add a dimension called “Employee” or “Customer” is causes a conflict with the keys in the AAG00600 aaTreeMstr table.

We verified this with the other values in the aaTreeMstr table.

So these 6 dimension Names are not allowed. Try it out in your new GP install- if you try and add the dimension “Employee”, it will give you that error. I have tested this in a GP 10 and a GP 2010 install, let me know if you get this error as well.

Related errors and resolution -

Error message when you try to post Analytical Accounting transactions in Microsoft Dynamics GP: "Cannot insert duplicate key in object"

Article ID : 897280

https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYKKQRRUZVRPSSXNSNKVMMVVRXTSXXQNNVZKKSSQUZOZXOKPKP&wa=wsignin1.0

http://mohdaoud.blogspot.com/2009/08/analytical-accounting-error-cannot.html

GP 9 Vs GP 10 Vs GP 2010 – Upgrade Value Guide

Up on Partnersource is the comparison guide comparing in summary the new features highlighted in each version of GP from V 9.0 onwards.

Check it out here - https://mbs.microsoft.com/partnersource/marketing/campaigns/existingcustomer/msdygp_compareguide.htm?p=5

The document details out the bullet points, module by module and is a great help when you need to point out to somebody what they will gain from an upgrade.

---

For lots of great posts about GP 2010 new features - http://www.jivtesh.com/2010/04/gp-2010-new-features-system.html,

and here http://www.gpwindow.com/GP_VERSIONS/GP_2010/

You can find posts about GP 10 here - http://www.gpwindow.com/GP_VERSIONS/GP_10/

GP SQL Scripts, Modifier with VBA, and GP Learning Resources

Mariano Gomez has just updated his excellent GP blog, and setup three excellent pages -

GP SQL Scripts Page – Mariano has listed his excellent SQL Scripts.  Most of Mariano’s scripts are also highly rated in the SQL Scripts section of GPWindow.

Modifier with VBA Page – Lots of VBA and other code samples.

GP Learning Resources  - This page has tutorials and links to links to Mariano’s presentations at Convergence and other Conferences.

 

Check out the new pages, Mariano is an expert GP consultant and almost everything he puts on his blog is stuff that would be useful to most people implementing GP.

As a side note earlier today I was searching for Management Reporter on GPWindow, and the new auto-complete, which is calculated dynamically on basis of the most used keywords in the GP Blogs and forums showed me “Mariano” in the list! I guess it just goes on to show how much work Mariano has done in the GP Community.

GPWindow Now Searches Dynamics GP Communities and Forums (Alpha Version)

Most people know and refer to the blog posts by GP Experts which are searchable and categorized at GPWindow. However, there is incredible amount of data buried and available via the GP Community Forums and Newsgroups.

The red hot Dynamics GP Community forum already has over 2,452 topics and multiple replies to most topics. The GP Public Newsgroups are being phased out, but they have a gold mine of over 90,000 posts.

In an effort to make that information more readily available, GPWindow now has GP Forums and Groups search

Go on, give it a shot - www.GPWindow.com 

 

 

Notes -

1. This is an alpha version. Although most posts in GP Community are indexed, only a portion of the GP Public newsgroups are currently indexed.
2. Try the search – having one place where you can search the awesome GP Blogs, and tens of thousands of forum posts, might save you some time. If you have any feedback, feel free to email me at jivtesh AT gmail DOT com or add your comment!