Solved

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

Posted on 2013-01-02
2
1,990 Views
Last Modified: 2013-06-19
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.
0
Comment
Question by:zackmccracken
2 Comments
 
LVL 25

Accepted Solution

by:
TempDBA earned 500 total points
ID: 38738154
The message comes when you are trying to insert into a table say with varchar(10) size, a value that need more data length than 10. In that case, the data has to be truncated to adjust into the field. You need to increase the size of the column.
0
 
LVL 3

Author Comment

by:zackmccracken
ID: 38739177
Thank you for your answer. Could you help me how to find the table and column which needs to be increased in size?
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now