SQL Server Product and Version Reporting with SCCM about sccm-zone.com HOT 11 CLOSED

Hi - I got this error.
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 'SQLProductInfo'. (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)

from sccm-zone.com.

@svillama please use the newest version of the report v2.6.5. The extension and definitions for version v2.6.4 were not tested and were incorrect.
I’ve updated the definitions, extensions and report today.

from sccm-zone.com.

@ramg1967 What version of SCCM are you using? The "dbo.fn_rbac_GetAdminIDsfromUserSIDs" is an essential function and it's available from SCCM 2012 R2

from sccm-zone.com.

@Ioan-Popovici - CB1910

from sccm-zone.com.

@ramg1967
Modify the code below at 'YOUR_SITE_CODE' with your site code, run it in SSMS (SQL Server Management Studio) and post the results here.

USE CM_YOUR_SITE_CODE
SELECT *
	FROM    dbo.sysobjects
	WHERE   id = OBJECT_ID(N'[dbo].[fn_rbac_GetAdminIDsfromUserSIDs]')

from sccm-zone.com.

Query completed successfully.
fn_rbac_GetAdminIDsfromUserSIDs 709681676 FN 1 0 0 0 0 0 2019-01-06 16:25:24.457 0 0 0 FN 0 0 0 2019-01-06 16:25:24.457 0 0 0 0 0 0 0

from sccm-zone.com.

Are any of the pre-installed reports working? All of them use this function in this exact form.

from sccm-zone.com.

from sccm-zone.com.

I can't see the image but I presume it's working.

Is the CM_DB SQL server different from the SSRS DB Server?

from sccm-zone.com.

Please join this discord server it's easier to communicate
https://discord.gg/PWwVMe

from sccm-zone.com.

Closing due inactivity, please reopen if you have more info

from sccm-zone.com.