Forum Discussion
Jeremy9251970
Dec 30, 2021Copper Contributor
Problems with Microsoft Project office 365 Visual reports MSOLAP$cubes
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:
When we check the event viewer, we find following informationals:
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
15 Replies
Sort By
- Jeremy9251970Copper ContributorIs there a way to enable MS project logging? Just to verify where it is going wrong.
Hello Jeremy9251970 ,
Just the default Office options https://support.microsoft.com/en-us/topic/change-office-diagnostics-settings-edf47acc-fee8-4e68-b9f7-3945ad6f81e7
Then use the data viewer: https://support.microsoft.com/en-us/office/using-the-diagnostic-data-viewer-with-office-cf761ce9-d805-4c60-a339-4e07f3182855
Paul
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
- Jeremy9251970Copper ContributorHi
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 regardsHi 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
- 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.- moody123Copper Contributor
Dale_HowardMVP 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?
- Jeremy9251970Copper ContributorHi,
I've contacted Microsoft Support and they have stated the following:
We have tested this behavior internally and unfortunately, this issue is persisting and we are able to re-create/reproduce this issue. It has already been highlighted to our escalation/senior peers and a fix would be rolled out in upcoming months, apologies but currently no ETA is confirmed
Only workaround at this moment is a rollback to: Version 2008(Build 13127.20910)
Kind regards,
Jeremy
- Jeremy9251970Copper Contributor
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