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

It will probably help if you give us some information on which third-party tool you are using. ModeratorSP 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

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

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. ModeratorSP 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

Thanks Mike, I'll doRegards, Anas N. Alhussein | Sharepoint Senior Developer

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

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

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

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

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