SSRS reports are not delevering. Reports configured with the Domain account. Can anyone please let me know what was the issue exactly . Below error has been found in the log : notification!WindowsService_19!1b3c!08/30/2012-02:10:05:: e ERROR: Error occured processing subscription 86d55a9e-6bd6-4c3a-834f-3cf726253e9e: Please enter an e-mail address. notification!WindowsService_19!bbc!08/30/2012-02:30:01:: e ERROR: Error occured processing subscription 86d55a9e-6bd6-4c3a-834f-3cf726253e9e: Please enter an e-mail address. library!DefaultDomain!5d0!08/30/2012-02:38:06:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. notification!WindowsService_19!494!08/30/2012-02:40:04:: e ERROR: Error occured processing subscription 86d55a9e-6bd6-4c3a-834f-3cf726253e9e: Please enter an e-mail address.

Hi, I am not getting your problem clearly, You don't have your reports in the project or you can't deploy your project. tell me clearly ..

Hi Esmari, I was just running used created report and found below messages in the error log ================================================================ ortrendering!WindowsService_19!494!08/30/2012-03:35:12:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.HandledReportRenderingException: , Microsoft.ReportingServices.ReportProcessing.HandledReportRenderingException: Excel Rendering Extension: Number of rows exceeds the maximum possible rows per sheet in this format; Rows Requested: 892428, Max Rows: 65536 ---> Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: Excel Rendering Extension: Number of rows exceeds the maximum possible rows per sheet in this format; Rows Requested: 892428, Max Rows: 65536 at Microsoft.ReportingServices.Rendering.ExcelRenderer.Layout.LayoutEngine.RenderPageToExcel(IExcelGenerator excel, String key, Dictionary`2 sharedBorderCache, Dictionary`2 sharedImageCache) at Microsoft.ReportingServices.Rendering.ExcelRenderer.MainEngine.RenderRPLPage(RPLReport report, Boolean headerInBody, Boolean suppressOutlines) at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory metaDataChunkFactory, IChunkFactory yukonCompiledDefinition) --- End of inner exception stack trace ---; library!WindowsService_19!494!08/30/2012-03:35:15:: w WARN: Microsoft.ReportingServices.ReportProcessing.HandledReportRenderingException: Excel Rendering Extension: Number of rows exceeds the maximum possible rows per sheet in this format; Rows Requested: 892428, Max Rows: 65536 ---> Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: Excel Rendering Extension: Number of rows exceeds the maximum possible rows per sheet in this format; Rows Requested: 892428, Max Rows: 65536 library!WindowsService_19!494!08/30/2012-03:35:17:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties. emailextension!WindowsService_19!494!08/30/2012-03:35:17:: e ERROR: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Excel Rendering Extension: Number of rows exceeds the maximum possible rows per sheet in this format; Rows Requested: 892428, Max Rows: 65536 ---> Microsoft.ReportingServices.ReportProcessing.HandledReportRenderingException: Excel Rendering Extension: Number of rows exceeds the maximum possible rows per sheet in this format; Rows Requested: 892428, Max Rows: 65536 ---> Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: Excel Rendering Extension: Number of rows exceeds the maximum possible rows per sheet in this format; Rows Requested: 892428, Max Rows: 65536 notification!WindowsService_19!494!08/30/2012-03:35:17:: e ERROR: Error occured processing subscription 5c9ed601-834c-42cf-9887-936e8b031e99: Failure sending mail: Excel Rendering Extension: Number of rows exceeds the maximum possible rows per sheet in this format; Rows Requested: 892428, Max Rows: 65536Mail will not be resent. library!WindowsService_19!494!08/30/2012-03:38:18:: i INFO: Call to CleanBatch() library!WindowsService_19!494!08/30/2012-03:38:18:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions. library!WindowsService_19!494!08/30/2012-03:38:18:: i INFO: Call to CleanBatch() ends library!WindowsService_19!494!08/30/2012-03:40:08:: i INFO: Schedule 1f7deceb-e8ec-4be7-bd7b-70fa69e13998 executed at 08/30/2012 03:40:08. schedule!WindowsService_19!494!08/30/2012-03:40:08:: Creating Time based subscription notification for subscription: 86d55a9e-6bd6-4c3a-834f-3cf726253e9e library!WindowsService_19!494!08/30/2012-03:40:08:: i INFO: Schedule 1f7deceb-e8ec-4be7-bd7b-70fa69e13998 execution completed at 08/30/2012 03:40:08. library!WindowsService_19!bbc!08/30/2012-03:40:08:: i INFO: Handling data-driven subscription 86d55a9e-6bd6-4c3a-834f-3cf726253e9e to report /EPC Reports/NDW EPC Change Activity Audit, owner: CABLE\SCasse000, delivery extension: Report Server Email. library!WindowsService_19!bbc!08/30/2012-03:40:08:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties. library!WindowsService_19!494!08/30/2012-03:40:09:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties. notification!WindowsService_19!494!08/30/2012-03:40:09:: i INFO: Handling subscription 86d55a9e-6bd6-4c3a-834f-3cf726253e9e to report NDW EPC Change Activity Audit, owner: CABLE\SCasse000, delivery extension: Report Server Email. notification!WindowsService_19!494!08/30/2012-03:40:09:: e ERROR: Error occured processing subscription 86d55a9e-6bd6-4c3a-834f-3cf726253e9e: Please enter an e-mail address. library!ReportServer_0-7!1404!08/30/2012-03:41:04:: Call to GetPermissionsAction(/EPC Reports/EPC Rate Code to Product Mapping). library!ReportServer_0-7!1404!08/30/2012-03:41:04:: Call to GetSystemPropertiesAction(). library!ReportServer_0-7!1404!08/30/2012-03:41:04:: Call to GetPropertiesAction(/EPC Reports/EPC Rate Code to Product Mapping, PathBased). library!ReportServer_0-7!1404!08/30/2012-03:41:04:: Call to GetPropertiesAction(/EPC Reports/EPC Rate Code to Product Mapping, PathBased). library!ReportServer_0-7!1404!08/30/2012-03:41:04:: Call to GetItemTypeAction(/EPC Reports/EPC Rate Code to Product Mapping). library!ReportServer_0-7!1404!08/30/2012-03:41:04:: Call to GetReportParametersAction(/EPC Reports/EPC Rate Code to Product Mapping). library!ReportServer_0-7!1404!08/30/2012-03:41:04:: Call to GetSystemPermissionsAction(). library!ReportServer_0-7!1404!08/30/2012-03:41:04:: Call to GetItemTypeAction(/EPC Reports/EPC Rate Code to Product Mapping). library!ReportServer_0-7!1404!08/30/2012-03:41:04:: Call to ListSubscriptionsAction(/EPC Reports/EPC Rate Code to Product Mapping, null). library!ReportServer_0-7!1404!08/30/2012-03:41:04:: Call to GetPropertiesAction(/EPC Reports/EPC Rate Code to Product Mapping, PathBased). library!ReportServer_0-7!1404!08/30/2012-03:41:05:: Call to ListEventsAction(). library!ReportServer_0-7!1404!08/30/2012-03:41:05:: Call to GetItemDataSourcesAction(/EPC Reports/EPC Rate Code to Product Mapping). library!ReportServer_0-7!1404!08/30/2012-03:41:05:: Call to GetItemTypeAction(/EPC Reports/EPC Rate Code to Product Mapping). library!ReportServer_0-7!1404!08/30/2012-03:41:05:: Call to GetReportItemReferencesAction(/EPC Reports/EPC Rate Code to Product Mapping). library!ReportServer_0-7!1404!08/30/2012-03:41:05:: Call to GetSystemPropertiesAction(). ================================================================ Any idea? I just need to udpate the user about the root cause of this.. please help. vijayasarathi

