Access Import Performance Issue

[rushikeshvartak]

• Access Import is taking 4 hours in DEV vs 3 days in TEST 
• What can be possible root cause other than sub version 
  • ECM version & sub version is same.
• Spoiler

  {
  "accountParams": {
  "connection": "acctAuth",
  "processingType": "SequentialAndIterative",
  "call": {
  "call1ABCDEFGHJKLM": {
  "callOrder": 1,
  "stageNumber": 1,
  "http": {
  "url": "https://XXXXXXXX/scim/v2/Users?filter=active%20eq%20%22Activated%22%20and%20(identityUserID%20sw%20%...",
  "httpHeaders": {
  "Authorization": "${access_token}",
  "Accept": "application/json"
  },
  "httpContentType": "application/json",
  "httpMethod": "GET"
  },
  "listField": "Resources",
  "keyField": "accountID",
  "colsToPropsMap": {
  "accountID": "uid~#~char",
  "name": "uid~#~char",
  "displayname": "displayName~#~char",
  "customproperty1": "identityStatus~#~char",
  "customproperty2": "email~#~char",
  "customproperty20": "#CONST#${new Date(Calendar.getInstance().getTimeInMillis())}~#~char",
  "customproperty31": "#CONST#${StringBuilder sb = new StringBuilder(); sb.append('{\"Groups\":{\"entIds\":['); List groupList = response.isMemberOf; if (groupList != null) { int size = groupList.size(); int count = 0; Iterator itr = groupList.iterator(); while (itr.hasNext()) { String str = itr.next().toLowerCase(); String delim='\"'; count++; if(count > 1) { sb.append(',').append(delim).append(str).append(delim); } else { sb.append(delim).append(str).append(delim); }; if(count == size) { break; }; }; }; sb.append('],\"keyField\":\"entitlement_value\"}}'); return sb.toString()}~#~char"
  },
  "pagination": {
  "nextUrl": {
  "nextUrlPath": "${response?.completeResponseMap?.itemsPerPage==5000?('https://XXXXXXXX/scim/v2/Users?filter=active%20eq%20%22Activated%22%20and%20(identityUserID%20sw%20%...}"
  }
  }
  },
  "call2NOPQRSUVWXYZ": {
  "callOrder": 2,
  "stageNumber": 2,
  "http": {
  "url": "https://XXXXXXXX/scim/v2/Users?filter=active%20eq%20%22Activated%22%20and%20(identityUserID%20sw%20%...",
  "httpHeaders": {
  "Authorization": "${access_token}",
  "Accept": "application/json"
  },
  "httpContentType": "application/json",
  "httpMethod": "GET"
  },
  "listField": "Resources",
  "keyField": "accountID",
  "colsToPropsMap": {
  "accountID": "uid~#~char",
  "name": "uid~#~char",
  "displayname": "displayName~#~char",
  "customproperty1": "identityStatus~#~char",
  "customproperty2": "email~#~char",
  "customproperty20": "#CONST#${new Date(Calendar.getInstance().getTimeInMillis())}~#~char",
  "customproperty31": "#CONST#${StringBuilder sb = new StringBuilder(); sb.append('{\"Groups\":{\"entIds\":['); List groupList = response.isMemberOf; if (groupList != null) { int size = groupList.size(); int count = 0; Iterator itr = groupList.iterator(); while (itr.hasNext()) { String str = itr.next().toLowerCase(); String delim='\"'; count++; if(count > 1) { sb.append(',').append(delim).append(str).append(delim); } else { sb.append(delim).append(str).append(delim); }; if(count == size) { break; }; }; }; sb.append('],\"keyField\":\"entitlement_value\"}}'); return sb.toString()}~#~char"
  },
  "pagination": {
  "nextUrl": {
  "nextUrlPath": "${response?.completeResponseMap?.itemsPerPage==5000?('https://XXXXXXXX/scim/v2/Users?filter=active%20eq%20%22Activated%22%20and%20(identityUserID%20sw%20%...}"
  }
  }
  },
  "call3IT": {
  "callOrder": 3,
  "stageNumber": 3,
  "http": {
  "url": "https://XXXXXXXX/scim/v2/Users?filter=active%20eq%20%22Activated%22%20and%20(identityUserID%20sw%20%...",
  "httpHeaders": {
  "Authorization": "${access_token}",
  "Accept": "application/json"
  },
  "httpContentType": "application/json",
  "httpMethod": "GET"
  },
  "listField": "Resources",
  "keyField": "accountID",
  "colsToPropsMap": {
  "accountID": "uid~#~char",
  "name": "uid~#~char",
  "displayname": "displayName~#~char",
  "customproperty1": "identityStatus~#~char",
  "customproperty2": "email~#~char",
  "customproperty31": "#CONST#Logic~#~char"
  },
  "pagination": {
  "nextUrl": {
  "nextUrlPath": "${response?.completeResponseMap?.itemsPerPage==5000?('https://XXXXXXXX/scim/v2/Users?filter=active%20eq%20%22Activated%22%20and%20(identityUserID%20sw%20%...}"
  }
  }
  }
  },
  "acctEntMappings": {
  "Groups": {
  "listPath": "ismemberof",
  "idPath": "",
  "keyField": "entitlement_value"
  }
  }
  },
  "entitlementParams": {
  "connection": "acctAuth",
  "processingType": "SequentialAndIterative",
  "entTypes": {
  "Groups": {
  "entTypeOrder": 1,
  "call": {
  "call1": {
  "callOrder": 1,
  "stageNumber": 1,
  "http": {
  "url": "https://XXXXXXXX/scim/v2/Groups?attributes=cn,entryUUID,entryDN,description&count=5000&startIndex=1",
  "httpHeaders": {
  "Authorization": "${access_token}",
  "Accept": "application/json"
  },
  "httpContentType": "application/json",
  "httpMethod": "GET"
  },
  "listField": "Resources",
  "keyField": "entitlementID",
  "colsToPropsMap": {
  "entitlementID": "entryUUID~#~char",
  "entitlement_value": "#CONST#${response.entryDN.toLowerCase()}~#~char"
  },
  "pagination": {
  "nextUrl": {
  "nextUrlPath": "${response?.completeResponseMap?.itemsPerPage==5000?('https://XXXXXXXX/scim/v2/Groups?attributes=cn,entryUUID,entryDN,description&count=5000&startIndex='+...}"
  }
  }
  }
  }
  }
  }
  },
  "acctEntParams": {
  "processingType": "acctToEntMapping"
  }
  }

[Raghu]

@rushikeshvartak  we are also same issue experienced, saviynt team suggested use configjson, after that never faced long time run job

{"show logs": "true"},{"connectionTimeoutConfig":{"connectionTimeout":20,"readTimeout":50,"r etryWait":2,"retryCount":3}}

[rushikeshvartak]

Its already in place 

[prtkrh007]

This needs to be followed through freshdesk ticket
https://saviyntsupport.saviynt.com/a/tickets/2041274?current_tab=details

[rushikeshvartak · Accepted solution]

This has been fixed by infra team by making same number of pods in both instances 

[NM]

Hi @rushikeshvartak by same server means?? You only had 1 servers  in test?