RSExecutionLog_Update.dts fails for named SQL Instance

Hi:
I am running SRS on a named instance of SQL. When I attempt to run this DTS
package, it fails on the five update steps with the error message "Cannot
open database requested in login 'ReportServer'. Login fails."
How can I point it to the non-default instance of SQL.
Thanks in advance.
Bruce.Have you tried changing the server name in the RSExecutionLog_Update.ini
file? I have never used the package with a non-default instance of SQL
server, but I assume it should work when you make the appropriate edits in
the above ini file.
Charles Kangai, MCT, MCDBA
"bwschiek@.hotmail.com" wrote:
> Hi:
> I am running SRS on a named instance of SQL. When I attempt to run this DTS
> package, it fails on the five update steps with the error message "Cannot
> open database requested in login 'ReportServer'. Login fails."
> How can I point it to the non-default instance of SQL.
> Thanks in advance.
> Bruce.|||Hi Charles:
It worked! I changed the server setting for both the source and destination
from (local) to ServerName\SQLInstanceName and the DTS package executed as
intented!
Thanks for the quick and accurate reply!
Bruce.
"Charles Kangai" wrote:
> Have you tried changing the server name in the RSExecutionLog_Update.ini
> file? I have never used the package with a non-default instance of SQL
> server, but I assume it should work when you make the appropriate edits in
> the above ini file.
> Charles Kangai, MCT, MCDBA
> "bwschiek@.hotmail.com" wrote:
> > Hi:
> >
> > I am running SRS on a named instance of SQL. When I attempt to run this DTS
> > package, it fails on the five update steps with the error message "Cannot
> > open database requested in login 'ReportServer'. Login fails."
> >
> > How can I point it to the non-default instance of SQL.
> >
> > Thanks in advance.
> >
> > Bruce.

RS2000 Large report fails to export to Excel

