Forum Discussion
Deleting item from Sharepoint Online list throwing the exception.Exception from HRESULT: 0x80131904
Hi,
I am using pnp JS Core library to delete the items from a SharePoint list, which used to work fine all the time. All of a sudden, we are receiving the following exception
For example, if I have 10 items in list, when i execute below code snippet, it deletes 2 items from list and it throws above error for 8 items. If i run again it deletes 2 more items and gives error for the rest.
It is deleting all the items, after I run several times.
I observe that it is always deleting 2 items for every run and throwing the error for the rest.
Snippet
$pnp.sp.web.lists.getByTitle('MyList').items.filter("AuthorId eq '" + _spPageContextInfo.userId + "'").get().then(function (docs) { for (var d = 0; d < docs.length; d++) { $pnp.sp.web.lists.getByTitle('Doc List').items.getById(docs[d].ID).delete(); }
After checking with Microsoft Support, it is mentioned that the cause of SPException is as follows.
There was a deadlock happening in SQL. The exact cause of the deadlock is unknown but it looks like this was a regression from an update.
Resolution
The SQL product group released and deployed a fix for this issue on tenant
It's working fine after the fix.
4 Replies
- Venkata Ratnam VemulaBrass Contributor
After checking with Microsoft Support, it is mentioned that the cause of SPException is as follows.
There was a deadlock happening in SQL. The exact cause of the deadlock is unknown but it looks like this was a regression from an update.
Resolution
The SQL product group released and deployed a fix for this issue on tenant
It's working fine after the fix.
- Ka Kit LawCopper ContributorHi, I am experiencing the same issue in SharePoint Online,
may I know where I can get/trigger the update from SQL product group?- Venkata Ratnam VemulaBrass ContributorHi,
Please contact Microsoft Support by mentioning the error you are getting exactly and you need to open a support ticket