VSS Import Log Errors

lbauer · Post by **lbauer** » Wed Jan 03, 2007 1:18 pm

You may see many errors in the import.log file when you do a VSS Import. Some errors are not critical and you can still have a successful import. This description will help you troubleshoot VSS Import Tool errors.

This is a benign error -- it means the same users exist in VSS and in Vault

Code: Select all

----8/16/2006 11:43:14 AM    admin--server1.mydomain.com(123.23.23.1)--SSL Disabled	System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.tblusers' with unique index 'idxuserlogins'.
The statement has been terminated.

This is a bad history query (for instance, end date of query is prior to begin date) It could be a user error or import error. If it's an import error it could be due to bad history data in VSS.

Code: Select all

----8/16/2006 1:49:16 PM     admin--server1.mydomain.com(123.23.23.1)--SSL Disabled	GetHistoryQueryItems returned: FailInvalidRange 
----8/16/2006 1:49:19 PM     admin--server1.mydomain.com(123.23.23.1)--SSL Disabled	GetHistoryQueryItems returned: FailInvalidRange

This error appears to be a SQL timeout. An operation may have taken too long.

Code: Select all

 ----8/16/2006 4:48:45 PM     admin--server1.mydomain.com(123.23.23.1)--SSL Disabled	System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

This item import failed because the item already exists in the repository:

Code: Select all

----8/17/2006 5:05:08 AM     admin--server1.mydomain.com(123.23.23.1)--SSL Disabled		(2ed11783-ca53-4058-ae33-0022d924c9b7) AddFolder: $/My Data returned: FailObjAlreadyExists

This means an item was already pinned:

Code: Select all

----8/18/2006 3:19:11 AM     admin--server1.mydomain.com(123.23.23.1)--SSL Disabled		(e2f973fa-ead7-4b7d-bd1f-e83dbd81362c) Pin: $/Parent Folder/SubfolderA/SubfolderC/FileDEF.txt returned: FailPinnedItemPath

This is a deadlock of two transactions, with one being rolled back:

Code: Select all

----8/18/2006 3:19:12 AM     admin--server1.mydomain.com(123.23.23.1)--SSL Disabled	Logout 
----8/18/2006 3:19:13 AM     admin--server1.mydomain.com(123.23.23.1)--SSL Disabled	Login 
----8/18/2006 3:19:14 AM     admin--server1.mydomain.com(123.23.23.1)--SSL Disabled	(6fa123a7-7f2f-42bf-9077-486178336f41)  returned: Failure ----8/18/2006 9:38:19 AM     admin--server1.mydomain.com(123.23.23.1)--SSL Disabled	System.Data.SqlClient.SqlException: Transaction (Process ID 56) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at VaultServiceSQL.VaultSqlSCC.SaveFoldersEntryDeltas(VaultSqlConn conn, String strXml)    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at VaultServiceSQL.VaultSqlSCC.SaveFoldersEntryDeltas(VaultSqlConn conn, String strXml)
----8/18/2006 9:38:19 AM     admin--server1.mydomain.com(123.23.23.1)--SSL Disabled	Could not save folder entries: Error in the application.

This means there's error in accessing the Vault database:

Code: Select all

----8/18/2006 9:38:26 AM     admin--server1.mydomain.com(123.23.23.1)--SSL Disabled	(00444698-2597-4190-b7e5-5b9666d6c9f6) EndTx (Revision - 0) returned: FailDBInsert 
----8/18/2006 9:38:26 AM     admin--server1.mydomain.com(123.23.23.1)--SSL Disabled		(00444698-2597-4190-b7e5-5b9666d6c9f6) AddFile: $/Parent Folder/SubfolderA/SubfolderB/FileABC.txt returned: FailDBInsert

This error and the deadlock errors are from SQL Server -- perhaps SQL Server is running out of space or can't keep up with the import because there isn't enough CPU or memory.

Code: Select all

----8/18/2006 9:38:19 AM     admin--server1.mydomain.com(123.23.23.1)--SSL Disabled	EndTx(): Failed commit changes for TxID 621641 
----8/18/2006 9:38:19 AM     admin--server1.mydomain.com(123.23.23.1)--SSL Disabled	SQL transaction 5647 successfully rolled back.