I have a report in which I get randomly the following error after pressing the "View Report" button (because in this report I need to select a parameter value from the dropdown field first):
An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'my_very_special_dataset'. (rsErrorExecutingCommand) Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "My_linked_postgresql_server".
My question is: What can be the cause of this error message?
What I can exclude as a cause:
Usually checking the permissions is stated as an advice or checking if the fields of a dataset still match the fields of that SQL View or table it uses. But both can be excluded since it happens randomly. Also, the parameters cannot be the cause because with the very same parameters it can sometimes work and simtes give me that error.
The enviroment in which the error occurs:
The error does only occur when opened via the browser in the Report Manager (of course the report was deployed there before) but NEVER occurred when opening the report with the "Run" functionality in the SQL Server Report builder.
About the datasets:
The report's datasets use only views which I have defined on the server with the SQL Server Management studio, no tables or procedures or functions. However the views themself use functions and also gather information via OPENQUERY from a linked PostgreSQL server. None of the datasets use filters but use the parameter in the Where clause.
Versions of the mentioned tools:
I use the SQL Server Management Studio (SSMS) version 13.0.16106.4 and SQL Server Report Builder version 3.0.