error when requesting "show labels"

DarrenS · Post by **DarrenS** » Wed Feb 25, 2004 11:07 pm

Using Vault 2.0 - client + server.

Periodically, when we right click a folder in the GUI client and select "show labels", we get an error dialog saying something like, "FailDBInsert"

I turned on Debug logging for Vault, and this is what I found:

Code: Select all

----2/23/2004 4:59:16 PM     admin--MyServerName(10.1.107.101)--SSL Disabled
	INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'fk_tblsessionrecursivelabelqueries_tblsessions'. The conflict occurred in database 'sgvault', table 'tblsessions', column 'sessionid'.
The statement has been terminated.
----2/23/2004 4:59:16 PM     admin--MyServerName(10.1.107.101)--SSL Disabled
	BeginLabelQuery returned: FailDBInsert

We're wondering if this has something to do with trying to log in simultaneously from different client machines...we weren't trying exactly that, but it's not out of the question.

Post by **jclausius** » Thu Feb 26, 2004 9:09 am

darren:

if you shut down the gui client, re-login, and show labels on the same folder, does it happen again?

anything you can provide on how to recreate this would be welcome.

Guest · Post by **Guest** » Thu Feb 26, 2004 1:56 pm

I'll let you know if we figure out the minimal scenario to recreate it.

One thing I can tell you - restarting IIS on the Vault server fixes the problem (for a while).

Post by **jclausius** » Thu Feb 26, 2004 10:54 pm

just exiting the gui client will release your session, thus clearing your rows within the sessions table.

i've got some testing to do w/ labels for an upcoming release. if you happen to recreate this, please let me know.

thx,
jeff