I am getting the following error when trying to run a SSRS report with the data extensions. The report runs fine when a server administrator runs it but not when a normal user runs it.
processing!ReportServer_0-5!1ac0!12/23/2009-09:56:08:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'RequestDiscussions'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'RequestDiscussions'. ---> System.Data.SQLite.SQLiteException: Unable to open the database file
unable to open database file
at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at #6g.#wj.#zi(String , String , IEsqParameterCollection , IEsqParameterCollection )
at #0g.#7g.#Kh(Boolean )
at Enesys.SharePoint.Query.EsqCommand.#fp(Boolean )
at Enesys.SharePoint.Query.EsqCommand.ExecuteReader(#io )
at Enesys.ReportingServices.Ersde.ErsdeCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()
--- End of inner exception stack trace ---
processing!ReportServer_0-5!1ac0!12/23/2009-09:56:08:: e ERROR: An exception has occurred in data source 'RequestDiscussions'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'RequestDiscussions'. ---> System.Data.SQLite.SQLiteException: Unable to open the database file
unable to open database file
processing!ReportServer_0-5!1ac0!12/23/2009-09:56:08:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...
processing!ReportServer_0-5!1ac0!12/23/2009-09:56:08:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'RequestDiscussions'. ---> System.Data.SQLite.SQLiteException: Unable to open the database file
unable to open database file
--- End of inner exception stack trace ---
processing!ReportServer_0-5!1ac0!12/23/2009-09:56:08:: w WARN: Data source 'MyDataSource': Report processing has been aborted.
processing!ReportServer_0-5!1ac0!12/23/2009-09:56:08:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'RequestDiscussions'. ---> System.Data.SQLite.SQLiteException: Unable to open the database file
unable to open database file
--- End of inner exception stack trace ---
chunks!ReportServer_0-5!1ac0!12/23/2009-09:56:08:: w WARN: Rolling back shared chunk transaction for snapshot '4c9a5d4d-495b-4899-8085-ac86500a292f', Permanent=False.
library!ReportServer_0-5!1ac0!12/23/2009-09:56:08:: w WARN: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'RequestDiscussions'. ---> System.Data.SQLite.SQLiteException: Unable to open the database file
unable to open database file
webserver!ReportServer_0-5!1ac0!12/23/2009-09:56:08:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'RequestDiscussions'. ---> System.Data.SQLite.SQLiteException: Unable to open the database file
unable to open database file