Report Builder – Query can be Executed Stand-Alone but not inside Report Builder

It occurred for me now a second time, that I am using Report Builder 3.0 and face the error that no connection to the query can be established to fetch the fields automatically. However, I am 100% sure the query is possible to execute and the credentials are correct. If you are, too, then you should check the query runtime. I noticed that when entering queries with more than 60 seconds runtime, Report Builder will start to recover itself – And that even when the timeout is set to infinite!

ReportBuilderSPTimeout

 

Once you also have this issue, you can quickly come around this issue by trying to limit the runtime of the query. As my target is to get automatically all the SP fields set within Report Builder, I usually limit the calculation by TOP 1  inserts.

ReportBuilderSPTimeoutTemporarySolution

Tags

Categories

Meta

Peter Merkert Written by:

Be First to Comment

Leave a Reply