Azure Access Import Job is failing with "Incorrect string value: '\xF0\x9D\x97\x96\xF0\x9D."

[AravindK]

Hi Team,
We are observing one issue after upgrading into latest version in 5.5Spx .
Azure Access import job is failing with below error :

Incorrect string value: '\xF0\x9D\x97\x96\xF0\x9D...' for column 'DESCRIPTION' at row 1 . We tried to check in the logs but we can see the below logs but nothing else like why it is coming and for which group it is throwing an error.

2023-09-28 20:05:00,505 [quartzScheduler_Worker-14] DEBUG generic.GenericProvisioningService - INFO ErEx: processAADGroupList:persistObjects : Incorrect string value: '\xF0\x9D\x97\x96\xF0\x9D...' for column 'DESCRIPTION' at row 1

We have seen couple of forums for already for the same issue but they are for Coloumn 'Entitlement_value' and not for DESCRIPTION.

Do we need to apply the fix as per the below forum or for Coloumn DESCRIPTION if we have another solution.

https://forums.saviynt.com/t5/application-access-governance/azure-ad-access-recon-failing/m-p/23969

[naveenss]

Hi @AravindK 

This is a change that has to be made at the DB level since I'm suspecting that the values have special characters in it. 

Please contact the Saviynt support team to troubelshoot and fix this further. 

[DixshantValecha]

Hi @AravindK,

Please use the Freshservice link for contacting Saviynt support.

Link:-https://saviyntsupport.saviynt.com