We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

ImportAccountEntJSON - Unable to map account with entitlement with single API call

JoshuaLawrence
New Contributor III
New Contributor III

Hi there,

I am having trouble trying to associate accounts with entitlements (type: userRole) via a single API call and processing type "http". Looking at the logs, the response is recieved successfully and it seems like it is able to get the correct ACCKEY values to map but the ENTKEY values are null for some reason.

Looking for any advice, thanks!

Here is the importAccountEntJSON:

{
"accountParams": {
"connection": "userAuth",
"createUsers": false,
"adminName": "admin",
"processingType": "SequentialAndIterative",
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"disableDeletedAccounts": true,
"http": {
"url": "<URL>",
"httpHeaders": {
"Content-Type": "application/json",
"Authorization": "${access_token}"
},
"httpContentType": "application/json",
"httpMethod": "GET",
"httpParams": {}
},
"listField": "",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "id~#~char",
"name": "userId~#~char",
"customproperty1": "givenName~#~char",
"customproperty2": "familyName~#~char",
"customproperty3": "id~#~char",
"customproperty4": "department~#~char",
"customproperty5": "loginPolicyGroupId~#~char",
"customproperty6": "modifyUser~#~char",
"customproperty8": "userRealmId~#~char",
"customproperty10": "tenantId~#~char"
}
}
}
},
"entitlementParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"userRole": {
"entTypeOrder": 0,
"call": {
"call1": {
 
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "<URL>",
"httpHeaders": {
"Authorization": "${access_token}",
"Content-Type": "application/json"
 
},
"httpContentType": "application/json",
"httpParams": {},
"httpMethod": "GET"
},
"listField": "",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "userRole.id~#~char",
"entitlement_value": "userRole.name~#~char"
}
}
}
}
}
},
  "acctEntParams": {
"processingType": "http",
    "entTypes": {
      "userRole": {
        "call": {
          "call1": {
"connection": "userAuth",
"callOrder": 0,
            "stageNumber": 0,
            "http": {
              "httpHeaders": {
                "Authorization": "${access_token}"
              },
              "url": "<URL>",
              "httpContentType": "application/json",
              "httpMethod": "GET"
            },
            "listField": "",
            "acctIdPath": "user.id",
            "entIdPath": "assetUserRole.userRole.id",
            "entKeyField": "entitlementID",
            "acctKeyField": "accountID"
          }
        }
      }
    }
  }
}
 
Here is the API response to get the correlation between accounts and entitlements:
[
    {
        "@baseType": null,
        "@schemaLocation": null,
        "@type": null,
        "assetUserRole": {
            "@baseType": null,
            "@schemaLocation": null,
            "@type": null,
            "manageableAsset": null,
            "userRole": {
                "@baseType": null,
                "@referredType": null,
                "@schemaLocation": null,
                "@type": null,
                "href": null,
                "id": 7,                        <----- This is the entitlement id
                "name": null
            }
        },
        "creationDate": "2023-01-20T09:50:35.7474Z",
        "description": null,
        "granter": {
            "@baseType": null,
            "@referredType": null,
            "@schemaLocation": null,
            "@type": null,
            "href": null,
            "id": null,
            "name": "arbor_dv",
            "role": null
        },
        "href": null,
        "id": 7,
        "privilege": null,
        "user": {
            "@baseType": null,
            "@referredType": null,
            "@schemaLocation": null,
            "@type": null,
            "href": null,
            "id": 1,                              <---- This is the account id
            "name": null,
            "role": null
        },
        "validFor": null
    },
...
]
 
