error when creating an exception

  • 7014755
  • 18-Mar-2014
  • 18-Mar-2014

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.

Status

Reported to Engineering