none
SSRS Dataset Error while creating report from Sharepoint List

    Question

  • processing!ReportServer_0-14!2410!04/24/2013-16:19:48:: e ERROR: An exception has occurred in data set 'DataSet2'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DataSet2'. ---> System.ArgumentOutOfRangeException: <nativehr>0x80131502</nativehr><nativestack></nativestack>
    processing!ReportServer_0-14!2410!04/24/2013-16:19:48:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...
    processing!ReportServer_0-14!2410!04/24/2013-16:19:48:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DataSet2'. ---> System.ArgumentOutOfRangeException: <nativehr>0x80131502</nativehr><nativestack></nativestack>
       --- End of inner exception stack trace ---;
    processing!ReportServer_0-14!2410!04/24/2013-16:19:48:: w WARN: Data source 'DataSource2': Report processing has been aborted.
    processing!ReportServer_0-14!2b94!04/24/2013-16:19:48:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DataSet2'. ---> System.ArgumentOutOfRangeException: <nativehr>0x80131502</nativehr><nativestack></nativestack>
       at Microsoft.SharePoint.Library.SPRequestInternalClass.GetListItemDataWithCallback2(IListItemSqlClient pSqlClient, String bstrUrl, String bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback, ISPDataCallback pFilterLinkCallback, ISPDataCallback pSchemaCallback, ISPDataCallback pRowCountCallback, Boolean& pbMaximalView)
       at Microsoft.SharePoint.Library.SPRequest.GetListItemDataWithCallback2(IListItemSqlClient pSqlClient, String bstrUrl, String bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback, ISPDataCallback pFilterLinkCallback, ISPDataCallback pSchemaCallback, ISPDataCallback pRowCountCallback, Boolean& pbMaximalView)
       at Microsoft.SharePoint.SPListItemCollection.EnsureListItemsData()
       at Microsoft.SharePoint.SPListItemCollection.GetDataTableCore(Boolean isJsGrid)
       at Microsoft.SharePoint.SPList.GetDataTable(SPQuery query, SPListGetDataTableOptions flags, SPListItemCollectionPosition& position)
       at Microsoft.ReportingServices.SharePoint.Objects.RSSPImpListBase`1.GetDataTable(RSSPQuery query, RSSPListGetDataTableOptions flags, RSSPListItemCollectionPosition& position)
       at Microsoft.ReportingServices.DataExtensions.SharePointList.SPLocalCommand.DataReader.ReadNextListChunk()
       at Microsoft.ReportingServices.DataExtensions.SharePointList.SPLocalCommand.DataReader.Read()
       at Microsoft.ReportingServices.DataExtensions.SharePointList.SPCommandBase.ExecuteReader(CommandBehavior behavior)
       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunEmbeddedQuery(Boolean& readerExtensionsSupported, Boolean& readerFieldProperties, List`1 queryParams, Object[] paramValues)
      
    Wednesday, April 24, 2013 11:35 AM

All replies

  • Hello,

    Based on the error message, the report fail to query the dataset. Please verify that you can connect to the SharePoint List datasource and query the dataset in Query Disgner. If you can run the report in BIDS or Report Builder, then delete the report on Report Server and redeploy the report.

    If the issue presists, please let me know.

    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    Thursday, April 25, 2013 3:13 AM
  • Hi Fanny,

    Thanks for reply.

    Error not solve till now .please help.

    I am using Report Builder for creating a report in SharePoint .I can create data source and data set properly and dataset working fine in Query Designer.But when I run report then error occurring. Please see below image .

    Friday, May 10, 2013 5:54 AM