UnhandledReportRenderingException in SQL Reporting Service happening randomly.
Hi: one of our customers are having this exception randomly. We put in some re-try code and keep-alive code, yet it still happens. So I am looking at the SQL log our customer sent us. And I saw this. So basicaly, one of the report has no data in certain field. would that be the cause of that problem? library!ReportServer_0-15!150c!10/11/2010-11:50:22:: i INFO: RenderForNewSession('/CMSm5/PharmaPac_Live/Custom/Documents/Purchase Order.Pharma.2008') processing!ReportServer_0-15!150c!10/11/2010-11:50:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 9., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 9. webserver!ReportServer_0-15!62c!10/11/2010-11:50:23:: i INFO: Processed report. Report='/CMSm5/PharmaPac_Live/Custom/Documents/Purchase Order.Pharma.2008', Stream='' library!ReportServer_0-15!13ec!10/11/2010-11:50:50:: Call to GetReportParametersAction(/CMSm5/PharmaPac_Live/Custom/Documents/Purchase Order.Pharma.2008). library!ReportServer_0-15!13ec!10/11/2010-11:50:51:: i INFO: RenderForNewSession('/CMSm5/PharmaPac_Live/Custom/Documents/Purchase Order.Pharma.2008') processing!ReportServer_0-15!13ec!10/11/2010-11:50:51:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 9., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 9. library!ReportServer_0-15!13ec!10/11/2010-11:50:58:: Call to GetReportParametersAction(/CMSm5/PharmaPac_Live/Custom/Documents/Purchase Order.Pharma.2008). library!ReportServer_0-15!13ec!10/11/2010-11:50:59:: i INFO: RenderForNewSession('/CMSm5/PharmaPac_Live/Custom/Documents/Purchase Order.Pharma.2008') processing!ReportServer_0-15!13ec!10/11/2010-11:50:59:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 9., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 9.
October 19th, 2010 7:41pm

Hi, Based on the error message, please check if the dataset field or report parameter missed values at that time. thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 8:34am

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

Other recent topics Other recent topics