This document describes the maximum amount of Data than can be processed through an Intelligent Contact Management (ICM) Message Delivery Service (MDS) Message and the architecture behind it.
When performing Database lookups with ICM (using dbworker.exe as the process to provide the interface between Router and the external Database), there is a maximum amount of Data than can be processed through a MDS Message.
The total amount of structured query language (SQL) Response data + db worker process (DBW) Response header cannot exceed 4096 bytes. This is a hardcoded limit for a MDS message.
The information in this document is based on ICM version 11.6
If too much data was returned to dbw from SQL Server, and dbw cannot pass it to the router (RTR), an error condition is generated, similar to this one:
06:33:38:639 ra-dbw Trace: Queue a lookup request
06:33:38:644 ra-dbw Trace: DBWorker Thread 4 (ID 5612 Table:Stores_Reception_BT.SRDB_NEW): Received request: transactionID 14583170
06:33:38:658 ra-dbw Trace: DBWorker Thread 4 (ID 5612),transactionID 14583170, Attempt to read the record:
06:33:38:679 ra-dbw Trace: DBWorker Thread 4 (ID 5612),transactionID 14583170, Succeeded.(…)