For EXPERTS: System.NullReferenceException: Object reference not .

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leo - 28 Jul 2005 17:05 GMT

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 ---

Reply to this Message

"Brad Syputa - MS" - 28 Jul 2005 18:49 GMT

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

Reply to this Message

Robert Bruckner [MSFT] - 29 Jul 2005 04:43 GMT

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

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

>I have a problem with a default implementation of Reporting Services with
>SP2
[quoted text clipped - 97 lines]
> CreateReportChunk A_4, Boolean& A_5)
> --- Fin del seguimiento de la pila de la excepción interna ---

Reply to this Message

Robert Bruckner [MSFT] - 29 Jul 2005 04:50 GMT

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

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

> 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?
[quoted text clipped - 105 lines]
>> CreateReportChunk A_4, Boolean& A_5)
>> --- Fin del seguimiento de la pila de la excepción interna ---

Reply to this Message

Leo - 30 Jul 2005 14:40 GMT

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.

> BTW, is this a report server that was upgraded from RS 2000 Beta 2, to RS
> 2000 RTM, and then to RS 2000 SP2?
[quoted text clipped - 111 lines]
> >> CreateReportChunk A_4, Boolean& A_5)
> >> --- Fin del seguimiento de la pila de la excepción interna ---

Reply to this Message