Here are the relevant logs:
2023-05-23/20:30:34.868 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - Inside processAccountEntitlementParams*****
2023-05-23/20:30:34.871 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - inside processAccountEntitlementsByHttp
2023-05-23/20:30:34.928 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - Inside pullObjectsByRest
2023-05-23/20:30:34.928 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestUtilService - Got showLogs = true
2023-05-23/20:30:34.928 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - Calling Webservice Url - <url> with httpParams - null
2023-05-23/20:30:34.928 [{}] [quartzScheduler_Worker-1] DEBUG services.HttpClientUtilityService - isFipsEnabled = false
2023-05-23/20:30:34.928 [{}] [quartzScheduler_Worker-1] DEBUG services.HttpClientUtilityService - getHttpClient - sslParams : null
2023-05-23/20:30:34.928 [{}] [quartzScheduler_Worker-1] DEBUG services.HttpClientUtilityService - getHttpClient - proxyParams : null
2023-05-23/20:30:34.928 [{}] [quartzScheduler_Worker-1] DEBUG services.HttpClientUtilityService - getHttpClient - sslSocketFactory : null
2023-05-23/20:30:34.934 [{}] [quartzScheduler_Worker-1] DEBUG services.HttpClientUtilityService - getHttpClient - HttpClientBuilder.create().build() called.
2023-05-23/20:30:35.223 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestUtilService - Got showLogs = true
2023-05-23/20:30:35.224 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - Got Webservice API Response: [<removed response text since too long to keep in this post (format same as above)>, cookies:[], statusCode:200]
2023-05-23/20:30:35.224 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - pullObjectsByRest - responseStatusCode ::200
2023-05-23/20:30:35.224 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - Entered getResponseHeaders method
2023-05-23/20:30:35.225 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - responseError : null
2023-05-23/20:30:35.225 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - isAuthError: false
2023-05-23/20:30:35.225 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - pullObjectsByRest - responseMap.size : 1
2023-05-23/20:30:35.225 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - pullObjectsByRest - objectList.size : 10
2023-05-23/20:30:35.225 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-23/20:30:35.225 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - ACCKEY:1530148;ENTVALKEY:null
2023-05-23/20:30:35.225 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-23/20:30:35.225 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - ACCKEY:1530149;ENTVALKEY:null
2023-05-23/20:30:35.226 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-23/20:30:35.226 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - ACCKEY:1530150;ENTVALKEY:null
2023-05-23/20:30:35.226 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-23/20:30:35.226 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - ACCKEY:1530151;ENTVALKEY:null
2023-05-23/20:30:35.226 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-23/20:30:35.226 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - ACCKEY:1530152;ENTVALKEY:null
2023-05-23/20:30:35.226 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-23/20:30:35.226 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - ACCKEY:1530153;ENTVALKEY:null
2023-05-23/20:30:35.227 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-23/20:30:35.227 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - ACCKEY:1530154;ENTVALKEY:null
2023-05-23/20:30:35.227 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-23/20:30:35.227 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - ACCKEY:1530155;ENTVALKEY:null
2023-05-23/20:30:35.227 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-23/20:30:35.227 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - ACCKEY:1530156;ENTVALKEY:null
2023-05-23/20:30:35.227 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-23/20:30:35.227 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - ACCKEY:1530157;ENTVALKEY:null
2023-05-23/20:30:35.234 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - Inside deleteAccountEntitlementsByEntType
2023-05-23/20:30:35.237 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - Deletion of old Account_entitlements1 complete
2023-05-23/20:30:35.239 [{}] [quartzScheduler_Worker-1] DEBUG rest.RestProvisioningService - processAccountEntitlementParams complete..
12 REPLIES 12

SB
Saviynt Employee
Saviynt Employee

Can you try with the below format once. Please update the field values before using.

{
  "acctEntParams": {
    "processingType": "http",
    "acctKeyField": "accountID",
    "entTypes": {
      "Roles": {
        "entKeyField": "entitlementID",
        "call": {
          "call1": {
            "connection": "userAuth",
            "callOrder": 0,
            "stageNumber": 0,
            "http": {
              "httpHeaders": {
                "Authorization": "${access_token}"
              },
              "url": "https://",
              "httpContentType": "application/json",
              "httpMethod": "GET"
            },
            "listField": "result",
            "acctIdPath": "user.value",
            "entIdPath": "role.value"
            }
          }
        }
      }
    }
  }
}

 


