Forum Discussion
Data Refresh Error
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-process-and-has-been-chosen-as-the-deadlock-victim-msg-1205/
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-process-and-has-been-chosen-as-the-deadlock-victim-msg-1205/