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