This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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

JoshuaLawrence
New Contributor III
New Contributor III

‎05/23/2023 02:09 PM

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..
0 Kudos
12 REPLIES 12

SB
Saviynt Employee
Saviynt Employee

‎05/24/2023 08:42 AM

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
0 Kudos

JoshuaLawrence
New Contributor III
New Contributor III

‎05/24/2023 03:41 PM

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"
          }
        }
      }
    }
  }
}

 

0 Kudos

Vedanth_BK
Saviynt Employee
Saviynt Employee
In response to JoshuaLawrence

‎05/25/2023 12:19 AM

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

0 Kudos

JoshuaLawrence
New Contributor III
New Contributor III
In response to Vedanth_BK

‎05/25/2023 03:50 PM

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

0 Kudos

rushikeshvartak
All-Star
All-Star
In response to JoshuaLawrence

‎05/25/2023 03:53 PM

share latest logs


Regards,
Rushikesh Vartak
If the response is helpful, please click Accept As Solution and kudos it.
0 Kudos

JoshuaLawrence
New Contributor III
New Contributor III
In response to rushikeshvartak

‎05/25/2023 04:08 PM - edited ‎05/25/2023 04:10 PM

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

 

0 Kudos

JoshuaLawrence
New Contributor III
New Contributor III
In response to rushikeshvartak

‎05/30/2023 02:12 PM

Hi,

any update on this one?

0 Kudos

JoshuaLawrence
New Contributor III
New Contributor III

‎06/07/2023 11:21 AM

Hi guys,

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

Thanks!

0 Kudos

SB
Saviynt Employee
Saviynt Employee

‎06/08/2023 10:03 AM - edited ‎06/08/2023 10:04 AM

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
0 Kudos

JoshuaLawrence
New Contributor III
New Contributor III
In response to SB

‎06/09/2023 08:59 AM - edited ‎06/09/2023 10:20 AM

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

0 Kudos

SB
Saviynt Employee
Saviynt Employee
In response to JoshuaLawrence

‎07/19/2023 08:36 AM

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


Regards,
Sahil
0 Kudos

JoshuaLawrence
New Contributor III
New Contributor III
In response to SB

‎07/19/2023 09:10 AM

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

Copyright © 2023 Khoros, LLC