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