SOLVED Les données de chaîne ou binaires seront tronquées. : pOFFICE_PRODUCTINFO_DATA

[vch01]

Hello,

I am with sccm version 2002 with updates.

In the SMS_INVENTORY_DATA_LOADER component I have this error message:

Microsoft SQL Server reported SQL 8152, severity 16: [22001][8152][Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data will be truncated. : pOFFICE_PRODUCTINFO_DATA

I realized that the pb appears on positions with office 365.
I did a test with a nonoffice position, I deleted a software and the update on sccm is correct.

I looked at the MiFID file of a post in error and I have the following line (attached a mif file)

Start Attribute Name = "Channel" ID = 2 Type = String Value = "Semi-Annual Enterprise Channel (Preview)" End Attribute

In the office_productinfo_data table, the channel00 column is limited to 30 characters while the value is more than 30 characters.

 

[Garth]

The message say it will truncate the string so it is not really a big deal. on top of that there is or will be an update to fix that. So make sure that you upgrade to 2006

 

[vch01]

Bonjour,
je viens de passer en 2006 et sa fonctionne de nouveau.
Vous pouvez cloturer le ticket.
merci.