Problem

-- getting such error at runtime :

failed to write items om commit transaction to queue 'hierchmessage_xxx' in queue server 'queue_xxx': a write items request is too big

(there is a typo in the error message in the product, reason why it is not corrected in aforementioned error message and article's title)

Resolution

* the total size of the attributes of a message is too big.

* you need to expand the size of the queue (defaul value is 16MB)

In Integrator standalone :

1- make sure yo have enough space left on the machine

2- queues must be empty (no message being processing), so drain the queues and make sure that no new message will enter in the system. if messages are processed while running the command, it might lead to errors like "unable to connect to the data pool". If it happens, Integrator server will have to be restarted after the command is executed

3- open the Task Monitor -> Process tab

4- retrieve the identfier of the queue task
Ex : Queue Task name QueueTask_5000_1 -> idendifier = 5000

5- run Integrator profile

6- make sure Integrator tasks are running (including the queue task)

7- increase the size of the queues to 30MB :
> r4edi expandqueuesize.x4 5000 30
Changing the queue file size to 30 MB, please wait and do not stop the queue task during this operation...
Operation completed successfully

* to decrease the size of the queue, or to change back to the previous value :

1. stop Integrator server

2. Set the environment variable in Integrator profile CORE_QUEUE_FILE_SIZE=8

3. Back-up and delete the content of the folder $CORE_DATA/queue

4. Run the profile and start Integrator server with the task stopped (core_servers start -S)

5. Run Force rebuild of run-time data from Copilot (directory queue and file “dir” are created)

6. Start the tasks (Integrator standalone) or restart Integrator server (B2Bi)

In B2Bi : In B2Bi this is handled by running the installer in Configure mode and changing the queue size. The maximum is 16 MB