Initial attempt at importing not going so well..

Tim Stubbs · Post by **Tim Stubbs** » Mon Jan 23, 2006 8:29 am

Just tried importing a single project (evaluating whether to switch) into the default repos. and here's what I get in the log:

"Opening: O:\srcsafe\srcsafe.ini
User: admin
VSS database open: True
Connected to Vault.
Logged out of the Vault Server.
There are 81 files and projects selected for import.
Refreshing SourceSafe connection...
Opening: O:\srcsafe\srcsafe.ini
User: admin
VSS database open: True
Connected to Vault.
Connected to Vault.

Beginning Export. 23/01/2006 14:20:41
Begin Export....

Memory used: 79073280.
Created ($/LEO_UIFs/PanelHolderBar) at 29/11/2005 10:29:28
Change set type: CreateFolder
Adding to transaction: $/LEO_UIFs/PanelHolderBar - $/PanelHolderBar
An error occurred while trying to end a transaction.
An exception was encountered during the transaction. Exception: Exception of type System.Exception was thrown. at VaultClientOperationsLib.ClientInstance.Commit(ChangeSetItemColl givenItems, Boolean keepCheckedOut, Boolean removeLocalCopy, Boolean bIsImport, DateTime dateImport, Int32 nUserIDImport, Int64& nRevID)
Transaction failed
Transaction failed
**Failed** - Error trying to commit. Exception of type System.Exception was thrown.
Trace: at VSSImport.WizardForm.ProcessTransaction(String strProgressText, DateTime dtg, Int32 userID)
23/01/2006 14:20:43 - Unable to commit for 29/11/2005 10:29:28 - $/LEO_UIFs/PanelHolderBar - Created .
Refreshing SourceSafe connection...
Opening: O:\srcsafe\srcsafe.ini
User: admin
VSS database open: True

23/01/2006 14:20:43 - Refreshing connection to the Vault server.

Logged out of the Vault Server.
Connected to Vault.
An error occurred while trying to end a transaction.
An exception was encountered during the transaction. Exception: Exception of type System.Exception was thrown. at VaultClientOperationsLib.ClientInstance.Commit(ChangeSetItemColl givenItems, Boolean keepCheckedOut, Boolean removeLocalCopy, Boolean bIsImport, DateTime dateImport, Int32 nUserIDImport, Int64& nRevID)
Transaction failed
Transaction failed
**Failed** - Error trying to commit. Exception of type System.Exception was thrown.
Trace: at VSSImport.WizardForm.ProcessTransaction(String strProgressText, DateTime dtg, Int32 userID)
23/01/2006 14:20:44 - Unable to commit for 29/11/2005 10:29:28 - $/LEO_UIFs/PanelHolderBar - Created .
Refreshing SourceSafe connection...
Opening: O:\srcsafe\srcsafe.ini
User: admin
VSS database open: True"

...and so on for each file.

Also shoud it be constantly reestabilishing the vault connection?

Apols, but we're not big on SQL Server here! Thanks folks..

lbauer · Post by **lbauer** » Mon Jan 23, 2006 8:42 am

Does the Vault server log file show any errors or useful information corresponding to the times of the commits? You can post it here or email it to linda at sourcegear.com.

One user ran into import problems because Vault Server options in the Admin Tool were set to require checkin comments, and files couldn't get checked in. Check your setting.

Also, review the Tips for a Successful import:

http://support.sourcegear.com/viewtopic.php?t=7

Tim Stubbs · Post by **Tim Stubbs** » Mon Jan 23, 2006 8:42 am

Just fired up the client and I can't create/add files folders to the repo. from there either with same error... Configuration issue somewhere?

lbauer · Post by **lbauer** » Mon Jan 23, 2006 8:45 am

The first step in diagnosing these problems is by taking a look at the Vault server log file.

Tim Stubbs · Post by **Tim Stubbs** » Mon Jan 23, 2006 8:47 am

lbauer wrote:Does the Vault server log file show any errors or useful information corresponding to the times of the commits? You can post it here or email it to linda at sourcegear.com.

One user ran into import problems because Vault Server options in the Admin Tool were set to require checkin comments, and files couldn't get checked in. Check your setting.

Also, review the Tips for a Successful import:

http://support.sourcegear.com/viewtopic.php?t=7

Hi Linda, thanks for the info.

I'll get the server log asap - it's in the server room

and i've no access to it from here (i've copied my SS db to a local on this PC and i'm importing to the server which was setup by our admin staff).

I've reviewed the tips (i'm downgraded to 6.0c from 6.0d for instance) too.

Checkin comments are not configured to be required in the repo. as per your suggestion (all are at default settings). I'm using SQL Server 2000 (afaik). Presumably the transaction commit is failed when trying to write to the DB somehow?

lbauer · Post by **lbauer** » Mon Jan 23, 2006 9:10 am

