Issue when exporting to excel...

Hi

i am using Reporting Services 2000 in my application, and am getting an error when i attempt to export to excel. the error that i recieve in the popup window is the following,

"Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Object reference not set to an instance of an object. "

i have discovered that this occurs when rendering the two textboxes used in the footer of my report, as when i remove them, the report renders fine. note all other export functions (pdf, csv etc etc) work fine. any help on how to fix this problem would be greatly recieved, the output of the RS log file is as follows

Cheers, Rob.

<Header>
<Product>Microsoft SQL Server Reporting Services Version 8.00.743.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServer__07_10_2006_10_52_29.log</Path>
<SystemName>PE-DEV-10</SystemName>
<OSName>Microsoft Windows NT 5.1.2600.0</OSName>
<OSVersion>5.1.2600.0</OSVersion>
</Header>
aspnet_wp!webserver!1278!10/07/2006-10:52:29:: i INFO: Reporting Web Server started
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
aspnet_wp!library!1278!10/07/2006-10:52:29:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
aspnet_wp!resourceutilities!1278!10/07/2006-10:52:29:: i INFO: Running on 1 physical processors, 2 logical processors
aspnet_wp!resourceutilities!1278!10/07/2006-10:52:29:: i INFO: Reporting Services starting SKU: Developer
aspnet_wp!runningjobs!1278!10/07/2006-10:52:29:: i INFO: Database Cleanup (Web Service) timer enabled: Cycle: 600 seconds
aspnet_wp!runningjobs!1278!10/07/2006-10:52:29:: i INFO: Running Requests Scavenger timer enabled: Cycle: 60 seconds
aspnet_wp!runningjobs!1278!10/07/2006-10:52:29:: i INFO: Running Requests DB timer enabled: Cycle: 60 seconds
aspnet_wp!runningjobs!1278!10/07/2006-10:52:29:: i INFO: Memory stats update timer enabled: Cycle: 60 seconds
aspnet_wp!crypto!1278!07/10/2006-10:52:29:: i INFO: Initializing crypto as user: PE-DEV-10\ASPNET
aspnet_wp!crypto!1278!07/10/2006-10:52:29:: i INFO: Exporting public key
aspnet_wp!crypto!1278!07/10/2006-10:52:29:: i INFO: Performing sku validation
aspnet_wp!crypto!1278!07/10/2006-10:52:29:: i INFO: Importing existing encryption key
aspnet_wp!library!1278!07/10/2006-10:52:33:: i INFO: Initializing ResponseBufferSizeKb to default value of '64' KB because it was not specified in Server system properties.
aspnet_wp!library!1278!07/10/2006-10:52:33:: i INFO: Initializing UseSessionCookies to 'True' as specified in Server system properties.
aspnet_wp!library!1278!07/10/2006-10:52:33:: i INFO: Initializing SqlStreamingBufferSize to default value of '65536' Bytes because it was not specified in Server system properties.
aspnet_wp!library!1278!07/10/2006-10:52:33:: i INFO: Initializing SessionTimeout to '600' second(s) as specified in Server system properties.
aspnet_wp!library!1278!07/10/2006-10:52:33:: i INFO: Call to RenderFirst( '/Reporting Services/Report Billing' )
aspnet_wp!library!1278!07/10/2006-10:52:34:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
aspnet_wp!webserver!1278!07/10/2006-10:52:34:: i INFO: Processed report. Report='/Reporting Services/Report Billing', Stream=''
aspnet_wp!library!1278!07/10/2006-10:52:34:: i INFO: Initializing SessionAccessTimeout to default value of '600' seconds because it was not specified in Server system properties.
aspnet_wp!chunks!12b4!07/10/2006-10:52:34:: i INFO: ### GetReportChunk('C_32_S', Image), chunk was not found! this=235b9d60-9642-4667-be50-5fa972a3010b
aspnet_wp!chunks!1278!07/10/2006-10:52:34:: i INFO: ### GetReportChunk('C_13_S', Image), chunk was not found! this=235b9d60-9642-4667-be50-5fa972a3010b
aspnet_wp!webserver!12b4!07/10/2006-10:52:35:: i INFO: Processed report. Report='/Reporting Services/Report Billing', Stream='C_32_S'
aspnet_wp!webserver!1278!07/10/2006-10:52:35:: i INFO: Processed report. Report='/Reporting Services/Report Billing', Stream='C_13_S'
aspnet_wp!library!12b4!07/10/2006-10:52:39:: i INFO: Call to RenderNext( '/Reporting Services/Report Billing' )
aspnet_wp!chunks!12b4!07/10/2006-10:52:39:: i INFO: ### GetReportChunk('RenderingInfo_EXCEL', Other), chunk was not found! this=235b9d60-9642-4667-be50-5fa972a3010b
aspnet_wp!reportrendering!12b4!07/10/2006-10:52:39:: 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.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.MarkFooterTextboxPosition(ReportItem reportItem, IntList parentIndexPath, Int32 index, Double parentLeft, Double parentTop, IPosArray& xArray, IPosArray& yArray)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreprocessFooterRectangle(ReportItemCollection reportItemsCollection, IntList parentIndexPath, Double parentLeft, Double parentTop, IPosArray& xArray, IPosArray& yArray)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessFooter(PageSection pageFooter)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.EvaluatePageHeaderFooterForLayout(Int32 currentPageNumber, Int32 pageCount, PageReportItems pageRIItems)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated, Boolean hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed, FormulaContext formulaContext, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayout, PageCollection& pageCollection)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReportItemCollection(ReportItemCollection reportItemCollection, ReportItem container, MarkInformation markInfoOfContainer, Boolean ignorePageBreaks, Boolean hasContainerLastPage, Boolean isHeaderBeingProcessed, FormulaContext formulaContextForContainer, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayoutOfContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetFirstPageLayoutOfRectangleOrSubReport(ReportItem reportItem, MarkInformation markInfoOfContainer, MarkInformation parentMarkInfo, ContainerStructure containerStructure, String language, Boolean isHeaderBeingProcessed, PageReportItems& firstPageReportItems, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessPage(Page page, ReportItemCollection riCollection, PageReportItems& firstPageReportItems, Boolean isHeaderBeingProcessed, String language, MarkInformation parentMarkInfo, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer, FormulaContext formulaContext)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated, Boolean hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed, FormulaContext formulaContext, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayout, PageCollection& pageCollection)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReportItemCollection(ReportItemCollection reportItemCollection, ReportItem container, MarkInformation markInfoOfContainer, Boolean ignorePageBreaks, Boolean hasContainerLastPage, Boolean isHeaderBeingProcessed, FormulaContext formulaContextForContainer, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayoutOfContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetFirstPageLayoutOfRectangleOrSubReport(ReportItem reportItem, MarkInformation markInfoOfContainer, MarkInformation parentMarkInfo, ContainerStructure containerStructure, String language, Boolean isHeaderBeingProcessed, PageReportItems& firstPageReportItems, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessPage(Page page, ReportItemCollection riCollection, PageReportItems& firstPageReportItems, Boolean isHeaderBeingProcessed, String language, MarkInformation parentMarkInfo, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer, FormulaContext formulaContext)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated, Boolean hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed, FormulaContext formulaContext, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayout, PageCollection& pageCollection)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReport()
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.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
End of inner exception stack trace
aspnet_wp!webserver!12b4!07/10/2006-10:52:40:: e ERROR: Reporting Services error 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.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.MarkFooterTextboxPosition(ReportItem reportItem, IntList parentIndexPath, Int32 index, Double parentLeft, Double parentTop, IPosArray& xArray, IPosArray& yArray)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreprocessFooterRectangle(ReportItemCollection reportItemsCollection, IntList parentIndexPath, Double parentLeft, Double parentTop, IPosArray& xArray, IPosArray& yArray)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessFooter(PageSection pageFooter)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.EvaluatePageHeaderFooterForLayout(Int32 currentPageNumber, Int32 pageCount, PageReportItems pageRIItems)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated, Boolean hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed, FormulaContext formulaContext, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayout, PageCollection& pageCollection)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReportItemCollection(ReportItemCollection reportItemCollection, ReportItem container, MarkInformation markInfoOfContainer, Boolean ignorePageBreaks, Boolean hasContainerLastPage, Boolean isHeaderBeingProcessed, FormulaContext formulaContextForContainer, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayoutOfContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetFirstPageLayoutOfRectangleOrSubReport(ReportItem reportItem, MarkInformation markInfoOfContainer, MarkInformation parentMarkInfo, ContainerStructure containerStructure, String language, Boolean isHeaderBeingProcessed, PageReportItems& firstPageReportItems, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessPage(Page page, ReportItemCollection riCollection, PageReportItems& firstPageReportItems, Boolean isHeaderBeingProcessed, String language, MarkInformation parentMarkInfo, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer, FormulaContext formulaContext)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated, Boolean hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed, FormulaContext formulaContext, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayout, PageCollection& pageCollection)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReportItemCollection(ReportItemCollection reportItemCollection, ReportItem container, MarkInformation markInfoOfContainer, Boolean ignorePageBreaks, Boolean hasContainerLastPage, Boolean isHeaderBeingProcessed, FormulaContext formulaContextForContainer, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayoutOfContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetFirstPageLayoutOfRectangleOrSubReport(ReportItem reportItem, MarkInformation markInfoOfContainer, MarkInformation parentMarkInfo, ContainerStructure containerStructure, String language, Boolean isHeaderBeingProcessed, PageReportItems& firstPageReportItems, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessPage(Page page, ReportItemCollection riCollection, PageReportItems& firstPageReportItems, Boolean isHeaderBeingProcessed, String language, MarkInformation parentMarkInfo, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer, FormulaContext formulaContext)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated, Boolean hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed, FormulaContext formulaContext, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayout, PageCollection& pageCollection)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReport()
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.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
at Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result)
at Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effecectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
aspnet_wp!library!1278!07/10/2006-10:59:39:: i INFO: Call to RenderFirst( '/Reporting Services/Report Billing' )
aspnet_wp!library!1278!07/10/2006-10:59:39:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
aspnet_wp!webserver!1278!07/10/2006-10:59:39:: i INFO: Processed report. Report='/Reporting Services/Report Billing', Stream=''
aspnet_wp!chunks!12b4!07/10/2006-10:59:39:: i INFO: ### GetReportChunk('C_32_S', Image), chunk was not found! this=5faf81b3-c2da-40ce-9720-8ab5d9a1f35a
aspnet_wp!chunks!1278!07/10/2006-10:59:39:: i INFO: ### GetReportChunk('C_13_S', Image), chunk was not found! this=5faf81b3-c2da-40ce-9720-8ab5d9a1f35a
aspnet_wp!webserver!12b4!07/10/2006-10:59:40:: i INFO: Processed report. Report='/Reporting Services/Report Billing', Stream='C_32_S'
aspnet_wp!webserver!1278!07/10/2006-10:59:40:: i INFO: Processed report. Report='/Reporting Services/Report Billing', Stream='C_13_S'
aspnet_wp!library!12b4!07/10/2006-10:59:41:: i INFO: Call to RenderNext( '/Reporting Services/Report Billing' )
aspnet_wp!chunks!12b4!07/10/2006-10:59:41:: i INFO: ### GetReportChunk('RenderingInfo_EXCEL', Other), chunk was not found! this=5faf81b3-c2da-40ce-9720-8ab5d9a1f35a
aspnet_wp!reportrendering!12b4!07/10/2006-10:59:41:: 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.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.MarkFooterTextboxPosition(ReportItem reportItem, IntList parentIndexPath, Int32 index, Double parentLeft, Double parentTop, IPosArray& xArray, IPosArray& yArray)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreprocessFooterRectangle(ReportItemCollection reportItemsCollection, IntList parentIndexPath, Double parentLeft, Double parentTop, IPosArray& xArray, IPosArray& yArray)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessFooter(PageSection pageFooter)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.EvaluatePageHeaderFooterForLayout(Int32 currentPageNumber, Int32 pageCount, PageReportItems pageRIItems)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated, Boolean hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed, FormulaContext formulaContext, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayout, PageCollection& pageCollection)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReportItemCollection(ReportItemCollection reportItemCollection, ReportItem container, MarkInformation markInfoOfContainer, Boolean ignorePageBreaks, Boolean hasContainerLastPage, Boolean isHeaderBeingProcessed, FormulaContext formulaContextForContainer, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayoutOfContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetFirstPageLayoutOfRectangleOrSubReport(ReportItem reportItem, MarkInformation markInfoOfContainer, MarkInformation parentMarkInfo, ContainerStructure containerStructure, String language, Boolean isHeaderBeingProcessed, PageReportItems& firstPageReportItems, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessPage(Page page, ReportItemCollection riCollection, PageReportItems& firstPageReportItems, Boolean isHeaderBeingProcessed, String language, MarkInformation parentMarkInfo, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer, FormulaContext formulaContext)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated, Boolean hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed, FormulaContext formulaContext, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayout, PageCollection& pageCollection)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReportItemCollection(ReportItemCollection reportItemCollection, ReportItem container, MarkInformation markInfoOfContainer, Boolean ignorePageBreaks, Boolean hasContainerLastPage, Boolean isHeaderBeingProcessed, FormulaContext formulaContextForContainer, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayoutOfContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetFirstPageLayoutOfRectangleOrSubReport(ReportItem reportItem, MarkInformation markInfoOfContainer, MarkInformation parentMarkInfo, ContainerStructure containerStructure, String language, Boolean isHeaderBeingProcessed, PageReportItems& firstPageReportItems, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessPage(Page page, ReportItemCollection riCollection, PageReportItems& firstPageReportItems, Boolean isHeaderBeingProcessed, String language, MarkInformation parentMarkInfo, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer, FormulaContext formulaContext)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated, Boolean hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed, FormulaContext formulaContext, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayout, PageCollection& pageCollection)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReport()
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.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
End of inner exception stack trace
aspnet_wp!webserver!12b4!07/10/2006-10:59:41:: e ERROR: Reporting Services error 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.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.MarkFooterTextboxPosition(ReportItem reportItem, IntList parentIndexPath, Int32 index, Double parentLeft, Double parentTop, IPosArray& xArray, IPosArray& yArray)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreprocessFooterRectangle(ReportItemCollection reportItemsCollection, IntList parentIndexPath, Double parentLeft, Double parentTop, IPosArray& xArray, IPosArray& yArray)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessFooter(PageSection pageFooter)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.EvaluatePageHeaderFooterForLayout(Int32 currentPageNumber, Int32 pageCount, PageReportItems pageRIItems)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated, Boolean hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed, FormulaContext formulaContext, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayout, PageCollection& pageCollection)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReportItemCollection(ReportItemCollection reportItemCollection, ReportItem container, MarkInformation markInfoOfContainer, Boolean ignorePageBreaks, Boolean hasContainerLastPage, Boolean isHeaderBeingProcessed, FormulaContext formulaContextForContainer, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayoutOfContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetFirstPageLayoutOfRectangleOrSubReport(ReportItem reportItem, MarkInformation markInfoOfContainer, MarkInformation parentMarkInfo, ContainerStructure containerStructure, String language, Boolean isHeaderBeingProcessed, PageReportItems& firstPageReportItems, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessPage(Page page, ReportItemCollection riCollection, PageReportItems& firstPageReportItems, Boolean isHeaderBeingProcessed, String language, MarkInformation parentMarkInfo, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer, FormulaContext formulaContext)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated, Boolean hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed, FormulaContext formulaContext, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayout, PageCollection& pageCollection)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReportItemCollection(ReportItemCollection reportItemCollection, ReportItem container, MarkInformation markInfoOfContainer, Boolean ignorePageBreaks, Boolean hasContainerLastPage, Boolean isHeaderBeingProcessed, FormulaContext formulaContextForContainer, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayoutOfContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetFirstPageLayoutOfRectangleOrSubReport(ReportItem reportItem, MarkInformation markInfoOfContainer, MarkInformation parentMarkInfo, ContainerStructure containerStructure, String language, Boolean isHeaderBeingProcessed, PageReportItems& firstPageReportItems, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessPage(Page page, ReportItemCollection riCollection, PageReportItems& firstPageReportItems, Boolean isHeaderBeingProcessed, String language, MarkInformation parentMarkInfo, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer, FormulaContext formulaContext)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated, Boolean hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed, FormulaContext formulaContext, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayout, PageCollection& pageCollection)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReport()
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.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
at Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result)
at Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effecectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
aspnet_wp!library!338!10/07/2006-11:02:29:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5 chunks, 0 running jobs
aspnet_wp!library!54c!07/10/2006-11:08:42:: i INFO: Call to RenderFirst( '/Reporting Services/Report Call Analysis' )
aspnet_wp!processing!338!10/07/2006-11:08:47:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DurationSummaryTextDataSet'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
aspnet_wp!processing!338!10/07/2006-11:08:47:: e ERROR: An exception has occurred in data source 'DurationSummaryTextDataSet'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
aspnet_wp!processing!338!10/07/2006-11:08:47:: e ERROR: An exception has occurred. Trying to abort processing. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
aspnet_wp!processing!338!10/07/2006-11:08:47:: i INFO: Merge abort handler called. Aborting data sources ...
aspnet_wp!processing!338!10/07/2006-11:08:47:: i INFO: Data source 'portfolio_1_specifics': Abort handler called. CanAbort = True.
aspnet_wp!processing!338!10/07/2006-11:08:47:: i INFO: Merge abort handler called. Aborting data sources ...
aspnet_wp!processing!338!10/07/2006-11:08:47:: i INFO: Data source 'portfolio_1_specifics': Abort handler called. CanAbort = True.
aspnet_wp!processing!338!10/07/2006-11:08:47:: i INFO: Merge abort handler called. Aborting data sources ...
aspnet_wp!processing!338!10/07/2006-11:08:47:: i INFO: Data source 'portfolio_1_specifics': Abort handler called. CanAbort = True.
aspnet_wp!processing!338!10/07/2006-11:08:47:: i INFO: Merge abort handler called. Aborting data sources ...
aspnet_wp!processing!338!10/07/2006-11:08:47:: i INFO: Data source 'portfolio_1_specifics': Abort handler called. CanAbort = True.
aspnet_wp!processing!338!10/07/2006-11:08:47:: i INFO: Data set 'DurationSummaryInfoDataSet': Cancelling command.
aspnet_wp!processing!338!10/07/2006-11:08:47:: i INFO: Data set 'DurationSummaryTextDataSet': Cancelling command.
aspnet_wp!dataextension!338!10/07/2006-11:08:47:: w WARN: CommandWrapper.Cancel not called, connection is not valid
aspnet_wp!processing!338!10/07/2006-11:08:47:: i INFO: Abort callback successful.
aspnet_wp!processing!54c!10/07/2006-11:08:47:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DurationSummaryInfoDataSet'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DurationSummaryInfoDataSet'. > System.Data.SqlClient.SqlException: Operation cancelled by user.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
aspnet_wp!processing!54c!10/07/2006-11:08:47:: e ERROR: An exception has occurred in data source 'DurationSummaryInfoDataSet'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DurationSummaryInfoDataSet'. > System.Data.SqlClient.SqlException: Operation cancelled by user.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
aspnet_wp!processing!54c!10/07/2006-11:08:47:: e ERROR: An exception has occurred. Trying to abort processing. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DurationSummaryInfoDataSet'. > System.Data.SqlClient.SqlException: Operation cancelled by user.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
aspnet_wp!processing!54c!10/07/2006-11:08:47:: i INFO: Some other thread has already aborted processing.
aspnet_wp!processing!54c!10/07/2006-11:08:47:: 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: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
End of inner exception stack trace
aspnet_wp!processing!54c!10/07/2006-11:08:47:: e ERROR: Data source 'portfolio_1_specifics': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.b.c()
at Microsoft.ReportingServices.ReportProcessing.z.af()
at Microsoft.ReportingServices.ReportProcessing.s.a()
aspnet_wp!processing!54c!10/07/2006-11:08:47:: w WARN: Data source 'portfolio_1_specifics': Report processing has been aborted.
aspnet_wp!processing!54c!10/07/2006-11:08:47:: 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: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
End of inner exception stack trace
aspnet_wp!processing!54c!10/07/2006-11:08:47:: e ERROR: An error has occurred while processing a sub-report. Details: An error has occurred during report processing.
aspnet_wp!processing!54c!10/07/2006-11:08:47:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.b.c()
at Microsoft.ReportingServices.ReportProcessing.z.af()
at Microsoft.ReportingServices.ReportProcessing.bb.a(ParameterInfoCollection A_0, Boolean A_1, GetReportChunk A_2)
at Microsoft.ReportingServices.ReportProcessing.a9.a(SubReport A_0, z A_1, Int32 A_2)
aspnet_wp!processing!54c!10/07/2006-11:08:48:: 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: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
End of inner exception stack trace
aspnet_wp!processing!54c!10/07/2006-11:08:48:: w WARN: Data source 'portfolio_1_specifics': Report processing has been aborted.
aspnet_wp!processing!54c!10/07/2006-11:08:48:: 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: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
End of inner exception stack trace
aspnet_wp!processing!54c!10/07/2006-11:08:48:: e ERROR: An error has occurred while processing a sub-report. Details: An error has occurred during report processing.
aspnet_wp!processing!54c!10/07/2006-11:08:48:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.b.c()
at Microsoft.ReportingServices.ReportProcessing.z.af()
at Microsoft.ReportingServices.ReportProcessing.bb.a(ParameterInfoCollection A_0, Boolean A_1, GetReportChunk A_2)
at Microsoft.ReportingServices.ReportProcessing.a9.a(SubReport A_0, z A_1, Int32 A_2)
aspnet_wp!processing!54c!10/07/2006-11:08:48:: 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: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
End of inner exception stack trace
aspnet_wp!processing!54c!10/07/2006-11:08:48:: w WARN: Data source 'portfolio_1_specifics': Report processing has been aborted.
aspnet_wp!processing!54c!10/07/2006-11:08:48:: 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: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
End of inner exception stack trace
aspnet_wp!processing!54c!10/07/2006-11:08:48:: e ERROR: An error has occurred while processing a sub-report. Details: An error has occurred during report processing.
aspnet_wp!processing!54c!10/07/2006-11:08:48:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.b.c()
at Microsoft.ReportingServices.ReportProcessing.z.af()
at Microsoft.ReportingServices.ReportProcessing.bb.a(ParameterInfoCollection A_0, Boolean A_1, GetReportChunk A_2)
at Microsoft.ReportingServices.ReportProcessing.a9.a(SubReport A_0, z A_1, Int32 A_2)
aspnet_wp!processing!54c!10/07/2006-11:08:48:: 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: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
End of inner exception stack trace
aspnet_wp!processing!54c!10/07/2006-11:08:48:: w WARN: Data source 'portfolio_1_specifics': Report processing has been aborted.
aspnet_wp!processing!54c!10/07/2006-11:08:48:: 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: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
End of inner exception stack trace
aspnet_wp!processing!54c!10/07/2006-11:08:48:: e ERROR: An error has occurred while processing a sub-report. Details: An error has occurred during report processing.
aspnet_wp!processing!54c!10/07/2006-11:08:48:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.b.c()
at Microsoft.ReportingServices.ReportProcessing.z.af()
at Microsoft.ReportingServices.ReportProcessing.bb.a(ParameterInfoCollection A_0, Boolean A_1, GetReportChunk A_2)
at Microsoft.ReportingServices.ReportProcessing.a9.a(SubReport A_0, z A_1, Int32 A_2)
aspnet_wp!processing!54c!10/07/2006-11:08:48:: 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: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
End of inner exception stack trace
aspnet_wp!processing!54c!10/07/2006-11:08:48:: w WARN: Data source 'portfolio_1_specifics': Report processing has been aborted.
aspnet_wp!processing!54c!10/07/2006-11:08:48:: 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: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
End of inner exception stack trace
aspnet_wp!processing!54c!10/07/2006-11:08:48:: e ERROR: An error has occurred while processing a sub-report. Details: An error has occurred during report processing.
aspnet_wp!processing!54c!10/07/2006-11:08:48:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.b.c()
at Microsoft.ReportingServices.ReportProcessing.z.af()
at Microsoft.ReportingServices.ReportProcessing.bb.a(ParameterInfoCollection A_0, Boolean A_1, GetReportChunk A_2)
at Microsoft.ReportingServices.ReportProcessing.a9.a(SubReport A_0, z A_1, Int32 A_2)
aspnet_wp!processing!54c!10/07/2006-11:08:48:: 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: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
End of inner exception stack trace
aspnet_wp!processing!54c!10/07/2006-11:08:48:: w WARN: Data source 'portfolio_1_specifics': Report processing has been aborted.
aspnet_wp!processing!54c!10/07/2006-11:08:48:: 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: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
End of inner exception stack trace
aspnet_wp!processing!54c!10/07/2006-11:08:48:: e ERROR: An error has occurred while processing a sub-report. Details: An error has occurred during report processing.
aspnet_wp!processing!54c!10/07/2006-11:08:48:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.b.c()
at Microsoft.ReportingServices.ReportProcessing.z.af()
at Microsoft.ReportingServices.ReportProcessing.bb.a(ParameterInfoCollection A_0, Boolean A_1, GetReportChunk A_2)
at Microsoft.ReportingServices.ReportProcessing.a9.a(SubReport A_0, z A_1, Int32 A_2)
aspnet_wp!processing!54c!10/07/2006-11:08:48:: 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: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
End of inner exception stack trace
aspnet_wp!processing!54c!10/07/2006-11:08:48:: w WARN: Data source 'portfolio_1_specifics': Report processing has been aborted.
aspnet_wp!processing!54c!10/07/2006-11:08:48:: 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: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
End of inner exception stack trace
aspnet_wp!processing!54c!10/07/2006-11:08:48:: e ERROR: An error has occurred while processing a sub-report. Details: An error has occurred during report processing.
aspnet_wp!processing!54c!10/07/2006-11:08:48:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.b.c()
at Microsoft.ReportingServices.ReportProcessing.z.af()
at Microsoft.ReportingServices.ReportProcessing.bb.a(ParameterInfoCollection A_0, Boolean A_1, GetReportChunk A_2)
at Microsoft.ReportingServices.ReportProcessing.a9.a(SubReport A_0, z A_1, Int32 A_2)
aspnet_wp!processing!54c!10/07/2006-11:08:48:: 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: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
End of inner exception stack trace
aspnet_wp!processing!54c!10/07/2006-11:08:48:: w WARN: Data source 'portfolio_1_specifics': Report processing has been aborted.
aspnet_wp!processing!54c!10/07/2006-11:08:48:: 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: Query execution failed for data set 'DurationSummaryTextDataSet'. > System.Data.SqlClient.SqlException: The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.a2.v()
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.a2.v()
at Microsoft.ReportingServices.ReportProcessing.ax.c()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.ax.b()
at Microsoft.ReportingServices.ReportProcessing.a2.a(Object A_0)
End of inner exception stack trace
aspnet_wp!processing!54c!10/07/2006-11:08:48:: e ERROR: An error has occurred while processing a sub-report. Details: An error has occurred during report processing.
aspnet_wp!processing!54c!10/07/2006-11:08:48:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.b.c()
at Microsoft.ReportingServices.ReportProcessing.z.af()
at Microsoft.ReportingServices.ReportProcessing.bb.a(ParameterInfoCollection A_0, Boolean A_1, GetReportChunk A_2)
at Microsoft.ReportingServices.ReportProcessing.a9.a(SubReport A_0, z A_1, Int32 A_2)
aspnet_wp!library!54c!07/10/2006-11:08:48:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
aspnet_wp!webserver!54c!07/10/2006-11:08:48:: i INFO: Processed report. Report='/Reporting Services/Report Call Analysis', Stream=''
aspnet_wp!chunks!1278!07/10/2006-11:08:48:: i INFO: ### GetReportChunk('C_35_S', Image), chunk was not found! this=f40dd283-f8da-494f-97f7-117acd8bbb74
aspnet_wp!chunks!54c!07/10/2006-11:08:48:: i INFO: ### GetReportChunk('C_14_S', Image), chunk was not found! this=f40dd283-f8da-494f-97f7-117acd8bbb74
aspnet_wp!webserver!1278!07/10/2006-11:08:48:: i INFO: Processed report. Report='/Reporting Services/Report Call Analysis', Stream='C_35_S'
aspnet_wp!webserver!54c!07/10/2006-11:08:48:: i INFO: Processed report. Report='/Reporting Services/Report Call Analysis', Stream='C_14_S'
aspnet_wp!library!1278!07/10/2006-11:08:51:: i INFO: Call to RenderNext( '/Reporting Services/Report Call Analysis' )
aspnet_wp!chunks!1278!07/10/2006-11:08:51:: i INFO: ### GetReportChunk('RenderingInfo_EXCEL', Other), chunk was not found! this=f40dd283-f8da-494f-97f7-117acd8bbb74
aspnet_wp!reportrendering!1278!07/10/2006-11:08:51:: 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.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.MarkFooterTextboxPosition(ReportItem reportItem, IntList parentIndexPath, Int32 index, Double parentLeft, Double parentTop, IPosArray& xArray, IPosArray& yArray)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreprocessFooterRectangle(ReportItemCollection reportItemsCollection, IntList parentIndexPath, Double parentLeft, Double parentTop, IPosArray& xArray, IPosArray& yArray)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessFooter(PageSection pageFooter)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.EvaluatePageHeaderFooterForLayout(Int32 currentPageNumber, Int32 pageCount, PageReportItems pageRIItems)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated, Boolean hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed, FormulaContext formulaContext, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayout, PageCollection& pageCollection)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReportItemCollection(ReportItemCollection reportItemCollection, ReportItem container, MarkInformation markInfoOfContainer, Boolean ignorePageBreaks, Boolean hasContainerLastPage, Boolean isHeaderBeingProcessed, FormulaContext formulaContextForContainer, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayoutOfContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetFirstPageLayoutOfRectangleOrSubReport(ReportItem reportItem, MarkInformation markInfoOfContainer, MarkInformation parentMarkInfo, ContainerStructure containerStructure, String language, Boolean isHeaderBeingProcessed, PageReportItems& firstPageReportItems, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessPage(Page page, ReportItemCollection riCollection, PageReportItems& firstPageReportItems, Boolean isHeaderBeingProcessed, String language, MarkInformation parentMarkInfo, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer, FormulaContext formulaContext)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated, Boolean hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed, FormulaContext formulaContext, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayout, PageCollection& pageCollection)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReportItemCollection(ReportItemCollection reportItemCollection, ReportItem container, MarkInformation markInfoOfContainer, Boolean ignorePageBreaks, Boolean hasContainerLastPage, Boolean isHeaderBeingProcessed, FormulaContext formulaContextForContainer, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayoutOfContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetFirstPageLayoutOfRectangleOrSubReport(ReportItem reportItem, MarkInformation markInfoOfContainer, MarkInformation parentMarkInfo, ContainerStructure containerStructure, String language, Boolean isHeaderBeingProcessed, PageReportItems& firstPageReportItems, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessPage(Page page, ReportItemCollection riCollection, PageReportItems& firstPageReportItems, Boolean isHeaderBeingProcessed, String language, MarkInformation parentMarkInfo, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer, FormulaContext formulaContext)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated, Boolean hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed, FormulaContext formulaContext, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayout, PageCollection& pageCollection)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReport()
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.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
End of inner exception stack trace
aspnet_wp!webserver!1278!07/10/2006-11:08:51:: e ERROR: Reporting Services error 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.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.MarkFooterTextboxPosition(ReportItem reportItem, IntList parentIndexPath, Int32 index, Double parentLeft, Double parentTop, IPosArray& xArray, IPosArray& yArray)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreprocessFooterRectangle(ReportItemCollection reportItemsCollection, IntList parentIndexPath, Double parentLeft, Double parentTop, IPosArray& xArray, IPosArray& yArray)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessFooter(PageSection pageFooter)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.EvaluatePageHeaderFooterForLayout(Int32 currentPageNumber, Int32 pageCount, PageReportItems pageRIItems)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated, Boolean hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed, FormulaContext formulaContext, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayout, PageCollection& pageCollection)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReportItemCollection(ReportItemCollection reportItemCollection, ReportItem container, MarkInformation markInfoOfContainer, Boolean ignorePageBreaks, Boolean hasContainerLastPage, Boolean isHeaderBeingProcessed, FormulaContext formulaContextForContainer, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayoutOfContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetFirstPageLayoutOfRectangleOrSubReport(ReportItem reportItem, MarkInformation markInfoOfContainer, MarkInformation parentMarkInfo, ContainerStructure containerStructure, String language, Boolean isHeaderBeingProcessed, PageReportItems& firstPageReportItems, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessPage(Page page, ReportItemCollection riCollection, PageReportItems& firstPageReportItems, Boolean isHeaderBeingProcessed, String language, MarkInformation parentMarkInfo, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer, FormulaContext formulaContext)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated, Boolean hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed, FormulaContext formulaContext, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayout, PageCollection& pageCollection)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReportItemCollection(ReportItemCollection reportItemCollection, ReportItem container, MarkInformation markInfoOfContainer, Boolean ignorePageBreaks, Boolean hasContainerLastPage, Boolean isHeaderBeingProcessed, FormulaContext formulaContextForContainer, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayoutOfContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetFirstPageLayoutOfRectangleOrSubReport(ReportItem reportItem, MarkInformation markInfoOfContainer, MarkInformation parentMarkInfo, ContainerStructure containerStructure, String language, Boolean isHeaderBeingProcessed, PageReportItems& firstPageReportItems, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessPage(Page page, ReportItemCollection riCollection, PageReportItems& firstPageReportItems, Boolean isHeaderBeingProcessed, String language, MarkInformation parentMarkInfo, ArrayList& unresNamesInRIInfo, Hashtable& namesInContainer, FormulaContext formulaContext)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated, Boolean hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed, FormulaContext formulaContext, String language, PageReportItems& firstPageReportItems, PageLayout& firstPageLayout, PageCollection& pageCollection)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReport()
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.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
at Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result)
at Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effecectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()

Is there anything special about the textboxes in the footer? Do they contain just plain text, or is there any sort of conditional formatting, formula values, report parameter values, etc?

|||

the contents of the textboxes are dynamic, but nothing too fancy though, one displays the page number and contains the following

="Page " & Globals!PageNumber & " of " & Globals!TotalPages

the other contains a refernce number and the date the report was generated, and contains the following

="Generated at " + Format(Globals!ExecutionTime, "HH:mm:ss") + " on " + Format(Globals!ExecutionTime, "dddd, d MMMM yyyy") & CHR(13) & CHR(10) & "Ref: " + FORMAT(Parameters!ReportingRequestId.Value)

Cheers

|||I reckon your tempdb has ran out of space.|||

im not sure if it is the tempdb, as it fails when processing two of the styles for the two footer textboxes, if i remove the TextAlign, and ALL of the Padding values for bothof the textboxes then it will export to excel fine, if i just remove one of the styles for either of the textboxes then its still fails, but i need to be able to set these styles and still have the export facility........

any ideas?

|||

im still stuck with this issue, does anyone have any ideas on how to solve this?

cheers

Rob

Issue when exporting to Excel

Hello

I have created a SRS report which I export to Excel.
I have noticed that Excel has added additional columns and the data appears to be overlapping. (link to screenshot below).

When I attempt to create a pivot table from this data, I receive the error:
"The pivot table name is not valid. To create a pivot table report, you must
use data that is organized as a list with labelled columns. If you are changing the name of a pivot table field, you must type a new name for the field.

What have I done wrong?

http://www.adlibsoftware.com/KATHY/excel_output.bmp

I think the problem is related to merged cells.

When exporting, the Excel renderer tries to recreate the report visually as closely as possible. To arrange the various bits of your reports it often needs to merge cells.

I've been battling with this for a while and haven't found a foolproof way of dealing with it. Try to align and size your heading so that it lines up with the table cells. That should minize the amount of cell merging it does.

Issue using the JDBC driver to connect to a remote server

Hi All,

We have a customer in Japan who's using our tool to connect to their SQL Server. Our application runs on a Linux machine and uses the MSSQL JDBC driver for connectivity.

We're getting errors back that are not-decipherable because, I presume, they're in Japanese, and then our logs don't log them in Unicode, so they get flattened out as question marks. The errors come out looking something like this:

Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]? 'MSSQL'

?

SQL State: HY000

SQL Code: 4060

[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]? 'sa' ?

SQL State: 28000

SQL Code: 18456

[Microsoft][SQLServer 2000 Driver for JDBC]An error occured while attempting to

log onto the database.

SQL State: 08001

SQL Code: 0

I think we could troubleshoot the problem if we could only read the errors coming back. I know in the ODBC world there are options like "Change the language of SQL Server system messages" and "Perform transaltion for character data" in the ODBC control panel. I couldn't find any similar options available in the JDBC driver however. Do they exist?

Even if they don't, just scanning the messages makes it pretty clear that there's an authentication/permissions issue at work here. We have another app using the same credentials that works fine though - so if there are any known issues about using JDBC to authenticate in a multi-lingual environment, that would be helpful too. Our tcpdumps seem to suggest that the JDBC driver is using multi-byte strings when communicating with the server, however the "working" application is using single-byte encoding. Could that be why we're not authenticating? How is that controlled? Note that at this point I'm just talking about authentication, not the codepages/encodings of the data in the database - right now I'm just worried about logging in.

Thanks!
Tom

I do not think app using single byte encoding should make any difference when logging in. You really should get the error string in English to understand what is going on.

|||

Error 4060 is "Cannot open database "..." requested by the login. The login failed.", 18456 is "Login failed for user ...".

I am moving to the "SQL Server Security" forum for further follow-up.

Issue to install Reporting Services

I installed SQL Server 2005 Express with Reporting Service on Windows Server 2003 Standard on a server called psmart01. I type the URL of reporting services: http://psmart01/reportserver$SQLEXPRESS and I get only:

psmart01/ReportServer$SQLExpress - /

Microsoft SQL Server Reporting Services Version 9.00.2047.00

I have gone through the Troubleshoot a Reporting Services Installation Problem of MSDN but there is not such issue.

I wonder if reporting service database is not created properly. When I restart the SQL Server Reporting Services I see in the eventvwr: Starting up database 'ReportServer$SQLExpressTempDB'. Why TempDB ?

Can someone help ?

I think you are seeing the Report Server v-dir listing, and your catalog is empty. This is expected. What do you see when you navigate to this URL:

http://psmart01/Reports$SQLExpress

Issue selecting two rows from two columns

I'm trying to select two rows from two columns and while I can select the columns, the selection of multiple rows is not falling into place. I can pull one row into the report, but not two.

This is what I'm writing

SELECT name, number FROM table
WHERE name="variable1',''variable2'

Something is occurring around the , between variable1 and variable2. I know I doing something wrong, but can't figure it out. I can pull variable1 by itself just fine.

The specific error is:
sql: errorYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'variable2' at line 2
number: 1064

Any ideas would be greatly appreciated. I tried searching and could not find an answer to this problem.Found the answer

SELECT name, number FROM table
WHERE name IN('var1', 'var2', 'var3')|||SELECT name, number FROM table
WHERE name in('variable1','variable2')

Issue restoring database

I'm running into a problem restoring a database to MSDE.
Actually, osql reports RESTORE DATABASE successfully
worked but when I view the database from enterprise
manager it tells me the database is still "loading..."
Any suggestions?
Sounds like you are using NORECOVERY with the RESTORE command. This will
leave the database expecting additional restores.
Jim
"Tim" <tim.huenke@.ngc.com> wrote in message
news:0f9c01c4dee6$ebe38f60$a401280a@.phx.gbl...
> I'm running into a problem restoring a database to MSDE.
> Actually, osql reports RESTORE DATABASE successfully
> worked but when I view the database from enterprise
> manager it tells me the database is still "loading..."
> Any suggestions?

Issue Resolved - Interaction between SQL Server and Access

I'm implementing row-level security in a SQL Server database that uses Microsoft Access for the front end. I'm using a UDF (a view behaves the same way) to restrict access to specific rows of a base table based on membership in a role. According to the reading I've done, if the base table has DENY ALL permissions for the role, and the UDF has GRANT ALL, members of the role should be able to update records in the base table via the UDF, without having direct access to the base table. However, I find that unless I grant appropriate permissions on the base table, the user is unable to update the table via the UDF.

Is this expected behavior? Nothing I've read suggests I should have to grant permissions on the columns of the base table.

Yes, that is expected behavior.

Permissions in SQL Server have three values: GRANT, DENY, or 'unsaid'.

If you have been GRANTed permission for a table, obviously you have permission.

If your permission is 'unsaid', then you 'may' still have permission due to permission having been granted to another role that includes you.

But IF you have been explicited DENY(ied), that 'trumps' all.

Think of it this way.

Children have a knack of knowing how to 'scope out' their parents. Perhaps a son wants to go out with friends. He may approach Mom and 'feel her out' to find out if she 'might' say yes WITHOUT directly asking her. He knows that if he asks her and she says 'No', his plans are shot because he cannot then go and ask Dad (DENY). So he will attempt to find out if it is 'safe' to ask her. If it seems safe, he will ask and he's 'home free' (GRANT).

However, if he feels that she would probably say No, then without having asked, he is now free to ask Dad. So Mom was 'unsaid', if permission can be had by another route, it will work for him.

So anytime permission is an explicit DENY, there is no route around it.

Often, in a strong SQL Server security model, TABLE permissions are left 'unsaid', and access is GRANTed through VIEWS, Functions, and Stored Procedures. Users are also added to the db_DenyDataReader and db_DenyDataWriter roles to prohibit them having direct table access.

|||

Thanks for responding.

Ah, yes, that's what I thought. But if I leave the permissions on the base table "unsaid", and grant all on the UDF, Access tells me that the recordset is not updatable (maybe because it can't "see" the PK column?). So I'm back to having to grant permissions in the base table, which is unacceptable.

I read through the good whitepaper on row-level security by Rask, Rubin and Neumann. The architecture they propose is great, but overkill for what I need to do. Nevertheless, I set up a test using their methodology: DENY ALL on the base table, GRANT ALL on a view, and put an INSTEAD OF trigger on the view to verify appropriate access and perform an update. But because Access thinks the recordset isn't updatable, the trigger never fires. If I grant SELECT permissions to just the PK column of the base table, Access thinks the recordset is updatable, but I still can't get the trigger to fire because Access wants at least SELECT permissions on the other base table columns before it will even try to perform the update.

|||

I would suggest the following topics from BOL:

· CREATE VIEW (http://msdn2.microsoft.com/en-us/library/ms187956.aspx), got to the section Updatable Views

· Modifying Data Through a View (http://msdn2.microsoft.com/en-us/library/ms180800.aspx)

I hope this information helps,

-Raul Garcia

SDE/T

SQL Server Engine

|||

In addition to Raul's suggestions, I offer the following insight.

Access will allow you to UPDATE or DELETE a row without the table having a primary key (or some unique identifier.)

SQL Server does NOT allow UPDATES or DELETES unless there is a unambiguous way to be certain what row is being addressed. If the VIEW does not include a PK, or unique identifier, it would not be updatable.

|||Thanks for the references, I'll read through them and see where they lead. I note that these are from SQL Server 2005 BOL, and the server that must host the application I'm working with is SQL Server 2000 SP4. I'm just wondering whether you know whether the support for updatable views changed between SQL 2000 and 2005?|||

As far as I understand, updatable views should be supported in SQL Server 2000 SP4, but I am not 100% sure if all the documentation in the links I included may apply to SQL Server 2000 SP4 as well.

I would recommend trying to find the same topic in BOL fro SQL Server 2000 and giving it a try; if you have any further questions please let us know, we will be glad to help.

Thanks,

-Raul Garcia

SDE/T

SQL Server Engine

|||

Thanks to both you and Arnie for responding to this inquiry.

The problem turns out to have been an interaction between SQL Server and Access. In order for Access to update a SQL Server view, the view must be declared the WITH VIEW_METADATA option. If designing the view in Access, this is accomplished by checking the view option "Update using view rules" on the properties page. Once I did this, I was able to DENY ALL on the base table and GRANT ALL on the view, and the view was updatable via Access with appropriate security.

I ran a SQL Profiler trace to see what Access was sending to SQL Server when the option was properly set--it showed that the UPDATE statement Access generated was against the view, not the base tables. Without using the VIEW_METADATA option, Access does not consider the recordset updatable (hence my original question), so it doesn't generate an UPDATE statement. So I couldn't run a trace to see what happens in that case. I expect that if I could, the UPDATE would be going against the base table rather than the view.

Again, thanks for your help.