Azure AD Access Recon failing

[tej2099]

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.

[DaanishJawed]

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.

[rushikeshvartak · Accepted solution]

This is regarding specical character in description right smiley chars 

[DaanishJawed · Accepted solution]

Hi Rushikesh,

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

[tej2099]

Thank you, Rushikesh!

[tej2099]

Thank you, Daanish!