Skip to main content

Notifications

Announcements

No record found.

Service | Customer Service, Contact Center, Fie...
Answered

SQL Server timeout expired. {1}{0}

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.

  • Michelle Wishart Profile Picture
    Michelle Wishart 40 on at
    RE: SQL Server timeout expired. {1}{0}

    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!!

  • Michelle Wishart Profile Picture
    Michelle Wishart 40 on at
    RE: SQL Server timeout expired. {1}{0}

    Thank you for your help.

  • Verified answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: SQL Server timeout expired. {1}{0}

    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)
  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SQL Server timeout expired. {1}{0}

    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
    Haig Liu Profile Picture
    Haig Liu Microsoft Employee on at
    RE: SQL Server timeout expired. {1}{0}

    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans