web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Answered

SQL Server timeout expired. {1}{0}

(0) ShareShare
ReportReport
Posted on by 40

Hello,

I am deleting bookings in out Staging environment because I am testing out various scopes for and goals with RSO. I am deleting from my booking view. While it is processing, it comes up with a SQL error and if I am doing a large amount, it only does partial, sometimes not even half. this seems to be a new issue. Does anyone have any ideas? Screen shot of the error message below.

pastedimage1669927646761v1.png

Thank you in advance for any help.

I have the same question (0)
  • Verified answer
    Haig Liu Profile Picture
    Microsoft Employee on at

    Hi Michelle Wishart,

    This is a bulk delete error, only a few will be successfully deleted, and a few will fail.

    This is because the number of records in the table was large, and they timed out during that time.

    So you need to created multiple bulk deletion with each different selection criteria to have a smaller number of records & monitored it for a while.

  • Suggested answer
    Community Member Profile Picture
    on at

    Hi Michelle Wishart,

    Please correct me if I am wrong.

    You are deleting records using the 'Bulk Record Deletion' feature and experiencing an SQL Server error.

    For more details about the 'Bulk Record Deletion' feature:

    1. Delete All Records From Dataverse Table [With Examples] - SPGuides
    2. Solved: Dataverse Bulk Delete - Delete All Data From Custo... - Power Platform Community (microsoft.com)
  • Verified answer
    Abdul Wahab Profile Picture
    12,119 Moderator on at

    Hi Michelle Wishart,

    Please correct me if I am wrong.

    You are deleting records using the 'Bulk Record Deletion' feature and experiencing an SQL Server error.

    pastedimage1669957848145v1.png

    For more details about the 'Bulk Record Deletion' feature:

    1. Delete All Records From Dataverse Table [With Examples] - SPGuides
    2. Solved: Dataverse Bulk Delete - Delete All Data From Custo... - Power Platform Community (microsoft.com)
  • Michelle Wishart Profile Picture
    40 on at

    Thank you for your help.

  • Michelle Wishart Profile Picture
    40 on at

    Thank you for your help. I was actually using the delete feature on the view I was using. I never noticed that there was a bulk delete option in the advanced settings. So, while I don't think this solved my problem in the traditional sense you did teach me something new which I find just as if not more helpful!!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Suriyanarayanan V Profile Picture

Suriyanarayanan V 22

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 18 Super User 2026 Season 1

#3
Encore Business Solutions Profile Picture

Encore Business Sol... 13

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans