Reporting Services Error - On Windows 2003 Server

I have Reporting Services, installed on a win 2003 server. For all the report
created with matrix (control) when I try to export as Excell file, I have
this error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Object reference not set to an instance of an object.
Can same body HELPPP'''?
Thanks,
Stefan.If you look in the log file that corresponds to that error in your /Log
Files directory, can you paste the full stack trace? Also, have you applied
Reporting Services 2000 SP1 yet?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stefan" <Stefan@.discussions.microsoft.com> wrote in message
news:861F8C47-2A80-48CA-B390-67DE27F96B63@.microsoft.com...
>I have Reporting Services, installed on a win 2003 server. For all the
>report
> created with matrix (control) when I try to export as Excell file, I have
> this error:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> Object reference not set to an instance of an object.
> Can same body HELPPP'''?
> Thanks,
> Stefan.
>|||I can't put all the log file is too big (limit of 30000).
Below I put a part from "ReportServer__04_19_2005_09_48_01.log" file:
w3wp!webserver!a88!04/19/2005-09:48:29:: 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.ReportProcessing.MatrixHeadingInstance.a(Int32
A_0, Int32 A_1, NonComputedUniqueNames& A_2, d A_3)
at
Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstanceList.a(Int32 A_0, NonComputedUniqueNames& A_1, d A_2)
at
Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstance.a(Int32
A_0, Int32 A_1, NonComputedUniqueNames& A_2, d A_3)
at
Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstanceList.a(Int32 A_0, NonComputedUniqueNames& A_1, d A_2)
at
Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstance.a(Int32
A_0, Int32 A_1, NonComputedUniqueNames& A_2, d A_3)
at
Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstanceList.a(Int32 A_0, NonComputedUniqueNames& A_1, d A_2)
at Microsoft.ReportingServices.ReportProcessing.MatrixInstance.a(Int32
A_0, NonComputedUniqueNames& A_1, d A_2)
at
Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(Int32 A_0,
NonComputedUniqueNames& A_1, d A_2)
at
Microsoft.ReportingServices.ReportProcessing.ReportItemColInstance.a(Int32
A_0, NonComputedUniqueNames& A_1, d A_2)
at Microsoft.ReportingServices.ReportProcessing.ReportInstance.a(Int32
A_0, NonComputedUniqueNames& A_1, d A_2)
at
Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(Int32 A_0,
NonComputedUniqueNames& A_1, d A_2)
at
Microsoft.ReportingServices.ReportRendering.RenderingContext.FindReportItemInBody(Int32 uniqueName)
at
Microsoft.ReportingServices.ReportRendering.RenderingContext.GetToggleParent(Int32 uniqueName)
at
Microsoft.ReportingServices.ReportRendering.MatrixMember.get_ToggleParent()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForRowMembers(MatrixMemberCollection
rowMembers, Int32 level, Page verticallySortedItems, Int32 indexOfMatrix,
Double left, Double top, ReportItemStructure cornerStructure, Hashtable&
outlineProhibitedGroups, Hashtable& outlineItems)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForRowMembers(MatrixMemberCollection
rowMembers, Int32 level, Page verticallySortedItems, Int32 indexOfMatrix,
Double left, Double top, ReportItemStructure cornerStructure, Hashtable&
outlineProhibitedGroups, Hashtable& outlineItems)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForMatrixChildren(Matrix
matrix, Page verticallySortedItems, Int32 indexOfMatrix, Page
horizontallySortedItems, Boolean ignorePageBreaks)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForDataRegionChildren(Page
dataRegions, Page verticallySortedItems, Page horizontallySortedItems,
ReportItemCollection reportItemCollection)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutline(Page
verticallySortedItems, ReportItemCollection riCollection, Page containers)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.CollectPages(ReportItemCollection
reportItemCollection, Double relativeLeft, Double relativeTop, Boolean
ignoreAllPageBreaks, Boolean isHeaderBeingProcessed, ArrayList&
pageCollection, Boolean& isPBSPropagated)
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()
Below I put "ReportServerWebApp__04_19_2005_09_47_54.log" file:
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>E. Europe Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerWebApp__04_19_2005_09_47_54.log</Path>
<SystemName>AJUTOR</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing MaxScheduleWait
to default value of '1' second(s) because it was not specified in
Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
DatabaseQueryTimeout to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing InstanceName to
default value of 'MSSQLSERVER.1' because it was not specified in
Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
ProcessRecycleOptions to default value of '0' because it was not specified
in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
RunningRequestsScavengerCycle to default value of '30' second(s) because it
was not specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
RunningRequestsDbCycle to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
RunningRequestsAge to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
CleanupCycleMinutes to default value of '10' minute(s) because it was not
specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
SecureConnectionLevel to default value of '1' because it was not specified
in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
Yes, we have applied SP1.
Thanks,
Stefan.
"Donovan Smith [MSFT]" wrote:
> If you look in the log file that corresponds to that error in your /Log
> Files directory, can you paste the full stack trace? Also, have you applied
> Reporting Services 2000 SP1 yet?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Stefan" <Stefan@.discussions.microsoft.com> wrote in message
> news:861F8C47-2A80-48CA-B390-67DE27F96B63@.microsoft.com...
> >I have Reporting Services, installed on a win 2003 server. For all the
> >report
> > created with matrix (control) when I try to export as Excell file, I have
> > this error:
> >
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown.
> > Object reference not set to an instance of an object.
> > Can same body HELPPP'''?
> >
> > Thanks,
> > Stefan.
> >
>
>|||This looks like something we resolved in SP2 (due out shortly). Would you
please email me a copy of your .rdl and .rdl.data file so I can be sure?
Thank you.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stefan" <Stefan@.discussions.microsoft.com> wrote in message
news:364F8B2E-E741-4109-96F3-F35035508AD7@.microsoft.com...
>I can't put all the log file is too big (limit of 30000).
> Below I put a part from "ReportServer__04_19_2005_09_48_01.log" file:
> w3wp!webserver!a88!04/19/2005-09:48:29:: 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.ReportProcessing.MatrixHeadingInstance.a(Int32
> A_0, Int32 A_1, NonComputedUniqueNames& A_2, d A_3)
> at
> Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstanceList.a(Int32
> A_0, NonComputedUniqueNames& A_1, d A_2)
> at
> Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstance.a(Int32
> A_0, Int32 A_1, NonComputedUniqueNames& A_2, d A_3)
> at
> Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstanceList.a(Int32
> A_0, NonComputedUniqueNames& A_1, d A_2)
> at
> Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstance.a(Int32
> A_0, Int32 A_1, NonComputedUniqueNames& A_2, d A_3)
> at
> Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstanceList.a(Int32
> A_0, NonComputedUniqueNames& A_1, d A_2)
> at Microsoft.ReportingServices.ReportProcessing.MatrixInstance.a(Int32
> A_0, NonComputedUniqueNames& A_1, d A_2)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(Int32
> A_0,
> NonComputedUniqueNames& A_1, d A_2)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportItemColInstance.a(Int32
> A_0, NonComputedUniqueNames& A_1, d A_2)
> at Microsoft.ReportingServices.ReportProcessing.ReportInstance.a(Int32
> A_0, NonComputedUniqueNames& A_1, d A_2)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(Int32
> A_0,
> NonComputedUniqueNames& A_1, d A_2)
> at
> Microsoft.ReportingServices.ReportRendering.RenderingContext.FindReportItemInBody(Int32
> uniqueName)
> at
> Microsoft.ReportingServices.ReportRendering.RenderingContext.GetToggleParent(Int32
> uniqueName)
> at
> Microsoft.ReportingServices.ReportRendering.MatrixMember.get_ToggleParent()
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForRowMembers(MatrixMemberCollection
> rowMembers, Int32 level, Page verticallySortedItems, Int32 indexOfMatrix,
> Double left, Double top, ReportItemStructure cornerStructure, Hashtable&
> outlineProhibitedGroups, Hashtable& outlineItems)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForRowMembers(MatrixMemberCollection
> rowMembers, Int32 level, Page verticallySortedItems, Int32 indexOfMatrix,
> Double left, Double top, ReportItemStructure cornerStructure, Hashtable&
> outlineProhibitedGroups, Hashtable& outlineItems)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForMatrixChildren(Matrix
> matrix, Page verticallySortedItems, Int32 indexOfMatrix, Page
> horizontallySortedItems, Boolean ignorePageBreaks)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForDataRegionChildren(Page
> dataRegions, Page verticallySortedItems, Page horizontallySortedItems,
> ReportItemCollection reportItemCollection)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutline(Page
> verticallySortedItems, ReportItemCollection riCollection, Page containers)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.CollectPages(ReportItemCollection
> reportItemCollection, Double relativeLeft, Double relativeTop, Boolean
> ignoreAllPageBreaks, Boolean isHeaderBeingProcessed, ArrayList&
> pageCollection, Boolean& isPBSPropagated)
> 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()
> Below I put "ReportServerWebApp__04_19_2005_09_47_54.log" file:
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.878.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>E. Europe Daylight Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerWebApp__04_19_2005_09_47_54.log</Path>
> <SystemName>AJUTOR</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
> file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing MaxScheduleWait
> to default value of '1' second(s) because it was not specified in
> Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> DatabaseQueryTimeout to default value of '30' second(s) because it was not
> specified in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing InstanceName to
> default value of 'MSSQLSERVER.1' because it was not specified in
> Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> ProcessRecycleOptions to default value of '0' because it was not
> specified
> in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> RunningRequestsScavengerCycle to default value of '30' second(s) because
> it
> was not specified in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> RunningRequestsDbCycle to default value of '30' second(s) because it was
> not
> specified in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> RunningRequestsAge to default value of '30' second(s) because it was not
> specified in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> CleanupCycleMinutes to default value of '10' minute(s) because it was not
> specified in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> SecureConnectionLevel to default value of '1' because it was not
> specified
> in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> DisplayErrorLink
> to 'True' as specified in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> WebServiceUseFileShareStorage to default value of 'False' because it was
> not
> specified in Configuration file.
> Yes, we have applied SP1.
> Thanks,
> Stefan.
> "Donovan Smith [MSFT]" wrote:
>> If you look in the log file that corresponds to that error in your /Log
>> Files directory, can you paste the full stack trace? Also, have you
>> applied
>> Reporting Services 2000 SP1 yet?
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Stefan" <Stefan@.discussions.microsoft.com> wrote in message
>> news:861F8C47-2A80-48CA-B390-67DE27F96B63@.microsoft.com...
>> >I have Reporting Services, installed on a win 2003 server. For all the
>> >report
>> > created with matrix (control) when I try to export as Excell file, I
>> > have
>> > this error:
>> >
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown.
>> > Object reference not set to an instance of an object.
>> > Can same body HELPPP'''?
>> >
>> > Thanks,
>> > Stefan.
>> >
>>|||I don't know your e-mail address. So, I give my address stefan.rustin@.cg-gc.ro.
Thanks,
Stefan.
"Donovan Smith [MSFT]" wrote:
> This looks like something we resolved in SP2 (due out shortly). Would you
> please email me a copy of your .rdl and .rdl.data file so I can be sure?
> Thank you.