SQL ETL Job Encounters Step 3 Failure in the Analysis Center Console (NETIQKB72346)

SQL ETL Job Encounters Step 3 Failure in the Analysis Center Console
An error occurred while assigning a value to variable "EndJobModTime": "The type of the value being assigned to variable "User::EndJobModTime" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.

An error occurred while assigning a value to variable "EndKSID": "The type of the value being assigned to variable "User::EndKSID" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object

NetIQ Analysis Center Hotfix 72012 will correct the flaw in the ETL processing logic, but cannot resolve the error once the failure has occurred.  If you are experiecing the problem described above follow the below and then apply Hotfix 72012:

https://www.netiq.com/support/nac/extended/hotfixes/default.asp

 

--QUERY 1
--EXECUTE THE FOLLOWING QUERY AGAINST THE PROBLEMATIC DATA SOURCE DATA MART

SELECT iValue FROM Variables WHERE Name = 'AM KS End KSID'

--QUERY 2
--EXECUTE THE FOLLOWING QUERY AGAINST THE CORRESPONDING QDB FOR THE DATA SOURCE
--RESULTS FROM THIS QUERY SHOULD BE HIGHER OR EQUAL TO THE VALUE IN THE 1ST QUERY

SELECT maxKSID = MAX(KSID) FROM KS

--QUERY 3
--IF THE RESULTS FROM QUERY 2 DO NOT MATCH QUERY 1
--THEN EXECUTE THE FOLLOWING QUERY AGAINST THE PROBLEMATIC DM
--REPLACE @result WITH THE VALUE FROM QUERY 2

UPDATE Variables SET iValue = @result WHERE NAME = 'AM KS End KSID'

 

Due to logic flaw in the ETL processing job, step 3 may fail if you have deleted all jobs or removed some Knowledge Scripts from the AppManager repository. 

Formerly known as NETIQKB72346