Getting error at Bi side regarding flight time out error in dremio community version

Hi Everyone,

So yesterday we got this error in Bi side So can you please confirm is this error form connector side?
And what does this Dataset unavailable means?
image

Thanks,
Fenil Jain.

@fenilj Can you please provide the profile for the job that was run? I want to see of the fragments status is FINISHED

@balaji.ramaswamy Just FYI, for that dashboard we are using 3 vds, 2 vds successfully executed in dremio side, and for 3rd one I am getting this.

image

cdb78894-ba15-4cb5-89a6-2ca9e1ece301.zip (6.0 KB)
5620140c-80b7-4776-9c5b-d5ee3f9a4c34.zip (6.0 KB)

@fenilj The 2 profiles you sent me are just getting metadata, is thia happening during initial connection?

@balaji.ramaswamy
This is the profile when connection happened

fc399131-258f-405d-83fe-a0b4a473195c.zip (6.0 KB)

@fenilj All the 3 profiles are just [Get Server Meta] so my question is, Are there any queries failing or you are trying to connect to Dremio and it is not successful?

Yes 3rd one failed on qlik with below error.

Error: (Connector error: Status(StatusCode=“Internal”, Detail=“ERROR [HY000] [Apache Arrow][Flight SQL] (100) Flight returned timeout error, with message: Deadline Exceeded. gRPC client debug context: {“created”:”@1724701257.430000000",“description”:“Deadline Exceeded”,“file”:“C:\jenkins\c@2\warpdrive\vcpkg\buildtrees\grpc\src\85a295989c-6cf7bf442d.clean\src\core\ext\filters\deadline\deadline_filter.cc”,“file_line”:81,“grpc_status”:4}. Client context: OK") (DirectAccess-1512))

@fenilj Checking internally, meanwhile if you run 2 queries and the disconnect from Qlik, reconnect again and then run the 3rd query does it work?

I can’t do that now But will try what you have suggested. we have started to migrate from dremio CE to dremio Cloud, So for a while I can’t do that. And qlik support told me that typically 1512 error comes when issue in data source, And we have faced same error in cloud also.

@fenilj Are you able to query tables in that source from the UI? If yes, source is working. Also try same connection form another JDBC tool like Dbeaver to narrow down

@balaji.ramaswamy Yes it is working. It is getting scheduled from BI tool. and most of the time it is working But sometimes it is failing. Ok I will check.