Employee Master data full load using compound employee API

[former_member60331]

Hi Experts,

I am using synchronous SOAP scenario to fetch employee master data using Compound Employee API.

I want to test full load using SOAP UI for which I have increased the time limit in SOAP UI, however, I am receiving the below error in CPI -

If i don't increase the time limit in SOAP UI, I receive the below error -

Can someone please help me resolve this issue and help me test this service from SOAP UI.

Regards,

Akash

[Sriprasadsbhat]

Hello Akash,

If you have already taken below performance improvement points as per your design then it might be issue with SFSF API server ( you can raise a ticket to SAP as per my understanding ).

1) Looping Process Call used correctly.

2) Content Enrichers are optimized as per the blog mentioned in above thread ( even you can think of usage of Hashmap ).

3) Proper pagination done and filters are applied correctly.

4) sessions are reused as per the SAP Help provided above.

Hope this helps.

Regards,

Sriprasad Shivaram Bhat

[former_member60331]

Hello sriprasadshivaramabhat,

Thank you for the reply and suggestion.

I have raised a ticket to SAP for the same.

FYI- the same error does not occur when i the change the page size from 400 to 100, however, the amount to time taken for full has increased to a great extend. Earlier it was 22 mins and now it is 1hr 57 mins.

Regards,

Akash

[Sriprasadsbhat]

Hello Akash,

First try to query Compound Employee and see how much time its taking.Then follow blog to see how to improvise performance of the Enricher and I suspect most of your processing time is consumed in Content Enricher.

https://blogs.sap.com/2019/11/08/handling-large-data-with-content-enricher-and-odata-v2-adapter/

Regards,

Sriprasad Shivaram Bhat

[former_member60331]

Hi sriprasadshivaramabhat,

I have tried with compound employee API and it takes around 3 mins for the full load. However, CE API alone does not suffices the requirement and that why we have to use content enricher.

I am ok with the processing time, but how should we make sure that if will not give broken pipe or the connection reset error.

I tested in on 30th last and it was working fine but today it is giving these error.

Regards,

Akash

[former_member60331]

Hi sriprasadshivaramabhat,

Thank you for the reply.

I am using looping call in my flow still I am getting this error.

Please check the screenshots below -

Iflow -

Looping call -

SuccessFactors SOAP adapter -

There are around 29k employees in the system. For single employee it is taking around 30 sec to receive the response in SOAP UI.

Can you please suggest what else can be done here.

Regards,

Akash

[Sriprasadsbhat]

Hello Akash,

If you are having large no of employees ( from EC Side ),try to use Looping Process Call then you should be able to get the data quicker.Also try to follow recommendations on Server Paging and snapshot modes.

https://help.sap.com/viewer/5bb9a5b997a843c88e769a105e4af4d4/1911/en-US/8745b9b76d1049c18850f1250213...

Regards,

Sriprasad Shivaram Bhat

[RaviRIyer]

Where is this variable defined S{property.SAP_SuccessFactorsHasMoreRecords.EC.SuccessFactors_CE} contains 'true' ? or is it a dynamic option - can i get some more details on this ?

[Gryphon]

Incidentally the above help link is also not found

[RaviRIyer]

figured out the variable...the link is still 404. 

[RaviRIyer]

Resolved