I have large report (200 pages, landscape 14x8.5) that will not export to
Excel.
Last night we scheduled the report to email us the Excel rendered file. The
subscription page shows the following error.
Failure sending mail: Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
We ran the report manually today and tried to export through the Report
Manager and it tries to download a file that is only 1.84K large. When we
click save we get an error.
Does anyone have any idea what I could do get this report to export to Excel?
I've inlcuded the trace log below detailing the why the it would not send
the mail.
ReportingServicesService!dbpolling!1460!5/4/2006-04:00:09:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!14d4!5/4/2006-04:00:09:: EventPolling
processing item 16f10910-40d4-4c9c-a06c-438872d94b26
ReportingServicesService!library!14d4!5/4/2006-04:00:09:: Schedule
446540f1-2ad4-4422-9751-4a98f39d6277 executed at 5/4/2006 4:00:09 AM.
ReportingServicesService!schedule!14d4!5/4/2006-04:00:09:: Creating Time
based subscription notification for subscription:
f804f939-b2ae-48cc-b656-8396e511fbb2
ReportingServicesService!library!14d4!5/4/2006-04:00:09:: Schedule
446540f1-2ad4-4422-9751-4a98f39d6277 execution completed at 5/4/2006 4:00:09
AM.
ReportingServicesService!dbpolling!14d4!5/4/2006-04:00:09:: EventPolling
finished processing item 16f10910-40d4-4c9c-a06c-438872d94b26
ReportingServicesService!dbpolling!1384!05/04/2006-04:00:09::
NotificationPolling processing item e493718d-bcfd-48fb-8420-908baa3f80c4
ReportingServicesService!dbpolling!1460!5/4/2006-04:00:09::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!library!1384!05/04/2006-04:00:13:: i INFO: Call to
RenderFirst( '/PSP Reporting/Resource Management/ResM02 - Allocation Report
By Initiative' )
ReportingServicesService!runningjobs!13e0!5/4/2006-04:01:40:: i INFO:
Adding: 1 running jobs to the database
ReportingServicesService!library!15e4!5/4/2006-04:09:40:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!processing!1384!5/4/2006-04:10:22:: e ERROR: There
is no data for the field at position 17.
ReportingServicesService!processing!1384!5/4/2006-04:10:22:: e ERROR: There
is no data for the field at position 18.
ReportingServicesService!processing!1384!5/4/2006-04:10:22:: e ERROR: There
is no data for the field at position 19.
ReportingServicesService!reportrendering!1384!05/04/2006-04:10:52:: e ERROR:
Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.ArgumentOutOfRangeException: Index was out of range.
Must be non-negative and less than the size of the collection.
Parameter name: index
at System.Collections.ArrayList.get_Item(Int32 index)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.PageTableGrid.get_Item(Int32 row, Int32 col)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderImage(PageTableGrid
pageTableGrid, ReportItemInfo reportItemInfo, PageCell pageCell, Int32 row,
Int32 col, Boolean addHeaderRows)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderGridCell(PageLayout
pageLayout, Int32 row, Int32 col, Hashtable& duplicateItemsTable, Boolean
addHeaderRows)
at
Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer
excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32 minCol,
Int32 maxCol)
at
Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet(ExcelRenderer excelRenderer, Stream stream, Int32 offset)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout pageLayout, Int32& currentPageNumber, Stack& stack)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
lastPageLayout)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime A_0,
GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
ReportingServicesService!library!1384!05/04/2006-04:10:52:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!1384!05/04/2006-04:10:52:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.ArgumentOutOfRangeException: Index was out of range.
Must be non-negative and less than the size of the collection.
Parameter name: index
at System.Collections.ArrayList.get_Item(Int32 index)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.PageTableGrid.get_Item(Int32 row, Int32 col)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderImage(PageTableGrid
pageTableGrid, ReportItemInfo reportItemInfo, PageCell pageCell, Int32 row,
Int32 col, Boolean addHeaderRows)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderGridCell(PageLayout
pageLayout, Int32 row, Int32 col, Hashtable& duplicateItemsTable, Boolean
addHeaderRows)
at
Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer
excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32 minCol,
Int32 maxCol)
at
Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet(ExcelRenderer excelRenderer, Stream stream, Int32 offset)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout pageLayout, Int32& currentPageNumber, Stack& stack)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
lastPageLayout)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime A_0,
GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime A_0,
GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
ProcessingContext pc, RenderingContext rc)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
reportContext, ItemProperties properties, ParameterInfoCollection
effectiveParameters, Guid reportId, ClientRequest session, String
description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
usedUserProfile)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!1384!05/04/2006-04:10:52::
Notification e493718d-bcfd-48fb-8420-908baa3f80c4 completed. Success: False,
Status: Failure sending mail: Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., DeliveryExtension: Report Server Email, Report: ResM02 - Allocation
Report By Initiative, Attempt 0
ReportingServicesService!dbpolling!1384!05/04/2006-04:10:52::
NotificationPolling finished processing item
e493718d-bcfd-48fb-8420-908baa3f80c4200 pages? AFAIK, Excel can only have about 65000 rows maximum. That could
be the cause of the error, if the report have too many rows of data.
"SBishop" <SBishop@.discussions.microsoft.com> wrote in message
news:68982103-D197-48FF-A23F-D6CAA7527758@.microsoft.com...
>I have large report (200 pages, landscape 14x8.5) that will not export to
> Excel.
> Last night we scheduled the report to email us the Excel rendered file.
> The
> subscription page shows the following error.
> Failure sending mail: Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> We ran the report manually today and tried to export through the Report
> Manager and it tries to download a file that is only 1.84K large. When we
> click save we get an error.
> Does anyone have any idea what I could do get this report to export to
> Excel?
> I've inlcuded the trace log below detailing the why the it would not send
> the mail.
> ReportingServicesService!dbpolling!1460!5/4/2006-04:00:09:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!14d4!5/4/2006-04:00:09:: EventPolling
> processing item 16f10910-40d4-4c9c-a06c-438872d94b26
> ReportingServicesService!library!14d4!5/4/2006-04:00:09:: Schedule
> 446540f1-2ad4-4422-9751-4a98f39d6277 executed at 5/4/2006 4:00:09 AM.
> ReportingServicesService!schedule!14d4!5/4/2006-04:00:09:: Creating Time
> based subscription notification for subscription:
> f804f939-b2ae-48cc-b656-8396e511fbb2
> ReportingServicesService!library!14d4!5/4/2006-04:00:09:: Schedule
> 446540f1-2ad4-4422-9751-4a98f39d6277 execution completed at 5/4/2006
> 4:00:09
> AM.
> ReportingServicesService!dbpolling!14d4!5/4/2006-04:00:09:: EventPolling
> finished processing item 16f10910-40d4-4c9c-a06c-438872d94b26
> ReportingServicesService!dbpolling!1384!05/04/2006-04:00:09::
> NotificationPolling processing item e493718d-bcfd-48fb-8420-908baa3f80c4
> ReportingServicesService!dbpolling!1460!5/4/2006-04:00:09::
> NotificationPolling processing 1 more items. 1 Total items in internal
> queue.
> ReportingServicesService!library!1384!05/04/2006-04:00:13:: i INFO: Call
> to
> RenderFirst( '/PSP Reporting/Resource Management/ResM02 - Allocation
> Report
> By Initiative' )
> ReportingServicesService!runningjobs!13e0!5/4/2006-04:01:40:: i INFO:
> Adding: 1 running jobs to the database
> ReportingServicesService!library!15e4!5/4/2006-04:09:40:: i INFO: Cleaned
> 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!processing!1384!5/4/2006-04:10:22:: e ERROR:
> There
> is no data for the field at position 17.
> ReportingServicesService!processing!1384!5/4/2006-04:10:22:: e ERROR:
> There
> is no data for the field at position 18.
> ReportingServicesService!processing!1384!5/4/2006-04:10:22:: e ERROR:
> There
> is no data for the field at position 19.
> ReportingServicesService!reportrendering!1384!05/04/2006-04:10:52:: e
> ERROR:
> Throwing
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown., ;
> Info:
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. --> System.ArgumentOutOfRangeException: Index was out of range.
> Must be non-negative and less than the size of the collection.
> Parameter name: index
> at System.Collections.ArrayList.get_Item(Int32 index)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.PageTableGrid.get_Item(Int32
> row, Int32 col)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderImage(PageTableGrid
> pageTableGrid, ReportItemInfo reportItemInfo, PageCell pageCell, Int32
> row,
> Int32 col, Boolean addHeaderRows)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderGridCell(PageLayout
> pageLayout, Int32 row, Int32 col, Hashtable& duplicateItemsTable, Boolean
> addHeaderRows)
> at
> Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer
> excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32
> minCol,
> Int32 maxCol)
> at
> Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet(ExcelRenderer
> excelRenderer, Stream stream, Int32 offset)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout
> pageLayout, Int32& currentPageNumber, Stack& stack)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
> pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
> lastPageLayout)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream
> createAndRegisterStream)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream
> createAndRegisterStream)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
> A_0,
> GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
> CreateReportChunk A_4, Boolean& A_5)
> -- End of inner exception stack trace --
> ReportingServicesService!library!1384!05/04/2006-04:10:52:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
> system
> properties.
> ReportingServicesService!emailextension!1384!05/04/2006-04:10:52:: Error
> sending email.
> Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. -->
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. --> System.ArgumentOutOfRangeException: Index was out of range.
> Must be non-negative and less than the size of the collection.
> Parameter name: index
> at System.Collections.ArrayList.get_Item(Int32 index)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.PageTableGrid.get_Item(Int32
> row, Int32 col)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderImage(PageTableGrid
> pageTableGrid, ReportItemInfo reportItemInfo, PageCell pageCell, Int32
> row,
> Int32 col, Boolean addHeaderRows)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderGridCell(PageLayout
> pageLayout, Int32 row, Int32 col, Hashtable& duplicateItemsTable, Boolean
> addHeaderRows)
> at
> Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer
> excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32
> minCol,
> Int32 maxCol)
> at
> Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet(ExcelRenderer
> excelRenderer, Stream stream, Int32 offset)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout
> pageLayout, Int32& currentPageNumber, Stack& stack)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
> pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
> lastPageLayout)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream
> createAndRegisterStream)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream
> createAndRegisterStream)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
> A_0,
> GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
> CreateReportChunk A_4, Boolean& A_5)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
> A_0,
> GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
> CreateReportChunk A_4, Boolean& A_5)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
> executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
> ProcessingContext pc, RenderingContext rc)
> at
> Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
> reportContext, ItemProperties properties, ParameterInfoCollection
> effectiveParameters, Guid reportId, ClientRequest session, String
> description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
> thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
> ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
> RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
> usedUserProfile)
> at
> Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> at
> Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]&
> secondaryStreamNames)
> at
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> at
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> at
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
> rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> renderFormat, String deviceInfo)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage
> message, Notification notification, SubscriptionData data)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification
> notification)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification
> notification)
> ReportingServicesService!notification!1384!05/04/2006-04:10:52::
> Notification e493718d-bcfd-48fb-8420-908baa3f80c4 completed. Success:
> False,
> Status: Failure sending mail: Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown., DeliveryExtension: Report Server Email, Report: ResM02 -
> Allocation
> Report By Initiative, Attempt 0
> ReportingServicesService!dbpolling!1384!05/04/2006-04:10:52::
> NotificationPolling finished processing item
> e493718d-bcfd-48fb-8420-908baa3f80c4
>

