SQL Dialog Skill Failed In MS Teams Channel with Oracle Digital Assistant (ODA) When Executing SQL Generated From OMRL Due to UncheckedOmrlSqlExecutionException and Status Code DEADLINE_EXCEEDED
(Doc ID 3004316.1)
Last updated on FEBRUARY 26, 2024
Applies to:
Oracle Digital Assistant - Version 23.x to 23.x [Release No_Release]Information in this document applies to any platform.
Symptoms
SQL Dialog Skill fails with the following error:
Error Flow:system.omrlDefaultFlow
Error State:omrlToSql
Error Message:
An error occurred when executing SQL generated from OMRL, reason: oracle.cloud.bots.omrl.coresql.connector.UncheckedOmrlSqlExecutionException: java.util.concurrent.CompletionException: oracle.cloud.bots.dataservice.DataServiceConnectorException: dataServiceId=XXXX-XXX-XXX-XX-XXXXX: grpcStatusCode=DEADLINE_EXCEEDED: grpcStatusMessage=deadline exceeded after 29.999953641s. [remote_addr=bots-data-service-connector-headless.default/xx.xx.xx.xx:xxxx], SQL: SELECT XXX FROM XX WHERE XXXX FETCH FIRST 100 ROWS ONLY
Error State:omrlToSql
Error Message:
An error occurred when executing SQL generated from OMRL, reason: oracle.cloud.bots.omrl.coresql.connector.UncheckedOmrlSqlExecutionException: java.util.concurrent.CompletionException: oracle.cloud.bots.dataservice.DataServiceConnectorException: dataServiceId=XXXX-XXX-XXX-XX-XXXXX: grpcStatusCode=DEADLINE_EXCEEDED: grpcStatusMessage=deadline exceeded after 29.999953641s. [remote_addr=bots-data-service-connector-headless.default/xx.xx.xx.xx:xxxx], SQL: SELECT XXX FROM XX WHERE XXXX FETCH FIRST 100 ROWS ONLY
Diagnosis:
- Manually execute the same generated SQL query at the source database, and the SQL query ran successfully.
- Also have another SQL Dialog Skill that accesses the same database and is working without issue.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |