Custom Report Error

Hello Folks,

I have been trying to create a custom report for below mentioned query.

SELECT v_R_System.Netbios_Name0 AS 'Computer Name',
v_GS_Autodesk320.ProductName0 AS 'Product Name',
v_GS_Autodesk320.Release0 AS 'Release',
v_GS_Autodesk320.SerialNumber0 AS 'Serial Number',
v_GS_Autodesk320.InstallType0 AS 'Deployment Type',
v_GS_Autodesk320.KeyName0 AS 'Key Name'
FROM v_R_System INNER JOIN
v_GS_Autodesk320 ON v_R_System.ResourceID =
v_GS_Autodesk320.ResourceID
WHERE v_GS_Autodesk320.SerialNumber0 is not NULL
ORDER by v_GS_Autodesk320.ProductName0

Now, when I run this query in report builder or SQL Server Management Studio, I get the desired output.

I have created a report for the same in SCCM 2012 console.

When this report is ran from console, I get the following error message.

Microsoft.Reporting.WinForms.ReportServerException
An error has occurred during report processing. (rsProcessingAborted)


Stack Trace:
   at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
   at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
   at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)
   at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()
   at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()
   at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)

-------------------------------

Microsoft.Reporting.WinForms.ReportServerException
Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)


Stack Trace:
   at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
   at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
   at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)
   at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()
   at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()
   at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)

-------------------------------

Microsoft.Reporting.WinForms.ReportServerException
For more information about this error navigate to the report server on the local server machine, or enable remote errors


Stack Trace:
   at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
   at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
   at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)
   at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()
   at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()
   at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)

-------------------------------

Any help\suggestions\recommendation to fix this would be appreciated.

Thank You !

June 18th, 2015 12:41pm

First off, stop accessing the reports via the console, instead access them via the web interface. Plus there is a lot less overhead using the web interface.

Secondly enable remote errors, to see the real error message. http://www.enhansoft.com/blog/enabling-remote-errors-in-sql

Free Windows Admin Tool Kit Click here and download it now
June 18th, 2015 1:30pm

If the query itself runs, it might have something to do with how you built your table or matrix in ReportBuilder. I would start looking there. 
June 18th, 2015 3:22pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics