Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Azure AD Access Recon failing

tej2099
New Contributor III
New Contributor III

Hi,

We are running access recon for Azure AD which is failing with the error:

 "Incorrect string value: '\xF0\x9F\x93\xA2' for column 'ENTITLEMENT_VALUE' at row 1".

PFB  ENTITLEMENT_ATTRIBUTE used in connection

{
"entitlementAttribute": {
"AADGroup": {
"colsToPropsMap": {
"entitlementID": "id~#~char",
"entitlement_value": "displayName~#~char",
"customproperty1": "deletionTimestamp~#~char",
"customproperty2": "description~#~char",
"customproperty5": "dirSyncEnabled~#~char",
"customproperty6": "lastDirSyncTime~#~char",
"customproperty7": "mail~#~char",
"customproperty8": "mailEnabled~#~char",
"customproperty9": "onPremisesSecurityIdentifier~#~char",
"customproperty10": "securityEnabled~#~char",
"customproperty11": "groupTypes~#~listAsString",
"customproperty12": "membershipRule~#~char",
"customproperty13": "membershipRuleProcessingState~#~char",
"customproperty16": "resourceProvisioningOptions~#~char"
}
},
"SKU": {
"colsToPropsMap": {
"entitlementID": "skuId~#~char",
"entitlement_value": "skuPartNumber~#~char",
"customproperty1": "appliesTo~#~char",
"customproperty2": "capabilityStatus~#~char",
"customproperty5": "consumedUnits~#~char",
"customproperty7": "prepaidUnits~#~listAsString"
}
}
}
}

Do let me know if any additional information is required. thanks.

5 REPLIES 5

DaanishJawed
Saviynt Employee
Saviynt Employee

Hi Tej,

This is a known issue which has been fixed as part of the JIRA - CONN-209.

There is a config change (Insert Query) which is required to be made in the DB to fix this.

Please raise a support ticket for the same.

Thanks.

This is regarding specical character in description right smiley chars 


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

Hi Rushikesh,

Yes that's correct. This is w.r.t the special characters.

Thank you, Rushikesh!

tej2099
New Contributor III
New Contributor III

Thank you, Daanish!