Description: SetColumn: Couldn't set [MinorVersion] to (0-B11).
( Exception Details: System.ArgumentException: Input string was not in a
correct format.Couldn't store <0-B11> in MinorVersion Column. Expected type is
Int32. ---> System.FormatException: Input string was not in a correct format.
at System.Number.StringToNumber(String str, NumberStyles options,
NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo
at System.String.System.IConvertible.ToInt32(IFormatProvider provider)
at System.Data.Common.Int32Storage.Set(Int32 record, Object value)
at System.Data.DataColumn.set_Item(Int32 record, Object value)
--- End of inner exception stack trace ---
This is working as designed. The warning error message within the logs is being revised by Symantec development.
This warning message is thrown when a program has a major or minor build version that contains alpha-numeric characters rather than just numeric characters. The full version will be recorded for the specific software component and the major and minor build information will be discarded (as per the above warning message)
This issue is slated to be addressed in the 7.1 release of Inventory and Software Management.
The following process is provided "As Is". This will work around the issue, but be advised there may be some ramifications as this process did not go through a QA process.
Reports that use the Minor-version and try to join to another data field of an INT value will fail – I checked our common reports that key off of data from the table I’m modifying, and none of them use the minorversion field.
Here is the process to follow to modify this value, plus how to confirm the change worked. There are two options.
Option 1 (Works for SQL 2005)
Option 2 (Recommended for SQL 2008)
Run the following SQL statements in SQL Server Management Studio if you get an error in SQL 2008 stating that "Saving changes is not permitted".
ALTER TABLE dbo.Inv_Software_Component ALTER COLUMN MinorVersion NVARCHAR(50)
To verify that the changes worked, do the following:
Inventory Solution 7.0 SP1x
Software Management 7.0x