This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 55.00000000000001%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPU%3C/text%3E%3C/svg%3E)
Hi,
I found that SMS_INVENTORY_DATA_LOADER component started logging Errors
[Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated. : pOFFICE_PRODUCTINFO_DATA
I found the problematic MIF file, looking at inventoried data of class "MICROSOFT|OFFICE_PRODUCTINFO|1.0" and comparing it to the columns in OFFICE_PRODUCTINFO_DATA table, I see that in my case value of attribute “Channel” doesn’t fit to the “Channel00” column because stored string is "Semi-Annual Enterprise Channel (Preview)" what gives 40 chars and column is limited to 30 … what should I do in this case? I cannot stop collecting this data because this is default class and cannot “uncheck” it in SCCM Client Settings/HW inventory classes, also I don’t think modification of column properties is allowed.
regards
I would open a case with Microsoft. They can guide you to the supported method to address this issue. I suspect it might be increatse the column width; but I don't know if that column width (if you were to change it) would be "reset" or cause an upgrade issue with a future upgrade of CM.
I personally wouldn't modify the column with of a built-in table like that without engaging Microsoft ECM support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
I suggest you change your tag to msc-operations-manager-general for System Center support.
This is not really a SQL Server problem, but an application problem.
ok got it, thank you
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hi @Paczkowski, Łukasz ,
Could you please try to increase the table data type length?
For issue about SCCM, you can add mem-cm-general tag so that people there will help you more effectively.
Best Regards,
Amelia
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi Amelia,
are you sure this is supported method?
p.s.
tag added, thank you
Hi PaczkowskiLukasz-0313,
Sorry that I’m not familiar with SCCM.
You can do a test in a test environment before changing it in production environment.
Hope that there will be SCCM experts who will look at this issue and help you.
Best Regards,
Amelia
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 60%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
Today I opened a microsoft-case...
Answer: This is a known bug, and it is fixed with SCCM 2006
I can confirm this, because I updated today (from SCCM 2002)
The case owner also mentioned that it is not supported to simply change the nvarchar(30) and highly recommended to upgrade to SCCM 2006 instead.
As sad as it is, there is no hotfix or other (supported) workaround for this issue with SCCM 2002.
Hope you can upgrade as soon as possible.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 64%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
I am already on 2006 and getting the error.
*** [22001][8152][Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated. : pOFFICE_ADDIN_DATA
ERROR - SQL Error in
ERROR - is NOT retyrable.
Rollback transaction: Machine=MachineName(GUID:ED687E67-9915-490B-85BA-1274FEFE7545)
Cannot process MIF XH3F4M7IG.MIF, moving it to Z:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\ErrorCode_4\k4qr1kgx.MIF
STATMSG: ID=2703 SEV=W LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=PS1.DomainName.Com SITE=P01 PID=3144 TID=117408 GMTDATE=Mon May 10 17:53:32.315 2021 ISTR0="XH3F4M7IG.MIF" ISTR1="E:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\ErrorCode_4\k4qr1kgx.MIF" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0
You will need to open a support case with MS about this.