Skip to Content
0
Apr 09, 2014 at 02:44 PM

sap_core_getSapChangeNumberOrMaxChangeNumber

96 Views

Hi experts!

My scenario is IDM SP9 with SQL 2012

I'm having an error when doing initial load AD

sap_core_getSapChangeNumberOrMaxChangeNumber :: Could Not mskey retrieve mskey value is:

follows the standard script below

// Main function: sap_core_getSapChangeNumberOrMaxChangeNumber

/**

* This function returns either the change number (SAP_CHANGENUMBER) of the user or if not existing the highest change number value of the user.

* @param {mskeyValue} mskey value of the user e.g. USERMSKEYVALUE

* @return {int} change number (SAP_CHANGENUMBER) of the user or if not existing the highest change number value of the user

*/

function sap_core_getSapChangeNumberOrMaxChangeNumber(mskeyValue){

var idStore = "%$glb.SAP_MASTER_IDS_ID%";

dbtype="%$ddm.databasetype%"

nolock="";

if(dbtype==1) {

nolock="WITH (NOLOCK)";

}

//get mskey for given mskey value

var mskey = uIS_Get(idStore, mskeyValue);

if (mskey == null || mskey.indexOf("ERROR") != -1){

uError("sap_core_getSapChangeNumberOrMaxChangeNumber:: could not retrieve mskey for mskey value: " + mskeyValue);

uSkip(1);

}

var currentChangeNumber = uSelect("SELECT aValue FROM idmv_value_basic_all "+nolock+" where mskey = " + mskey + " and AttrName = 'SAP_CHANGENUMBER'");

if(currentChangeNumber == null || currentChangeNumber == "") {

currentChangeNumber = sap_core_getMaxChangeNumber(mskey);

uInfo("sap_core_getSapChangeNumberOrMaxChangeNumber:: user does not have a SAP_CHANGENUMBER, using now: " + currentChangeNumber);

} else {

uInfo("sap_core_getSapChangeNumberOrMaxChangeNumber:: user " + mskeyValue + " has already a SAP_CHANGENUMBER: " + currentChangeNumber);

}

return currentChangeNumber;

}

any idea what might be?

Thanks

Leandro