Data-Driven Subscriptions - PDF Files - Size limitation (?)
Hello, I use SQL Server Reporting Services 2005 (x86) on Windows Server 2003 (x86). I Have a report published on my server and it works fine. I configured a report subscription to generate PDF files on shared folder network. This subscription created 115 reports and shared an error for 12 other reports. I genereted manualy the 12 missing reports, and exported them to PDF file. I found, that 115 files are between 50Ko and - 600Ko, and the others 12 reports are more bigger, between 601Ko and 700Ko. I don't think there is a configuration on sql server to limit the size of generated PDF file, no? Anyone have a solution for this problem?
May 15th, 2012 11:05am

I do not believe there is any file size limitation. It certainly should not be less than a megabyte, like your files are. Is there anything in the SSRS log files to indicate the error? http://msdn.microsoft.com/en-us/library/ms157403(v=sql.90).aspx
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2012 11:49am

On the log files i have this: Line 6987: ReportingServicesService!processing!43!15/05/2012-20:29:49:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Impossible de lire la ligne de donnes suivante pour le dataset Stats_Proportion_Mail., ; Line 7412: ReportingServicesService!processing!43!15/05/2012-20:29:49:: e ERROR: An exception has occurred in data source 'Stats_Proportion_Mail'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Impossible de lire la ligne de donnes suivante pour le dataset Stats_Proportion_Mail. ---> System.Data.SqlClient.SqlException: Une erreur grave s'est produite sur la commande actuelle. Les rsultats ventuels doivent tre ignors. Line 7477: ReportingServicesService!processing!43!15/05/2012-20:29:49:: i INFO: Merge abort handler called for ID=-1. Aborting data sources ... Line 8018: ReportingServicesService!processing!43!15/05/2012-20:29:49:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Une erreur s'est produite lors du traitement du rapport., ; Line 8064: ReportingServicesService!processing!43!15/05/2012-20:29:49:: w WARN: Data set 'Stats_Temps_De_Pause': Report processing has been aborted. But I'm sure the problem is not on the datasets: _ All reports works fine when i see the report on the server _ I split my original report to two smaller reports and I configured a data-driven subscription: all reports were automatically generated fine
May 16th, 2012 6:11am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics