<div>
Thank you for your answer. Could you help me how to find the table and column which needs to be increased in size?
</div>


Thank you for your answer. Could you help me how to find the table and column which needs to be increased in size?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Im using SCCM 2012 on one server with sql 2008 r2 with sp2 (x64) on a seperate server.<br />
<br />
Reporting works ok but it seems when there's more information, ie. when i drill down in the report 'Details of non-compliant rules of configuration items in a configuration baseline for an asset '- i select the server on which the baseline has been deployed.. i select the number of non-compliant rules for the baseline 'WS2008R2SP1 Domain Controller Security Compliance-Protocol Configuration i receive the error:<br />
<br />
An error has occurred during report processing. (rsProcessingAborted)<br />
Query execution failed for dataset 'DataSet0'. (rsErrorExecutingCommand)<br />
String or binary data would be truncated. The statement has been terminated. <br />
<br />
Ive already set no timeout for reports<br />
I expect it cant be the user since it works fine on 90% of all reports<br />
<br />
Hope you can help out.
</div>
</div>


Hi,

Im using SCCM 2012 on one server with sql 2008 r2 with sp2 (x64) on a seperate server.

Reporting works ok but it seems when there's more information, ie. when i drill down in the report 'Details of non-compliant rules of configuration items in a configuration baseline for an asset '- i select the server on which the baseline has been deployed.. i select the number of non-compliant rules for the baseline 'WS2008R2SP1 Domain Controller Security Compliance-Protocol Configuration i receive the error:

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DataSet0'. (rsErrorExecutingCommand)
String or binary data would be truncated. The statement has been terminated. 

Ive already set no timeout for reports
I expect it cant be the user since it works fine on 90% of all reports

Hope you can help out.

error SCCM 2012 reports, Query execution failed for dataset 'DataSet0'. (rsErrorExecutingCommand) String or binary data would be truncated. The statement has been terminated.

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft server applications are those applications developed specifically, but not necessarily exclusively, on the Windows Server platform. In addition to well-known products like SQL Server, Exchange, Internet Information Services (IIS), Microsoft Dynamics, Forefront, Lync and Sharepoint, they include applications like Skype, BizTalk, Hyper-V, Groove and Commerce Server. Server applications are managed with the Microsoft System Center.