Excel is overwriting a row instead appending. RabbitMQ limit processing is set to 1

Questions
1

I have the workflow triggered by RabbitMQ ( Parallel Message Processing Limit
is set to 1)
The workflow creates an excel sheet OR append row to the existing sheet.
Even though processing limit is set, I can see how row content is changing, while I am looking at the file.
The solution I have to use for now is Wait node (with 20 sec timeout). I tried 2-5-10 secs timeout and it was not sufficient enough to do not overwrite the file.
I know there is a similar issue already raised, however the solution advised is to use queue. And I am already using RabbitMQ, and the same issue is still present

![Screenshot 2024-08-21 at 2.30.19 PM|690x220](upload://hEvlMpC1X2hIqTdBNNTVmlTGyrK.pn

Information on your n8n setup

  • 1.52.0:
  • graphQL:
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • selfhosted cloud:
  • Operating system:
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

hello @oksana_miller

Can you share the workflow?

I suppose the message from your RabbitMQ queue is removing instantly instead of the end of the workflow

4
5

Change the RMQ trigger options to these:
image

6

Thank you , this works as expected.
I was not aware of this feature, was thinking Parallel processing limit would force to wait until execution is finished.

Thanks for help, resolved for me

7

Hi again.

The solution works , but not consistently. Sometimes even with the Processing Limit and Delete From Queue When Execution Finishes, the rows are still overriding.

If there is an option to share video recording, I could send it over

8

Posting the screen recording to show that rows are overwritten despite the Parameters set in RabbitMQ node.

Pay attention at 35-40 secs and see how row 15 is overwritten

9

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.