none
Cannot get Report Pack (Project 2007 SDK) working for MSPS 2007 and SQL 2008 RRS feed

  • Question

  • Hi all,

     

    My environment consists of Windows Server 2008, MSPS 2007 and SQL 2008.  All of them have SP2 applied.  I'm also very new to SQL and MSPS.

     

    I’m having a problem with the report pack setup using the Project 2007 SDK.  I load the report pack code sample (Project 2007 Report Pack.sln) in Visual Studio, change the data source information to reflect my server name (can6800vm018) and database (Type: Microsoft SQL Server, catalog=ReportServer) I want to use, change the report pack properties (TargetReportFolder -> http://can6800vm018/Reports, TargetServerURL -> http://can6800vm018/reportserver) and then attempt to deploy the project pack when I receive the following error:

     System.Web.Services.Protocols.SoapException: This operation is not supported on a report server that is configured to run in Sharepoint Integrated mode.

    Report server seems to be up and running as when I hit the link under Web Service URL in Reporting Services Configuration Manager I see "CAN6800VM018/ReportServer - /" in big bold lettering with a few directories listed below with the dates (Is this what I'm supposed to see):

    Thursday, April 21, 2011 2:31 PM   <dir> http://can6800vm018

    Thursday, April 21, 2011 2:43 PM   <dir> http://can6800vm018/PWA

    Thursday, April 21, 2011 2:35 PM   <dir> http://can6800vm018:8000/ssp/admin

     

    I tried something out but I’m not sure if this is correct.  I removed the /reportserver from my TargetServerURL in Visual Studio so I was left with just the server name.  I was able to deploy the reports successfully and they showed up on my Sharepoint site.  When I try to open any of them I get the following error:

     

    Error

    An error has occurred during the report processing. (rsProcessingAborted)

    Query execution failed for dataset 'CostCenterList'. (rsErrorExecutingCommand)

    Invalid object name 'MSP_EpmResource'.

     

    This is what I get in the reporting services log:

     

    library!ReportServer_0-1!db0!06/01/2011-15:24:28:: Call to GetPermissionsAction(http://can6800vm018/PWA/reports/1.0 Cost Center Availability Report.rdl).

    library!ReportServer_0-1!db0!06/01/2011-15:24:28:: Call to ListParentsAction(http://can6800vm018/PWA/reports/1.0 Cost Center Availability Report.rdl).

    processing!ReportServer_0-1!db0!06/01/2011-15:24:29:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'CostCenterList'., ;

    Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'CostCenterList'. ---> System.Data.SqlClient.SqlException: Invalid object name 'MSP_EpmResource'.

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

       at System.Data.SqlClient.SqlDataReader.get_MetaData()

       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

       at Microsoft.ReportingServices.DataExtensions.SqlCommandWrapperExtension.ExecuteReader(CommandBehavior behavior)

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()

       --- End of inner exception stack trace ---

    processing!ReportServer_0-1!db0!06/01/2011-15:24:29:: e ERROR: An exception has occurred in data source 'CostCenterList'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'CostCenterList'. ---> System.Data.SqlClient.SqlException: Invalid object name 'MSP_EpmResource'.

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

       at System.Data.SqlClient.SqlDataReader.get_MetaData()

       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

       at Microsoft.ReportingServices.DataExtensions.SqlCommandWrapperExtension.ExecuteReader(CommandBehavior behavior)

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()

       --- End of inner exception stack trace ---

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.Process()

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeParameterDataSet.Process()

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessConcurrent(Object threadSet)

    processing!ReportServer_0-1!db0!06/01/2011-15:24:29:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...

    dataextension!ReportServer_0-1!db0!06/01/2011-15:24:29:: w WARN: CommandWrapper.Cancel not called, connection is not valid

    processing!ReportServer_0-1!db0!06/01/2011-15:24:29:: 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 'CostCenterList'. ---> System.Data.SqlClient.SqlException: Invalid object name 'MSP_EpmResource'.

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

       at System.Data.SqlClient.SqlDataReader.get_MetaData()

       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

       at Microsoft.ReportingServices.DataExtensions.SqlCommandWrapperExtension.ExecuteReader(CommandBehavior behavior)

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()

       --- End of inner exception stack trace ---

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.Process()

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeParameterDataSet.Process()

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessConcurrent(Object threadSet)

       --- End of inner exception stack trace ---

    processing!ReportServer_0-1!db0!06/01/2011-15:24:29:: w WARN: Data source 'Project_Data_Source': Report processing has been aborted.

    processing!ReportServer_0-1!db0!06/01/2011-15:24:29:: 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 'CostCenterList'. ---> System.Data.SqlClient.SqlException: Invalid object name 'MSP_EpmResource'.

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

       at System.Data.SqlClient.SqlDataReader.get_MetaData()

       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

       at Microsoft.ReportingServices.DataExtensions.SqlCommandWrapperExtension.ExecuteReader(CommandBehavior behavior)

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()

       --- End of inner exception stack trace ---

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.Process()

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeParameterDataSet.Process()

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessConcurrent(Object threadSet)

       --- End of inner exception stack trace ---

    chunks!ReportServer_0-1!db0!06/01/2011-15:24:29:: w WARN: Rolling back shared chunk transaction for snapshot '9cdbfc3f-8139-464c-9ceb-d5dadf3398f8', Permanent=True.

    processing!ReportServer_0-1!db0!06/01/2011-15:24:29:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'CostCenterList'., ;

    Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'CostCenterList'. ---> System.Data.SqlClient.SqlException: Invalid object name 'MSP_EpmResource'.

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

       at System.Data.SqlClient.SqlDataReader.get_MetaData()

       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

       at Microsoft.ReportingServices.DataExtensions.SqlCommandWrapperExtension.ExecuteReader(CommandBehavior behavior)

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()

       --- End of inner exception stack trace ---

    processing!ReportServer_0-1!db0!06/01/2011-15:24:29:: e ERROR: An exception has occurred in data source 'CostCenterList'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'CostCenterList'. ---> System.Data.SqlClient.SqlException: Invalid object name 'MSP_EpmResource'.

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

       at System.Data.SqlClient.SqlDataReader.get_MetaData()

       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

       at Microsoft.ReportingServices.DataExtensions.SqlCommandWrapperExtension.ExecuteReader(CommandBehavior behavior)

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()

       --- End of inner exception stack trace ---

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.Process()

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeParameterDataSet.Process()

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessConcurrent(Object threadSet)

    processing!ReportServer_0-1!db0!06/01/2011-15:24:29:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...

    dataextension!ReportServer_0-1!db0!06/01/2011-15:24:29:: w WARN: CommandWrapper.Cancel not called, connection is not valid

    processing!ReportServer_0-1!db0!06/01/2011-15:24:29:: 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 'CostCenterList'. ---> System.Data.SqlClient.SqlException: Invalid object name 'MSP_EpmResource'.

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

       at System.Data.SqlClient.SqlDataReader.get_MetaData()

       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

       at Microsoft.ReportingServices.DataExtensions.SqlCommandWrapperExtension.ExecuteReader(CommandBehavior behavior)

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()

       --- End of inner exception stack trace ---

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.Process()

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeParameterDataSet.Process()

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessConcurrent(Object threadSet)

       --- End of inner exception stack trace ---

    processing!ReportServer_0-1!db0!06/01/2011-15:24:29:: w WARN: Data source 'Project_Data_Source': Report processing has been aborted.

    processing!ReportServer_0-1!db0!06/01/2011-15:24:29:: 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 'CostCenterList'. ---> System.Data.SqlClient.SqlException: Invalid object name 'MSP_EpmResource'.

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

       at System.Data.SqlClient.SqlDataReader.get_MetaData()

       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

       at Microsoft.ReportingServices.DataExtensions.SqlCommandWrapperExtension.ExecuteReader(CommandBehavior behavior)

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()

       --- End of inner exception stack trace ---

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.Process()

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeParameterDataSet.Process()

       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessConcurrent(Object threadSet)

       --- End of inner exception stack trace ---

    chunks!ReportServer_0-1!db0!06/01/2011-15:24:29:: w WARN: Rolling back shared chunk transaction for snapshot '9cdbfc3f-8139-464c-9ceb-d5dadf3398f8', Permanent=True.

     

     Am I on the right track with my approach or do I need to figure out why I get the “Sharepoint Integrated Mode” error when I try to deploy the report pack with /ReportServer added to my TargetServerURL in Visual Studio?  Please help!

     

    Thanks!

     

    Andre

    Thursday, June 2, 2011 1:46 PM

Answers

  • Hi all,

    I finally figured out what was happening.  When I deployed the reports, I used the database ReportServer.  I changed this to ProjectSever_Reporting, deployed it again, and it worked.  The reason I did is is because I noticed in the log file for Reporting Services that it couldn't query a specific table.  I took a look at the tables in the ReportServer database in SQL Server Management Studio and couldn't find those tables.  I started looking through other databases and found the exact entry in ProjectSever_Reporting.

    Hope this helps someone!

     

    Andre

    Friday, June 3, 2011 3:19 PM

All replies

  • Hi Andre,  It seems like you are set up ok to display your reports in PWA.  However your target url should be the PWA site as in http://can6800vm018/PWA/

    But first, you will need to set up a doc library for your reports.  http://can6800vm018/PWA/reports.  Then you'll need to configure the library's content types.  So in the document library settings you would add Report builder report, report data source, and possibly report builder model.

    Try this out.  Your data source will also be uploaded to PWA.  YOu can have it in the same folder as your reports or create a directory for it.

    I hope this is helpful.

    Jenn Penn

    Thursday, June 2, 2011 2:17 PM
  • Hi Jenn,

     

    Thanks for the reply!  I changed the TargetReportFolder to http://can6800vm018/PWA/reports and the TargetServerURL to http://can6800vm018/PWA/ and the reports deployed successfully under Documents in PWA.  I still get the same error when I try to load any of the reports.

    I did find that the "Report Server Integration Feature" was not active under Site Collection Features so I enabled that but I still get the same error.

    I couldn't find the "document library settings you would add Report builder report, report data source, and possibly report builder model." like you mentioned above...could you please point me in the right direction?

     

    Thanks!

     

    Andre

    Thursday, June 2, 2011 3:10 PM
  • Navigate to the document library that you've deployed your reports.  Click the settings drop down menu and select document library settings.  You should see a section for Content Types, just below that is a link to "Add from existing site content types."  Click that, you can add them there.

    I am still fairly new to this too.  I had trouble with the datasource where I had to reconfigure it after it was deployed to the site. That could be your issue too.  Read the error messages carefully as they sometimes give a good indication of what specifically is wrong.

    Thursday, June 2, 2011 3:17 PM
  • Also forgot to tell you, you have to turn on manage content types to see the options I refered to earlier.  In the docuemnt library settings under General Settings, click on advance settings. check yes to allow management of content types.

    Thursday, June 2, 2011 3:29 PM
  • Thanks Jenn,

    Took me a few minutes to figure out how to enable to content types but then I was able to add all of them.  Unfortunately I'm still getting the same error but you definitely pointed me in the right direction.

    Thanks for all your help and if you think of anything else please let me know!

     

    Andre

    Thursday, June 2, 2011 3:42 PM
  • Hi all,

    I finally figured out what was happening.  When I deployed the reports, I used the database ReportServer.  I changed this to ProjectSever_Reporting, deployed it again, and it worked.  The reason I did is is because I noticed in the log file for Reporting Services that it couldn't query a specific table.  I took a look at the tables in the ReportServer database in SQL Server Management Studio and couldn't find those tables.  I started looking through other databases and found the exact entry in ProjectSever_Reporting.

    Hope this helps someone!

     

    Andre

    Friday, June 3, 2011 3:19 PM