none
DPM2010 restoring a list to SharePoint 2010 fails because of an SQL error during the import phase. RRS feed

  • Question

  • Hello,

    I've installed DPM2010 as a test for backing up SharePoint.

    Restoring a single item works as expected but when i try to restore a List the recovery operation fails.

    I've trawled through the logs and the DPM errors are these:

    This is on the SharePoint server that hosts the temp files:

    Import Log:

    [2/24/2011 9:16:32 AM] [List] [Shared Documents]   ExtendedVerbose: Creating
    [2/24/2011 9:16:32 AM] [List] [Shared Documents]   Error: An unexpected error has occurred.
    [2/24/2011 9:16:32 AM] [List] [Shared Documents]   Debug:    at Microsoft.SharePoint.SPGlobal.HandleComException(COMException comEx)
       at Microsoft.SharePoint.Library.SPRequest.CreateListOnImport(String bstrUrl, Guid& pguidListId, String bstrTitle, String bstrDescription, Int32 lTemplateID, String bstrFeatureId, Guid guidRootFolderId, Int64 llFlags, Int32 iVersion, Int32 iAuthor, String bstrFields, String bstrContentTypes, String bstrImageUrl, String bstrEventSinkAssembly, String bstrEventSinkClass, String bstrEventSinkData, Guid guidDocTemplateId, String bstrViews, String bstrForms, Boolean bCompressedSchema, DateTime dtTimeCreated)
       at Microsoft.SharePoint.Deployment.ListSerializer.CreateList(SPWeb parentWeb, Dictionary`2 listMetaData, Boolean usingPublicSchema)
       at Microsoft.SharePoint.Deployment.ListSerializer.SetObjectData(Object obj, SerializationInfo info, StreamingContext context, ISurrogateSelector selector)
       at Microsoft.SharePoint.Deployment.XmlFormatter.CallSetObjectData(Object obj, SerializationInfo objectData, ISerializationSurrogate surrogate, ISurrogateSelector selector)
    [2/24/2011 9:16:32 AM] FatalError: An unexpected error has occurred.
    [2/24/2011 9:16:32 AM] Debug:    at Microsoft.SharePoint.SPGlobal.HandleComException(COMException comEx)
       at Microsoft.SharePoint.Library.SPRequest.CreateListOnImport(String bstrUrl, Guid& pguidListId, String bstrTitle, String bstrDescription, Int32 lTemplateID, String bstrFeatureId, Guid guidRootFolderId, Int64 llFlags, Int32 iVersion, Int32 iAuthor, String bstrFields, String bstrContentTypes, String bstrImageUrl, String bstrEventSinkAssembly, String bstrEventSinkClass, String bstrEventSinkData, Guid guidDocTemplateId, String bstrViews, String bstrForms, Boolean bCompressedSchema, DateTime dtTimeCreated)
       at Microsoft.SharePoint.Deployment.ListSerializer.CreateList(SPWeb parentWeb, Dictionary`2 listMetaData, Boolean usingPublicSchema)
       at Microsoft.SharePoint.Deployment.ListSerializer.SetObjectData(Object obj, SerializationInfo info, StreamingContext context, ISurrogateSelector selector)
       at Microsoft.SharePoint.Deployment.XmlFormatter.CallSetObjectData(Object obj, SerializationInfo objectData, ISerializationSurrogate surrogate, ISurrogateSelector selector)
       at Microsoft.SharePoint.Deployment.XmlFormatter.ParseObject(Type objectType, Boolean isChildObject)
       at Microsoft.SharePoint.Deployment.XmlFormatter.DeserializeObject(Type objectType, Boolean isChildObject, DeploymentObject envelope)
       at Microsoft.SharePoint.Deployment.XmlFormatter.Deserialize(Stream serializationStream)
       at Microsoft.SharePoint.Deployment.ObjectSerializer.Deserialize(Stream serializationStream)
       at Microsoft.SharePoint.Deployment.SPImport.DeserializeObjects()
       at Microsoft.SharePoint.Deployment.SPImport.Run()
    [2/24/2011 9:16:32 AM] Progress: Import did not complete.
    [2/24/2011 9:16:32 AM] Finish Time: 2/24/2011 9:16:32 AM.
    [2/24/2011 9:16:32 AM] Duration: 00:00:18
    [2/24/2011 9:16:32 AM] Finished with 0 warnings.
    [2/24/2011 9:16:32 AM] Finished with 2 errors.

    The ULS log from SharePoint says the following:

    System.Data.SqlClient.SqlException: Operand type clash: datetime is incompatible with uniqueidentifier   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.ConsumeMetaData()   at System.Data.SqlClient.SqlDataReader.get_MetaData()   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(Comm...	 
    02/24/2011 09:16:32.22*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	880i	High  	...andBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)   at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock)	 
    02/24/2011 09:16:32.22 	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	880k	High  	  at Microsoft.SharePoint.SPSqlClient.ExecuteQueryInternal(Boolean retryfordeadlock)   at Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean retryfordeadlock)   at Microsoft.SharePoint.Library.SPRequestInternalClass.CreateListOnImport(String bstrUrl, Guid& pguidListId, String bstrTitle, String bstrDescription, Int32 lTemplateID, String bstrFeatureId, Guid guidRootFolderId, Int64 llFlags, Int32 iVersion, Int32 iAuthor, String bstrFields, String bstrContentTypes, String bstrImageUrl, String bstrEventSinkAssembly, String bstrEventSinkClass, String bstrEventSinkData, Guid guidDocTemplateId, String bstrViews, String bstrForms, Boolean bCompressedSchema, DateTime dtTimeCreated)   at Microsoft.SharePoint.Library.SPRequest.CreateListOnImport(String bstrUrl, Guid& pguidListId, String bstr...	 
    02/24/2011 09:16:32.22*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	880k	High  	...Title, String bstrDescription, Int32 lTemplateID, String bstrFeatureId, Guid guidRootFolderId, Int64 llFlags, Int32 iVersion, Int32 iAuthor, String bstrFields, String bstrContentTypes, String bstrImageUrl, String bstrEventSinkAssembly, String bstrEventSinkClass, String bstrEventSinkData, Guid guidDocTemplateId, String bstrViews, String bstrForms, Boolean bCompressedSchema, DateTime dtTimeCreated)   at Microsoft.SharePoint.Deployment.ListSerializer.CreateList(SPWeb parentWeb, Dictionary`2 listMetaData, Boolean usingPublicSchema)   at Microsoft.SharePoint.Deployment.ListSerializer.SetObjectData(Object obj, SerializationInfo info, StreamingContext context, ISurrogateSelector selector)   at Microsoft.SharePoint.Deployment.XmlFormatter.CallSetObjectData(Object obj, SerializationInfo objec...	 
    02/24/2011 09:16:32.22*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	880k	High  	...tData, ISerializationSurrogate surrogate, ISurrogateSelector selector)   at Microsoft.SharePoint.Deployment.XmlFormatter.ParseObject(Type objectType, Boolean isChildObject)   at Microsoft.SharePoint.Deployment.XmlFormatter.DeserializeObject(Type objectType, Boolean isChildObject, DeploymentObject envelope)   at Microsoft.SharePoint.Deployment.XmlFormatter.Deserialize(Stream serializationStream)   at Microsoft.SharePoint.Deployment.ObjectSerializer.Deserialize(Stream serializationStream)   at Microsoft.SharePoint.Deployment.SPImport.DeserializeObjects()   at Microsoft.SharePoint.Deployment.SPImport.Run()   at WSSCmdlets.CWssImportHelper.ImportUrlDelegate()   at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.<RunWithElevatedPrivileges>b__2()   at Microsoft.SharePoint.Ut...	 
    02/24/2011 09:16:32.22*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	880k	High  	...ilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)   at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)   at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)   at WSSCmdlets.CWSSCmdlets.ImportUrl(String targetUrl, String importPath, String importFileName, Boolean importSecurity, Boolean isAlternateURLRecovery, String roType, Int32& hr, String& exceptionMessage) 	 
    02/24/2011 09:16:32.22 	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	880j	High  	SqlError: 'Operand type clash: datetime is incompatible with uniqueidentifier'  Source: '.Net SqlClient Data Provider' Number: 206 State: 2 Class: 16 Procedure: 'proc_CreateList' LineNumber: 0 Server: 'WAGENBORGSQL'	 
    02/24/2011 09:16:32.22 	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	5586	Critical	Unknown SQL Exception 206 occurred. Additional error information from SQL Server is included below. Operand type clash: datetime is incompatible with uniqueidentifier	 
    02/24/2011 09:16:32.22 	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzku	High  	ConnectionString: 'Data Source=WAGENBORGSQL;Initial Catalog=SPS_MySite_Content_DB_001;Integrated Security=True;Enlist=False;Asynchronous Processing=False;Connect Timeout=15'  ConnectionState: Closed ConnectionTimeout: 15	 
    02/24/2011 09:16:32.24 	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	SqlCommand: 'DECLARE @SiteId uniqueidentifier;DECLARE @ListId uniqueidentifier;DECLARE @WebId uniqueidentifier;DECLARE @FolderFullUrlRet nvarchar(256);DECLARE @FolderListCtFullUrl nvarchar(256);DECLARE @Retval int;SET @WebId = @wssp0;SET @ListId = @wssp1;SET @SiteId = @wssp2;SET @FolderFullUrlRet = N'';BEGIN TRAN;EXEC @Retval = proc_CreateList @SiteId,@WebId,@ListId, @wssp3, @wssp4, @wssp5, @wssp6, @wssp7, @wssp8, @wssp9, @wssp10, @wssp11, @wssp12, @wssp13, @wssp14, @wssp15, @wssp16, @wssp17, @wssp18, @wssp19, @wssp20, @wssp21, @wssp22, @wssp23, @wssp24, @wssp25, @wssp26, @wssp27, @wssp28, @wssp29, @wssp30, @wssp31, @wssp32, @wssp33, @wssp34, @wssp35, NULL, NULL, @FolderFullUrlRet OUTPUT, @wssp36; IF @Retval = 0 BEGIN EXEC @Retval = proc_AddNewRowOrdToList @SiteId,@WebId,@ListId, @wssp37,...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	... NULL END IF @Retval = 0 BEGIN  EXEC proc_MapContentTypeToList @SiteId,@WebId,@ListId,0x010100C704B7D3DE86854B8BB1BBE84B6E85B8,1  SET @FolderListCtFullUrl = @FolderFullUrlRet + N'/Forms/Document'; EXEC proc_CopyResourceDir @SiteId,@WebId,0x0101,N'personal/wagenborg_wagictkbo', @FolderListCtFullUrl  EXEC proc_MapContentTypeToList @SiteId,@WebId,@ListId,0x01200035518FACD6AE234BA691E3F0B624AE48,1  EXEC proc_MapContentTypeToList @SiteId,@WebId,@ListId,0x0101,1  EXEC proc_MapContentTypeToList @SiteId,@WebId,@ListId,0x0120,1  EXEC proc_MapContentTypeToList @SiteId,@WebId,@ListId,0x0F4E56FA700CB94AB8630177E6DDD247,0  EXEC proc_MapContentTypeToList @SiteId,@WebId,@ListId,0xC6F61B4B394FAC45ACD516FE7A214E5E,0  EXEC proc_MapContentTypeToList @SiteId,@WebId,@ListId,0x9FCB1ECD4EDD294FAB9...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...EE9FF40048D64,0  EXEC proc_MapContentTypeToList @SiteId,@WebId,@ListId,0x2D9BF2FBE5CAAA498E0A29955B540122,0  EXEC proc_MapContentTypeToList @SiteId,@WebId,@ListId,0xA01220E5EB510C4C8DFB9B8A0EBEDCB6,0  EXEC proc_MapContentTypeToList @SiteId,@WebId,@ListId,0x7B72365DB2BCD247A2311F0BC63B7439,0 EXEC proc_CreateView @wssp38, @wssp39, @wssp40, @wssp41, @ListId, @wssp42, @wssp43, @wssp44, @wssp45, @wssp46, @wssp47, @wssp48, @wssp49, @wssp50, @wssp51, @wssp52, @wssp53, @wssp54;EXEC proc_CreateView @wssp55, @wssp56, @wssp57, @wssp58, @ListId, @wssp59, @wssp60, @wssp61, @wssp62, @wssp63, @wssp64, @wssp65, @wssp66, @wssp67, @wssp68, @wssp69, @wssp70, @wssp71;EXEC proc_CreateView @wssp72, @wssp73, @wssp74, @wssp75, @ListId, @wssp76, @wssp77, @wssp78, @wssp79, @wssp80, @wssp81, @wssp82, @wssp83, ...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...@wssp84, @wssp85, @wssp86, @wssp87, @wssp88;EXEC proc_CreateView @wssp89, @wssp90, @wssp91, @wssp92, @ListId, @wssp93, @wssp94, @wssp95, @wssp96, @wssp97, @wssp98, @wssp99, @wssp100, @wssp101, @wssp102, @wssp103, @wssp104, @wssp105;EXEC proc_CreateView @wssp106, @wssp107, @wssp108, @wssp109, @ListId, @wssp110, @wssp111, @wssp112, @wssp113, @wssp114, @wssp115, @wssp116, @wssp117, @wssp118, @wssp119, @wssp120, @wssp121, @wssp122;EXEC proc_CreateView @wssp123, @wssp124, @wssp125, @wssp126, @ListId, @wssp127, @wssp128, @wssp129, @wssp130, @wssp131, @wssp132, @wssp133, @wssp134, @wssp135, @wssp136, @wssp137, @wssp138, @wssp139;EXEC proc_CreateView @wssp140, @wssp141, @wssp142, @wssp143, @ListId, @wssp144, @wssp145, @wssp146, @wssp147, @wssp148, @wssp149, @wssp150, @wssp151, @wssp152, @wssp153, ...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...@wssp154, @wssp155, @wssp156; EXEC proc_UpdateDiskUsed @SiteId, 1; COMMIT TRAN END ELSE BEGIN ROLLBACK TRAN; SELECT @Retval END '   CommandType: Text CommandTimeout: 0   Parameter: '@wssp0' Type: UniqueIdentifier Size: 0 Direction: Input Value: '18367c03-3692-4187-8da9-9b263e6b74fd'   Parameter: '@wssp1' Type: UniqueIdentifier Size: 0 Direction: Input Value: '2da2b084-3529-4f47-a0f9-479f8efc23e3'   Parameter: '@wssp2' Type: UniqueIdentifier Size: 0 Direction: Input Value: '97050cdb-6a44-4250-a0e4-e9861f212bdb'   Parameter: '@wssp3' Type: NVarChar Size: 0 Direction: Input Value: ''   Parameter: '@wssp4' Type: NVarChar Size: 0 Direction: Input Value: ''   Parameter: '@wssp5' Type: Bit Size: 0 Direction: Input Value: 'True'   Parameter: '@wssp6' Type: NVarChar Size: 4000 Direc...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...tion: Input Value: 'Shared Documents'   Parameter: '@wssp7' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp8' Type: Int Size: 0 Direction: Input Value: '9'   Parameter: '@wssp9' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp10' Type: Bit Size: 0 Direction: Input Value: 'False'   Parameter: '@wssp11' Type: UniqueIdentifier Size: 0 Direction: Input Value: '00bfea71-e717-4e80-aa17-d0c71b360101'   Parameter: '@wssp12' Type: Int Size: 0 Direction: Input Value: '101'   Parameter: '@wssp13' Type: UniqueIdentifier Size: 0 Direction: Input Value: '34602e72-926a-4623-b9e9-57f32f2037c1'   Parameter: '@wssp14' Type: NVarChar Size: 4000 Direction: Input Value: '/_layouts/images/itdl.png'   Parameter: '@wssp15' Type: NVarChar Size: 0 Direction: Inpu...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...t Value: ''   Parameter: '@wssp16' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp17' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp18' Type: NVarChar Size: 4000 Direction: Input Value: 'Use this document library to store your documents. Documents sha...'   Parameter: '@wssp19' Type: Int Size: 0 Direction: Input Value: ''   Parameter: '@wssp20' Type: Int Size: 0 Direction: Input Value: ''   Parameter: '@wssp21' Type: VarBinary Size: 8000 Direction: Input   Parameter: '@wssp22' Type: Int Size: 0 Direction: Input Value: '0'   Parameter: '@wssp23' Type: BigInt Size: 0 Direction: Input Value: '8392712'   Parameter: '@wssp24' Type: Int Size: 0 Direction: Input Value: ''   Parameter: '@wssp25' Type: Int Size: 0 Direction: Input Value: '' ...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...  Parameter: '@wssp26' Type: Int Size: 0 Direction: Input Value: ''   Parameter: '@wssp27' Type: Bit Size: 0 Direction: Input Value: 'False'   Parameter: '@wssp28' Type: Bit Size: 0 Direction: Input Value: 'False'   Parameter: '@wssp29' Type: NVarChar Size: 0 Direction: Input Value: ''   Parameter: '@wssp30' Type: NVarChar Size: 0 Direction: Input Value: ''   Parameter: '@wssp31' Type: NVarChar Size: 0 Direction: Input Value: ''   Parameter: '@wssp32' Type: VarBinary Size: 8000 Direction: Input   Parameter: '@wssp33' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'cda8b2b2-ed5a-4d93-a26d-c95c16364a91'   Parameter: '@wssp34' Type: NVarChar Size: 4000 Direction: Input Value: '$Resources:spscore,PersonalSiteOnet_List_MyDocuments;'   Parameter: '@wssp35' Type: NVarCh...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...ar Size: 4000 Direction: Input Value: '$Resources:spscore,PersonalSiteOnet_List_MyDocuments_Description...'   Parameter: '@wssp36' Type: DateTime Size: 0 Direction: Input Value: '02/24/2011 08:16:32'   Parameter: '@wssp37' Type: Int Size: 0 Direction: Input Value: '0'   Parameter: '@wssp38' Type: UniqueIdentifier Size: 0 Direction: Input Value: '97050cdb-6a44-4250-a0e4-e9861f212bdb'   Parameter: '@wssp39' Type: UniqueIdentifier Size: 0 Direction: Input Value: '18367c03-3692-4187-8da9-9b263e6b74fd'   Parameter: '@wssp40' Type: NVarChar Size: 4000 Direction: Input Value: '1f5abb32-9f87-4774-89a2-fb2b2adedf78'   Parameter: '@wssp41' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp42' Type: Int Size: 0 Direction: Input Value: '0'   Parameter: '@wssp43' Type: In...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...t Size: 0 Direction: Input Value: '25165829'   Parameter: '@wssp44' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp45' Type: NVarChar Size: 4000 Direction: Input Value: 'All Documents'   Parameter: '@wssp46' Type: VarBinary Size: 0 Direction: Input   Parameter: '@wssp47' Type: UniqueIdentifier Size: 0 Direction: Input Value: '53e515c4-73d3-4fc3-a5f0-c5110209459f'   Parameter: '@wssp48' Type: UniqueIdentifier Size: 0 Direction: Input Value: '874f5460-71f9-fecc-e894-e7e858d9713e'   Parameter: '@wssp49' Type: NVarChar Size: 4000 Direction: Input Value: 'Main'   Parameter: '@wssp50' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp51' Type: Int Size: 0 Direction: Input Value: '0'   Parameter: '@wssp52' Type: VarBinary Size: 0 Direction: Input...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...   Parameter: '@wssp53' Type: NVarChar Size: 0 Direction: Input Value: ''   Parameter: '@wssp54' Type: NVarChar Size: 0 Direction: Input Value: ''   Parameter: '@wssp55' Type: UniqueIdentifier Size: 0 Direction: Input Value: '97050cdb-6a44-4250-a0e4-e9861f212bdb'   Parameter: '@wssp56' Type: UniqueIdentifier Size: 0 Direction: Input Value: '18367c03-3692-4187-8da9-9b263e6b74fd'   Parameter: '@wssp57' Type: NVarChar Size: 4000 Direction: Input Value: 'ec465f27-4859-4114-89b1-33a6c7e8d815'   Parameter: '@wssp58' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp59' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp60' Type: Int Size: 0 Direction: Input Value: '1033'   Parameter: '@wssp61' Type: Int Size: 0 Direction: Input Value: '7'   Parame...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...ter: '@wssp62' Type: NVarChar Size: 4000 Direction: Input Value: 'Merge Documents'   Parameter: '@wssp63' Type: VarBinary Size: 0 Direction: Input   Parameter: '@wssp64' Type: UniqueIdentifier Size: 0 Direction: Input Value: '34e8ff74-623d-4bbb-87c4-761d344f48a9'   Parameter: '@wssp65' Type: UniqueIdentifier Size: 0 Direction: Input Value: '874f5460-71f9-fecc-e894-e7e858d9713e'   Parameter: '@wssp66' Type: NVarChar Size: 4000 Direction: Input Value: 'Main'   Parameter: '@wssp67' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp68' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp69' Type: VarBinary Size: 0 Direction: Input   Parameter: '@wssp70' Type: NVarChar Size: 0 Direction: Input Value: ''   Parameter: '@wssp71' Type: NVarChar Size: 0 ...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...Direction: Input Value: ''   Parameter: '@wssp72' Type: UniqueIdentifier Size: 0 Direction: Input Value: '97050cdb-6a44-4250-a0e4-e9861f212bdb'   Parameter: '@wssp73' Type: UniqueIdentifier Size: 0 Direction: Input Value: '18367c03-3692-4187-8da9-9b263e6b74fd'   Parameter: '@wssp74' Type: NVarChar Size: 4000 Direction: Input Value: 'd6c678c9-6242-475c-9e09-3d98f7694c3d'   Parameter: '@wssp75' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp76' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp77' Type: Int Size: 0 Direction: Input Value: '9'   Parameter: '@wssp78' Type: Int Size: 0 Direction: Input Value: '9'   Parameter: '@wssp79' Type: NVarChar Size: 4000 Direction: Input Value: 'Relink Documents'   Parameter: '@wssp80' Type: VarBinary Si...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...ze: 0 Direction: Input   Parameter: '@wssp81' Type: UniqueIdentifier Size: 0 Direction: Input Value: '82bc3768-4024-45e5-8089-d5e722094cf8'   Parameter: '@wssp82' Type: UniqueIdentifier Size: 0 Direction: Input Value: '874f5460-71f9-fecc-e894-e7e858d9713e'   Parameter: '@wssp83' Type: NVarChar Size: 4000 Direction: Input Value: 'Main'   Parameter: '@wssp84' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp85' Type: Int Size: 0 Direction: Input Value: '2'   Parameter: '@wssp86' Type: VarBinary Size: 0 Direction: Input   Parameter: '@wssp87' Type: NVarChar Size: 0 Direction: Input Value: ''   Parameter: '@wssp88' Type: NVarChar Size: 0 Direction: Input Value: ''   Parameter: '@wssp89' Type: UniqueIdentifier Size: 0 Direction: Input Value: '97050cdb-6a44-4250...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...-a0e4-e9861f212bdb'   Parameter: '@wssp90' Type: UniqueIdentifier Size: 0 Direction: Input Value: '18367c03-3692-4187-8da9-9b263e6b74fd'   Parameter: '@wssp91' Type: NVarChar Size: 4000 Direction: Input Value: '645a3a85-db75-40c7-8fe1-95915212f48b'   Parameter: '@wssp92' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp93' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp94' Type: Int Size: 0 Direction: Input Value: '13'   Parameter: '@wssp95' Type: Int Size: 0 Direction: Input Value: '40'   Parameter: '@wssp96' Type: NVarChar Size: 4000 Direction: Input Value: 'assetLibTemp'   Parameter: '@wssp97' Type: VarBinary Size: 0 Direction: Input   Parameter: '@wssp98' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'f6814211-e492-4397-a2bd-...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...001e60b7fedb'   Parameter: '@wssp99' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'baf5274e-a800-8dc3-96d0-0003d9405663'   Parameter: '@wssp100' Type: NVarChar Size: 4000 Direction: Input Value: 'Main'   Parameter: '@wssp101' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp102' Type: Int Size: 0 Direction: Input Value: '3'   Parameter: '@wssp103' Type: VarBinary Size: 0 Direction: Input   Parameter: '@wssp104' Type: NVarChar Size: 0 Direction: Input Value: ''   Parameter: '@wssp105' Type: NVarChar Size: 0 Direction: Input Value: ''   Parameter: '@wssp106' Type: UniqueIdentifier Size: 0 Direction: Input Value: '97050cdb-6a44-4250-a0e4-e9861f212bdb'   Parameter: '@wssp107' Type: UniqueIdentifier Size: 0 Direction: Input Value: '18367c03-3692-4187-...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...8da9-9b263e6b74fd'   Parameter: '@wssp108' Type: NVarChar Size: 4000 Direction: Input Value: '3ef91bea-7185-4d0d-9092-227be0162a88'   Parameter: '@wssp109' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp110' Type: Int Size: 0 Direction: Input Value: '4'   Parameter: '@wssp111' Type: Int Size: 0 Direction: Input Value: '1048576'   Parameter: '@wssp112' Type: Int Size: 0 Direction: Input Value: ''   Parameter: '@wssp113' Type: NVarChar Size: 4000 Direction: Input Value: ''   Parameter: '@wssp114' Type: VarBinary Size: 0 Direction: Input   Parameter: '@wssp115' Type: UniqueIdentifier Size: 0 Direction: Input Value: '3b277d7f-f271-4f94-9e59-1a8538ab128f'   Parameter: '@wssp116' Type: UniqueIdentifier Size: 0 Direction: Input Value: '9f56656f-6aa3-0d55-a812-7...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...11bf65864ea'   Parameter: '@wssp117' Type: NVarChar Size: 4000 Direction: Input Value: 'Main'   Parameter: '@wssp118' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp119' Type: Int Size: 0 Direction: Input Value: '0'   Parameter: '@wssp120' Type: VarBinary Size: 0 Direction: Input   Parameter: '@wssp121' Type: NVarChar Size: 0 Direction: Input Value: ''   Parameter: '@wssp122' Type: NVarChar Size: 0 Direction: Input Value: ''   Parameter: '@wssp123' Type: UniqueIdentifier Size: 0 Direction: Input Value: '97050cdb-6a44-4250-a0e4-e9861f212bdb'   Parameter: '@wssp124' Type: UniqueIdentifier Size: 0 Direction: Input Value: '18367c03-3692-4187-8da9-9b263e6b74fd'   Parameter: '@wssp125' Type: NVarChar Size: 4000 Direction: Input Value: 'b0769298-b9f5-4d0b-aad5-...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...a35ff8da838d'   Parameter: '@wssp126' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp127' Type: Int Size: 0 Direction: Input Value: '6'   Parameter: '@wssp128' Type: Int Size: 0 Direction: Input Value: '1048576'   Parameter: '@wssp129' Type: Int Size: 0 Direction: Input Value: ''   Parameter: '@wssp130' Type: NVarChar Size: 4000 Direction: Input Value: ''   Parameter: '@wssp131' Type: VarBinary Size: 0 Direction: Input   Parameter: '@wssp132' Type: UniqueIdentifier Size: 0 Direction: Input Value: '843f21c1-9032-4e3b-9380-5f0984c74a41'   Parameter: '@wssp133' Type: UniqueIdentifier Size: 0 Direction: Input Value: '9f56656f-6aa3-0d55-a812-711bf65864ea'   Parameter: '@wssp134' Type: NVarChar Size: 4000 Direction: Input Value: 'Main'   Parameter: '@wssp135...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp136' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp137' Type: VarBinary Size: 0 Direction: Input   Parameter: '@wssp138' Type: NVarChar Size: 0 Direction: Input Value: ''   Parameter: '@wssp139' Type: NVarChar Size: 0 Direction: Input Value: ''   Parameter: '@wssp140' Type: UniqueIdentifier Size: 0 Direction: Input Value: '97050cdb-6a44-4250-a0e4-e9861f212bdb'   Parameter: '@wssp141' Type: UniqueIdentifier Size: 0 Direction: Input Value: '18367c03-3692-4187-8da9-9b263e6b74fd'   Parameter: '@wssp142' Type: NVarChar Size: 4000 Direction: Input Value: '23e0f496-e51e-4fb0-a5ea-ba0a4baf579f'   Parameter: '@wssp143' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp144' Type: In...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...t Size: 0 Direction: Input Value: '8'   Parameter: '@wssp145' Type: Int Size: 0 Direction: Input Value: '1048576'   Parameter: '@wssp146' Type: Int Size: 0 Direction: Input Value: ''   Parameter: '@wssp147' Type: NVarChar Size: 4000 Direction: Input Value: ''   Parameter: '@wssp148' Type: VarBinary Size: 0 Direction: Input   Parameter: '@wssp149' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'd28c58bc-313b-4e1d-b80e-83c767c148cc'   Parameter: '@wssp150' Type: UniqueIdentifier Size: 0 Direction: Input Value: '9f56656f-6aa3-0d55-a812-711bf65864ea'   Parameter: '@wssp151' Type: NVarChar Size: 4000 Direction: Input Value: 'Main'   Parameter: '@wssp152' Type: Int Size: 0 Direction: Input Value: '1'   Parameter: '@wssp153' Type: Int Size: 0 Direction: Input Value: '2' ...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	tzkv	High  	...  Parameter: '@wssp154' Type: VarBinary Size: 0 Direction: Input   Parameter: '@wssp155' Type: NVarChar Size: 0 Direction: Input Value: ''   Parameter: '@wssp156' Type: NVarChar Size: 0 Direction: Input Value: ''	 
    02/24/2011 09:16:32.24 	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	d0d6	High  	System.Data.SqlClient.SqlException: Operand type clash: datetime is incompatible with uniqueidentifier   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.ConsumeMetaData()   at System.Data.SqlClient.SqlDataReader.get_MetaData()   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(Comm...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	d0d6	High  	...andBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)   at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock)   at Microsoft.SharePoint.SPSqlClient.ExecuteQueryInte...	 
    02/24/2011 09:16:32.24*	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Database           	d0d6	High  	...rnal(Boolean retryfordeadlock)   at Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean retryfordeadlock)	 
    02/24/2011 09:16:32.24 	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	General            	8e2s	Medium 	Unknown SPRequest error occurred. More information: 0x80131904	 
    02/24/2011 09:16:32.24 	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	General            	72k4	Medium 	<nativehr>0x80131904</nativehr><nativestack></nativestack>	 
    02/24/2011 09:16:32.24 	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	General            	8kh7	High  	<nativehr>0x80131904</nativehr><nativestack></nativestack>	 
    02/24/2011 09:16:32.24 	WSSCmdletsWrapper.exe (0x19C4)     	0x1128	SharePoint Foundation     	Content Migration       	nasm	High  	[List] [Shared Documents] An unexpected error has occurred.	 

    I have no clue....  The database server is the same, the sitecollection is the same. Why would it hang?

    Any help is appreciated.

    Regards,

    Kor

     

     

    Thursday, February 24, 2011 11:02 AM

Answers

  • Well i seem to have fixed it.

     

    Could be 2 things:

    1: I still had to run PSConfig after a patch. ( Not so likely )

    2: I disabled the loopbackcheck on the LSA registry key. ( More Likely ) I did this on the SharePoint servers that were used for the temporary restore storage.

    So if anyone is running into this on a machine that uses hostheaders please disable the loopbackcheck.

    Regards,

    Kor

    Monday, February 28, 2011 6:52 AM

All replies

  • Well i seem to have fixed it.

     

    Could be 2 things:

    1: I still had to run PSConfig after a patch. ( Not so likely )

    2: I disabled the loopbackcheck on the LSA registry key. ( More Likely ) I did this on the SharePoint servers that were used for the temporary restore storage.

    So if anyone is running into this on a machine that uses hostheaders please disable the loopbackcheck.

    Regards,

    Kor

    Monday, February 28, 2011 6:52 AM
  • Hi,

    Thanks for posting this. I had the same issue.

    Was fixed after I ran the SharePoint configuration wizard.

    Tuesday, October 25, 2011 10:16 AM