Regards,
Sahil

JoshuaLawrence
New Contributor III
New Contributor III

Thanks for the reply, I tried this but still seem to get the same issue in the logs where the ACCKEY's are correct but the ENTKEY's are null. Maybe this is a data type issue? since when we import all the entitlements the id's are integers in the api response (different from accounts since the account id's are returned as strings in the api response)

This is what I tried with:

{
  "accountParams": {
    "connection": "userAuth",
    "createUsers": false,
    "adminName": "admin",
    "processingType": "SequentialAndIterative",
    "call": {
      "call1": {
        "callOrder": 0,
        "stageNumber": 0,
        "http": {
          "url": "<url>",
          "httpHeaders": {
            "Content-Type": "application/json",
            "Authorization": "${access_token}"
          },
          "httpContentType": "application/json",
          "httpMethod": "GET",
          "httpParams": {}
        },
        "listField": "",
        "keyField": "accountID",
        "colsToPropsMap": {
          "accountID": "userId~#~char",
          "name": "userId~#~char",
          "customproperty1": "givenName~#~char",
          "customproperty2": "familyName~#~char",
          "customproperty3": "id~#~char",
          "customproperty4": "department~#~char",
          "customproperty5": "loginPolicyGroupId~#~char",
          "customproperty6": "modifyUser~#~char",
          "customproperty8": "userRealmId~#~char",
          "customproperty10": "tenantId~#~char"
        }
      }
    }
  },
  "entitlementParams": {
    "connection": "userAuth",
    "processingType": "SequentialAndIterative",
    "entTypes": {
      "userRole": {
        "entTypeOrder": 0,
        "call": {
          "call1": {
            "callOrder": 0,
            "stageNumber": 0,
            "http": {
              "url": "<url>",
              "httpHeaders": {
                "Authorization": "${access_token}",
                "Content-Type": "application/json"
              },
              "httpContentType": "application/json",
              "httpParams": {},
              "httpMethod": "GET"
            },
            "listField": "",
            "keyField": "entitlementID",
            "colsToPropsMap": {
              "entitlementID": "userRole.id~#~char",
              "entitlement_value": "userRole.name~#~char"
            }
          }
        }
      }
    }
  },
  "acctEntParams": {
    "processingType": "http",
    "acctKeyField": "accountID",
    "entTypes": {
      "userRole": {
        "entKeyField": "entitlementID",
        "call": {
          "call1": {
            "connection": "userAuth",
            "callOrder": 0,
            "stageNumber": 0,
            "http": {
              "httpHeaders": {
                "Authorization": "${access_token}"
              },
              "url": "<url>",
              "httpContentType": "application/json",
              "httpMethod": "GET"
            },
            "listField": "",
            "acctIdPath": "user.id",
            "entIdPath": "assetUserRole.userRole.id"
          }
        }
      }
    }
  }
}

 

Hi @JoshuaLawrence ,

Please try using the below json 

