I have referred the sample โAI Chatbotโ using sql functions and created my own with sample data
But, I intermittently face below issue when the agent executor is calling the function that we have defined in the prompt. If a call the same sql function explicitly, it returns the expected result
Error is
Invoking: `workspace__default__defects_by_requirement_id` with `{'req_id': '567645'}` {"error": "ServiceErrorCode.BAD_REQUEST: com.databricks.api.base.DatabricksServiceException: TABLE_DOES_NOT_EXIST: Table 'f8c06ded-e387-495c-9d43-e51f4896dd0d' does not exist."} Invoking: `workspace__default__defects_by_requirement_id` with `{'req_id': '567645'}` {"error": "ServiceErrorCode.BAD_REQUEST: com.databricks.api.base.DatabricksServiceException: TABLE_DOES_NOT_EXIST: Table 'f8c06ded-e387-495c-9d43-e51f4896dd0d' does not exist."}It seems that the table for the requirement ID 567645 does not exist. Let me try to retrieve the defects for a different requirement ID. <function=workspace__default__defects_by_requirement_id>{"req_id": "123456"}</function>
Could anyone please help to resolve?