Environment
NetIQ Secure Configuration Manager 5.9.1
Situation
An error occurs when creating an exception. Error: Invalid length parameter passed into the substring function
Resolution
Make sure to backup the database.
Log out of SCM.
Open the stored procedure from the link below and paste it in a new query window in SQL Server Management Studio and execute it.
ftp://tsdownload:yellow&77down@ftp.netiq.com/download/Products/SCM/SCM591/Bug846445Fix/dbo.spGetExemptionHeader.PRC
Cause
There was a problem while parsing the sentence field of the Exemption table.