Data Refresh Error

[tmhalila]

Hello team,

I have a table with 1120920 records, but it receives data every time I run the query so it is real-time data. The problem I face is when I refresh the dashboard in the afternoon or morning I get the error message below. Now my question is the error due to real-time data? or something else.

I use the import mode to connect between the dashboard and the database.

[ray_aramburo · Accepted solution]

You have a ton of records so your queries require a lot of memory/resources for them to be updated. Since you are connected to a database, someone/something else is also consuming from the database. This causes for your source to not be able to attend all requests and decides to shut down yours. 

Check if this page gives you more insight https://sqlbak.com/academy/transaction-process-id-was-deadlocked-on-lock-resources-with-another-proc...