For EXPERTS: System.NullReferenceException: Object reference not .

I have a problem with a default implementation of Reporting Services with SP2
in one box, with SQL 2000 SP4.
The tool works fine, I have 10 Reports working without problems, but when I
want to execute one of them, this error message appears :
aspnet_wp!webserver!294!07/25/2005-16:06:56:: e ERROR: Reporting Services
error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Error
inesperado al procesar los informes. -->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Error
inesperado al procesar los informes. --> System.NullReferenceException:
Referencia a objeto no establecida como instancia de un objeto.
In English is something like:
System.NullReferenceException: Object reference not set to an
instance of an object.
Iâ'm using a sql function inside a DataSet and I probed it in SQL Analizer
and worked ok ( it took 20 seconds, is heavy) but when I executed the Report,
appeared that message. I changed the report execution timeout from the
Report Administration but still having the error.
If anyone have an idea ... I need help !!
Thanks!!
LEO.
Heres is my log:
aspnet_wp!processing!3a4!07/28/2005-12:48:29:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Error
inesperado al procesar los informes., ;
Info:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Error
inesperado al procesar los informes. --> System.NullReferenceException:
Referencia a objeto no establecida como instancia de un objeto.
at Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(d A_0)
at Microsoft.ReportingServices.ReportProcessing.o.a(ReportItemInstance
A_0, Boolean A_1)
at
Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
A_0, Boolean A_1)
at
Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
A_0, Boolean A_1)
at
Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
A_0, Boolean A_1)
at Microsoft.ReportingServices.ReportProcessing.o.a(ReportItemInstance
A_0, IList A_1, RenderingPagesRangesList A_2)
at Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItem A_0,
Boolean A_1, Int32 A_2)
at
Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance A_0,
ReportItemCollection A_1)
at
Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance A_0)
at Microsoft.ReportingServices.ReportProcessing.a0.b()
at Microsoft.ReportingServices.ReportProcessing.c.c(ProcessingStages A_0)
at Microsoft.ReportingServices.ReportProcessing.c.d(ProcessingStages A_0)
at Microsoft.ReportingServices.ReportProcessing.ac.a(ProcessingStages
A_0, Boolean A_1)
at Microsoft.ReportingServices.ReportProcessing.a4.a(ReportItemInstance
A_0, IList A_1, RenderingPagesRangesList A_2)
at Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItem A_0,
Boolean A_1, Int32 A_2)
at
Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance A_0,
ReportItemCollection A_1)
at
Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance A_0)
at
Microsoft.ReportingServices.ReportProcessing.bb.a(ParameterInfoCollection
A_0, Boolean A_1)
at
Microsoft.ReportingServices.ReportProcessing.bb.b(ParameterInfoCollection
A_0, Boolean A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report
A_0, ProcessingContext A_1, Boolean A_2, GetReportChunk A_3, az A_4, DateTime
A_5, CreateReportChunk A_6, ab& A_7)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime A_0,
GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- Fin del seguimiento de la pila de la excepción interna --This sounds like a bug. If you need further assistance, I suggest
contacting Microsoft Product Support. If it is indeed a bug and not user
error, any fees will be refunded.
--
| Thread-Topic: For EXPERTS: System.NullReferenceException: Object
reference not .
| thread-index: AcWTjhy6HiRzY1eyQ9OOA8fay/B5TA==| X-WBNR-Posting-Host: 24.232.107.196
| From: =?Utf-8?B?TGVv?= <Leo@.discussions.microsoft.com>
| Subject: For EXPERTS: System.NullReferenceException: Object reference not|||For the one report that has this problem - can you try to republish the RDL
of that report under a new name and check if the report runs then?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Leo" <Leo@.discussions.microsoft.com> wrote in message
news:4306B254-7122-4B67-851B-39331212141C@.microsoft.com...
>I have a problem with a default implementation of Reporting Services with
>SP2
> in one box, with SQL 2000 SP4.
> The tool works fine, I have 10 Reports working without problems, but when
> I
> want to execute one of them, this error message appears :
> aspnet_wp!webserver!294!07/25/2005-16:06:56:: e ERROR: Reporting Services
> error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Error
> inesperado al procesar los informes. -->
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> Error
> inesperado al procesar los informes. --> System.NullReferenceException:
> Referencia a objeto no establecida como instancia de un objeto.
>
> In English is something like:
> System.NullReferenceException: Object reference not set to an
> instance of an object.
>
> I'm using a sql function inside a DataSet and I probed it in SQL Analizer
> and worked ok ( it took 20 seconds, is heavy) but when I executed the
> Report,
> appeared that message. I changed the report execution timeout from the
> Report Administration but still having the error.
> If anyone have an idea ... I need help !!
> Thanks!!
> LEO.
> Heres is my log:
> aspnet_wp!processing!3a4!07/28/2005-12:48:29:: e ERROR: Throwing
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> Error
> inesperado al procesar los informes., ;
> Info:
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> Error
> inesperado al procesar los informes. --> System.NullReferenceException:
> Referencia a objeto no establecida como instancia de un objeto.
> at Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(d
> A_0)
> at Microsoft.ReportingServices.ReportProcessing.o.a(ReportItemInstance
> A_0, Boolean A_1)
> at
> Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
> A_0, Boolean A_1)
> at
> Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
> A_0, Boolean A_1)
> at
> Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
> A_0, Boolean A_1)
> at Microsoft.ReportingServices.ReportProcessing.o.a(ReportItemInstance
> A_0, IList A_1, RenderingPagesRangesList A_2)
> at Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItem A_0,
> Boolean A_1, Int32 A_2)
> at
> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
> A_0,
> ReportItemCollection A_1)
> at
> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
> A_0)
> at Microsoft.ReportingServices.ReportProcessing.a0.b()
> at Microsoft.ReportingServices.ReportProcessing.c.c(ProcessingStages
> A_0)
> at Microsoft.ReportingServices.ReportProcessing.c.d(ProcessingStages
> A_0)
> at Microsoft.ReportingServices.ReportProcessing.ac.a(ProcessingStages
> A_0, Boolean A_1)
> at Microsoft.ReportingServices.ReportProcessing.a4.a(ReportItemInstance
> A_0, IList A_1, RenderingPagesRangesList A_2)
> at Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItem A_0,
> Boolean A_1, Int32 A_2)
> at
> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
> A_0,
> ReportItemCollection A_1)
> at
> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
> A_0)
> at
> Microsoft.ReportingServices.ReportProcessing.bb.a(ParameterInfoCollection
> A_0, Boolean A_1)
> at
> Microsoft.ReportingServices.ReportProcessing.bb.b(ParameterInfoCollection
> A_0, Boolean A_1)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report
> A_0, ProcessingContext A_1, Boolean A_2, GetReportChunk A_3, az A_4,
> DateTime
> A_5, CreateReportChunk A_6, ab& A_7)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
> A_0,
> GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
> CreateReportChunk A_4, Boolean& A_5)
> -- Fin del seguimiento de la pila de la excepción interna --
>|||BTW, is this a report server that was upgraded from RS 2000 Beta 2, to RS
2000 RTM, and then to RS 2000 SP2?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:e55j%23%23%23kFHA.3260@.TK2MSFTNGP10.phx.gbl...
> For the one report that has this problem - can you try to republish the
> RDL of that report under a new name and check if the report runs then?
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Leo" <Leo@.discussions.microsoft.com> wrote in message
> news:4306B254-7122-4B67-851B-39331212141C@.microsoft.com...
>>I have a problem with a default implementation of Reporting Services with
>>SP2
>> in one box, with SQL 2000 SP4.
>> The tool works fine, I have 10 Reports working without problems, but when
>> I
>> want to execute one of them, this error message appears :
>> aspnet_wp!webserver!294!07/25/2005-16:06:56:: e ERROR: Reporting Services
>> error Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
>> Error
>> inesperado al procesar los informes. -->
>> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
>> Error
>> inesperado al procesar los informes. --> System.NullReferenceException:
>> Referencia a objeto no establecida como instancia de un objeto.
>>
>> In English is something like:
>> System.NullReferenceException: Object reference not set to an
>> instance of an object.
>>
>> I'm using a sql function inside a DataSet and I probed it in SQL Analizer
>> and worked ok ( it took 20 seconds, is heavy) but when I executed the
>> Report,
>> appeared that message. I changed the report execution timeout from the
>> Report Administration but still having the error.
>> If anyone have an idea ... I need help !!
>> Thanks!!
>> LEO.
>> Heres is my log:
>> aspnet_wp!processing!3a4!07/28/2005-12:48:29:: e ERROR: Throwing
>> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
>> Error
>> inesperado al procesar los informes., ;
>> Info:
>> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
>> Error
>> inesperado al procesar los informes. --> System.NullReferenceException:
>> Referencia a objeto no establecida como instancia de un objeto.
>> at Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(d
>> A_0)
>> at Microsoft.ReportingServices.ReportProcessing.o.a(ReportItemInstance
>> A_0, Boolean A_1)
>> at
>> Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
>> A_0, Boolean A_1)
>> at
>> Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
>> A_0, Boolean A_1)
>> at
>> Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
>> A_0, Boolean A_1)
>> at Microsoft.ReportingServices.ReportProcessing.o.a(ReportItemInstance
>> A_0, IList A_1, RenderingPagesRangesList A_2)
>> at Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItem A_0,
>> Boolean A_1, Int32 A_2)
>> at
>> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
>> A_0,
>> ReportItemCollection A_1)
>> at
>> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
>> A_0)
>> at Microsoft.ReportingServices.ReportProcessing.a0.b()
>> at Microsoft.ReportingServices.ReportProcessing.c.c(ProcessingStages
>> A_0)
>> at Microsoft.ReportingServices.ReportProcessing.c.d(ProcessingStages
>> A_0)
>> at Microsoft.ReportingServices.ReportProcessing.ac.a(ProcessingStages
>> A_0, Boolean A_1)
>> at Microsoft.ReportingServices.ReportProcessing.a4.a(ReportItemInstance
>> A_0, IList A_1, RenderingPagesRangesList A_2)
>> at Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItem A_0,
>> Boolean A_1, Int32 A_2)
>> at
>> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
>> A_0,
>> ReportItemCollection A_1)
>> at
>> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
>> A_0)
>> at
>> Microsoft.ReportingServices.ReportProcessing.bb.a(ParameterInfoCollection
>> A_0, Boolean A_1)
>> at
>> Microsoft.ReportingServices.ReportProcessing.bb.b(ParameterInfoCollection
>> A_0, Boolean A_1)
>> at
>> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report
>> A_0, ProcessingContext A_1, Boolean A_2, GetReportChunk A_3, az A_4,
>> DateTime
>> A_5, CreateReportChunk A_6, ab& A_7)
>> at
>> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
>> A_0,
>> GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
>> CreateReportChunk A_4, Boolean& A_5)
>> -- Fin del seguimiento de la pila de la excepción interna --
>>
>|||Hi Robert. Thanks for your response.
I just republish the same report with a different name but still showing the
error.
RS was upgraded from RS2000 (8.00.743) directly to RS2000 SP2 (8.00.1042)
Its difficult to analize, because the sql function executes normally in SQL
Analizer (takes 18 seconds aprox), but RS shows that error.
Otherwise, the report executes ok with some parameters, but don't work if
those parameters mean to process lot of SQL registers (f.e: <All the tickets>
to process)
Is there a bug that don't support certain number of registers to process? I
don't think so ... but .....
Thanks again.
Leo.
"Robert Bruckner [MSFT]" wrote:
> BTW, is this a report server that was upgraded from RS 2000 Beta 2, to RS
> 2000 RTM, and then to RS 2000 SP2?
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:e55j%23%23%23kFHA.3260@.TK2MSFTNGP10.phx.gbl...
> > For the one report that has this problem - can you try to republish the
> > RDL of that report under a new name and check if the report runs then?
> >
> > -- Robert
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> >
> > "Leo" <Leo@.discussions.microsoft.com> wrote in message
> > news:4306B254-7122-4B67-851B-39331212141C@.microsoft.com...
> >>I have a problem with a default implementation of Reporting Services with
> >>SP2
> >> in one box, with SQL 2000 SP4.
> >>
> >> The tool works fine, I have 10 Reports working without problems, but when
> >> I
> >> want to execute one of them, this error message appears :
> >>
> >> aspnet_wp!webserver!294!07/25/2005-16:06:56:: e ERROR: Reporting Services
> >> error Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> >> Error
> >> inesperado al procesar los informes. -->
> >> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> >> Error
> >> inesperado al procesar los informes. --> System.NullReferenceException:
> >> Referencia a objeto no establecida como instancia de un objeto.
> >>
> >>
> >> In English is something like:
> >>
> >> System.NullReferenceException: Object reference not set to an
> >> instance of an object.
> >>
> >>
> >> I'm using a sql function inside a DataSet and I probed it in SQL Analizer
> >> and worked ok ( it took 20 seconds, is heavy) but when I executed the
> >> Report,
> >> appeared that message. I changed the report execution timeout from the
> >> Report Administration but still having the error.
> >>
> >> If anyone have an idea ... I need help !!
> >> Thanks!!
> >> LEO.
> >>
> >> Heres is my log:
> >>
> >> aspnet_wp!processing!3a4!07/28/2005-12:48:29:: e ERROR: Throwing
> >> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> >> Error
> >> inesperado al procesar los informes., ;
> >> Info:
> >> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> >> Error
> >> inesperado al procesar los informes. --> System.NullReferenceException:
> >> Referencia a objeto no establecida como instancia de un objeto.
> >> at Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(d
> >> A_0)
> >> at Microsoft.ReportingServices.ReportProcessing.o.a(ReportItemInstance
> >> A_0, Boolean A_1)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
> >> A_0, Boolean A_1)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
> >> A_0, Boolean A_1)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
> >> A_0, Boolean A_1)
> >> at Microsoft.ReportingServices.ReportProcessing.o.a(ReportItemInstance
> >> A_0, IList A_1, RenderingPagesRangesList A_2)
> >> at Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItem A_0,
> >> Boolean A_1, Int32 A_2)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
> >> A_0,
> >> ReportItemCollection A_1)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
> >> A_0)
> >> at Microsoft.ReportingServices.ReportProcessing.a0.b()
> >> at Microsoft.ReportingServices.ReportProcessing.c.c(ProcessingStages
> >> A_0)
> >> at Microsoft.ReportingServices.ReportProcessing.c.d(ProcessingStages
> >> A_0)
> >> at Microsoft.ReportingServices.ReportProcessing.ac.a(ProcessingStages
> >> A_0, Boolean A_1)
> >> at Microsoft.ReportingServices.ReportProcessing.a4.a(ReportItemInstance
> >> A_0, IList A_1, RenderingPagesRangesList A_2)
> >> at Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItem A_0,
> >> Boolean A_1, Int32 A_2)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
> >> A_0,
> >> ReportItemCollection A_1)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
> >> A_0)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.bb.a(ParameterInfoCollection
> >> A_0, Boolean A_1)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.bb.b(ParameterInfoCollection
> >> A_0, Boolean A_1)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report
> >> A_0, ProcessingContext A_1, Boolean A_2, GetReportChunk A_3, az A_4,
> >> DateTime
> >> A_5, CreateReportChunk A_6, ab& A_7)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
> >> A_0,
> >> GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
> >> CreateReportChunk A_4, Boolean& A_5)
> >> -- Fin del seguimiento de la pila de la excepción interna --
> >>
> >>
> >
> >
>
>