SQLITE_ERROR: no such column: NaN - when resume wait node

[michalbd]

Describe the problem/error/question

I’m using a Wait node with resume: “webhook” mode in my main workflow. A separate Callback Coordinator workflow collects results from parallel sub-workflows and then POSTs to the Wait node’s webhook-waiting URL to resume the main workflow.

The Problem: When I POST to http://localhost:5678/webhook-waiting/{webhookId}/{executionId}, I always get a 500 error with SQLITE_ERROR: no such column: NaN, even when sending the simplest possible JSON body.

I’ve verified:

• The execution ID is correct and matches the waiting execution

• The webhook ID matches the Wait node

• The JSON body is valid and contains no NaN values

• Tried minimal payload: {“status”:“done”,“count”:3} - same error

• Tried Raw body type with Content-Type: application/json - same error

What is the error message (if any)?

500 - “{“code”:0,“message”:“SQLITE_ERROR: no such column: NaN”}”

Full request details:

{
“body”: “{“status”:“done”,“count”:3}”,
“headers”: {
“content-type”: “application/json”
},
“method”: “POST”,
“uri”: “http://localhost:5678/webhook-waiting/parallel-callback-receiver/1297”
}

Please share your workflow

Main Workflow (simplified):

{
“nodes”: [
{
“parameters”: {
“resume”: “webhook”,
“options”: {}
},
“name”: “Wait for Callbacks”,
“type”: “n8n-nodes-base.wait”,
“webhookId”: “parallel-callback-receiver”
}
]
}

Callback Coordinator (the one that POSTs to resume):

The resumeUrl is constructed as: http://localhost:5678/webhook-waiting/parallel-callback-receiver/${executionId}

Share the output returned by the last node

Input to HTTP Request node:

{
“resumeUrl”: “http://localhost:5678/webhook-waiting/parallel-callback-receiver/1297”,
“bodyString”: “{“status”:“done”,“count”:3}”
}

Error Output:

Error code: 500
Full message: 500 - “{“code”:0,“message”:“SQLITE_ERROR: no such column: NaN”}”

Information on your n8n setup

• n8n version: 1.120.4
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main): default
• Running n8n via (Docker, npm, n8n cloud, desktop app): docker
• Operating system: Windows 11 Enterprise, wsl2

[ramin1]

Just to confirm there is nothing wrong with your workflow, run below workflow manually and check the outcome

[michalbd]

@michalbd

500 - “{“code”:0,“message”:“SQLITE_ERROR: no such column: NaN”}”

so why I got: 500 - “{“code”:0,“message”:“SQLITE_ERROR: no such column: NaN”}”

from where it come?

[ramin1]

your http url is wrong. url for a resume url must be like https://x.app.n8n.cloud/webhook-waiting/694

but you are using

http://localhost:5678/webhook-waiting/parallel-callback-receiver/${executionId}

after webhook-waiting you added parallel-callback-receiver that is NAN

calling

domain/webhook-waiting/1000 result in 404 “The execution “1000” does not exist.” if you do not have a such record

domain/webhook-waiting/1000 result in 409 “The execution "50 has finished already.” if you have the record

domain/webhook-waiting/aNANvalue result in “SQLITE_ERROR: no such column: NaN”

[michalbd]

aligned the 2 workflows to POST with same correct url and its working,

thanks!!