tool invoke error: read tool response failed: request failed: req_id: 5434597ace PluginInvokeError

[lihongji426]

Please confirm before submission 在提交之前，请确认

• I have searched for existing issues search for existing issues, including closed ones.
  我已经搜索了现有问题搜索现有问题，包括已关闭的问题。"

Dify version Dify版本

last

db_query or db_query_pre_auth

Database Query (Pre-authorization) 数据库查询（预授权）

Plugin version 插件版本

0.0.11

database and version 数据库及版本

pgsql17

Problem description 问题描述

{
"action_input": {
"query_sql": "SELECT * FROM aps_sap_requirement_summary WHERE plant = 'NTA1' AND requirement_date >= '2026-01-01' AND requirement_date <= '2026-01-31' AND requirement_date IS NOT NULL"
},
"action_name": "sql_query_pre_auth",
"observation": "tool invoke error: read tool response failed: request failed: req_id: 5434597ace PluginInvokeError: {"args":{},"error_type":"RuntimeError","message":"Error executing SQL: NaTType does not support strftime"}",
"thought": "知识库中未明确提到需求日期字段是否存在空值问题。需要尝试使用 IS NOT NULL 条件过滤空值，确保查询能够成功执行。"
}