locked
SharePoint Site Export failed with SQL deadlock RRS feed

  • Question

  • Hi,

    We are using a 3rd party tool to take a SharePoint backup of our production portal in scheduled manner and it is working fine till the last wednesday.

    This tool take the backup by exporting the sharepoint site. Actually the export completed with 1 error as below:

    -----------------------------

    [16/07/2011 1:24:46 PM]: Error: Transaction (Process ID 181) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.HasMoreRows()
       at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
       at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
       at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
       at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
       at System.Data.Common.LoadAdapter.FillFromReader(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
       at System.Data.DataSet.Load(IDataReader reader, LoadOption loadOption, FillErrorEventHandler errorHandler, DataTable[] tables)
       at System.Data.DataSet.Load(IDataReader reader, LoadOption loadOption, String[] tables)
       at Microsoft.SharePoint.Deployment.ListItemObjectHelper.GetNextBatchInstance()
       at Microsoft.SharePoint.Deployment.ListItemObjectHelper.GetNextBatch()
       at Microsoft.SharePoint.Deployment.ObjectHelper.RetrieveDataFromDatabase(ExportObject exportObject)

    ----------------------------------------

    Please any help to diagnose and fix this error?

     


    Regards, Anas N. Alhussein | Sharepoint Senior Developer
    Sunday, July 17, 2011 7:05 AM

Answers

  • Dear All,

    The SQL deadlock resolved, it may be occurred because of ongoing write access operations. Anyway, the issue now is being investgated by the 3rd party "EMC" backup support:

    "Unable to cast object of type 'MOSSParserLibrary.Dependency' to type 'MOSSParserLibrary.MOSSObjectTempl'"

    If you have any idea, please share it?

     


    Regards, Anas N. Alhussein | Sharepoint Senior Developer
    Saturday, July 23, 2011 5:51 AM

All replies

  • It will probably help if you give us some information on which third-party tool you are using.

     

    Moderator


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Sunday, July 17, 2011 7:22 AM
  • The 3rd tool is (EMC Networker)

    Now the export completed with 0 errors, but the emc backup still failed with the error:

    "Unable to cast object of type 'MOSSParserLibrary.Dependency' to type 'MOSSParserLibrary.MOSSObjectTempl'"

    Any Idea?


    Regards, Anas N. Alhussein | Sharepoint Senior Developer
    Sunday, July 17, 2011 7:26 AM
  • Thanks for the reply.

     

    The first and obvious question is that as this is a problem with a third-party tool, have you contacted that third party company (Here presumably EMC) and what did they say?

    While people here may be able to help, supporting EMC Networker is actually the job of the people who sold it to you and they should be the first people you ask.

     

    Moderator


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Sunday, July 17, 2011 7:45 AM
  • Thanks Mike, I'll do
    Regards, Anas N. Alhussein | Sharepoint Senior Developer
    Sunday, July 17, 2011 7:51 AM
  •  

    Hi A.N.Alhussein,

     

    According to the following error message, there are many reasons for this issue:

     

    [16/07/2011 1:24:46 PM]: Error: Transaction (Process ID 181) was deadlocked on lock resources with another process and has been chosen as the deadlock victim

     

    Firstly, check your SQL server’s version according to the this article. If you were using SQL server 2008, ensure you install SP1.

     

    Secondly, check your SharePoint server’s version. Make sure you apply the latest update.

     

    Finally, deadlock occurs on the SQL server when taking Export is because the users are accessing the site and there are read and write operations going on that site. Hence, we need to make sure that the site is Read only and then run the Export.

     

    Thanks,

    Rock Wang

    Forum Support

    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Regards, Rock Wang Microsoft Online Community Support
    Monday, July 18, 2011 7:36 AM
  • Hi Alhussein,

    What is your sharepoint version? Do you get the same deadlock error when exorting site content using stsadm export commnad?

    Thanks,

    Soumo

    Tuesday, July 19, 2011 3:25 AM
  • Hi,

     

    Have you resolved your issue? If anything is unclear, feel free to reply to the forum.

     

    Thanks,

    Rock Wang

    Forum Support

    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Regards, Rock Wang Microsoft Online Community Support
    Thursday, July 21, 2011 2:14 AM
  • Dear All,

    The SQL deadlock resolved, it may be occurred because of ongoing write access operations. Anyway, the issue now is being investgated by the 3rd party "EMC" backup support:

    "Unable to cast object of type 'MOSSParserLibrary.Dependency' to type 'MOSSParserLibrary.MOSSObjectTempl'"

    If you have any idea, please share it?

     


    Regards, Anas N. Alhussein | Sharepoint Senior Developer
    Saturday, July 23, 2011 5:51 AM
  • stsadm -o setsitelock -url http://site -lock readonly
    stsadm -o export -url http://site -filename C:\backup\site -cabsize 1024 -overwrite -includeusersecurity -versions 4 -nofilecompression
    stsadm -o setsitelock -url http://site -lock none
    Wednesday, October 10, 2012 10:23 PM