{
  "accountParams": {
    "connection": "userAuth",
    "createUsers": false,
    "adminName": "admin",
    "processingType": "SequentialAndIterative",
    "call": {
      "call1": {
        "callOrder": 0,
        "stageNumber": 0,
        "http": {
          "url": "<url>",
          "httpHeaders": {
            "Content-Type": "application/json",
            "Authorization": "${access_token}"
          },
          "httpContentType": "application/json",
          "httpMethod": "GET",
          "httpParams": {}
        },
        "listField": "",
        "keyField": "accountID",
        "colsToPropsMap": {
          "accountID": "userId~#~char",
          "name": "userId~#~char",
          "customproperty1": "givenName~#~char",
          "customproperty2": "familyName~#~char",
          "customproperty3": "id~#~char",
          "customproperty4": "department~#~char",
          "customproperty5": "loginPolicyGroupId~#~char",
          "customproperty6": "modifyUser~#~char",
          "customproperty8": "userRealmId~#~char",
          "customproperty10": "tenantId~#~char"
        }
      }
    }
  },
  "entitlementParams": {
    "connection": "userAuth",
    "processingType": "SequentialAndIterative",
    "entTypes": {
      "userRole": {
        "entTypeOrder": 0,
        "call": {
          "call1": {
            "callOrder": 0,
            "stageNumber": 0,
            "http": {
              "url": "<url>",
              "httpHeaders": {
                "Authorization": "${access_token}",
                "Content-Type": "application/json"
              },
              "httpContentType": "application/json",
              "httpParams": {},
              "httpMethod": "GET"
            },
            "listField": "",
            "keyField": "entitlementID",
            "colsToPropsMap": {
              "entitlementID": "userRole.id~#~char",
              "entitlement_value": "userRole.name~#~char"
            }
          }
        }
      }
    }
  },
  "acctEntParams": {
    "entTypes": {
      "userRole": {
        "call": {
          "call1": {
            "processingType": "http",
            "connection": "userAuth",
            "http": {
              "httpHeaders": {
                "Authorization": "${access_token}"
              },
              "url": "<url>",
              "httpContentType": "application/json",
              "httpMethod": "GET"
            },
            "listField": "",
            "acctIdPath": "user.id",
            "entKeyField": "entitlementID",
            "acctKeyField": "accountID",
            "entIdPath": "assetUserRole.userRole.id"
          }
        }
      }
    }
  }
}

Thank you

Vedanth

Hi Vedanth thanks for the reply, I tried this and still get the same problem in the logs

share latest logs


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Here are the latest logs, thanks

 