rs.CreateReport() with overwrite set to true fails to update report description

When calling the RS SOAP API's CreateReport method, it doesn't seem like the report description is updated, unless I first delete the report and then recreate it.

Here's what my call looks like -
Warning[] warnings = rs.CreateReport(reportName, "/" + folder, true, buffer, null);

Is this a known issue?

Try

Dim descprop As New [Property]
desc.Name = "Description"
desc.Value = "Now is the time for all good men to come to the aid of their country."

rs.CreateReport(reportName, "/" + folder, true, buffer, desc);

Note, this is Visual Basic, you will need to convert it to your language C#

Ham

|||

Hello Arjun B,

I'm having the same problem as you described in your post.

Were you able to find a solution? If so, what were you able to do?

Thanks!

|||lmttag - try hammer's suggestion. worked for me!|||

Thanks for the reply. I tried the suggestion. However, it still didn't work.

Here's the situation... We have a report that has been deployed to production a few weeks ago. Since then the report has changed slightly; two parameters have changed--one parameter went from not being marked internal to being marked internal and the other parameter's default value changed (just a simple string change).

Now we want to programmatically deploy the updated report to production and overwrite the existing report. However, when we try this, the parameters, as shown through Report Manger, have not changed. They're the same as the original deployment. And, there is no error/exception thrown that might be causing the problem.

Here's the code snippet:

System.Byte[] definition = null;
ReportingService2005.Warning[] warnings = null;
ReportingService2005.Property property = new ReportingService2005.Property();
property.Name = "Description";
property.Value = "Updated Report Description";
ReportingService2005.Property[] properties = new ReportingService2005.Property[1];
properties[0] = property;

string name = (string)dr["Name"]; // Variable that holds the name
string file = (string)dr["FullName"]; // Variable that holds the file

System.IO.FileStream stream = System.IO.File.OpenRead(file);
definition = new System.Byte[stream.Length];
stream.Read(definition, 0, (int)stream.Length);
stream.Close();

//warnings = rs.CreateReport(name, parent, true, definition, null);
warnings = rs.CreateReport(name, parent, true, definition, properties);

Any help is greatly appreciated. Thanks!

|||

Sorry for so many post, but does it have to be the Description property? We have descriptions built into the reports, and, if we change the description property in code to get the CreateReport() method to work, then we'll lose the correct description for the report. And, we would rather not hard-code descriptions in our application that is trying to overwrite the report.

Thanks again.

rs.CreateReport() with overwrite set to true fails to update report description

When calling the RS SOAP API's CreateReport method, it doesn't seem like the report description is updated, unless I first delete the report and then recreate it.

Here's what my call looks like -
Warning[] warnings = rs.CreateReport(reportName, "/" + folder, true, buffer, null);

Is this a known issue?

Try

Dim descprop As New [Property]
desc.Name = "Description"
desc.Value = "Now is the time for all good men to come to the aid of their country."

rs.CreateReport(reportName, "/" + folder, true, buffer, desc);

Note, this is Visual Basic, you will need to convert it to your language C#

Ham

|||

Hello Arjun B,

I'm having the same problem as you described in your post.

Were you able to find a solution? If so, what were you able to do?

Thanks!

|||lmttag - try hammer's suggestion. worked for me!|||

Thanks for the reply. I tried the suggestion. However, it still didn't work.

Here's the situation... We have a report that has been deployed to production a few weeks ago. Since then the report has changed slightly; two parameters have changed--one parameter went from not being marked internal to being marked internal and the other parameter's default value changed (just a simple string change).

Now we want to programmatically deploy the updated report to production and overwrite the existing report. However, when we try this, the parameters, as shown through Report Manger, have not changed. They're the same as the original deployment. And, there is no error/exception thrown that might be causing the problem.

Here's the code snippet:

System.Byte[] definition = null;
ReportingService2005.Warning[] warnings = null;
ReportingService2005.Property property = new ReportingService2005.Property();
property.Name = "Description";
property.Value = "Updated Report Description";
ReportingService2005.Property[] properties = new ReportingService2005.Property[1];
properties[0] = property;

string name = (string)dr["Name"]; // Variable that holds the name
string file = (string)dr["FullName"]; // Variable that holds the file

System.IO.FileStream stream = System.IO.File.OpenRead(file);
definition = new System.Byte[stream.Length];
stream.Read(definition, 0, (int)stream.Length);
stream.Close();

//warnings = rs.CreateReport(name, parent, true, definition, null);
warnings = rs.CreateReport(name, parent, true, definition, properties);

Any help is greatly appreciated. Thanks!

|||

Sorry for so many post, but does it have to be the Description property? We have descriptions built into the reports, and, if we change the description property in code to get the CreateReport() method to work, then we'll lose the correct description for the report. And, we would rather not hard-code descriptions in our application that is trying to overwrite the report.

Thanks again.

RS Install fails with HRESULT: 2147942405

