04/10/2023 05:41 AM
Hi team,
I'm facing this error while entitlement import from the DB connection.
Query:
<dataMapping> <before-import> </before-import> <sql-query description="This is the Source DB Query">
<![CDATA[SELECT 'Oracle DB HRDEV' as securitysystem,'Oracle DB HRDEV' as endpoint,'memberOf' as enttype,PK_EPKID as entname,1 as status from EP_DB_ROLES]]>
</sql-query> <mapper description="This is the mapping field for SAviynt Field name" deleteentitlementowner="true">
<mapfield saviyntproperty="securitysystems.systemname" sourceproperty="securitysystem" type="character"></mapfield>
<mapfield saviyntproperty="endpoints.endpointname" sourceproperty="endpoint" type="character"></mapfield>
<mapfield saviyntproperty="entitlementtypes.entitlementname" sourceproperty="enttype" type="character"></mapfield>
<mapfield saviyntproperty="entitlementvalues.entitlement_value" sourceproperty="entname" type="character"></mapfield>
<mapfield saviyntproperty="entitlementvalues.displayname" sourceproperty="displayname" type="character"></mapfield>
<mapfield saviyntproperty="entitlementvalues.status" sourceproperty="status" type="character"></mapfield>
</mapper>
<after-import description="EMAIL,BATCH,SQL"> </after-import> </dataMapping>
Please let me know what I'm missing.
Regards,
Gopi.
Solved! Go to Solution.
04/10/2023 07:58 AM
Hi Gopi,
Can you please make below change for status in the mapper (instead of character , try type ="number" ) and try again.
04/10/2023 09:38 AM
Hi @dgandhi
It's working after the type changes to a number. Thank you so much for helping.
Thanks,
Gopi.