Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error: Subreport could not be shown.

Status
Not open for further replies.

stanja

MIS
Sep 10, 2001
149
BE
Hello ,
I've got a report with subreports running on a daily basis that is exported to excel and mailed to several persons.
Since recently one of the sheets isn't showing the data but the error message Error: Subreport could not be shown.
When i then manually restart the job it's ok.
I'm using win 2003 server with sql 2005 Standard Edition (64-bit) SP1 9.00.2047.00

Below the content of the reporting logging
ReportingServicesService!library!a!07/30/2007-06:30:12:: i INFO: Call to RenderFirst( '/Hoboken reporting/Management - Daily figures' )
ReportingServicesService!runningjobs!4!30/07/2007-06:30:45:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!4!30/07/2007-06:33:39:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!dbpolling!f!30/07/2007-06:35:02:: EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!4!30/07/2007-06:35:02:: EventPolling processing item bc72ef57-20e5-447b-96be-c6cef7982c7a
ReportingServicesService!library!4!30/07/2007-06:35:04:: Schedule b82db1a8-ecdb-4fc2-a04e-856a52bbef34 executed at 30/07/2007 6:35:04 AM.
ReportingServicesService!schedule!4!30/07/2007-06:35:04:: Creating Time based subscription notification for subscription: cf146d78-fa05-42af-ae3a-aa362ea5acd6
ReportingServicesService!library!4!30/07/2007-06:35:04:: Schedule b82db1a8-ecdb-4fc2-a04e-856a52bbef34 execution completed at 30/07/2007 6:35:04 AM.
ReportingServicesService!dbpolling!f!30/07/2007-06:35:04:: NotificationPolling processing 1 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!17!30/07/2007-06:35:04:: NotificationPolling processing item d326abd9-1aea-4317-8f5a-e39d39af96f8
ReportingServicesService!dbpolling!4!30/07/2007-06:35:04:: EventPolling finished processing item bc72ef57-20e5-447b-96be-c6cef7982c7a
ReportingServicesService!library!17!07/30/2007-06:35:06:: i INFO: Call to RenderFirst( '/Hoboken reporting/Management - Weekly figures' )
ReportingServicesService!runningjobs!e!30/07/2007-06:35:45:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!e!30/07/2007-06:43:39:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!dbpolling!f!30/07/2007-06:45:07:: EventPolling processing 4 more items. 4 Total items in internal queue.
ReportingServicesService!dbpolling!e!30/07/2007-06:45:07:: EventPolling processing item cc8eb05c-67c9-4eea-b560-0888a0e411a5
ReportingServicesService!dbpolling!4!30/07/2007-06:45:07:: EventPolling processing item cf72148c-7ce0-444b-a06a-62074e24bb15
ReportingServicesService!dbpolling!3!30/07/2007-06:45:08:: EventPolling processing item cd01faf4-1697-4bc6-90f0-659f49ba8012
ReportingServicesService!library!4!30/07/2007-06:45:08:: Schedule 7adb96fa-4ff9-45d9-b200-d15865d18064 executed at 30/07/2007 6:45:08 AM.
ReportingServicesService!schedule!4!30/07/2007-06:45:08:: Creating Time based subscription notification for subscription: f968d885-83ac-4637-b437-efa7157f801f
ReportingServicesService!library!e!30/07/2007-06:45:08:: Schedule ec47ad49-ff07-4e03-bafe-cd214c4436d1 executed at 30/07/2007 6:45:08 AM.
ReportingServicesService!schedule!e!30/07/2007-06:45:08:: Creating Time based subscription notification for subscription: 243cc8f6-2481-4cbc-9726-77eace336489
ReportingServicesService!library!4!30/07/2007-06:45:08:: Schedule 7adb96fa-4ff9-45d9-b200-d15865d18064 execution completed at 30/07/2007 6:45:08 AM.
ReportingServicesService!dbpolling!4!30/07/2007-06:45:08:: EventPolling finished processing item cf72148c-7ce0-444b-a06a-62074e24bb15
ReportingServicesService!dbpolling!4!30/07/2007-06:45:08:: EventPolling processing item 313675b6-4135-4e64-b0d1-348c82c4dc1e
ReportingServicesService!library!e!30/07/2007-06:45:08:: Schedule ec47ad49-ff07-4e03-bafe-cd214c4436d1 execution completed at 30/07/2007 6:45:08 AM.
ReportingServicesService!dbpolling!e!30/07/2007-06:45:08:: EventPolling finished processing item cc8eb05c-67c9-4eea-b560-0888a0e411a5
ReportingServicesService!dbpolling!f!30/07/2007-06:45:09:: NotificationPolling processing 2 more items. 4 Total items in internal queue.
ReportingServicesService!dbpolling!e!30/07/2007-06:45:09:: NotificationPolling processing item 60b74c12-bb7f-48c8-b6cc-8288f920669b
ReportingServicesService!library!4!30/07/2007-06:45:09:: Schedule 73df329f-94ce-4caf-a597-c3bf9f5faa92 executed at 30/07/2007 6:45:09 AM.
ReportingServicesService!schedule!4!30/07/2007-06:45:09:: Creating Time based subscription notification for subscription: bfa9de97-f189-4dba-9eea-07bc1ffe6458
ReportingServicesService!dbpolling!c!30/07/2007-06:45:09:: NotificationPolling processing item 5cc98d6d-b9ce-4224-9491-ab7e9e48db64
ReportingServicesService!library!4!30/07/2007-06:45:09:: Schedule 73df329f-94ce-4caf-a597-c3bf9f5faa92 execution completed at 30/07/2007 6:45:09 AM.
ReportingServicesService!library!e!07/30/2007-06:45:09:: i INFO: Call to RenderFirst( '/Hoboken reporting/Management - Week Day Sales' )
ReportingServicesService!dbpolling!4!30/07/2007-06:45:09:: EventPolling finished processing item 313675b6-4135-4e64-b0d1-348c82c4dc1e
ReportingServicesService!library!3!30/07/2007-06:45:10:: Schedule d1d54369-7800-4d16-bf64-77fd515f6dea executed at 30/07/2007 6:45:10 AM.
ReportingServicesService!schedule!3!30/07/2007-06:45:10:: Creating Time based subscription notification for subscription: 36d38ed7-73a9-4609-b97d-382a9f2c0e9d
ReportingServicesService!library!c!07/30/2007-06:45:10:: i INFO: Call to RenderFirst( '/Hoboken reporting/Management - Weekly Monday LFL' )
ReportingServicesService!library!3!30/07/2007-06:45:11:: Schedule d1d54369-7800-4d16-bf64-77fd515f6dea execution completed at 30/07/2007 6:45:11 AM.
ReportingServicesService!dbpolling!3!30/07/2007-06:45:11:: EventPolling finished processing item cd01faf4-1697-4bc6-90f0-659f49ba8012
ReportingServicesService!dbpolling!f!30/07/2007-06:45:11:: EventPolling processing 4 more items. 4 Total items in internal queue.
ReportingServicesService!dbpolling!4!30/07/2007-06:45:11:: EventPolling processing item ab67e733-3c49-4f83-aa28-6543b11e195e
ReportingServicesService!dbpolling!3!30/07/2007-06:45:11:: EventPolling processing item 451bb708-d42f-4691-af88-91071cf9baa9
ReportingServicesService!library!3!30/07/2007-06:45:12:: Schedule b41db65e-4114-44b1-af56-26a7ab1709bc executed at 30/07/2007 6:45:12 AM.
ReportingServicesService!schedule!3!30/07/2007-06:45:12:: Creating Time based subscription notification for subscription: 90d6eae1-e260-4831-b9d5-5bd9089e151d
ReportingServicesService!library!3!30/07/2007-06:45:12:: Schedule b41db65e-4114-44b1-af56-26a7ab1709bc execution completed at 30/07/2007 6:45:12 AM.
ReportingServicesService!dbpolling!f!30/07/2007-06:45:12:: NotificationPolling processing 3 more items. 7 Total items in internal queue.
ReportingServicesService!runningjobs!c!7/30/2007-06:45:12:: w WARN: Thread pool pressure. Using current thread for a work item.
ReportingServicesService!dbpolling!3!30/07/2007-06:45:12:: EventPolling finished processing item 451bb708-d42f-4691-af88-91071cf9baa9
ReportingServicesService!dbpolling!3!30/07/2007-06:45:12:: EventPolling processing item 41e22d56-128c-4438-af66-6e844490cfe9
ReportingServicesService!library!4!30/07/2007-06:45:14:: Schedule fea0a7b7-ec44-48d5-b380-8cc9b580c014 executed at 30/07/2007 6:45:14 AM.
ReportingServicesService!schedule!4!30/07/2007-06:45:14:: Creating Time based subscription notification for subscription: c541312e-d08c-436e-8919-251533d7c1fb
ReportingServicesService!runningjobs!c!7/30/2007-06:45:14:: w WARN: Thread pool pressure. Using current thread for a work item.
ReportingServicesService!library!4!30/07/2007-06:45:15:: Schedule fea0a7b7-ec44-48d5-b380-8cc9b580c014 execution completed at 30/07/2007 6:45:15 AM.
ReportingServicesService!dbpolling!4!30/07/2007-06:45:15:: EventPolling finished processing item ab67e733-3c49-4f83-aa28-6543b11e195e
ReportingServicesService!dbpolling!4!30/07/2007-06:45:15:: EventPolling processing item 31117bb3-19b7-4922-a163-eb7f5ff88595
ReportingServicesService!dbpolling!f!30/07/2007-06:45:15:: NotificationPolling processing 1 more items. 8 Total items in internal queue.
ReportingServicesService!library!3!30/07/2007-06:45:16:: Schedule 93b027f8-c3d7-4ce2-ba74-b79b9f325128 executed at 30/07/2007 6:45:16 AM.
ReportingServicesService!schedule!3!30/07/2007-06:45:16:: Creating Time based subscription notification for subscription: 1eb20739-e545-49bc-aac0-850fedbe16f8
ReportingServicesService!library!3!30/07/2007-06:45:16:: Schedule 93b027f8-c3d7-4ce2-ba74-b79b9f325128 execution completed at 30/07/2007 6:45:16 AM.
ReportingServicesService!dbpolling!3!30/07/2007-06:45:16:: EventPolling finished processing item 41e22d56-128c-4438-af66-6e844490cfe9
ReportingServicesService!dbpolling!3!30/07/2007-06:45:16:: NotificationPolling processing item 22975d35-7e62-4b73-8c04-16df5ee2bffc
ReportingServicesService!library!4!30/07/2007-06:45:16:: Schedule 11b01c6c-094e-4b5a-a03b-d22ad0716d72 executed at 30/07/2007 6:45:16 AM.
ReportingServicesService!schedule!4!30/07/2007-06:45:16:: Creating Time based subscription notification for subscription: 01d87a0b-42a0-4a74-8d53-b1ee90070a8c
ReportingServicesService!library!4!30/07/2007-06:45:17:: Schedule 11b01c6c-094e-4b5a-a03b-d22ad0716d72 execution completed at 30/07/2007 6:45:17 AM.
ReportingServicesService!dbpolling!4!30/07/2007-06:45:17:: EventPolling finished processing item 31117bb3-19b7-4922-a163-eb7f5ff88595
ReportingServicesService!dbpolling!4!30/07/2007-06:45:17:: NotificationPolling processing item a539c19a-85ef-45a4-81dd-c4feec40d4f0
ReportingServicesService!dbpolling!8!30/07/2007-06:45:19:: NotificationPolling processing item 8b45ef2f-6c07-4fb0-8e21-bf26777235f9
ReportingServicesService!dbpolling!15!30/07/2007-06:45:20:: NotificationPolling processing item ae4be8ff-1745-4082-8cf4-f940e1aab74b
ReportingServicesService!library!8!07/30/2007-06:45:26:: i INFO: Call to RenderFirst( '/Hoboken reporting/Management - Week Sales' )
ReportingServicesService!library!15!07/30/2007-06:45:27:: i INFO: Call to RenderFirst( '/Hoboken reporting/Management - Customer - Shops YTD' )
ReportingServicesService!library!3!07/30/2007-06:45:27:: i INFO: Call to RenderFirst( '/Hoboken reporting/Management - Customer - Shops MTD' )
ReportingServicesService!library!4!07/30/2007-06:45:27:: i INFO: Call to RenderFirst( '/Hoboken reporting/Management - Store Sales' )
ReportingServicesService!runningjobs!15!7/30/2007-06:45:28:: w WARN: Thread pool pressure. Using current thread for a work item.
ReportingServicesService!runningjobs!3!7/30/2007-06:45:29:: w WARN: Thread pool pressure. Using current thread for a work item.
ReportingServicesService!runningjobs!4!7/30/2007-06:45:31:: w WARN: Thread pool pressure. Using current thread for a work item.
ReportingServicesService!runningjobs!12!30/07/2007-06:45:45:: i INFO: Adding: 2 running jobs to the database
ReportingServicesService!runningjobs!8!07/30/2007-06:46:00:: w WARN: Thread pool pressure. Using current thread for a work item.
ReportingServicesService!library!8!07/30/2007-06:46:02:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!8!07/30/2007-06:46:02:: Email successfully sent to "fleflot" <fleflot>, "adevlieger" <adevlieger>
ReportingServicesService!dbpolling!f!30/07/2007-06:46:02:: NotificationPolling processing 1 more items. 8 Total items in internal queue.
ReportingServicesService!dbpolling!d!30/07/2007-06:46:02:: NotificationPolling processing item 8171f870-6f65-498a-aa22-fc36826ccb03
ReportingServicesService!notification!8!07/30/2007-06:46:02:: Notification 8b45ef2f-6c07-4fb0-8e21-bf26777235f9 completed. Success: True, Status: Mail sent to fleflot;adevlieger, DeliveryExtension: Report Server Email, Report: Management - Week Sales, Attempt 0
ReportingServicesService!dbpolling!8!07/30/2007-06:46:03:: NotificationPolling finished processing item 8b45ef2f-6c07-4fb0-8e21-bf26777235f9
ReportingServicesService!library!d!07/30/2007-06:46:04:: i INFO: Call to RenderFirst( '/Hoboken reporting/Management - LFL Item Sales' )
ReportingServicesService!runningjobs!d!7/30/2007-06:46:08:: w WARN: Thread pool pressure. Using current thread for a work item.
ReportingServicesService!runningjobs!e!07/30/2007-06:46:25:: w WARN: Thread pool pressure. Using current thread for a work item.
ReportingServicesService!library!e!07/30/2007-06:46:27:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!e!07/30/2007-06:46:28:: Email successfully sent to "fleflot" <fleflot>, "adevlieger" <adevlieger>
ReportingServicesService!notification!e!07/30/2007-06:46:28:: Notification 60b74c12-bb7f-48c8-b6cc-8288f920669b completed. Success: True, Status: Mail sent to fleflot;adevlieger, DeliveryExtension: Report Server Email, Report: Management - Week Day Sales, Attempt 0
ReportingServicesService!dbpolling!e!07/30/2007-06:46:28:: NotificationPolling finished processing item 60b74c12-bb7f-48c8-b6cc-8288f920669b
ReportingServicesService!dbpolling!f!30/07/2007-06:46:29:: NotificationPolling processing 1 more items. 8 Total items in internal queue.
ReportingServicesService!dbpolling!18!30/07/2007-06:46:29:: NotificationPolling processing item bb196cf0-f334-40f0-8d45-7b7cb6aa2d27
ReportingServicesService!library!18!07/30/2007-06:46:30:: i INFO: Call to RenderFirst( '/Hoboken reporting/Management - LFL Item Sales Week Comparison' )
ReportingServicesService!runningjobs!19!30/07/2007-06:46:45:: i INFO: Adding: 4 running jobs to the database
ReportingServicesService!runningjobs!1c!30/07/2007-06:47:48:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!runningjobs!3!07/30/2007-06:49:52:: w WARN: Thread pool pressure. Using current thread for a work item.
ReportingServicesService!library!3!07/30/2007-06:49:53:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!3!07/30/2007-06:49:54:: Email successfully sent to "fleflot" <fleflot>, "adevlieger" <adevlieger>
ReportingServicesService!notification!3!07/30/2007-06:49:54:: Notification 22975d35-7e62-4b73-8c04-16df5ee2bffc completed. Success: True, Status: Mail sent to fleflot;adevlieger, DeliveryExtension: Report Server Email, Report: Management - Customer - Shops MTD, Attempt 0
ReportingServicesService!dbpolling!3!07/30/2007-06:49:54:: NotificationPolling finished processing item 22975d35-7e62-4b73-8c04-16df5ee2bffc
ReportingServicesService!runningjobs!18!07/30/2007-06:50:48:: w WARN: Thread pool pressure. Using current thread for a work item.
ReportingServicesService!library!18!07/30/2007-06:50:49:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!18!07/30/2007-06:50:50:: Email successfully sent to "fleflot" <fleflot>, "adevlieger" <adevlieger>
ReportingServicesService!notification!18!07/30/2007-06:50:50:: Notification bb196cf0-f334-40f0-8d45-7b7cb6aa2d27 completed. Success: True, Status: Mail sent to fleflot;adevlieger, DeliveryExtension: Report Server Email, Report: Management - LFL Item Sales Week Comparison, Attempt 0
ReportingServicesService!dbpolling!18!07/30/2007-06:50:50:: NotificationPolling finished processing item bb196cf0-f334-40f0-8d45-7b7cb6aa2d27
ReportingServicesService!runningjobs!4!7/30/2007-06:50:52:: w WARN: Thread pool pressure. Using current thread for a work item.
ReportingServicesService!library!18!30/07/2007-06:53:39:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!15!07/30/2007-06:54:41:: w WARN: Thread pool pressure. Using current thread for a work item.
ReportingServicesService!library!15!07/30/2007-06:54:42:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!15!07/30/2007-06:54:42:: Email successfully sent to "fleflot" <fleflot>, "adevlieger" <adevlieger>
ReportingServicesService!notification!15!07/30/2007-06:54:42:: Notification ae4be8ff-1745-4082-8cf4-f940e1aab74b completed. Success: True, Status: Mail sent to fleflot;adevlieger, DeliveryExtension: Report Server Email, Report: Management - Customer - Shops YTD, Attempt 0
ReportingServicesService!dbpolling!15!07/30/2007-06:54:42:: NotificationPolling finished processing item ae4be8ff-1745-4082-8cf4-f940e1aab74b
ReportingServicesService!library!4!07/30/2007-06:54:45:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!4!07/30/2007-06:54:45:: Email successfully sent to "fleflot" <fleflot>, "adevlieger" <adevlieger>
ReportingServicesService!notification!4!07/30/2007-06:54:45:: Notification a539c19a-85ef-45a4-81dd-c4feec40d4f0 completed. Success: True, Status: Mail sent to fleflot;adevlieger, DeliveryExtension: Report Server Email, Report: Management - Store Sales, Attempt 0
ReportingServicesService!dbpolling!4!07/30/2007-06:54:45:: NotificationPolling finished processing item a539c19a-85ef-45a4-81dd-c4feec40d4f0
ReportingServicesService!processing!17!30/07/2007-06:55:59:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 55., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 55.
ReportingServicesService!processing!17!30/07/2007-06:55:59:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 56., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 56.
ReportingServicesService!processing!17!30/07/2007-06:55:59:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 57., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 57.
ReportingServicesService!library!17!07/30/2007-06:56:22:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!17!07/30/2007-06:56:27:: Email successfully sent to "fleflot" <fleflot>, "gtorrekens" <gtorrekens>, "fsteen" <fsteen>, "plathouwers" <plathouwers>, "adevlieger" <adevlieger>, "clathouwers" <clathouwers>, "dneyt" <dneyt>, "hgoethals" <hgoethals>, "pmelsen" <pmelsen>, "vvandeghinste" <vvandeghinste>, "efernandez" <efernandez>, "elathouwers" <elathouwers>, "mjespers" <mjespers>, "kvanlooveren" <kvanlooveren>, "jvandevloed" <jvandevloed>, "ngielis" <ngielis>, "dbertens" <dbertens>, "pdebodt" <pdebodt>, "asamyn" <asamyn>, "kvanlooveren" <kvanlooveren>, "kantonissen" <kantonissen>, "bdebeuckelaer" <bdebeuckelaer>
ReportingServicesService!notification!17!07/30/2007-06:56:27:: Notification d326abd9-1aea-4317-8f5a-e39d39af96f8 completed. Success: True, Status: Mail sent to fleflot;gtorrekens;fsteen;plathouwers;adevlieger;clathouwers;dneyt;hgoethals;pmelsen;vvandeghinste;efernandez;elathouwers;mjespers;kvanlooveren;jvandevloed;ngielis;dbertens;pdebodt;asamyn; kvanlooveren;kantonissen;bdebeuckelaer, DeliveryExtension: Report Server Email, Report: Management - Weekly figures, Attempt 0
ReportingServicesService!dbpolling!17!07/30/2007-06:56:27:: NotificationPolling finished processing item d326abd9-1aea-4317-8f5a-e39d39af96f8
ReportingServicesService!library!d!07/30/2007-06:56:38:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!d!07/30/2007-06:56:39:: Email successfully sent to "fleflot" <fleflot>, "adevlieger" <adevlieger>
ReportingServicesService!notification!d!07/30/2007-06:56:39:: Notification 8171f870-6f65-498a-aa22-fc36826ccb03 completed. Success: True, Status: Mail sent to fleflot;adevlieger, DeliveryExtension: Report Server Email, Report: Management - LFL Item Sales, Attempt 0
ReportingServicesService!dbpolling!d!07/30/2007-06:56:39:: NotificationPolling finished processing item 8171f870-6f65-498a-aa22-fc36826ccb03
ReportingServicesService!runningjobs!17!30/07/2007-07:00:45:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!processing!a!7/30/2007-07:00:45:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the data set ADS., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the data set ADS. ---> System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
Operation cancelled by user.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at Microsoft.ReportingServices.DataExtensions.DataReaderWrapper.Read()
at Microsoft.ReportingServices.DataExtensions.MappingDataReader.GetNextRow()
--- End of inner exception stack trace ---
ReportingServicesService!processing!a!7/30/2007-07:00:45:: e ERROR: An exception has occurred in data source 'ADS'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the data set ADS. ---> System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
Operation cancelled by user.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at Microsoft.ReportingServices.DataExtensions.DataReaderWrapper.Read()
at Microsoft.ReportingServices.DataExtensions.MappingDataReader.GetNextRow()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.DataExtensions.MappingDataReader.GetNextRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.GetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassGetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPass()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
ReportingServicesService!processing!a!7/30/2007-07:00:45:: i INFO: Merge abort handler called for ID=5. Aborting data sources ...
ReportingServicesService!processing!a!7/30/2007-07:00:45:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the data set ADS. ---> System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
Operation cancelled by user.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at Microsoft.ReportingServices.DataExtensions.DataReaderWrapper.Read()
at Microsoft.ReportingServices.DataExtensions.MappingDataReader.GetNextRow()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.DataExtensions.MappingDataReader.GetNextRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.GetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassGetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPass()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
ReportingServicesService!processing!a!7/30/2007-07:00:45:: w WARN: Data source 'ADS': Report processing has been aborted.
ReportingServicesService!processing!a!7/30/2007-07:00:45:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the data set ADS. ---> System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
Operation cancelled by user.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at Microsoft.ReportingServices.DataExtensions.DataReaderWrapper.Read()
at Microsoft.ReportingServices.DataExtensions.MappingDataReader.GetNextRow()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.DataExtensions.MappingDataReader.GetNextRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.GetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassGetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPass()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
ReportingServicesService!runningjobs!17!30/07/2007-07:01:45:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!runningjobs!17!30/07/2007-07:01:45:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!runningjobs!17!30/07/2007-07:02:45:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!library!17!30/07/2007-07:03:39:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!17!30/07/2007-07:03:45:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!runningjobs!17!30/07/2007-07:03:45:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!runningjobs!17!30/07/2007-07:04:45:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!runningjobs!4!30/07/2007-07:05:45:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!runningjobs!17!30/07/2007-07:06:45:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!runningjobs!17!30/07/2007-07:07:45:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!runningjobs!4!30/07/2007-07:08:45:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!runningjobs!17!30/07/2007-07:09:45:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!runningjobs!4!30/07/2007-07:10:45:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!runningjobs!4!30/07/2007-07:11:45:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!runningjobs!17!30/07/2007-07:11:45:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!runningjobs!17!30/07/2007-07:12:45:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!library!c!07/30/2007-07:13:05:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!c!07/30/2007-07:13:05:: Email successfully sent to "fleflot" <fleflot>, "adevlieger" <adevlieger>
ReportingServicesService!notification!c!07/30/2007-07:13:05:: Notification 5cc98d6d-b9ce-4224-9491-ab7e9e48db64 completed. Success: True, Status: Mail sent to fleflot;adevlieger, DeliveryExtension: Report Server Email, Report: Management - Weekly Monday LFL, Attempt 0
ReportingServicesService!dbpolling!c!07/30/2007-07:13:05:: NotificationPolling finished processing item 5cc98d6d-b9ce-4224-9491-ab7e9e48db64
ReportingServicesService!library!17!30/07/2007-07:13:39:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!4!30/07/2007-07:13:45:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!runningjobs!4!30/07/2007-07:13:45:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!runningjobs!17!30/07/2007-07:14:45:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!runningjobs!c!30/07/2007-07:15:45:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!runningjobs!17!30/07/2007-07:16:45:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!runningjobs!17!30/07/2007-07:17:45:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!library!a!07/30/2007-07:17:50:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!a!07/30/2007-07:17:54:: Email successfully sent to "fleflot" <fleflot>, "gtorrekens" <gtorrekens>, "fsteen" <fsteen>, "plathouwers" <plathouwers>, "adevlieger" <adevlieger>, "clathouwers" <clathouwers>, "dneyt" <dneyt>, "hgoethals" <hgoethals>, "pmelsen" <pmelsen>, "vvandeghinste" <vvandeghinste>, "efernandez" <efernandez>, "elathouwers" <elathouwers>, "kvanlooveren" <kvanlooveren>, "jvandevloed" <jvandevloed>, "ngielis" <ngielis>, "dbertens" <dbertens>, "pdebodt" <pdebodt>, "asamyn" <asamyn>, "kvanlooveren" <kvanlooveren>, "kantonissen" <kantonissen>, "bdebeuckelaer" <bdebeuckelaer>, "tsomers" <tsomers>
ReportingServicesService!notification!a!07/30/2007-07:17:54:: Notification 14264f1d-67d0-4c83-8a19-183f4a378f0c completed. Success: True, Status: Mail sent to fleflot;gtorrekens;fsteen;plathouwers;adevlieger;clathouwers;dneyt;hgoethals;pmelsen;vvandeghinste;efernandez;elathouwers;kvanlooveren;jvandevloed;ngielis;dbertens;pdebodt;asamyn;kvanlooveren;kantonissen;bdebeuckelaer;tsomers, DeliveryExtension: Report Server Email, Report: Management - Daily figures, Attempt 0
ReportingServicesService!dbpolling!a!07/30/2007-07:17:54:: NotificationPolling finished processing item 14264f1d-67d0-4c83-8a19-183f4a378f0c
ReportingServicesService!library!c!30/07/2007-07:23:41:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 1 snapshots, 11 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!library!17!30/07/2007-07:33:39:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!library!a!30/07/2007-07:43:39:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!library!4!30/07/2007-07:53:39:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!dbpolling!f!30/07/2007-08:00:01:: EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!4!30/07/2007-08:00:01:: EventPolling processing item 895aceff-4189-4b7b-aa38-e0d89e92808e
ReportingServicesService!library!4!30/07/2007-08:00:02:: Schedule 7b0425f1-af00-40a1-a24a-31bf469858cd executed at 30/07/2007 8:00:02 AM.
ReportingServicesService!schedule!4!30/07/2007-08:00:02:: Creating Time based subscription notification for subscription: 4da91aec-d5af-4e72-b241-9c944487694b
ReportingServicesService!library!4!30/07/2007-08:00:02:: Schedule 7b0425f1-af00-40a1-a24a-31bf469858cd execution completed at 30/07/2007 8:00:02 AM.
ReportingServicesService!dbpolling!4!30/07/2007-08:00:02:: EventPolling finished processing item 895aceff-4189-4b7b-aa38-e0d89e92808e
ReportingServicesService!dbpolling!f!30/07/2007-08:00:02:: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!a!30/07/2007-08:00:02:: NotificationPolling processing item b1b24098-2c0f-4f43-b11d-561dd0457cdf
ReportingServicesService!library!a!07/30/2007-08:00:03:: i INFO: Call to RenderFirst( '/Finance reporting/Finance - Verschillenlijst Omzet Profashionall en ADS' )
ReportingServicesService!runningjobs!4!30/07/2007-08:00:45:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!a!07/30/2007-08:01:00:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!library!a!07/30/2007-08:01:00:: i INFO: Initializing StoredParametersThreshold to '1500' characters as specified in Server system properties.
ReportingServicesService!library!a!07/30/2007-08:01:01:: i INFO: Initializing StoredParametersLifetime to '180' days as specified in Server system properties.
ReportingServicesService!emailextension!a!07/30/2007-08:01:02:: Email successfully sent to "ttock" <ttock>
ReportingServicesService!notification!a!07/30/2007-08:01:02:: Notification b1b24098-2c0f-4f43-b11d-561dd0457cdf completed. Success: True, Status: Mail sent to ttock, DeliveryExtension: Report Server Email, Report: Finance - Verschillenlijst Omzet Profashionall en ADS, Attempt 0
ReportingServicesService!dbpolling!a!07/30/2007-08:01:02:: NotificationPolling finished processing item b1b24098-2c0f-4f43-b11d-561dd0457cdf
ReportingServicesService!library!4!30/07/2007-08:03:39:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!library!4!30/07/2007-08:13:39:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!library!c!30/07/2007-08:23:39:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!library!4!30/07/2007-08:33:39:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!library!17!30/07/2007-08:43:39:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams


tx for any help
regards
Stanja
 
I looked through the log you posted, and I saw some error messages. I don't know if it will help you or not, but I pasted them below:

Code:
There is no data for the field at position 55., ;
There is no data for the field at position 56., ;
There is no data for the field at position 57., ;

Code:
Cannot read the next data row for the data set ADS., ;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top