I previously had RS installed and working fine. Recently I tried to access
the local reporting server instance on my development machine and noticed
that it wasn't working. One thing led to another and I ended up uninstalling
RS and then found that I couldn't re-install it. The end of the "RS Setup
Bootstrap" log file shows the following:
---
WorkDir=D:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
ScuProgressDlg::SetupFinished()
ScuProgressDlg::DialogProc() installation done... waiting for setup mgr
SCU_SetupMgr::svc() finished. SetupMgr: state=FINISHED, cancel_state=0,
is_done=1, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=D:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
QuietMode=false
Unattended=false
WorkDir=D:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:420}
<EndFunc Name='UpdateComponents' Return='0' GetLastError='0'>
<Func Name='DwLaunchMsiExec'>
<Func Name='PerformDetections'>
0
Failed to find property in cache: InstalledInstances
Failed to perform discovery on machine: JCHORLTON4
HRESULT: 2147942405
<EndFunc Name='PerformDetections' Return='2' GetLastError='183'>
<Func Name='FSetupLogging'>
<Func Name='CreateSetupLogCabs'>
Creating Setup Logs Cab "C:\Program Files\Microsoft SQL Server\80\RS Setup
Bootstrap\LOG\RSStp_.cab"
---
I found a similar bug article
(http://support.microsoft.com/default.aspx?scid=kb;en-us;897020) but this
doesn't seem to affect my install.
I currently have SQL 2000 Developer installed and running under the system
account and there are no traces of previous RS installs that I can find on my
system but the Reporting Services install still fails right after it installs
the "Setup Support Files". Has anyone else seen this?Has anyone seen this problem? I've done everything to my machine that I can
think of and nothing seems to cure it. I talked to MS support and they have
records of similar problems but the only cure they have is to rebuild the
entire machine. This is not my preferred cure since this machine is a dev
machine and will take several days to rebuild. We've also had this happen to
another machine here so this can't be that uncommon.
The weird thing is that SQL Server 2000 and MSDE both install with no
problems it's just the Reporting Services install that craps out. I'm
thinking that this is just another one of Microsoft's poorly written installs
that corrupts Windows somehow.

RS Install fails on Win2003

Hi gang,
Heres the problem: When I try to run the setup for Reporting Services it
fails near the end, stating the following:
Product: Microsoft SQL Server 2000 Reporting Services Standard Edition --
Error 29581. SQL Setup failed to execute a command for server configuration.
The error was: Database 'ReportServerDB' does not exist. Check sysdatabases.
Refer to the Server error logs and setup logs for detailed error information.
SETUP:
Windows Server 2003 Std. Ed., running ASP.NET and IIS.. This is the server
Im trying to install RS to. Im unsure which service pack this server is
running; it doesnt say anything just version 5.2 build 3790
Windows 2000 with SP4, running MSSQL 2000 Std. Ed. with SP4, this is the
server that I want to store the data on.
I have tried a couple of different settings to connect to the database; I
tried using the NT Authority\ Network service, the local machine acct, and
lately the administrator acct, but I still get the same error.
I would be thankful for any suggestions..
Take care,
ChristianSetup uses the user running setup to create the databases, make sure this
use is a dbo on your sql server. For some reason the database is not being
created, one thing we have seen before is if there is no default location
for DB's then setup will fail, so check to see if there is a default
directory for new databases.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"farastray" <farastray@.discussions.microsoft.com> wrote in message
news:9AA86980-D98C-48A6-A58C-4EF5458F4381@.microsoft.com...
> Hi gang,
> Heres the problem: When I try to run the setup for Reporting Services it
> fails near the end, stating the following:
> Product: Microsoft SQL Server 2000 Reporting Services Standard Edition --
> Error 29581. SQL Setup failed to execute a command for server
> configuration.
> The error was: Database 'ReportServerDB' does not exist. Check
> sysdatabases.
> Refer to the Server error logs and setup logs for detailed error
> information.
> SETUP:
> Windows Server 2003 Std. Ed., running ASP.NET and IIS.. This is the server
> Im trying to install RS to. Im unsure which service pack this server is
> running; it doesnt say anything just version 5.2 build 3790
> Windows 2000 with SP4, running MSSQL 2000 Std. Ed. with SP4, this is the
> server that I want to store the data on.
> I have tried a couple of different settings to connect to the database; I
> tried using the NT Authority\ Network service, the local machine acct, and
> lately the administrator acct, but I still get the same error.
> I would be thankful for any suggestions..
> Take care,
> Christian|||Ok... still no luck.
I created a new user, gave him every single right you can possibly have, and
made him database owner of all databases.
I also went in under my database server's properties (in SQL Ent Mgr) and
specified a default database directory.
I tried loging in with different users, (both sql users, local/domain users)
but it is still giving me the same error: Database 'Report Server' does not
exist.
Does anyone else know how to solve this'
"Daniel Reib (MSFT)" wrote:
> Setup uses the user running setup to create the databases, make sure this
> use is a dbo on your sql server. For some reason the database is not being
> created, one thing we have seen before is if there is no default location
> for DB's then setup will fail, so check to see if there is a default
> directory for new databases.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "farastray" <farastray@.discussions.microsoft.com> wrote in message
> news:9AA86980-D98C-48A6-A58C-4EF5458F4381@.microsoft.com...
> > Hi gang,
> >
> > Heres the problem: When I try to run the setup for Reporting Services it
> > fails near the end, stating the following:
> >
> > Product: Microsoft SQL Server 2000 Reporting Services Standard Edition --
> > Error 29581. SQL Setup failed to execute a command for server
> > configuration.
> > The error was: Database 'ReportServerDB' does not exist. Check
> > sysdatabases.
> > Refer to the Server error logs and setup logs for detailed error
> > information.
> >
> > SETUP:
> >
> > Windows Server 2003 Std. Ed., running ASP.NET and IIS.. This is the server
> > Im trying to install RS to. Im unsure which service pack this server is
> > running; it doesnt say anything just version 5.2 build 3790
> >
> > Windows 2000 with SP4, running MSSQL 2000 Std. Ed. with SP4, this is the
> > server that I want to store the data on.
> >
> > I have tried a couple of different settings to connect to the database; I
> > tried using the NT Authority\ Network service, the local machine acct, and
> > lately the administrator acct, but I still get the same error.
> >
> > I would be thankful for any suggestions..
> >
> > Take care,
> >
> > Christian
>
>|||You say you tried logging in as different users. Do you mean you entered
these in one of the RS setup dialogs? If so then that is not correct.
Setup uses the user that is running setup to create the databases. That is
the currently logged in windows user. If you want to use SQL Auth during
setup there are some command line parameters that you can use to make setup
use SQL Auth during setup. Look in the template.ini file for the
RSSETUPACCOUNT and RSSETUPPASSWORD parameters.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"farastray" <farastray@.discussions.microsoft.com> wrote in message
news:4560E92E-792B-4BE4-A405-88037601CE37@.microsoft.com...
> Ok... still no luck.
> I created a new user, gave him every single right you can possibly have,
> and
> made him database owner of all databases.
> I also went in under my database server's properties (in SQL Ent Mgr) and
> specified a default database directory.
> I tried loging in with different users, (both sql users, local/domain
> users)
> but it is still giving me the same error: Database 'Report Server' does
> not
> exist.
> Does anyone else know how to solve this'
> "Daniel Reib (MSFT)" wrote:
>> Setup uses the user running setup to create the databases, make sure this
>> use is a dbo on your sql server. For some reason the database is not
>> being
>> created, one thing we have seen before is if there is no default location
>> for DB's then setup will fail, so check to see if there is a default
>> directory for new databases.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "farastray" <farastray@.discussions.microsoft.com> wrote in message
>> news:9AA86980-D98C-48A6-A58C-4EF5458F4381@.microsoft.com...
>> > Hi gang,
>> >
>> > Heres the problem: When I try to run the setup for Reporting Services
>> > it
>> > fails near the end, stating the following:
>> >
>> > Product: Microsoft SQL Server 2000 Reporting Services Standard
>> > Edition --
>> > Error 29581. SQL Setup failed to execute a command for server
>> > configuration.
>> > The error was: Database 'ReportServerDB' does not exist. Check
>> > sysdatabases.
>> > Refer to the Server error logs and setup logs for detailed error
>> > information.
>> >
>> > SETUP:
>> >
>> > Windows Server 2003 Std. Ed., running ASP.NET and IIS.. This is the
>> > server
>> > Im trying to install RS to. Im unsure which service pack this server is
>> > running; it doesnt say anything just version 5.2 build 3790
>> >
>> > Windows 2000 with SP4, running MSSQL 2000 Std. Ed. with SP4, this is
>> > the
>> > server that I want to store the data on.
>> >
>> > I have tried a couple of different settings to connect to the database;
>> > I
>> > tried using the NT Authority\ Network service, the local machine acct,
>> > and
>> > lately the administrator acct, but I still get the same error.
>> >
>> > I would be thankful for any suggestions..
>> >
>> > Take care,
>> >
>> > Christian
>>|||What I meant by different users is that I tried both different SQL users
(when using SQL authentiaction), as well as trying different domain users..
"Daniel Reib (MSFT)" wrote:
> You say you tried logging in as different users. Do you mean you entered
> these in one of the RS setup dialogs? If so then that is not correct.
> Setup uses the user that is running setup to create the databases. That is
> the currently logged in windows user. If you want to use SQL Auth during
> setup there are some command line parameters that you can use to make setup
> use SQL Auth during setup. Look in the template.ini file for the
> RSSETUPACCOUNT and RSSETUPPASSWORD parameters.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "farastray" <farastray@.discussions.microsoft.com> wrote in message
> news:4560E92E-792B-4BE4-A405-88037601CE37@.microsoft.com...
> > Ok... still no luck.
> >
> > I created a new user, gave him every single right you can possibly have,
> > and
> > made him database owner of all databases.
> >
> > I also went in under my database server's properties (in SQL Ent Mgr) and
> > specified a default database directory.
> >
> > I tried loging in with different users, (both sql users, local/domain
> > users)
> > but it is still giving me the same error: Database 'Report Server' does
> > not
> > exist.
> >
> > Does anyone else know how to solve this'
> >
> > "Daniel Reib (MSFT)" wrote:
> >
> >> Setup uses the user running setup to create the databases, make sure this
> >> use is a dbo on your sql server. For some reason the database is not
> >> being
> >> created, one thing we have seen before is if there is no default location
> >> for DB's then setup will fail, so check to see if there is a default
> >> directory for new databases.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "farastray" <farastray@.discussions.microsoft.com> wrote in message
> >> news:9AA86980-D98C-48A6-A58C-4EF5458F4381@.microsoft.com...
> >> > Hi gang,
> >> >
> >> > Heres the problem: When I try to run the setup for Reporting Services
> >> > it
> >> > fails near the end, stating the following:
> >> >
> >> > Product: Microsoft SQL Server 2000 Reporting Services Standard
> >> > Edition --
> >> > Error 29581. SQL Setup failed to execute a command for server
> >> > configuration.
> >> > The error was: Database 'ReportServerDB' does not exist. Check
> >> > sysdatabases.
> >> > Refer to the Server error logs and setup logs for detailed error
> >> > information.
> >> >
> >> > SETUP:
> >> >
> >> > Windows Server 2003 Std. Ed., running ASP.NET and IIS.. This is the
> >> > server
> >> > Im trying to install RS to. Im unsure which service pack this server is
> >> > running; it doesnt say anything just version 5.2 build 3790
> >> >
> >> > Windows 2000 with SP4, running MSSQL 2000 Std. Ed. with SP4, this is
> >> > the
> >> > server that I want to store the data on.
> >> >
> >> > I have tried a couple of different settings to connect to the database;
> >> > I
> >> > tried using the NT Authority\ Network service, the local machine acct,
> >> > and
> >> > lately the administrator acct, but I still get the same error.
> >> >
> >> > I would be thankful for any suggestions..
> >> >
> >> > Take care,
> >> >
> >> > Christian
> >>
> >>
> >>
>
>|||This maybe a silly question, but how do I pass in the commandline parameters?
I tried using setup.exe -RSSETUPACCOUNT="sa" and -RSSETUPPASSWORD="password"
in the command prompt, but it wont take the parameters.. I tried using single
quotes, space instead of =, and / instead of -.. What am I doing wrong?|||farastray wrote:
> This maybe a silly question, but how do I pass in the commandline parameters?
> I tried using setup.exe -RSSETUPACCOUNT="sa" and -RSSETUPPASSWORD="password"
> in the command prompt, but it wont take the parameters.. I tried using single
> quotes, space instead of =, and / instead of -.. What am I doing wrong?
Don't use anything but the property. msiexec uses PROPERTY=value
setup.exe RSSETUPACCOUNT=sa RSSETUPPASSWORD=password
Joachim.

RS fails to render a report with changes just made

Scenario: Using VS, I deploy a new version of a report (e.g., change some
text) to ReportServer. When I view the report from the web server using a
browser, the report does not show the change.
I tried deleting the report from the server, and re-deploying. The new
report appears in Reports, with the new datatime stamp, but when it renders,
it still renders the OLD version! Eventually, the new report shows up (e.g.,
hours later).
I also tried using a new session of the browser; it makes no difference.
I tried using both server\Reports and server\ReportServer. Same behavior on
both.
I tried setting "report history" on "Site Settings" and on the properties
page of the report to 1 (the lowest permitted number). Same behavior.
I assume some kind of caching at the server level is the cause, requiring a
new setting in the Web.Config or rssrvpolicy.config, but I don't know what
those settings might be.
I am using RS SP2, and have duplicated the behavior on both W2K3, and XP,
and using both IIS5 and IIS6.
Any help will be very much appreciated!"JohnWoll" <JohnWoll@.discussions.microsoft.com> schrieb im Newsbeitrag
news:12A1EE71-64D7-4CD2-9D80-A7CE0CFB846C@.microsoft.com...
> Scenario: Using VS, I deploy a new version of a report (e.g., change some
> text) to ReportServer. When I view the report from the web server using a
> browser, the report does not show the change.
> I tried deleting the report from the server, and re-deploying. The new
> report appears in Reports, with the new datatime stamp, but when it
> renders,
> it still renders the OLD version! Eventually, the new report shows up
> (e.g.,
> hours later).
> I also tried using a new session of the browser; it makes no difference.
> I tried using both server\Reports and server\ReportServer. Same behavior
> on
> both.
> I tried setting "report history" on "Site Settings" and on the properties
> page of the report to 1 (the lowest permitted number). Same behavior.
> I assume some kind of caching at the server level is the cause, requiring
> a
> new setting in the Web.Config or rssrvpolicy.config, but I don't know what
> those settings might be.
> I am using RS SP2, and have duplicated the behavior on both W2K3, and XP,
> and using both IIS5 and IIS6.
> Any help will be very much appreciated!|||Try reloading the site with STRG+F5 in the browser, if this resolves your
issues, this should be a client side vaching problem.
HTH, Jens SUessmeyer.
--
http://www.sqlserver2005.de
--
"JohnWoll" <JohnWoll@.discussions.microsoft.com> schrieb im Newsbeitrag
news:12A1EE71-64D7-4CD2-9D80-A7CE0CFB846C@.microsoft.com...
> Scenario: Using VS, I deploy a new version of a report (e.g., change some
> text) to ReportServer. When I view the report from the web server using a
> browser, the report does not show the change.
> I tried deleting the report from the server, and re-deploying. The new
> report appears in Reports, with the new datatime stamp, but when it
> renders,
> it still renders the OLD version! Eventually, the new report shows up
> (e.g.,
> hours later).
> I also tried using a new session of the browser; it makes no difference.
> I tried using both server\Reports and server\ReportServer. Same behavior
> on
> both.
> I tried setting "report history" on "Site Settings" and on the properties
> page of the report to 1 (the lowest permitted number). Same behavior.
> I assume some kind of caching at the server level is the cause, requiring
> a
> new setting in the Web.Config or rssrvpolicy.config, but I don't know what
> those settings might be.
> I am using RS SP2, and have duplicated the behavior on both W2K3, and XP,
> and using both IIS5 and IIS6.
> Any help will be very much appreciated!|||I think I have eliminated client side issues as the reason.
Please explain what you mean by "Try reloading the site with STRG+F5 in the
browser", maybe an example.
Thanks for the helping!
"Jens Sü�meyer" wrote:
> Try reloading the site with STRG+F5 in the browser, if this resolves your
> issues, this should be a client side vaching problem.
> HTH, Jens SUessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "JohnWoll" <JohnWoll@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:12A1EE71-64D7-4CD2-9D80-A7CE0CFB846C@.microsoft.com...
> > Scenario: Using VS, I deploy a new version of a report (e.g., change some
> > text) to ReportServer. When I view the report from the web server using a
> > browser, the report does not show the change.
> >
> > I tried deleting the report from the server, and re-deploying. The new
> > report appears in Reports, with the new datatime stamp, but when it
> > renders,
> > it still renders the OLD version! Eventually, the new report shows up
> > (e.g.,
> > hours later).
> >
> > I also tried using a new session of the browser; it makes no difference.
> >
> > I tried using both server\Reports and server\ReportServer. Same behavior
> > on
> > both.
> >
> > I tried setting "report history" on "Site Settings" and on the properties
> > page of the report to 1 (the lowest permitted number). Same behavior.
> >
> > I assume some kind of caching at the server level is the cause, requiring
> > a
> > new setting in the Web.Config or rssrvpolicy.config, but I don't know what
> > those settings might be.
> >
> > I am using RS SP2, and have duplicated the behavior on both W2K3, and XP,
> > and using both IIS5 and IIS6.
> >
> > Any help will be very much appreciated!
>
>|||When you say you tried to use a new session of the browser what do you mean?
If you close IE and re-open it you should see the new report. I have never
not seen a new report (however I have not specified any caching). If you
have just taken the defaults when creating a report and have not set any
caching option in Report Manager then if you shut IE and re-open it you
should see the new report. Also, usually if you change the parameters and
run the report you should get the new report. Usually if I click on the
refresh of the report (not the IE refresh, you will also get the new
report).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OrAqjykTFHA.3544@.TK2MSFTNGP12.phx.gbl...
> "JohnWoll" <JohnWoll@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:12A1EE71-64D7-4CD2-9D80-A7CE0CFB846C@.microsoft.com...
>> Scenario: Using VS, I deploy a new version of a report (e.g., change some
>> text) to ReportServer. When I view the report from the web server using a
>> browser, the report does not show the change.
>> I tried deleting the report from the server, and re-deploying. The new
>> report appears in Reports, with the new datatime stamp, but when it
>> renders,
>> it still renders the OLD version! Eventually, the new report shows up
>> (e.g.,
>> hours later).
>> I also tried using a new session of the browser; it makes no difference.
>> I tried using both server\Reports and server\ReportServer. Same behavior
>> on
>> both.
>> I tried setting "report history" on "Site Settings" and on the properties
>> page of the report to 1 (the lowest permitted number). Same behavior.
>> I assume some kind of caching at the server level is the cause, requiring
>> a
>> new setting in the Web.Config or rssrvpolicy.config, but I don't know
>> what
>> those settings might be.
>> I am using RS SP2, and have duplicated the behavior on both W2K3, and XP,
>> and using both IIS5 and IIS6.
>> Any help will be very much appreciated!
>|||In answer to what I mean by using a "new session of the browser": I close MS
Internet Explorer, open it, enter the address for Reports, navigate to the
report and run it.
Here is the exact sequence I use:
-Make a change to a report using VS, e.g., change the value of a text box.
-Rebuild and redploy to ReportServer
-Launch IE, enter the url for Reports, navigate to the report, and the
change I made to the textbox value is not there.
-I delete the report completely, using Reports web interface.
-I rebuild and redploy the report. I close IE, open it again, enter the URL,
navigate to the report (which has a new datetime stamp), and run it. The
change is still missing!
- Changing parameters makes no difference.
- I am not using any caching, that I am aware of.
I appreciate the help. Let me know what you suggest I do next.
"Bruce L-C [MVP]" wrote:
> When you say you tried to use a new session of the browser what do you mean?
> If you close IE and re-open it you should see the new report. I have never
> not seen a new report (however I have not specified any caching). If you
> have just taken the defaults when creating a report and have not set any
> caching option in Report Manager then if you shut IE and re-open it you
> should see the new report. Also, usually if you change the parameters and
> run the report you should get the new report. Usually if I click on the
> refresh of the report (not the IE refresh, you will also get the new
> report).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jens Sü�meyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
> message news:OrAqjykTFHA.3544@.TK2MSFTNGP12.phx.gbl...
> >
> > "JohnWoll" <JohnWoll@.discussions.microsoft.com> schrieb im Newsbeitrag
> > news:12A1EE71-64D7-4CD2-9D80-A7CE0CFB846C@.microsoft.com...
> >> Scenario: Using VS, I deploy a new version of a report (e.g., change some
> >> text) to ReportServer. When I view the report from the web server using a
> >> browser, the report does not show the change.
> >>
> >> I tried deleting the report from the server, and re-deploying. The new
> >> report appears in Reports, with the new datatime stamp, but when it
> >> renders,
> >> it still renders the OLD version! Eventually, the new report shows up
> >> (e.g.,
> >> hours later).
> >>
> >> I also tried using a new session of the browser; it makes no difference.
> >>
> >> I tried using both server\Reports and server\ReportServer. Same behavior
> >> on
> >> both.
> >>
> >> I tried setting "report history" on "Site Settings" and on the properties
> >> page of the report to 1 (the lowest permitted number). Same behavior.
> >>
> >> I assume some kind of caching at the server level is the cause, requiring
> >> a
> >> new setting in the Web.Config or rssrvpolicy.config, but I don't know
> >> what
> >> those settings might be.
> >>
> >> I am using RS SP2, and have duplicated the behavior on both W2K3, and XP,
> >> and using both IIS5 and IIS6.
> >>
> >> Any help will be very much appreciated!
> >
> >
>
>|||I confirmed that only if I do ALL of the following will the change to the
report appear consistently:
1. Delete the report from Report Server.
2. Redploy.
3. Change a parameter.
I can live with that.
Thanks, Bruce, for the suggestion of changing the parameter! I had tried
that, but not WITH deleting and redeploying.
"Bruce L-C [MVP]" wrote:
> When you say you tried to use a new session of the browser what do you mean?
> If you close IE and re-open it you should see the new report. I have never
> not seen a new report (however I have not specified any caching). If you
> have just taken the defaults when creating a report and have not set any
> caching option in Report Manager then if you shut IE and re-open it you
> should see the new report. Also, usually if you change the parameters and
> run the report you should get the new report. Usually if I click on the
> refresh of the report (not the IE refresh, you will also get the new
> report).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jens Sü�meyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
> message news:OrAqjykTFHA.3544@.TK2MSFTNGP12.phx.gbl...
> >
> > "JohnWoll" <JohnWoll@.discussions.microsoft.com> schrieb im Newsbeitrag
> > news:12A1EE71-64D7-4CD2-9D80-A7CE0CFB846C@.microsoft.com...
> >> Scenario: Using VS, I deploy a new version of a report (e.g., change some
> >> text) to ReportServer. When I view the report from the web server using a
> >> browser, the report does not show the change.
> >>
> >> I tried deleting the report from the server, and re-deploying. The new
> >> report appears in Reports, with the new datatime stamp, but when it
> >> renders,
> >> it still renders the OLD version! Eventually, the new report shows up
> >> (e.g.,
> >> hours later).
> >>
> >> I also tried using a new session of the browser; it makes no difference.
> >>
> >> I tried using both server\Reports and server\ReportServer. Same behavior
> >> on
> >> both.
> >>
> >> I tried setting "report history" on "Site Settings" and on the properties
> >> page of the report to 1 (the lowest permitted number). Same behavior.
> >>
> >> I assume some kind of caching at the server level is the cause, requiring
> >> a
> >> new setting in the Web.Config or rssrvpolicy.config, but I don't know
> >> what
> >> those settings might be.
> >>
> >> I am using RS SP2, and have duplicated the behavior on both W2K3, and XP,
> >> and using both IIS5 and IIS6.
> >>
> >> Any help will be very much appreciated!
> >
> >
>
>|||You don't have to delete the report. Try just 2 and 3.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
news:81A637BD-D409-4AD6-9C0E-C55E8334A867@.microsoft.com...
>I confirmed that only if I do ALL of the following will the change to the
> report appear consistently:
> 1. Delete the report from Report Server.
> 2. Redploy.
> 3. Change a parameter.
> I can live with that.
> Thanks, Bruce, for the suggestion of changing the parameter! I had tried
> that, but not WITH deleting and redeploying.
> "Bruce L-C [MVP]" wrote:
>> When you say you tried to use a new session of the browser what do you
>> mean?
>> If you close IE and re-open it you should see the new report. I have
>> never
>> not seen a new report (however I have not specified any caching). If you
>> have just taken the defaults when creating a report and have not set any
>> caching option in Report Manager then if you shut IE and re-open it you
>> should see the new report. Also, usually if you change the parameters and
>> run the report you should get the new report. Usually if I click on the
>> refresh of the report (not the IE refresh, you will also get the new
>> report).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
>> in
>> message news:OrAqjykTFHA.3544@.TK2MSFTNGP12.phx.gbl...
>> >
>> > "JohnWoll" <JohnWoll@.discussions.microsoft.com> schrieb im Newsbeitrag
>> > news:12A1EE71-64D7-4CD2-9D80-A7CE0CFB846C@.microsoft.com...
>> >> Scenario: Using VS, I deploy a new version of a report (e.g., change
>> >> some
>> >> text) to ReportServer. When I view the report from the web server
>> >> using a
>> >> browser, the report does not show the change.
>> >>
>> >> I tried deleting the report from the server, and re-deploying. The new
>> >> report appears in Reports, with the new datatime stamp, but when it
>> >> renders,
>> >> it still renders the OLD version! Eventually, the new report shows up
>> >> (e.g.,
>> >> hours later).
>> >>
>> >> I also tried using a new session of the browser; it makes no
>> >> difference.
>> >>
>> >> I tried using both server\Reports and server\ReportServer. Same
>> >> behavior
>> >> on
>> >> both.
>> >>
>> >> I tried setting "report history" on "Site Settings" and on the
>> >> properties
>> >> page of the report to 1 (the lowest permitted number). Same behavior.
>> >>
>> >> I assume some kind of caching at the server level is the cause,
>> >> requiring
>> >> a
>> >> new setting in the Web.Config or rssrvpolicy.config, but I don't know
>> >> what
>> >> those settings might be.
>> >>
>> >> I am using RS SP2, and have duplicated the behavior on both W2K3, and
>> >> XP,
>> >> and using both IIS5 and IIS6.
>> >>
>> >> Any help will be very much appreciated!
>> >
>> >
>>|||As well as checking your I.E. settings for caching, you should also check if
the results are being cached at your proxy server.
"JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
news:045033C0-C950-411C-84B9-934D9FC92F4A@.microsoft.com...
> I think I have eliminated client side issues as the reason.
> Please explain what you mean by "Try reloading the site with STRG+F5 in
the
> browser", maybe an example.
> Thanks for the helping!
> "Jens Süßmeyer" wrote:
> > Try reloading the site with STRG+F5 in the browser, if this resolves
your
> > issues, this should be a client side vaching problem.
> >
> > HTH, Jens SUessmeyer.
> >
> > --
> > http://www.sqlserver2005.de
> > --
> >
> >
> > "JohnWoll" <JohnWoll@.discussions.microsoft.com> schrieb im Newsbeitrag
> > news:12A1EE71-64D7-4CD2-9D80-A7CE0CFB846C@.microsoft.com...
> > > Scenario: Using VS, I deploy a new version of a report (e.g., change
some
> > > text) to ReportServer. When I view the report from the web server
using a
> > > browser, the report does not show the change.
> > >
> > > I tried deleting the report from the server, and re-deploying. The new
> > > report appears in Reports, with the new datatime stamp, but when it
> > > renders,
> > > it still renders the OLD version! Eventually, the new report shows up
> > > (e.g.,
> > > hours later).
> > >
> > > I also tried using a new session of the browser; it makes no
difference.
> > >
> > > I tried using both server\Reports and server\ReportServer. Same
behavior
> > > on
> > > both.
> > >
> > > I tried setting "report history" on "Site Settings" and on the
properties
> > > page of the report to 1 (the lowest permitted number). Same behavior.
> > >
> > > I assume some kind of caching at the server level is the cause,
requiring
> > > a
> > > new setting in the Web.Config or rssrvpolicy.config, but I don't know
what
> > > those settings might be.
> > >
> > > I am using RS SP2, and have duplicated the behavior on both W2K3, and
XP,
> > > and using both IIS5 and IIS6.
> > >
> > > Any help will be very much appreciated!
> >
> >
> >

RS 2005: Subscription fails with Internal error

Hi all,

I have a (for me) strange problem with subscribing reports.

I've setup several reports that I want to create monthly and store to a file share.
In BIDS Preview and deployed to the report server everything works fine.

Each of my reports has an own schedule (they'll be created step by step), export format is Excel, as credentials I use a local user, all parameters are set porperly.
When the time to render the reports has gone, I just see the following behind each subscription:

Failure writing file LIS04 : An internal error occurred on the report

server. See the error log for more details.

The Log file contains the following: (I highlighted what I think to be the key error)

ReportingServicesService!library!4!12/19/2006-10:20:35:: i INFO: Call to RenderFirst( '/CM Reports/LIS04' )
ReportingServicesService!library!e!12/19/2006-10:20:37:: 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!12/19/2006-10:21:22:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties.
ReportingServicesService!library!4!12/19/2006-10:21:22:: i INFO: Initializing SnapshotCompression to 'SQL' as specified in Server system properties.
ReportingServicesService!runningjobs!f!12/19/2006-10:21:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!14!12/19/2006-10:21:37:: 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!1a!12/19/2006-10:22:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!19!12/19/2006-10:22:37:: 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!1b!12/19/2006-10:23:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!1c!12/19/2006-10:23:37:: 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!3!12/19/2006-10:24:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!17!12/19/2006-10:24:37:: 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!12/19/2006-10:25:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!3!12/19/2006-10:25:37:: 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!16!12/19/2006-10:26:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!19!12/19/2006-10:26:37:: 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!18!12/19/2006-10:27:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!13!12/19/2006-10:27:37:: 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!d!12/19/2006-10:28:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!1c!12/19/2006-10:28:37:: 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!1c!12/19/2006-10:29:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!14!12/19/2006-10:29:37:: 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!13!12/19/2006-10:30:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!15!12/19/2006-10:30:37:: 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!1c!12/19/2006-10:31:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!8!12/19/2006-10:31:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!dbpolling!c!12/19/2006-10:32:10:: EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f!12/19/2006-10:32:10:: EventPolling processing item ea730ae6-d1ad-4535-b651-5bdfe4c0339f
ReportingServicesService!library!f!12/19/2006-10:32:10:: Schedule 9587e9db-b005-4f96-ad18-4afc29207481 executed at 12/19/2006 10:32:10 AM.
ReportingServicesService!schedule!f!12/19/2006-10:32:10:: Creating Time based subscription notification for subscription: 2ae5c0ed-9eea-4ca4-8e41-be5cde9f7908
ReportingServicesService!library!f!12/19/2006-10:32:10:: Schedule 9587e9db-b005-4f96-ad18-4afc29207481 execution completed at 12/19/2006 10:32:10 AM.
ReportingServicesService!dbpolling!f!12/19/2006-10:32:10:: EventPolling finished processing item ea730ae6-d1ad-4535-b651-5bdfe4c0339f
ReportingServicesService!dbpolling!c!12/19/2006-10:32:20:: NotificationPolling processing 1 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!13!12/19/2006-10:32:20:: NotificationPolling processing item b216a965-eaa7-4003-b776-4663c19c8d54
ReportingServicesService!library!13!12/19/2006-10:32:21:: i INFO: Call to RenderFirst( '/CM Reports/LIS04' )
ReportingServicesService!library!13!12/19/2006-10:32:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.OverflowException: Arithmetic operation resulted in an overflow.
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper)
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(ClientRequest session, String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
End of inner exception stack trace
ReportingServicesService!runningjobs!17!12/19/2006-10:32:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!15!12/19/2006-10:32:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams

Does anyone have an idea what goes wrong here?

Best regards
Florian
Are you running 64 bit RS? If yes, it looks like a known problem that will be fixed in SP2.