2023-05-25/22:54:33.012 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - Calling Webservice Url - <url> with httpParams - null
2023-05-25/22:54:33.012 [{}] [quartzScheduler_Worker-4]  DEBUG services.HttpClientUtilityService - isFipsEnabled = false
2023-05-25/22:54:33.012 [{}] [quartzScheduler_Worker-4]  DEBUG services.HttpClientUtilityService - getHttpClient - sslParams : null
2023-05-25/22:54:33.012 [{}] [quartzScheduler_Worker-4]  DEBUG services.HttpClientUtilityService - getHttpClient - proxyParams : null
2023-05-25/22:54:33.012 [{}] [quartzScheduler_Worker-4]  DEBUG services.HttpClientUtilityService - getHttpClient - sslSocketFactory : null
2023-05-25/22:54:33.017 [{}] [quartzScheduler_Worker-4]  DEBUG services.HttpClientUtilityService - getHttpClient - HttpClientBuilder.create().build() called.
2023-05-25/22:54:33.142 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestUtilService - Got showLogs = true
2023-05-25/22:54:33.143 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - Got Webservice API Response: [headers:[<headers>], responseText:[{"@baseType":null,"@schemaLocation":null,"@type":null,"assetUserRole":{"@baseType":null,"@schemaLocation":null,"@type":null,"manageableAsset":null,"userRole":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":7,"name":null}},"creationDate":"2023-01-20T09:50:35.7474Z","description":null,"granter":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":null,"name":"arbor_dv","role":null},"href":null,"id":7,"privilege":null,"user":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":1,"name":null,"role":null},"validFor":null},{"@baseType":null,"@schemaLocation":null,"@type":null,"assetUserRole":{"@baseType":null,"@schemaLocation":null,"@type":null,"manageableAsset":null,"userRole":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":1,"name":null}},"creationDate":"2023-01-20T09:50:35.7474Z","description":null,"granter":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":null,"name":"arbor_dv","role":null},"href":null,"id":1,"privilege":null,"user":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":2,"name":null,"role":null},"validFor":null},{"@baseType":null,"@schemaLocation":null,"@type":null,"assetUserRole":{"@baseType":null,"@schemaLocation":null,"@type":null,"manageableAsset":null,"userRole":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":2,"name":null}},"creationDate":"2023-01-20T09:50:35.7474Z","description":null,"granter":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":null,"name":"arbor_dv","role":null},"href":null,"id":2,"privilege":null,"user":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":3,"name":null,"role":null},"validFor":null},{"@baseType":null,"@schemaLocation":null,"@type":null,"assetUserRole":{"@baseType":null,"@schemaLocation":null,"@type":null,"manageableAsset":null,"userRole":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":3,"name":null}},"creationDate":"2023-01-20T09:50:35.7474Z","description":null,"granter":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":null,"name":"arbor_dv","role":null},"href":null,"id":3,"privilege":null,"user":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":4,"name":null,"role":null},"validFor":null},{"@baseType":null,"@schemaLocation":null,"@type":null,"assetUserRole":{"@baseType":null,"@schemaLocation":null,"@type":null,"manageableAsset":null,"userRole":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":4,"name":null}},"creationDate":"2023-01-20T09:50:35.7474Z","description":null,"granter":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":null,"name":"arbor_dv","role":null},"href":null,"id":4,"privilege":null,"user":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":5,"name":null,"role":null},"validFor":null},{"@baseType":null,"@schemaLocation":null,"@type":null,"assetUserRole":{"@baseType":null,"@schemaLocation":null,"@type":null,"manageableAsset":null,"userRole":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":5,"name":null}},"creationDate":"2023-01-20T09:50:35.7474Z","description":null,"granter":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":null,"name":"arbor_dv","role":null},"href":null,"id":5,"privilege":null,"user":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":6,"name":null,"role":null},"validFor":null},{"@baseType":null,"@schemaLocation":null,"@type":null,"assetUserRole":{"@baseType":null,"@schemaLocation":null,"@type":null,"manageableAsset":null,"userRole":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":8,"name":null}},"creationDate":"2023-01-20T09:50:35.7474Z","description":null,"granter":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":null,"name":"arbor_dv","role":null},"href":null,"id":8,"privilege":null,"user":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":7,"name":null,"role":null},"validFor":null},{"@baseType":null,"@schemaLocation":null,"@type":null,"assetUserRole":{"@baseType":null,"@schemaLocation":null,"@type":null,"manageableAsset":null,"userRole":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":6,"name":null}},"creationDate":"2023-01-20T09:50:35.7474Z","description":null,"granter":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":null,"name":"arbor_dv","role":null},"href":null,"id":6,"privilege":null,"user":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":8,"name":null,"role":null},"validFor":null},{"@baseType":null,"@schemaLocation":null,"@type":null,"assetUserRole":{"@baseType":null,"@schemaLocation":null,"@type":null,"manageableAsset":null,"userRole":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":1,"name":null}},"creationDate":"2023-01-20T10:13:21.726Z","description":null,"granter":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":null,"name":"optimaadmin","role":null},"href":null,"id":9,"privilege":null,"user":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":9,"name":null,"role":null},"validFor":null},{"@baseType":null,"@schemaLocation":null,"@type":null,"assetUserRole":{"@baseType":null,"@schemaLocation":null,"@type":null,"manageableAsset":null,"userRole":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":7,"name":null}},"creationDate":"2023-05-05T21:48:08.488154Z","description":null,"granter":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":null,"name":"kenan","role":null},"href":null,"id":15,"privilege":null,"user":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":16,"name":null,"role":null},"validFor":null},{"@baseType":null,"@schemaLocation":null,"@type":null,"assetUserRole":{"@baseType":null,"@schemaLocation":null,"@type":null,"manageableAsset":null,"userRole":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":1,"name":null}},"creationDate":"2023-05-24T18:10:10.562705Z","description":null,"granter":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":null,"name":"kenan","role":null},"href":null,"id":17,"privilege":null,"user":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":38,"name":null,"role":null},"validFor":null},{"@baseType":null,"@schemaLocation":null,"@type":null,"assetUserRole":{"@baseType":null,"@schemaLocation":null,"@type":null,"manageableAsset":null,"userRole":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":5,"name":null}},"creationDate":"2023-05-24T20:06:59.101834Z","description":null,"granter":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":null,"name":"kenan","role":null},"href":null,"id":20,"privilege":null,"user":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":53,"name":null,"role":null},"validFor":null},{"@baseType":null,"@schemaLocation":null,"@type":null,"assetUserRole":{"@baseType":null,"@schemaLocation":null,"@type":null,"manageableAsset":null,"userRole":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":6,"name":null}},"creationDate":"2023-05-24T19:56:22.364956Z","description":null,"granter":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":null,"name":"kenan","role":null},"href":null,"id":19,"privilege":null,"user":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":53,"name":null,"role":null},"validFor":null},{"@baseType":null,"@schemaLocation":null,"@type":null,"assetUserRole":{"@baseType":null,"@schemaLocation":null,"@type":null,"manageableAsset":null,"userRole":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":5,"name":null}},"creationDate":"2023-05-25T22:53:48.90077Z","description":null,"granter":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":null,"name":"kenan","role":null},"href":null,"id":23,"privilege":null,"user":{"@baseType":null,"@referredType":null,"@schemaLocation":null,"@type":null,"href":null,"id":56,"name":null,"role":null},"validFor":null}], cookies:[], statusCode:200]
2023-05-25/22:54:33.143 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - pullObjectsByRest - responseStatusCode ::200
2023-05-25/22:54:33.143 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - Entered getResponseHeaders method
2023-05-25/22:54:33.143 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - responseError : null
2023-05-25/22:54:33.143 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - isAuthError: false
2023-05-25/22:54:33.143 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - pullObjectsByRest - responseMap.size : 1
2023-05-25/22:54:33.143 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - pullObjectsByRest - objectList.size : 14
2023-05-25/22:54:33.143 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - Decrementing connectionParamMap.refreshTryCount : 0
2023-05-25/22:54:33.144 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-25/22:54:33.144 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - ACCKEY:1530177;ENTVALKEY:null
2023-05-25/22:54:33.144 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-25/22:54:33.144 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - ACCKEY:1530178;ENTVALKEY:null
2023-05-25/22:54:33.144 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-25/22:54:33.144 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - ACCKEY:1530179;ENTVALKEY:null
2023-05-25/22:54:33.144 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-25/22:54:33.144 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - ACCKEY:1530180;ENTVALKEY:null
2023-05-25/22:54:33.144 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-25/22:54:33.144 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - ACCKEY:1530181;ENTVALKEY:null
2023-05-25/22:54:33.145 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-25/22:54:33.145 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - ACCKEY:1530182;ENTVALKEY:null
2023-05-25/22:54:33.145 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-25/22:54:33.145 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - ACCKEY:1530183;ENTVALKEY:null
2023-05-25/22:54:33.145 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-25/22:54:33.145 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - ACCKEY:1530184;ENTVALKEY:null
2023-05-25/22:54:33.145 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-25/22:54:33.145 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - ACCKEY:1530185;ENTVALKEY:null
2023-05-25/22:54:33.145 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-25/22:54:33.145 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - ACCKEY:1530186;ENTVALKEY:null
2023-05-25/22:54:33.145 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-25/22:54:33.145 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - ACCKEY:1530196;ENTVALKEY:null
2023-05-25/22:54:33.145 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-25/22:54:33.145 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - ACCKEY:1530102;ENTVALKEY:null
2023-05-25/22:54:33.146 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-25/22:54:33.146 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - ACCKEY:1530102;ENTVALKEY:null
2023-05-25/22:54:33.146 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-05-25/22:54:33.146 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - ACCKEY:1530461;ENTVALKEY:null
2023-05-25/22:54:33.152 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - Inside deleteAccountEntitlementsByEntType 
2023-05-25/22:54:33.155 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - Deletion of old Account_entitlements1 complete
2023-05-25/22:54:33.157 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - processAccountEntitlementParams complete..
2023-05-25/22:54:33.157 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - calling processEntitlementOwnerParams - memento.entTypesSet : [199]
2023-05-25/22:54:33.157 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - Inside processEntitlementOwnerParams*****
2023-05-25/22:54:33.157 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - processEntitlementOwnerParams complete..
2023-05-25/22:54:33.157 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - Enter cleanUpDeletedLinks
2023-05-25/22:54:33.157 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - Inside cleanUpEntitlement2ByEntType 
2023-05-25/22:54:33.158 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - Entitlements2 deleteQuery = select e2.ENT2KEY from Entitlements2 e2 inner join Entitlement_values ev1 on e2.ENTITLEMENT_VALUE1KEY=ev1.ENTITLEMENT_VALUEKEY inner join Entitlement_values ev2 on e2.ENTITLEMENT_VALUE2KEY=ev2.ENTITLEMENT_VALUEKEY inner join Entitlement_types et1 on ev1.ENTITLEMENTTYPEKEY=et1.ENTITLEMENTTYPEKEY inner join Entitlement_types et2 on ev2.ENTITLEMENTTYPEKEY=et2.ENTITLEMENTTYPEKEY where et1.ENTITLEMENTTYPEKEY in(199) and et2.ENTITLEMENTTYPEKEY in(199) and (e2.JOB_ID is not null and e2.JOB_ID <> '797259')
2023-05-25/22:54:33.163 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - Inside cleanUpEntitlementMapLink 
2023-05-25/22:54:33.163 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - EntitlementMap deleteQuery = select emap.ENTITLEMENT_VALUE1KEY, emap.ENTITLEMENT_VALUE2KEY from EntitlementMap emap inner join Entitlement_values ev1 on emap.ENTITLEMENT_VALUE1KEY = ev1.ENTITLEMENT_VALUEKEY inner join Entitlement_values ev2 on emap.ENTITLEMENT_VALUE2KEY = ev2.ENTITLEMENT_VALUEKEY inner join Entitlement_types et1 on ev1.ENTITLEMENTTYPEKEY = et1.ENTITLEMENTTYPEKEY inner join Entitlement_types et2 on ev2.ENTITLEMENTTYPEKEY = et2.ENTITLEMENTTYPEKEY where et1.ENTITLEMENTTYPEKEY in(199) and et2.ENTITLEMENTTYPEKEY in(199) and emap.JOB_ID is not null and emap.JOB_ID <> '797259'
2023-05-25/22:54:33.169 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - Inside cleanUpEntMappingInfoField 
2023-05-25/22:54:33.169 [{}] [quartzScheduler_Worker-4]  DEBUG rest.RestProvisioningService - Entitlements Mapping InfoField deleteQuery = update entitlement_values ev inner join entitlement_types et on ev.ENTITLEMENTTYPEKEY = et.ENTITLEMENTTYPEKEY set entitlementMappingJson = null where et.ENDPOINTKEY = 86

 

Hi,

any update on this one?

JoshuaLawrence
New Contributor III
New Contributor III

Hi guys,

we are still dealing with this issue, anything else we can try?

Thanks!

SB
Saviynt Employee
Saviynt Employee

To be certain, Can you confirm if

1. we only have 1 api url that gives all the information - Accounts/Entitlements and Acc to ENT mapping or are these 3 separate urls.

2. The account and entitlements have been imported successfully individually. 


Regards,
Sahil

JoshuaLawrence
New Contributor III
New Contributor III

1. yes we only have the one api call that gives all the account to entitlement mappings

2. yes the accounts and entitlements have been imported successfully, and I have checked that the accountID's and entitlementID's are correct

also one thing to note, we have multiple entitlements with the same ID's but they are in different endpoints so I don't think this should affect the mapping?

thanks

I wanted to check if this is still an issue or was it fixed.


Regards,
Sahil

JoshuaLawrence
New Contributor III
New Contributor III

Hi Sahil,

Yes this is still an issue, we are currently working with Saviynt Support to investigate as it seems our syntax is correct but not working as expected

Thanks