SqlError: error while parsing protocol: invalid communication buffer structure

[satya-dev]

Hi Experts,

I am getting error in below sql while passing more than 1k records in clause.

let inStringData = '1', '2', '3', '4', '5',.............'1000'.  

let extractioItems = await tx.run( `SELECT et.* FROM MyTable_Head et LEFT JOIN MyTable_Items ei ON et.col1 = ei.col1 AND et.col2 = ei.col2 WHERE et.col1 = '${req.data.col1}' AND ei.col3 is NULL AND et.col2 in ( ${inStringData } )`
)

detailed exception:-
Error _fnAddWorkbenchDb [SqlError: error while parsing protocol: invalid communication buffer structure] {
2022-06-10T08:16:56.571+0000 [APP/PROC/WEB/0] OUT code: 1033,
2022-06-10T08:16:56.571+0000 [APP/PROC/WEB/0] OUT sqlState: 'HY000',
2022-06-10T08:16:56.571+0000 [APP/PROC/WEB/0] OUT level: 1,
2022-06-10T08:16:56.571+0000 [APP/PROC/WEB/0] OUT position: 0,
2022-06-10T08:16:56.571+0000 [APP/PROC/WEB/0] OUT query: 'SELECT et.*        n' +
2022-06-10T08:16:56.571+0000 [APP/PROC/WEB/0] OUT '                FROM MyTable_Head etn' +
2022-06-10T08:16:56.571+0000 [APP/PROC/WEB/0] OUT '                LEFT JOIN MyTable_Items ei ON et.col1 = ei.col1 AND et.col2 = ei.col2' +
2022-06-10T08:16:56.571+0000 [APP/PROC/WEB/0] OUT "                 WHERE et.col1 = '001137'n" +
2022-06-10T08:16:56.571+0000 [APP/PROC/WEB/0] OUT '                 AND ei.col3 is NULLn' +
2022-06-10T08:16:56.572+0000 [APP/PROC/WEB/0] OUT "                 AND et.col2 in ('1', '2', '3', '4'............'1000')"
2022-06-10T08:16:56.572+0000 [APP/PROC/WEB/0] OUT }

but same query working for small number of records.

I found below link, but it is not helpful.

https://github.com/SAP/node-hdb/issues/19

I am usign CAP model and deployed in BTP.

[LuizGomes]

.....news?

[AdrianDBorja]

This issue is still happening, surprised no one has replied so far after a year