socket hang up timeout error with m3api-rest v2 bulk API

Hello,

I'm facing a peculiar issue with the m3api-rest v2 bulk API returning a status 504 error.
I'm trying to perform a bulk request with 40 transactions of OIS100MI/AddLineBatchEnt.
It returns the following error after 5 mins of processing - "Request aborted after target server failed to respond within the configured timeout of 300000 milliseconds (actual 300001)".

1) If I try with a smaller batch of 20 transactions, it completes processing in around 3 minutes. The bulk API usually processes a bigger number of requests in less time. Is this an issue with the OIS100MI/AddLineBatchEnt API?

2) Is there a way to increase this gateway timeout period for this bulk API?

I have attached my sample JSON request below. Thanks!

Request Body:

{
"program": "OIS100MI",
"cono": 780,
"divi": "",
"excludeEmptyValues": false,
"maxReturnedRecords": 0,
"transactions": [
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] },
{ "transaction": "AddLineBatchEnt", "record": { "CONO": 780, "ORNO": "0010000522", "ORQT": "1", "ITNO": "BAG001", "WHLO": "500", "LTYP": 0 }, "selectedColumns": ["PONR"] }
]
}

Find more posts tagged with

ION API Gateway

Accepted answers

All comments

sean-scanlon

One of the more frustrating aspects of the bulk MI. It does seem to have odd performance problems. Try EVS100 instead perhaps?

My guess is that the order line updates for the same order cause some race conditions / thrashing / db locks to slow things down.

Rene Bottern

I have been running Bulk Requests that takes over 20 minutes (adding > 50 000 lines to a Price List) without any problem, but I use the 'ExecuteSnd' Bulk API.
Not sure if this is the one you're using above as well.

Santhosh CP

Hello! Thanks for suggesting EVS100. I will check if it supports fully API-based data loading like the bulk MI.

Santhosh CP

Hello! I was previously using the execute endpoint. I switched to the executeSnd but unfortunately I'm facing the same issue. It gets timed out at exactly 5 minute mark.

Rene Bottern

Would you mind letting me know from where (application) you are trying this call?
I have done this successfully from Excel using VBA (REST) as an example.

Santhosh CP

So far I have tried it directly in ION API and in Postman

Copyright © 2025 Infor. All rights reserved.