Vault Check in - not allowing

[sedc]

We are experiencing a big problem with check in option. Valut client is not allowing the users to check in their files from their systems. It is not allowing to do an undo check out also. We had to login with admin rights / login on a different system and do the undo checkout. In last one week it happend 5-6 times and we had to lose many changes.

Any ideas please.

Thanks,

Sudha Suddala
Web Development Lead.

[bfinney]

We'll need to get some more info from you in order to diagnose what's going on. Specifically:

What version of vault are you running?

What error messages do the clients receive when the checkins fail?

Is there any relevent entries in the vault server log?

[sedc]

We are experiencing this problem again.

I do not see any related entries in Vault log file (sgvault.log). It works for some files and some users, and for some it won't.

I have attached the log file.

Version: Vault Server 3.0.7

New issue: We are experiencing problem with the DELETE operation also. You can find entries for this problem in the log attached.

Thanks,
Sudha Suddala.

[lbauer]

First let's deal with the delete problem:

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

Next, the checkin problem. When a user is unable to checkin a file, is this the error in the log that corresponds to the time of the failed checkin?

----1/24/2006 3:25:09 PM JohnP--WDE_JOHNP(10.1.0.103)--SSL Disabled BeginTx returned: FailOutofDateObjVerID
----1/24/2006 3:25:09 PM JohnP--WDE_JOHNP(10.1.0.103)--SSL Disabled VaultLib.VaultRequestCheckIn returned: FailOutofDateObjVerID

[sedc]

Check in option:

The checkin option in the menu itself is disabled. So we are not even able to click the option.

Delete :
Thanks for the information. We will check the settings in the reply that you have mentioned and will get back.

Thanks for the help,
Sudha Suddala.

[sedc]

Here are the vaules from the query that was given in the previous topic. Please check and let us know if they need to be changed.

ANSI_NULLS - 0

ANSI_PADDING - 0

ANSI_WARNINGS - 0

ARITHABORT -0

CONCAT_NULL_YIELDS_NULL - 0

QUOTED_IDENTIFIER - 1

NUMERIC_ROUNDABORT - 0

Here is the query Just in case if you need for reference:

SELECT

DATABASEPROPERTYEX('sgvault', 'IsAnsiNullsEnabled') AS [ANSI_NULLS],

DATABASEPROPERTYEX('sgvault', 'IsAnsiPaddingEnabled') AS [ANSI_PADDING],

DATABASEPROPERTYEX('sgvault', 'IsAnsiWarningsEnabled') AS [ANSI_WARNINGS],

DATABASEPROPERTYEX('sgvault', 'IsArithmeticAbortEnabled') AS[ARITHABORT],

DATABASEPROPERTYEX('sgvault', 'IsNullConcat') AS [CONCAT_NULL_YIELDS_NULL],

DATABASEPROPERTYEX('sgvault', 'IsQuotedIdentifiersEnabled') AS [QUOTED_IDENTIFIER],

DATABASEPROPERTYEX('sgvault', 'IsNumericRoundAbortEnabled') AS [NUMERIC_ROUNDABORT]


Thanks,
Sudha Suddala.

[lbauer]

The settings on my sgvault database are:

ANSI_NULLS - 1

ANSI_PADDING - 1

ANSI_WARNINGS - 1

ARITHABORT -1

CONCAT_NULL_YIELDS_NULL - 1

QUOTED_IDENTIFIER - 1

NUMERIC_ROUNDABORT - 0

The number 1 means the item is enabled.

[sedc]

Thank you. We will change the values as speficied and see how it goes.

Check in option:

Could you give us any clue on why check in menu option is disabled?

Thanks,
Sudha Suddala.

[sedc]

From what I gather, we need to use query analyzer to change these settings. Is there any other tool / way to change these settings, please let me know.

Thanks for your help,
Sudha Suddala.

[lbauer]

we need to use query analyzer to change these settings

Sounds like a good plan. If you continue to see the checkin menu problem after the SQL configuration is fixed, let us know.