Problems with Microsoft Project office 365 Visual reports MSOLAP$cubes

Occasional Contributor

Problems with Microsoft Project office 365 Visual reports MSOLAP$cubes

Hi

We have some problems with our Microsoft Project while trying to generate a Visual report:

Screenshot 2021-12-30 151654.png

When we check the event viewer, we find following informationals:

161385-image.png

We tried the following:
Reinstall and update the office 365 applications (we are running Version 2102 Build 13801.20960)
Installed https://docs.microsoft.com/en-us/analysis-services/client-libraries?view=asallproducts-allversions drivers.
Tried to repair office installation
Tried to update Visual C++ redistributables + tried to repair

 

Informational:
We are running a Horizon VDI setup W10 enterprise Build 19042.1237

 

11 Replies
Jeremy --

Ever since the Visual Reports feature was added in Microsoft Project 2007 (if memory serves me correctly), I have found this feature to be a bit flaky. If I had one US dollar for every time I have seen that "An unknown error has occurred" error dialog, I would be a wealthy man. :)

Whenever I see that error message, I simply try generating the Visual Report again until it finally works. I am not aware of any permanent fix to the problem. Sometimes I am able to generate the Visual Report on the first try, and sometimes I have to try again and again until it finally works.

What happens if you try generating the Visual Report multiple times? Do you eventually succeed? Or is the process failing every time? And if it fails every time, is the problem limited to specific projects or to all projects? Please let us know and we will try to help you.

Hello @Jeremy9251970 ,

I'm guessing this is due to the VDI set up and not MS Project / Excel related and this is happening for every project you try. It is probably that the MS Project App can't see / recognise that the Excel app is also available on the VDI? 

Paul

@Dale Howard 

 

Hi

 

Thanks for the help :).

I tried to generate the visual report a couple of times but it keeps failing. It is not limited to a specific project but it occurs with all of the projects. Even with sample projects from Microsoft.

 

Kind regards

Hi
Thanks for the help.

It is possible that this is related to the VDI, we have tried to do this on the golden image (base image) of the VDI and with the local admin account, this does work. But whenever i log in with an account with the actual license, it seems like it stops working. I have opened a case with the VDI support aswell.

Kind regards

Hi @Jeremy9251970 ,

This will be an issue with the VDI set up and not MS Project / Excel / Visio, hopefully your VDI support team can resolve this for you.

Paul

@Paul Mather 

Hi,

Thanks for the response. First of all best wishes for 2022!
Still looking into this issue together with the VDI team, seems like something is going wrong with the shared. And we got another fault code: see attached screenshot

 

 

 

Hello @Jeremy9251970 - Best wishes to you too.
Hopefully the VDI team can resolve this issue for you.

Is there a way to enable MS project logging? Just to verify where it is going wrong.

@Dale Howard I was having this problem on and off but could keep retrying and eventually the report would run. Sometimes just renaming the file would do the trick.

 

As of yesterday, no success at all.  Have you found any resolution?