web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

MR 2012 download to Excel stopped working after Windows update

(0) ShareShare
ReportReport
Posted on by 75,848 Moderator

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

I have the same question (0)
  • JoshP Profile Picture
    on at

    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!

  • Richard Wheeler Profile Picture
    75,848 Moderator on at

    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.

  • Richard Wheeler Profile Picture
    75,848 Moderator on at

    - 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
    75,848 Moderator on at

    - 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

  • JoshP Profile Picture
    on at

    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!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans