Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

MR 2012 download to Excel stopped working after Windows update

Posted on by 75,730

A couple of weeks ago a Windows update hit that broke the ability to download an MR 2012 CU16 report to Excel. When you click the download button and choose Excel, it pauses for a few seconds, you see the screen flicker and try to do something, but then nothing happens. If you try to print the same thing happens. I have checked all the IE 11 settings and all looks well. Any suggestions on how to reengage this connection?

*This post is locked for comments

  • JoshP Profile Picture
    JoshP on at
    RE: MR 2012 download to Excel stopped working after Windows update

    Hi Richard,

    Thanks for the additional detail. Both event viewer messages do not appear to be related to the web viewer or exporting to Excel. The first two are because of using the Legacy provider. The other message says it is from the deployment log source so that likely occurred when the services were last deployed. I recommend re-creating the issue and see if any messages are logged during the time you re-created. Another suggestion would be to put Internet Explorer into debug mode (F12) and re-create the issue and see the result when compared to a working environment.

    Thanks!

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: MR 2012 download to Excel stopped working after Windows update

    - EventData

     source DeploymentLogSource

     id -1

     component  

     errorMessage  

     exceptionMessage Cannot start service MR2012ApplicationService on computer '.'.

     exceptionSource System.ServiceProcess

     exceptionType System.InvalidOperationException

     stackTrace at System.ServiceProcess.ServiceController.Start(String[] args) at Microsoft.Dynamics.Performance.Deployment.Common.Commanding.DelegateCommand`1.Execute(Object parameter) at Microsoft.Dynamics.Performance.Deployment.Common.Commanding.DelegateOnBackgroundThreadCommand`1.<>c__DisplayClass2_0.<Execute>b__0()

     failureBucketId d5ecb4f5-9853-4a84-b513-10b59f8e714c

     appDomainId 1

     buildVersion 2.12.16000.17

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: MR 2012 download to Excel stopped working after Windows update

    - EventData

     assembly Microsoft.Dynamics.Performance.Reporting.NativeReport.Server, Version=7.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35

     errorMessage The provider for company MyCompany-AA does not support integrated windows authentication through service accounts and drill down has been disabled. Contact your system administrator.

     time 10/17/2017

     exceptionMessage The provider for company TFC-AA does not support integrated windows authentication through service accounts and drill down has been disabled. Contact your system administrator.

     exceptionSource Microsoft.Dynamics.Performance.Reporting.NativeReport.Server

     exceptionType Microsoft.Dynamics.Performance.Reporting.Common.ReportingCompanyUnsupportedAuthenticationException

     stackTrace at Microsoft.Dynamics.Performance.Reporting.NativeReport.NativeReportDirectLink.<>c__DisplayClass2_0.<SubmitRequest>b__0(NativeReportConnectionCacheKey key) at System.Lazy`1.CreateValue() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Lazy`1.get_Value() at Microsoft.Dynamics.Performance.Common.Caching.AutoExpiringDisposableCache`2.GetOrAdd(TKey key, Func`2 createCacheItemValue, Boolean acquireOwnership) at Microsoft.Dynamics.Performance.Reporting.NativeReport.NativeReportDirectLink.SubmitRequest(GLRequest request, String companyName, Int32 reportId) at Microsoft.Dynamics.Performance.Reporting.NativeReport.ReportDataContext.<>c__DisplayClass48_0.<LoadCurrencies>b__0(ReportDataContext context)

     appDomainId 2

     buildVersion 2.12.16000.17

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: MR 2012 download to Excel stopped working after Windows update

    1. Confirm there is not an active pop-up blocker enable in the browser, or a 3rd party pop-up blocker that is running.

    No pop blockers on their two workstations nor on their server.

    2. Confirm that the address for the MR web viewer is added as a Trusted Site.

    The MR web site address is a trusted site

    3. Can the issue be re-created directly on the MR server?

    Yes

    4. Record which updates were installed. Do not uninstall any updates, especially security-related updates, but keep a record of what was installed for future reference.

    I would have to ask their IT staff for this information. What Windows updates came over last Tuesday is what did this on the two workstations. MR was working fine until then. However, no updates were applied to the server so I have explanation there.

    5. I do not know what updates were installed or if they were server-only updates, IE updates, desktop-only updates, .NET updates, etc. Looking at the list of updates which are suspected, can the issue be re-created from a workstation which has not had the same updates installed?

    They have deployed the updates to all workstations.

    6. Does the issue continue if you stop both MR services and start them again?

    Yes

    7. If multiple browsers are installed, does the issue happen for all of them?

    IE 111, Chrome and Mozilla makes no difference.

    8. Are any messages/errors output in the Event Viewer on the MR server? Look at the custom event sources under Applications and Services Logs | Microsoft | Dynamics. There are several "MR-" logs.

    I will send the two events logs in a separate reply.

    In the meantime, the customer may be able to use the Report Viewer as a temporary workaround to export reports to Excel if needed. There are some limitations with using the Report Viewer to do the export so hopefully it works fine for them until the web viewer issue is corrected.

    I have suggested this to them.

  • JoshP Profile Picture
    JoshP on at
    RE: MR 2012 download to Excel stopped working after Windows update

    Hello Richard,

    Thanks for posting your question. I checked with the team and we have not heard of reports from other customers where this type of issue has occurred related to a Windows Update. I would like to confirm some things before pointing the cause of the issue to an update as it may be an issue unique to this environment. If this is a high priority issue, please open a support case so we can work together and validate the cause of the issue and determine a solution. If it is not urgent, I posted a few suggestions as well as some questions below:

    1. Confirm there is not an active pop-up blocker enable in the browser, or a 3rd party pop-up blocker that is running.

    2. Confirm that the address for the MR web viewer is added as a Trusted Site.

    3. Can the issue be re-created directly on the MR server?

    4. Record which updates were installed. Do not uninstall any updates, especially security-related updates, but keep a record of what was installed for future reference.

    5. I do not know what updates were installed or if they were server-only updates, IE updates, desktop-only updates, .NET updates, etc. Looking at the list of updates which are suspected, can the issue be re-created from a workstation which has not had the same updates installed?

    6. Does the issue continue if you stop both MR services and start them again?

    7. If multiple browsers are installed, does the issue happen for all of them?

    8. Are any messages/errors output in the Event Viewer on the MR server? Look at the custom event sources under Applications and Services Logs | Microsoft | Dynamics. There are several "MR-" logs.

    In the meantime, the customer may be able to use the Report Viewer as a temporary workaround to export reports to Excel if needed. There are some limitations with using the Report Viewer to do the export so hopefully it works fine for them until the web viewer issue is corrected.

    Thanks!

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans