Entitlments not getting imported after running the EntitlementImport job for DB Application

[RizvanaShaik]

HI Team ,

we are not able to import the entitlement type and entitlements while doing the entitlement value import for DB application 

please suggest if am missing anything 

below are the part of error we are facing after  running the job 

"2024-08-28T12:31:53.921+00:00","ecm-worker","saviynt.EntitlementValueImportService","quartzScheduler_Worker-9-dvxd7","DEBUG","skipping insert/update as entitlement_types NOT FOUNDGROUPS_ApplicationName"
"2024-08-28T12:31:53.921+00:00","ecm-worker","saviynt.EntitlementValueImportService","quartzScheduler_Worker-9-dvxd7","DEBUG","Batch execution completed for adding/ updating entitlements"

Thanks

Rizvana Shaik

[rushikeshvartak]

• Please share ent xml

[RizvanaShaik]

Please Find the below shared ENTITLEMENTVALUEIMPORT

<dataMapping>

<sql-query description="This is the Source DB Query">
<![CDATA[

select '<ApplicationName>' as secSysName, '<ApplicationName>' as endpointName, 'Role' as entType, '1' as status, ULUSER from <table_name> where ULUGRP = '*GROUP'

]]>
</sql-query>
<mapper description="This is the mapping field for Saviynt Field name">
<mapfield saviyntproperty="securitysystems.systemname" sourceproperty="secSysName" type="character"></mapfield>
<mapfield saviyntproperty="endpoints.endpointname" sourceproperty="endpointName" type="character"></mapfield>
<mapfield saviyntproperty="entitlementtypes.entitlementname" sourceproperty="entType" type="character"></mapfield>
<mapfield saviyntproperty="entitlementvalues.entitlement_value" sourceproperty="ULUSER" type="character"></mapfield>
<mapfield saviyntproperty="entitlementvalues.entitlementID" sourceproperty="ULUSER" type="character"></mapfield>
<mapfield saviyntproperty="entitlementvalues.entitlement_glossary" sourceproperty="ULUSER" type="character"></mapfield>
<mapfield saviyntproperty="entitlementvalues.status" sourceproperty="status" type="number"></mapfield>
</mapper>

</dataMapping>

[rushikeshvartak]

Does above query works in database ? If yes share screenshot of output

[stalluri]

@RizvanaShaik 
Can you share the output of the data on DB if you use the query?

<dataMapping>

<sql-query description="This is the Source DB Query">

<![CDATA[

Use XXXXXX //Databasename

select '<ApplicationName>' as secSysName, '<ApplicationName>' as endpointName, 'Role' as entType, '1' as status, ULUSER as UlUser  from <table_name> where ULUGRP = '*GROUP'

]]>

</sql-query>

<mapper description="This is the mapping field for Saviynt Field name">

<mapfield saviyntproperty="securitysystems.systemname" sourceproperty="secSysName" type="character"></mapfield>

<mapfield saviyntproperty="endpoints.endpointname" sourceproperty="endpointName" type="character"></mapfield>

<mapfield saviyntproperty="entitlementtypes.entitlementname" sourceproperty="entType" type="character"></mapfield>

<mapfield saviyntproperty="entitlementvalues.entitlement_value" sourceproperty="UlUser" type="character"></mapfield>

<mapfield saviyntproperty="entitlementvalues.entitlementID" sourceproperty="UlUser" type="character"></mapfield>

<mapfield saviyntproperty="entitlementvalues.entitlement_glossary" sourceproperty="UlUser" type="character"></mapfield>

<mapfield saviyntproperty="entitlementvalues.status" sourceproperty="status" type="number"></mapfield>

</mapper>

</dataMapping>

[NM]

Hi @RizvanaShaik , create an entitlement type with name Role in the endpoint and then give it a shot.