Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter Sh...
Microsoft Dynamics GP (Archived)

Management Reporter Showing Same Data in Test as in Production

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello:

I have Management Reporter 2012 CU13 running in a production and test environment.

Both of the ManagementReporter databases are on separate SQL instances.  I can tell this because, prior to restoring the .tdbx files from production to test, the reports in test looked different from production.

Now, after restoring the .tdbx files from production to test and running the Management Reporter financials in test, the financials in test are showing the same data as that of production!

How can that be?  When I created MR in test, I did not point it to production SQL.  And, we have not restored GP data into the test environment from production in close to a month.

Thanks!

John

*This post is locked for comments

  • Verified answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Management Reporter Showing Same Data in Test as in Production

    Glad you found my other post from the GPUG forum :-)

    https://www.gpug.com/communities/community-home/digestviewer/viewthread?GroupId=247&MID=25133&tab=digestviewer&CommunityKey=4754a624-39c5-4458-8105-02b65a7e929e

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter Showing Same Data in Test as in Production

    Hi Matt:

    Actually, I got my answer from the GPUG Forum as follows:

    If you go into SQL Management Studio and query the content of the table [ControlCompany] from your MR database, you should see the 5th field (GLentityConnectionInformation) which contains the XML connection string to your GP server.. copy the field for one of the company you're using and past it into a notepad

    In the 30 something lines from that XML file, you should locate a section like this :

    This will tell you what GP server MR is really connected to :-)

    Beat Bucher came up with this.  

    It's true.  The data is production.  When I originally copied over the ManagementReproter database, it must have maintained this pointing to production.

    I'm okay with that.

    Thanks, again, for chiming in!

    John

  • MattPaulen Profile Picture
    MattPaulen 6,910 on at
    RE: Management Reporter Showing Same Data in Test as in Production

    It sounds like your Management Reporter database is set for the test environment, which would be where your report definitions and any changes would be stored but the data connections are pointing to the production.

    If you really wanted to get it figured out, post a screenshot of the config console with the integration selected and I could potentially help.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter Showing Same Data in Test as in Production

    Hi There, Matt:

    I took a look at all of those spots, and they're pointing to the test environment.  What's weird, though, is that not only is it pulling in production's data, but I have to enter my production "sa" password instead of my test "sa" password in order to access MR in the test environment.

    It's okay, I guess.  Again, I can tell that the ManagementReporter database is in the test instance.  When I make changes in production to Management Reporter financials, those changes are not reflected in the test environment.

    It's just a curiosity.  :)

    John

  • MattPaulen Profile Picture
    MattPaulen 6,910 on at
    RE: Management Reporter Showing Same Data in Test as in Production

    There definitely has to be something pointing to production.  Are you using the legacy or datamart adapter on the test box?

    Double-check your connections in the Configuration Console again.  Can yous share a screenshot of your config console and your integrations?  

    Also, when in the Report Designer, check the connection by going to Tools >> Connection and make sure that is pointing to the test.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans