The server had an error processing the file upload . . .

[TheSQLGuru]

WindowsXP SP2+, SQL Server Dev Edition 2000, Build 2600: Service Pack 2.

Sorry to trouble you, but my Vault system was working and then stopped accepting checkins/adds. I am pretty sure it must be some MS or other patch that was recently installed that is causing the problem, as I have not (to my recollection) changed any settings. I went through your FAQ and also the article http://support.sourcegear.com/viewtopic.php?p=2449. I have disabled Zone Alarm, AdSubtract, bypassed proxy, disabled chunked encoding and still get the same error in the client when trying to check in or add a file.

I also upgraded Vault to 3.5.1 from 3.1.7 and still get the same error.

The odd thing is that the server log doesn't seem to reflect the error:

----4/18/2007 8:12:12 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled Getting repository Structure-> Rep ID: 4 Base: 244 Target: -1
----4/18/2007 8:12:12 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled TreeManager: cache matches repository revision and folder security hasn't changed. Returning cached tree, revID 244
----4/18/2007 8:12:12 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled VaultServiceAPI::GetRepositoryTreeDelta() UserID:1 RepID:4 Base:244 Target:244 Calling VaultRepUtil.DiffRepTrees() - in-memory tree diff.
----4/18/2007 8:12:12 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled GetRepositoryStructure returned: Success
----4/18/2007 8:12:12 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled Getting list of checkout changes.
----4/18/2007 8:12:12 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled GetCheckOutListChanges returned: Success
----4/18/2007 8:12:52 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled BeginTx beginning transaction
----4/18/2007 8:12:52 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled TreeManager: cache matches repository revision and folder security hasn't changed. Returning cached tree, revID 244
----4/18/2007 8:12:52 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled (af913a04-1378-4742-9f80-77d9e8da8910) BeginTx returned: Success
----4/18/2007 8:12:52 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled (af913a04-1378-4742-9f80-77d9e8da8910) CheckIn: $/TPSQLSVR02/DBATools/Procedure/dbo.usp_HourlyTLogBackup.sql returned: Success
----4/18/2007 8:12:53 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled Receiving an uploaded file.
----4/18/2007 8:12:53 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled Receiving an uploaded file.
----4/18/2007 8:12:53 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled Receiving an uploaded file.
----4/18/2007 8:12:53 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled Ending transaction
----4/18/2007 8:12:53 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled (af913a04-1378-4742-9f80-77d9e8da8910) EndTx (Revision - 0) returned: Success
----4/18/2007 8:12:53 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled Getting repository Structure-> Rep ID: 4 Base: 244 Target: -1
----4/18/2007 8:12:53 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled TreeManager: cache matches repository revision and folder security hasn't changed. Returning cached tree, revID 244
----4/18/2007 8:12:53 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled VaultServiceAPI::GetRepositoryTreeDelta() UserID:1 RepID:4 Base:244 Target:244 Calling VaultRepUtil.DiffRepTrees() - in-memory tree diff.
----4/18/2007 8:12:53 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled GetRepositoryStructure returned: Success
----4/18/2007 8:12:53 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled Getting list of checkout changes.
----4/18/2007 8:12:53 AM admin--127.0.0.1(127.0.0.1)--SSL Disabled GetCheckOutListChanges returned: Success

[lbauer]

What error do you get on the client side?

Are you sure the file wasn't checked in?

What patch did you apply?

[TheSQLGuru]

I posted the client error as the subject, but it wouldn't fit. I forgot to post entire message. Sorry!

Here is the entire client-side message set when trying to check in a file that shows checked out in client:

[4/18/2007 8:12:52 AM] Preparing data to begin transaction
[4/18/2007 8:12:52 AM] Beginning transaction
[4/18/2007 8:12:53 AM] Check in $/TPSQLSVR02/DBATools/Procedure/dbo.usp_HourlyTLogBackup.sql
[4/18/2007 8:12:53 AM] Upload for item $/TPSQLSVR02/DBATools/Procedure/dbo.usp_HourlyTLogBackup.sql failed, retrying...
[4/18/2007 8:12:53 AM] Upload for item $/TPSQLSVR02/DBATools/Procedure/dbo.usp_HourlyTLogBackup.sql failed, retrying...
[4/18/2007 8:12:53 AM] Upload for item $/TPSQLSVR02/DBATools/Procedure/dbo.usp_HourlyTLogBackup.sql failed, retrying...
[4/18/2007 8:12:53 AM] Ending the transaction
[4/18/2007 8:12:53 AM] Upload for item $/TPSQLSVR02/DBATools/Procedure/dbo.usp_HourlyTLogBackup.sql failed too many times, aborting transaction.
Please verify your network settings using the Options dialog under the Tools menu in the Vault GUI Client.
The specific error was "The server had an error processing the file upload but did not return an error header. The remote server returned an error: (500) Internal Server Error."
An exception was encountered during the transaction. Exception: The server had an error processing the file upload but did not return an error header. The remote server returned an error: (500) Internal Server Error. at VaultClientOperationsLib.ClientInstance.UploadItem(ChangeSetItem item, String txID, Byte[]& streamBuffer, Int32& bytesWrittenThisFile, Boolean bIsImport)
at VaultClientOperationsLib.UploadThread.ProcessCommand(UploadThreadCommand command, UploadThreadCommandResult& outputResult)
[4/18/2007 8:12:53 AM] Transaction failed
[4/18/2007 8:12:53 AM] Transaction failed


Here is the entire client-side message set when trying to add a file that does not show on client:

[4/18/2007 9:08:47 AM] Preparing data to begin transaction
[4/18/2007 9:08:47 AM] Beginning transaction
[4/18/2007 9:08:47 AM] Add $/TPSQLSVR02/DBATools/Procedure/usp_NightlyTLogBackup.sql
[4/18/2007 9:08:47 AM] Upload for item $/TPSQLSVR02/DBATools/Procedure/usp_NightlyTLogBackup.sql failed, retrying...
[4/18/2007 9:08:47 AM] Upload for item $/TPSQLSVR02/DBATools/Procedure/usp_NightlyTLogBackup.sql failed, retrying...
[4/18/2007 9:08:47 AM] Upload for item $/TPSQLSVR02/DBATools/Procedure/usp_NightlyTLogBackup.sql failed, retrying...
[4/18/2007 9:08:47 AM] Upload for item $/TPSQLSVR02/DBATools/Procedure/usp_NightlyTLogBackup.sql failed too many times, aborting transaction.
Please verify your network settings using the Options dialog under the Tools menu in the Vault GUI Client.
The specific error was "The server had an error processing the file upload but did not return an error header. The remote server returned an error: (500) Internal Server Error."
An exception was encountered during the transaction. Exception: The server had an error processing the file upload but did not return an error header. The remote server returned an error: (500) Internal Server Error. at VaultClientOperationsLib.ClientInstance.UploadItem(ChangeSetItem item, String txID, Byte[]& streamBuffer, Int32& bytesWrittenThisFile, Boolean bIsImport)
at VaultClientOperationsLib.UploadThread.ProcessCommand(UploadThreadCommand command, UploadThreadCommandResult& outputResult)
[4/18/2007 9:08:48 AM] Ending the transaction
[4/18/2007 9:08:48 AM] Transaction failed
[4/18/2007 9:08:48 AM] Transaction failed

As for patch, I applied the 3.5.1 install (from 3.1.7). I did have an issue during the first attempt at upgrading because I did not have the 3.1.7 install msi file so that version could be uninstalled. I note that the Vault client now shows as vertion 3.5.1 (4786). I don't really know how to check the server aspx version.

I also note that I wasn't able to follow the instructions on checking the web service impersonation stuff in the 2449 article I referenced in my initial post. Not sure how to do that.

[lbauer]

I am pretty sure it must be some MS or other patch that was recently installed that is causing the problem, as I have not (to my recollection) changed any settings.

This was the patch I was referring to. Do you know specifically what it was?

We have another report of the same type of problem after installing certain MS updates -- we think it's a VS 2005 update.

Did you try a full uninstall of Vault, keeping the database, then reinstall?

[TheSQLGuru]

Sorry, I have installed a number of Microsoft patches fed to me by their automatic updates feature since I last used Vault, so I really have no idea which patch may have caused it. I don't even know which patches have been installed.

As I mentioned, I cannot uninstall the 3.1.7 version because I do not have the installer msi, which is required. I get a message saying I need "VaultServer_3_1_7.msi". Can you post it somewhere I can pick it up so I can uninstall 3.1.7 and 3.5.1 and try again??

Also, if I completely uninstall everything, will I lose user definition, settings, etc, or is all of that stored in the sql database?

[lbauer]

If you upgraded to Vault 3.5.1, I'm confused about why it's asking for the 3.1.7 msi file to uninstall . . .

You can get the server installer for 3.1.7 here:
http://download.sourcegear.com/files/Va ... _3_1_7.msi

All your data -- code, users, etc. is in your database, so you shouldn't lose anything. Be sure you make a backup of your SQL Server database before you go further.

[TheSQLGuru]

As I mentioned (I think) in my original post, when attempting to install 3.5.1 it wanted to uninstall 3.1.7 and could not because I don't have the 3.1.7 msi file. Also, you asked me to uninstall and reinstall, which I could not do for the 3.1.7 version (which still shows up in Add/Remove Programs as an application to uninstall).

I will follow up with another post after uninstalling everything and reinstalling.

[TheSQLGuru]

A full uninstall of 3.1.7 and 3.5.1 and a reinstall of 3.5.1 worked and I can now check in and add files. Thanks for the assistance!