Skip to content

[Bug] [Module Name] ChatData error,Can not find sql in response #2158

@w371803361

Description

@w371803361

Search before asking

  • I had searched in the issues and found no similar issues.

Operating system information

Linux

Python version information

3.10

DB-GPT version

latest release

Related scenes

  • Chat Data
  • Chat Excel
  • Chat DB
  • Chat Knowledge
  • Model Management
  • Dashboard
  • Plugins

Installation Information

Device information

CPU集群

Models information

text2vec-large-chinese
qwen2.5-7b

What happened

对话数据时,无法显示结果,报错如图:
Uploading 60ff40dee757c878fb0a754a73ca448.png…
报错日志:2024-11-27 10:35:20 localhost1 dbgpt.app.scene.chat_db.auto_execute.out_parser[113762] ERROR json load failed:{ "thoughts": "用户想要查询表‘2023集团volte自忙时2月质差’中的前十条信息。根据提供的表结构定义,可以直接从该表中选择前10条记录。", "sql": "SELECT * FROM "2023集团volte自忙时2月质差 " LIMIT 10;", "display_type": "response_table" } do_action:SqlAction(sql='', thoughts='{ "thoughts": "用户想要查询表‘2023集团volte自忙时2月质差’中的前十条信息。根据提供的表结构定义,可以直接从该表中选择前10条记录。", "sql": "SELECT * FROM "2023集团volte自忙时2月质差 " LIMIT 10;", "display_type": "response_table" }', display='') 2024-11-27 10:35:20 localhost1 dbgpt.app.scene.chat_db.auto_execute.out_parser[113762] ERROR parse_view_response error!Can not find sql in response 2024-11-27 10:35:20 localhost1 dbgpt.util.retry[113762] ERROR Attempt 1 of 1 failed with error: AppActionException, Generate view content failed

What you expected to happen

如何呈现如文档实例中显示的样子?
image

How to reproduce

添加数据库,输入:查询XXX表前2条数据

Additional context

No response

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions