When upgrading the AppManager repository from AppManager 6.0.2 toversion 7.0, upgrade may abort. (NETIQKB70189)

When upgrading the AppManager repository from AppManager 6.0.2 to AppManager 7.0, upgrade may abort with a return code of 1073741819

AppManager upgrade of the repository or QDB fails with error 'return code=-1073741819 reference qdbupgrade.log'

QDBupgrade.log ends at executing ksdiff.exe

DSDiffTrace.log has the following entry... 'QDBError: SQLSTATE=37000, native error=536, message=[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid length parameter passed to the substring function.'

• Launch a SQL Query to locate the orphaned Knowledge Scripts.  For Example:  SELECT Name from dbo.KS WHERE Name NOT LIKE '%/_%' ESCAPE '/';

To Delete the Knowledge Scripts:

• Launch a SQL Query to delete these Knowledge Scripts.  For Example:  DELETE FROM dbo.KS WHERE Name NOT LIKE '%/_%' ESCAPE '/';

To Rename the Knowledge Scripts:

• Check out the Knowledge Scripts
• Launch a SQL Query to rename these Knowledge Scripts so that they get assigned to a different category.  For Example:  UPDATE dbo.KS SET Name = 'CategoryName_' & Name WHERE Name NOT LIKE '%/_%' ESCAPE '/';
• Check in the Knowledge Scripts

Formerly known as NETIQKB70189