Unable to Import associations between Master and Derived SAP Roles

[Pravallika_t]

Hello Team,

We are trying to Integrate Saviynt with SAP ECC instance. All the Entitlements are getting imported properly (SAP Roles, TCodes, Profiles etc).

we have used below tables for Accounts and entitlements Import in the mentioned sequence:

USR02, TSTC, TSTCT, AGR_AGRS, AGR_TEXTS, AGR_DEFINE, AGR_USERS, AGR_TCODES, USORG, AGR_1252, AGR_1251

But we are not getting the associations between master and derived SAP Roles which are defined in AGR_DEFINE table in target SAP Instance

Please let us know how to import the associations? or What we are doing.

Thanks &Regards,

Pravallika Taniparthy

[rushikeshvartak]

Did you trying running only AGR_DEFINE

[Pravallika_t]

Yes I did but I couldn't find the associations as in the target SAP Instance

Thanks & regards,

Pravallika Taniparthy

[rushikeshvartak]

Share logs and job configs screenshots 

[Pravallika_t]

Hello Rushikesh,

Please find the attached logs and job configurations

Thanks & Regards,

Pravallika Taniparthy

[rushikeshvartak]

As per logs data is getting pulled 

"2024-08-02T14:45:21.358+00:00","ecm-worker","integration.SapDataImportService","quartzScheduler_Worker-2-2rf5n","DEBUG","Extracting 150000 rows from SAP for table - AGR_DEFINE starting at 150000 row "
"2024-08-02T14:45:21.358+00:00","ecm-worker","integration.SapDataImportService","quartzScheduler_Worker-2-2rf5n","DEBUG","SecuritySystem jobid - 2180225, tableName-AGR_DEFINE, updatedTableName-AGR_DEFINE"
"2024-08-02T14:45:21.358+00:00","ecm-worker","integration.SapDataImportService","quartzScheduler_Worker-2-2rf5n","DEBUG","Setting GET_SORTED Import parameter to X"
"2024-08-02T14:45:21.358+00:00","ecm-worker","integration.SapDataImportService","quartzScheduler_Worker-2-2rf5n","DEBUG","Not setting USE_ET_DATA_4_RETURN Import parameter to X"
"2024-08-02T14:45:21.358+00:00","ecm-worker","integration.SapDataImportService","quartzScheduler_Worker-2-2rf5n","DEBUG","Calling SAP Function"
"2024-08-02T14:45:21.473+00:00","ecm-worker","integration.SapDataImportService","quartzScheduler_Worker-2-2rf5n","DEBUG","SAP Function Execution time in milliseconds: 115"
"2024-08-02T14:45:21.473+00:00","ecm-worker","integration.SapDataImportService","quartzScheduler_Worker-2-2rf5n","DEBUG","Retrieving output data from DATA table"
"2024-08-02T14:45:21.473+00:00","ecm-worker","integration.SapDataImportService","quartzScheduler_Worker-2-2rf5n","DEBUG","No data retrieved from SAP for the SecuritySystem , table AGR_DEFINE jobid - 2180225"

[Pravallika_t]

Hello Rushikesh,

Where exactly the data from AGR_DEFINE will be stored in Saviynt?

Thanks & Regards,

Pravallika Taniparthy

[rushikeshvartak]

entitlement_values