topic Re: Report Builder throws excessive Warnings in ReportingServicesService in Report Server

Report Builder throws excessive Warnings in ReportingServicesService

Anonymous — Tue, 25 Oct 2022 19:06:04 GMT

Since the May 2022 update our PowerBI RS servers have been throwing excessive warnings when "Editing a report" from the portal

Example:

library!ReportServer_0-5!1d5c!10/25/2022-15:49:26:: i INFO: Call to CreateReportEditSessionAction(Parent=/, Report=****NameOfTheReport*****). User: MYDOMAIN\MYUSERID.
processing!ReportServer_0-5!1d5c!10/25/2022-15:49:26:: w WARN: An exception occurred when extracting info about expression usage. Details: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.CodeAnalysis.VisualBasic, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.CodeAnalysis.VisualBasic, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'
at Microsoft.ReportingServices.RdlExpressions.ExpressionExtractor.ExtractExpression(ExpressionInfo exprInfo)
at Microsoft.ReportingServices.RdlExpressions.VBExpressionParser.AddToExpressionInstrumentation(ExpressionInfo expressionInfo)

WRN: Assembly binding logging is turned OFF.

This warning is repeated about 20 times, bloating the logs. When deploying large batches of reports using powershell modules, this turns into over 1000 copies of said error.

I have repeated the use case against a much older server installation (Jan 2019) and do not get the same Warnings.

I have turned on Fusion logging as per internet guidance :~) and with the added verbose logging can clearly see the report server is looking for:

LOG: Attempting download of new URL file:///L:/Program_Files/PBIRS/PBIRS/ReportServer/RSTempFiles/reportserver/87b89504/492007a1/Microsoft.CodeAnalysis.VisualBasic.DLL.

The DLL its searching for definitely does not exist in the installation directory:

l:\programfiles\pbirs\reportserver\bin along with all the other DLLs the fusion logs reference

Update to Sept 2022? Update dot.Net? Thoughts

Re: Report Builder throws excessive Warnings in ReportingServicesService

Anonymous — Wed, 26 Oct 2022 05:57:42 GMT

Hi Anonymous ,

You can indeed upgrade your Power BI report Server to the September release to see if this issue is mitigated.

Have you tried running Power BI Report Server as an administrator?

Best Regards,
Community Support Team _ Caitlyn

Re: Report Builder throws excessive Warnings in ReportingServicesService

Anonymous — Wed, 26 Oct 2022 12:13:05 GMT

Running as admin makes no differnce. Same warnings thrown in the logs

Re: Report Builder throws excessive Warnings in ReportingServicesService

THarmes — Thu, 27 Oct 2022 07:43:29 GMT

We see the same problem on our server. Setting the suggested registry entry hasn´t changed anything.
The problem occured some versions before and wasn´t solved in any upgrade we made. (Currently have have Sep 22 deployed).

Any help on the topic is appreciated!

Best regards,

Thomas

Re: Report Builder throws excessive Warnings in ReportingServicesService

Anonymous — Mon, 23 Oct 2023 03:45:30 GMT

ok I was experiencing this error also for the Portal when opening a folder. It just started happening one day with no apparent reason. My first approach was to download the .rdl, drop the folder, recreate and reupload rdl files and relink. This works for a few weeks then the issue reoccurred. This time I searched for the Microsoft.CodeAnalysis.VisualBasic.DLL file and found it in several locations in the PBIRS folder location. So I copied the file to the PBIRS/Portal folder, as the Portal was showing the error. Restart PBIRS and the issue has disappeared.
Hoping this helps someone else.

If an official fix is found for this, I'd love to see it.