Forum Discussion

Venkata Ratnam Vemula's avatar
Venkata Ratnam Vemula
Brass Contributor
Apr 11, 2018
Solved

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

Spoiler
{"odata.error":{"code":"-2146232060, Microsoft.SharePoint.SPException","message":{"lang":"en-US","value":"Exception from HRESULT: 0x80131904"}}}

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

  • 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 Law's avatar
      Ka Kit Law
      Copper Contributor
      Hi, 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 Vemula's avatar
        Venkata Ratnam Vemula
        Brass Contributor
        Hi,
        Please contact Microsoft Support by mentioning the error you are getting exactly and you need to open a support ticket