Hi Vijayasarathi1, Based on your description, you create a subscription and configure the report rendered with Excel format. However, when rendering the report with Excel Rendering Extension, you encounter the error that the number of requested row exceeds the maximum possible rows per sheet in Excel. In your case, whats the version of the SQL Server? If we are using SQL Server 2005,2008 or 2008R2, the maximum number of rows in Excel is 65536, which checked by the rendering extension. In SQL Server 2012, the maximum number of rows per worksheet is 1,048,576. We should make sure that the content of the report will not exceed the maximum rows per worksheet in Excel. So, please redesign your report if the report contains much content. For example, you can add a group to the table based on the row number and then add a page break at the end of the group. When export the report to Excel, the content will display in more than more one worksheet. For more detail information, please refer to the thread below: http://social.technet.microsoft.com/Forums/en/sqlreportingservices/thread/941ff6c9-ed7c-4b82-8ce3-4f78f9cb5787 For more information about Exporting to Microsoft Excel, please see: http://msdn.microsoft.com/en-us/library/dd255234(v=sql.100).aspx Regards, Fanny LiuFanny Liu TechNet Community Support

Hi Vijayasarathi1, Based on your description, you create a subscription and configure the report rendered with Excel format. However, when rendering the report with Excel Rendering Extension, you encounter the error that the number of requested row exceeds the maximum possible rows per sheet in Excel. In your case, whats the version of the SQL Server? If we are using SQL Server 2005,2008 or 2008R2, the maximum number of rows in Excel is 65536, which checked by the rendering extension. In SQL Server 2012, the maximum number of rows per worksheet is 1,048,576. We should make sure that the content of the report will not exceed the maximum rows per worksheet in Excel. So, please redesign your report if the report contains much content. For example, you can add a group to the table based on the row number and then add a page break at the end of the group. When export the report to Excel, the content will display in more than more one worksheet. For more detail information, please refer to the thread below: http://social.technet.microsoft.com/Forums/en/sqlreportingservices/thread/941ff6c9-ed7c-4b82-8ce3-4f78f9cb5787 For more information about Exporting to Microsoft Excel, please see: http://msdn.microsoft.com/en-us/library/dd255234(v=sql.100).aspx Regards, Fanny LiuFanny Liu TechNet Community Support

Hi Vijayasarathi1, Based on your description, you create a subscription and configure the report rendered with Excel format. However, when rendering the report with Excel Rendering Extension, you encounter the error that the number of requested row exceeds the maximum possible rows per sheet in Excel. In your case, whats the version of the SQL Server? If we are using SQL Server 2005,2008 or 2008R2, the maximum number of rows in Excel is 65536, which checked by the rendering extension. In SQL Server 2012, the maximum number of rows per worksheet is 1,048,576. We should make sure that the content of the report will not exceed the maximum rows per worksheet in Excel. So, please redesign your report if the report contains much content. For example, you can add a group to the table based on the row number and then add a page break at the end of the group. When export the report to Excel, the content will display in more than more one worksheet. For more detail information, please refer to the thread below: http://social.technet.microsoft.com/Forums/en/sqlreportingservices/thread/941ff6c9-ed7c-4b82-8ce3-4f78f9cb5787 For more information about Exporting to Microsoft Excel, please see: http://msdn.microsoft.com/en-us/library/dd255234(v=sql.100).aspx Regards, Fanny LiuFanny Liu TechNet Community Support

Hi Fanny, Thanks for the info. vijayasarathi