Search

Reporting Services NULL delivery extension failing by Radim Hampel

Active

1
0
Sign in
to vote
Type: Bug
ID: 772100
Opened: 11/24/2012 12:32:24 PM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
I try to cache reports on watawarehoue scenario, reports based on analysis services. I use C# application to render every available report to cache it.

It works when some delivery extension is picked: PDF,CSV,HTML4.0,PDF..., however I'd like to use NULL extension, but with that it raises exception in log file (however it seems that caching itself works and there is a record in ExecutionLog with NULL type).

Just changing from NULL to CSV (or any other) will result in no exception in log file.

Even using RS.EXE utility has same effect.
Details (expand)

Product Language

English

Version

SQL Server 2012 - Enterprise Edition

Category

Reporting Services

Operating System

Windows Server 2008 Enterprise

Operating System Language

English

Steps to Reproduce

        static void d()
        {
            ReportExecution2005.ReportExecutionService re = new ReportExecution2005.ReportExecutionService();
            re.Credentials = System.Net.CredentialCache.DefaultCredentials;
            string reportName = "/folder/report";

            string historyId = null, extension = null, encoding = null, mimeType = null;
            string format = "NULL";
            string deviceInfo = null;
            string[] streams = null;
            ReportExecution2005.Warning[] warning = null;

            ExecutionInfo ei = re.LoadReport(reportName, historyId);

            re.Render(format, deviceInfo, out extension, out mimeType, out encoding, out warning, out streams);
            //re.Render2(format, deviceInfo, PageCountMode.Actual, out extension, out mimeType, out encoding, out warning, out streams);
        }

RSS script:
Public Sub Main()
RenderReport("/Merchandising/MER003 Net Sales")
End Sub

Public Sub RenderReport(reportPath as string)
Dim format as string = "NULL"

' Prepare Render arguments
Dim historyID as string = Nothing
Dim deviceInfo as string = Nothing
Dim extension as string = Nothing
Dim encoding as string
Dim mimeType as string
Dim warnings() AS Warning = Nothing
Dim streamIDs() as string = Nothing
Dim results() as Byte

rs.LoadReport(reportPath, historyID)

results = rs.Render(format, deviceInfo, extension, mimeType, encoding, warnings, streamIDs)
End Sub

Actual Results

library!ReportServer_0-105!2870!11/24/2012-21:13:27:: i INFO: RenderForNewSession('/Merchandising/MER003 Net Sales From To')
webserver!ReportServer_0-105!2870!11/24/2012-21:13:37:: e ERROR: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, PageCountMode pageCountMode, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.Render(String Format, String DeviceInfo, PageCountMode pageCountMode, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.Render2(String Format, String DeviceInfo, PageCountMode PaginationMode, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)

Expected Results

No exception in log file.

Platform

X64

Virtualization

Other (e.g. VM Ware, specify in Description)
File Attachments
0 attachments
Sign in to post a comment.
Sign in to post a workaround.