ARTICLES MASTER CREATION IN CCO MANAGER SLOW FROM S4 THROUGH STANDARD API

[ThoulathKhan]

Hello,

Articles master creation in the CCO MANAGER IS VERY SLOW WITH A RATE OF MERELY 600-1000 per hour. We are trying to do bulk insert through API from S4. It's taking quite a lot of time. Please advise the Needful.

Thanks.

[former_member280904]

Hi Thoulath,

please check two points in your system: The limit for the inbound queue and the number of articles that are sent in per call.

Limit of inbound queue

Via the table "MASTER_DATA_CONFIGURATION", the number of entries that the queue allows can be increased. Initially, it is set to 1.000, you can increase it to 10.000 and beyond, dependent on your system capacities.

Type 0 is Material, 1 is Customer, 2 is Gift card, 3 is Server user, 4 is Stock transactions. To increase the limit, change the field "MAX_QUEUE_SIZE".

Improved thoughput

Consider to send several articles per HTTP inbound call to CCOm for article upload. Initially, only one article per call has been sent, resulting into 40.000 calls and a lot of overhead in the processing. The system processes best a batch of articles that are provided in one call. For that, you can increase the number of articles per call. Use a batch of 100 as a starting point and increase if needed to reach a good result.

The same we did in your system with very acceptable results.

Best regards,
Armin

[former_member244182]

Hi Armin

I will thank you for this comment if you have the SQL query, could you provide it to me.

Regards

[anderson_schmitt]

Hi Thoulath,

1 - What is the version (FP and PL) of the SAP Customer Checkout manager?
2 - Which is your the DB system? MS SQL Server or SAP HANA?
3 - Which tool is used to synchronize the Articles via API? Swagger, Postman, SoapUI, etc...?
4 - What are the server specifications? Processor, Memory, etc...
5 - How many articles are sent through the API?
6 - What is the version of the Apache Tomcat?
7 - How much memory is allocated for the Java under the Apache Tomcat settings?

Another option to synchronize articles and customers from the S4 system to the CCO manager is the SOAP Services.
Did you try to use the SOAP services instead of using the API?
Refer to the KBA ##3132855 for additional information.

Regards,
Anderson

[ThoulathKhan]

1- FP 12 PL09

2- MSSQL

3- FROM CPI THROUGH API (STANDARD) VIA SWAGGER

4- MEMORY IS MORE THAN SUFFIECIENT BECAUSE CPU WAS AROUND 24% AND MEMORY WAS AROUND 15% OCCUPIED DURING THE TRANSFER.

24 GB MEMORY & INTEL XEON SILVER PROCESSOR 4208

5- NEARLY 40000 ARTICLES BUT IN BATCHES. LIKE 1000-2000, 2000-5000 PER BATCH.

6- 9.0.45

7- Initial Memory pool 1024 MB and Maximum Memory pool 4096 MB

NOT THROUGH SOAPUI BECAUSE WE ARE DOING IT THROUGH MIDDLEWARE(CPI) ONLY FROM S4

[anderson_schmitt]

Hi thoulathkhans

what is the version and edition of your MS SQL Server?
E.g.: MS SQL Server 2019 Standard

Regards,
Anderson

[ThoulathKhan]

Hi Anderson,

MSSQL Version is 2015.

Thanks & Regards,

Thoulath Khan S