It could be a problem writing to the DB; it could be a proxy issue, maybe something else. First step is the server log. Email it to linda at SourceGear.com. Thanks.

Tim Stubbs · Post by **Tim Stubbs** » Mon Jan 23, 2006 10:34 am

lbauer wrote:It could be a problem writing to the DB; it could be a proxy issue, maybe something else. First step is the server log. Email it to linda at SourceGear.com. Thanks.

linda at sourcegear.com? I'll give that a go failing that should i use support at sourcegear.com? Will do it in about 5 mins

Tim Stubbs · Post by **Tim Stubbs** » Mon Jan 23, 2006 10:39 am

Done.

lbauer · Post by **lbauer** » Mon Jan 23, 2006 11:13 am

Thanks. I'd rather not have my actual email address listed on the forum as it generates spam. Hence the cryptic linda at sourcegear.com. A human can figure that out; a spider can't.

Tim Stubbs · Post by **Tim Stubbs** » Mon Jan 23, 2006 11:24 am

lbauer wrote:Thanks. I'd rather not have my actual email address listed on the forum as it generates spam. Hence the cryptic linda at sourcegear.com. A human can figure that out; a spider can't.

Apols

lbauer · Post by **lbauer** » Mon Jan 23, 2006 11:36 am

The checkin failure is due to this error in the log file:
"Failed to load Msxml2.dll"

See this KB article for a fix:

http://support.sourcegear.com/viewtopic.php?t=5020

There's also this error:

----1/23/2006 1:12:34 PM admin--Y510Q302(172.31.5.111)--SSL Disabled System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'tblusers' with unique index 'idxuserlogins'.
The statement has been terminated.

Update -- this last is a benign error -- it happens when importing users, but is not a problem.

Tim Stubbs · Post by **Tim Stubbs** » Tue Jan 24, 2006 2:52 am

Ok i've asked admin to implement the fix and i'll see how it goes.

FYI we've got 5gb of sourcesafe db to import, stretching back over 10 years..

Tim Stubbs · Post by **Tim Stubbs** » Tue Jan 24, 2006 3:31 am

Fix has been applied but a attempt to create a directory failed - here's this morning's log section:

"----1/24/2006 9:23:42 AM sgvaultsystem--()--
System Started
Version 3.1.6.3658
Cache Level = 1
DataBase Buffer Size (KB) = 256
LogFile Path = C:\WINNT\Temp\sgvault
Log Level = Quiet
Archive Log = Weekly
ReverseDNS Lookup = True
Maximum HTTP Request Length = 102400
Overwrite Log on Startup = False
Session Timeout = 4320
Active Directory Domain =
SGVault Working Directory = C:\WINNT\Temp
SGVault Server URL = http://LEO4/VaultService
Identity = LEO4\ASPNET
----1/24/2006 9:23:51 AM admin--Y510Q302(172.31.5.111)--SSL Disabled Login
----1/24/2006 9:24:21 AM admin--Y510Q302(172.31.5.111)--SSL Disabled System.Data.SqlClient.SqlException: Failed to load Msxml2.dll.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at VaultServiceSQL.VaultSqlSCC.CreateBubbleFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, String strXml, HybridDictionary& hdBubbles) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at VaultServiceSQL.VaultSqlSCC.CreateBubbleFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, String strXml, HybridDictionary& hdBubbles)
----1/24/2006 9:24:21 AM admin--Y510Q302(172.31.5.111)--SSL Disabled Could not create bubble folders: Error in the application. at VaultServiceSQL.VaultSqlSCC.CreateBubbleFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, String strXml, HybridDictionary& hdBubbles)
at VaultServiceAPILib.VaultServiceAPI.SaveRepository(VaultTransactionContainer txContainer, VaultRepository repOld, VaultRepository repNew)
----1/24/2006 9:24:21 AM admin--Y510Q302(172.31.5.111)--SSL Disabled (578070d7-1957-4691-8495-e84036613e7a) EndTx (Revision - 0) returned: FailDBInsert
----1/24/2006 9:24:21 AM admin--Y510Q302(172.31.5.111)--SSL Disabled (578070d7-1957-4691-8495-e84036613e7a) AddFolder: $/test returned: FailDBInsert
----1/24/2006 9:24:56 AM admin--Y510Q302(172.31.5.111)--SSL Disabled Logout "

I'm checking with the admin guy as to whether the patch has been correctly applied (i'd summise not!)

Tim Stubbs · Post by **Tim Stubbs** » Tue Jan 24, 2006 4:16 am

Ok we restarted eveything and i can now create folders/files... retrying the import for a single project

Tim Stubbs · Post by **Tim Stubbs** » Tue Jan 24, 2006 6:22 am

Hmmm it's going to take 1 day, 3 hours and 22 minutes for this single project.. SS is locally stored, but the vault db is on another machine on the LAN - will doing the import on the vault server pc make a drastic difference?