Home Forums Reporting Services Reporting Services Reporting Services problem with extract Excel RE: Reporting Services problem with extract Excel

  • September 4, 2008 at 5:45 am

    #867043

    David Klug (6/26/2008)

    This is a known issue with SSRS 2005 and earlier; Reporting Services is memory dependent. On very large reports, you are consuming all available RAM and the server is restarting to correct the issue. The prompt for a login while a report generates is an indicator of being disconnected from the report server.

    If you check your error logs, you will most likely find out of memory exceptions. The only way to get around this is to increase the RAM but there is still a limit to how large of a report you'd be able to run.

    Dave

    I am having similar problems where both running reports and exporting reports will cause a prompt to login. Using Task Manager, I checked my servers memory and it shows 4G of 8G available. In my log, I am not getting any errors about low memory. I do not think it is a memory issue.

    After a reboot, the reports will run better but the export to Excel still continues to fail. I have tried exporting to CSV and that works. However, the CSV export has problems because one field is a comment field and if the user typed commas, apostrophes or single quotes the Excel will not import the data correctly.

    Below are the entries from my most recent attempt lot export a report. Any assistance would be greatly appreciated.

    Rob

    w3wp!library!6!09/04/2008-05:15:45:: Call to GetPermissionsAction(/).

    w3wp!library!1!09/04/2008-05:15:45:: Call to GetPropertiesAction(/, PathBased).

    w3wp!library!6!09/04/2008-05:15:45:: Call to GetSystemPermissionsAction().

    w3wp!library!1!09/04/2008-05:15:45:: Call to ListChildrenAction(/, False).

    w3wp!library!1!09/04/2008-05:15:45:: Call to GetSystemPropertiesAction().

    w3wp!library!a!09/04/2008-05:15:45:: Call to GetSystemPropertiesAction().

    w3wp!library!b!09/04/2008-05:16:23:: Call to GetPermissionsAction(/Region - NAR).

    w3wp!library!1!09/04/2008-05:16:23:: Call to GetPropertiesAction(/Region - NAR, PathBased).

    w3wp!library!1!09/04/2008-05:16:23:: Call to GetSystemPermissionsAction().

    w3wp!library!1!09/04/2008-05:16:23:: Call to ListChildrenAction(/Region - NAR, False).

    w3wp!library!6!09/04/2008-05:16:23:: Call to GetSystemPropertiesAction().

    w3wp!library!6!09/04/2008-05:16:23:: Call to GetSystemPropertiesAction().

    w3wp!library!6!09/04/2008-05:16:25:: Call to GetPermissionsAction(/Region - NAR/GSD).

    w3wp!library!b!09/04/2008-05:16:25:: Call to GetPropertiesAction(/Region - NAR/GSD, PathBased).

    w3wp!library!b!09/04/2008-05:16:25:: Call to GetSystemPermissionsAction().

    w3wp!library!b!09/04/2008-05:16:25:: Call to ListChildrenAction(/Region - NAR/GSD, False).

    w3wp!library!6!09/04/2008-05:16:25:: Call to GetSystemPropertiesAction().

    w3wp!library!b!09/04/2008-05:16:25:: Call to GetSystemPropertiesAction().

    w3wp!library!a!09/04/2008-05:16:28:: Call to GetPermissionsAction(/Region - NAR/GSD/Global Operations Report).

    w3wp!library!6!09/04/2008-05:16:28:: Call to GetPropertiesAction(/Region - NAR/GSD/Global Operations Report, PathBased).

    w3wp!library!6!09/04/2008-05:16:28:: Call to GetSystemPermissionsAction().

    w3wp!library!b!09/04/2008-05:16:28:: Call to ListChildrenAction(/Region - NAR/GSD/Global Operations Report, False).

    w3wp!library!6!09/04/2008-05:16:28:: Call to GetSystemPropertiesAction().

    w3wp!library!6!09/04/2008-05:16:28:: Call to GetSystemPropertiesAction().

    w3wp!library!6!09/04/2008-05:16:30:: Call to GetPermissionsAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report).

    w3wp!library!6!09/04/2008-05:16:30:: Call to GetSystemPropertiesAction().

    w3wp!library!6!09/04/2008-05:16:30:: Call to GetPropertiesAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report, PathBased).

    w3wp!library!6!09/04/2008-05:16:30:: Call to GetSystemPermissionsAction().

    w3wp!library!6!09/04/2008-05:16:30:: Call to GetPropertiesAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report, PathBased).

    w3wp!library!6!09/04/2008-05:16:30:: Call to ListEventsAction().

    w3wp!library!1!09/04/2008-05:16:30:: Call to GetSystemPropertiesAction().

    w3wp!library!b!09/04/2008-05:16:55:: Call to GetPermissionsAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report).

    w3wp!library!1!09/04/2008-05:16:55:: Call to GetSystemPropertiesAction().

    w3wp!library!1!09/04/2008-05:16:55:: Call to GetPropertiesAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report, PathBased).

    w3wp!library!b!09/04/2008-05:16:55:: Call to GetSystemPermissionsAction().

    w3wp!library!a!09/04/2008-05:16:55:: Call to GetPropertiesAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report, PathBased).

    w3wp!library!1!09/04/2008-05:16:55:: Call to GetSystemPropertiesAction().

    w3wp!library!a!04/09/2008-05:17:36:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams

    w3wp!library!b!09/04/2008-05:18:25:: Call to GetPermissionsAction(/).

    w3wp!library!b!09/04/2008-05:18:25:: Call to GetPropertiesAction(/, PathBased).

    w3wp!library!b!09/04/2008-05:18:25:: Call to GetSystemPermissionsAction().

    w3wp!library!6!09/04/2008-05:18:25:: Call to ListChildrenAction(/, False).

    w3wp!library!6!09/04/2008-05:18:25:: Call to GetSystemPropertiesAction().

    w3wp!library!1!09/04/2008-05:18:28:: Call to GetPermissionsAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report).

    w3wp!library!6!09/04/2008-05:18:28:: Call to GetSystemPropertiesAction().

    w3wp!library!a!09/04/2008-05:18:28:: Call to GetPropertiesAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report, PathBased).

    w3wp!library!a!09/04/2008-05:18:28:: Call to GetSystemPermissionsAction().

    w3wp!library!6!09/04/2008-05:18:28:: Call to GetPropertiesAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report, PathBased).

    w3wp!library!1!09/04/2008-05:18:28:: Call to GetSystemPropertiesAction().

    w3wp!library!1!09/04/2008-05:18:29:: Call to GetPermissionsAction(/Region - NAR).

    w3wp!library!1!09/04/2008-05:18:29:: Call to GetPropertiesAction(/Region - NAR, PathBased).

    w3wp!library!1!09/04/2008-05:18:29:: Call to GetSystemPermissionsAction().

    w3wp!library!6!09/04/2008-05:18:29:: Call to ListChildrenAction(/Region - NAR, False).

    w3wp!library!6!09/04/2008-05:18:29:: Call to GetSystemPropertiesAction().

    w3wp!library!6!09/04/2008-05:18:31:: Call to GetPermissionsAction(/Region - NAR/CSI).

    w3wp!library!6!09/04/2008-05:18:31:: Call to GetPropertiesAction(/Region - NAR/CSI, PathBased).

    w3wp!library!6!09/04/2008-05:18:31:: Call to GetSystemPermissionsAction().

    w3wp!library!1!09/04/2008-05:18:31:: Call to ListChildrenAction(/Region - NAR/CSI, False).

    w3wp!library!b!09/04/2008-05:18:31:: Call to GetSystemPropertiesAction().

    w3wp!library!1!09/04/2008-05:18:33:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report).

    w3wp!library!1!09/04/2008-05:18:33:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report, PathBased).

    w3wp!library!6!09/04/2008-05:18:33:: Call to GetSystemPermissionsAction().

    w3wp!library!1!09/04/2008-05:18:33:: Call to ListChildrenAction(/Region - NAR/CSI/Global Operations Report, False).

    w3wp!library!6!09/04/2008-05:18:33:: Call to GetSystemPropertiesAction().

    w3wp!library!1!09/04/2008-05:18:52:: Call to GetPermissionsAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report).

    w3wp!library!b!09/04/2008-05:18:52:: Call to GetSystemPropertiesAction().

    w3wp!library!6!09/04/2008-05:18:52:: Call to GetPropertiesAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report, PathBased).

    w3wp!library!1!09/04/2008-05:18:52:: Call to GetSystemPermissionsAction().

    w3wp!library!1!09/04/2008-05:18:52:: Call to GetPropertiesAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report, PathBased).

    w3wp!library!1!09/04/2008-05:18:52:: Call to GetSystemPropertiesAction().

    w3wp!library!1!09/04/2008-05:18:58:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report).

    w3wp!library!1!09/04/2008-05:18:58:: Call to GetSystemPropertiesAction().

    w3wp!library!a!09/04/2008-05:18:58:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report, PathBased).

    w3wp!library!a!09/04/2008-05:18:58:: Call to GetSystemPermissionsAction().

    w3wp!library!a!09/04/2008-05:18:58:: Call to GetSystemPropertiesAction().

    w3wp!library!1!09/04/2008-05:18:59:: i INFO: Call to RenderFirst( '/Region - NAR/GSD/Global Operations Report/Order Summary Report' )

    w3wp!library!b!09/04/2008-05:19:24:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report).

    w3wp!library!b!09/04/2008-05:19:24:: Call to GetSystemPropertiesAction().

    w3wp!library!b!09/04/2008-05:19:24:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report, PathBased).

    w3wp!library!b!09/04/2008-05:19:24:: Call to GetSystemPermissionsAction().

    w3wp!library!b!09/04/2008-05:19:24:: Call to GetSystemPropertiesAction().

    w3wp!runningjobs!a!04/09/2008-05:19:36:: i INFO: Adding: 1 running jobs to the database

    w3wp!library!a!09/04/2008-05:19:42:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report).

    w3wp!library!b!09/04/2008-05:19:42:: Call to GetSystemPropertiesAction().

    w3wp!library!b!09/04/2008-05:19:42:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report, PathBased).

    w3wp!library!a!09/04/2008-05:19:42:: Call to GetSystemPermissionsAction().

    w3wp!library!b!09/04/2008-05:19:42:: Call to GetSystemPropertiesAction().

    w3wp!library!7!09/04/2008-05:19:59:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report).

    w3wp!library!7!09/04/2008-05:19:59:: Call to GetSystemPropertiesAction().

    w3wp!library!7!09/04/2008-05:19:59:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report, PathBased).

    w3wp!library!a!09/04/2008-05:19:59:: Call to GetSystemPermissionsAction().

    w3wp!library!a!09/04/2008-05:19:59:: Call to GetSystemPropertiesAction().

    w3wp!library!7!09/04/2008-05:20:12:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report).

    w3wp!library!7!09/04/2008-05:20:12:: Call to GetSystemPropertiesAction().

    w3wp!library!b!09/04/2008-05:20:12:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report, PathBased).

    w3wp!library!7!09/04/2008-05:20:12:: Call to GetSystemPermissionsAction().

    w3wp!library!7!09/04/2008-05:20:12:: Call to GetSystemPropertiesAction().

    w3wp!library!a!09/04/2008-05:20:17:: i INFO: Call to RenderFirst( '/Region - NAR/CSI/Global Operations Report/Line Item Detail Report' )

    w3wp!webserver!a!09/04/2008-05:21:16:: i INFO: Processed report. Report='/Region - NAR/CSI/Global Operations Report/Line Item Detail Report', Stream=''

    w3wp!webserver!1!09/04/2008-05:21:43:: i INFO: Processed report. Report='/Region - NAR/GSD/Global Operations Report/Order Summary Report', Stream=''

    w3wp!library!6!09/04/2008-05:22:45:: i INFO: Call to RenderNext( '/Region - NAR/CSI/Global Operations Report/Line Item Detail Report' )

    w3wp!library!7!09/04/2008-05:22:50:: i INFO: Call to RenderNext( '/Region - NAR/GSD/Global Operations Report/Order Summary Report' )

    w3wp!runningjobs!b!04/09/2008-05:23:36:: i INFO: Adding: 2 running jobs to the database

    w3wp!cache!6!09/04/2008-05:26:33:: i INFO: Session live: /Region - NAR/CSI/Global Operations Report/Line Item Detail Report

    w3wp!webserver!6!09/04/2008-05:26:33:: i INFO: Processed report. Report='/Region - NAR/CSI/Global Operations Report/Line Item Detail Report', Stream=''

    w3wp!library!6!04/09/2008-05:27:38:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams

    w3wp!library!a!09/04/2008-05:28:21:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report).

    w3wp!library!a!09/04/2008-05:28:21:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report, PathBased).

    w3wp!library!a!09/04/2008-05:28:21:: Call to GetSystemPermissionsAction().

    w3wp!library!a!09/04/2008-05:28:21:: Call to ListChildrenAction(/Region - NAR/CSI/Global Operations Report, False).

    w3wp!library!a!09/04/2008-05:28:21:: Call to GetSystemPropertiesAction().

    w3wp!library!a!09/04/2008-05:28:25:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report).

    w3wp!library!b!09/04/2008-05:28:25:: Call to GetSystemPropertiesAction().

    w3wp!library!b!09/04/2008-05:28:25:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report, PathBased).

    w3wp!library!b!09/04/2008-05:28:25:: Call to GetSystemPermissionsAction().

    w3wp!library!b!09/04/2008-05:28:25:: Call to GetSystemPropertiesAction().

    w3wp!library!b!09/04/2008-05:28:39:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report).

    w3wp!library!b!09/04/2008-05:28:39:: Call to GetSystemPropertiesAction().

    w3wp!library!b!09/04/2008-05:28:39:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report, PathBased).

    w3wp!library!b!09/04/2008-05:28:39:: Call to GetSystemPermissionsAction().

    w3wp!library!a!09/04/2008-05:28:39:: Call to GetSystemPropertiesAction().

    w3wp!library!b!09/04/2008-05:28:51:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report).

    w3wp!library!b!09/04/2008-05:28:51:: Call to GetSystemPropertiesAction().

    w3wp!library!b!09/04/2008-05:28:51:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report, PathBased).

    w3wp!library!b!09/04/2008-05:28:51:: Call to GetSystemPermissionsAction().

    w3wp!library!6!09/04/2008-05:28:51:: Call to GetSystemPropertiesAction().

    w3wp!library!a!09/04/2008-05:29:05:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report).

    w3wp!library!a!09/04/2008-05:29:05:: Call to GetSystemPropertiesAction().

    w3wp!library!a!09/04/2008-05:29:05:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report, PathBased).

    w3wp!library!b!09/04/2008-05:29:05:: Call to GetSystemPermissionsAction().

    w3wp!library!b!09/04/2008-05:29:05:: Call to GetSystemPropertiesAction().

    w3wp!library!b!09/04/2008-05:29:13:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report).

    w3wp!library!6!09/04/2008-05:29:13:: Call to GetSystemPropertiesAction().

    w3wp!library!6!09/04/2008-05:29:13:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report, PathBased).

    w3wp!library!6!09/04/2008-05:29:13:: Call to GetSystemPermissionsAction().

    w3wp!library!b!09/04/2008-05:29:13:: Call to GetSystemPropertiesAction().

    w3wp!library!b!09/04/2008-05:29:21:: i INFO: Call to RenderFirst( '/Region - NAR/CSI/Global Operations Report/Order Summary Report' )

    w3wp!runningjobs!a!04/09/2008-05:30:36:: i INFO: Adding: 1 running jobs to the database

    w3wp!webserver!b!09/04/2008-05:31:50:: i INFO: Processed report. Report='/Region - NAR/CSI/Global Operations Report/Order Summary Report', Stream=''

    w3wp!library!a!09/04/2008-05:32:01:: i INFO: Call to RenderNext( '/Region - NAR/CSI/Global Operations Report/Order Summary Report' )

    w3wp!runningjobs!6!04/09/2008-05:32:36:: i INFO: Adding: 1 running jobs to the database

    w3wp!cache!7!09/04/2008-05:33:14:: i INFO: Session live: /Region - NAR/GSD/Global Operations Report/Order Summary Report

    w3wp!webserver!7!09/04/2008-05:33:14:: i INFO: Processed report. Report='/Region - NAR/GSD/Global Operations Report/Order Summary Report', Stream=''

    w3wp!library!7!09/04/2008-05:33:14:: i INFO: Call to RenderNext( '/Region - NAR/GSD/Global Operations Report/Order Summary Report' )

    w3wp!cache!a!09/04/2008-05:33:26:: i INFO: Session live: /Region - NAR/CSI/Global Operations Report/Order Summary Report

    w3wp!webserver!a!09/04/2008-05:33:26:: i INFO: Processed report. Report='/Region - NAR/CSI/Global Operations Report/Order Summary Report', Stream=''

    w3wp!runningjobs!6!04/09/2008-05:34:36:: i INFO: Adding: 1 running jobs to the database

    w3wp!library!6!04/09/2008-05:37:37:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 1 snapshots, 11 chunks, 0 running jobs, 0 persisted streams