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