Smart View Error When refreshing Large Ad Hoc Sheets: “Smart View handled an unknown exception thrown by Microsoft Office.”
Posted by Ben Collins on 28 July 2016 11:20 AM

The error has been reported on HFM versions onwards.

When attempting to refresh large Ad Hoc Files users were receiving the following error: “Smart View handled an unknown exception thrown by Microsoft Office.”

It was initially believed that the issue was a bug. This was recorded as a fix on smart view version However, this is not always the case.

From investigations the issue was due to the loss of network connections on a IIS level. This was discovered by finding ASP.NET errors on the Web Server indicating an issue with the smart view "HFMOfficeProvider.aspx" link.

The solution was run the command prompt "IISRESET". This re-estabilished the links. 

Note: It may be worth confirming the last time the Hyperion Services were restarted. Regular scheduling to restart the Hyperion Services can also help with performance.

Please find attached the screen shots of the errors found in the Event Viewer.

 Screen Shot 2016-07-27 at 10.38.51.png (92.12 KB)
(0 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name: