Cannot view or add labels on a folder

vonwyss · Post by **vonwyss** » Tue Jan 09, 2007 1:12 am

Hi!

On one folder in our repository, we can no longer view labels or add a new label.

This is very recent and only applies to this one folder.

The client displays a rather unhelpful FailDBInsert message when trying to add a new label as well as when trying to display labels.

The server log is more explicit: When trying to add a new label, the following appears:

----08.01.2007 16:00:36 admin--isabella-one.garaio.com(194.230.65.129)--SSL Disabled System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__#tbllabelview_____7FCC985B'. Cannot insert duplicate key in object 'dbo.#tbllabelview'.
The statement has been terminated.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.AddLabel(VaultSqlConn conn, Int32 nRepID, Int32 nUserID, VaultLabelItem vLabel, Int64& nLabelID, Int64& nObjID, String& strExistingRootPath) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.AddLabel(VaultSqlConn conn, Int32 nRepID, Int32 nUserID, VaultLabelItem vLabel, Int64& nLabelID, Int64& nObjID, String& strExistingRootPath)
----08.01.2007 16:00:36 admin--isabella-one.garaio.com(194.230.65.129)--SSL Disabled AddLabel returned: FailDBInsert

When trying to show labels, the following appears:

----08.01.2007 16:00:36 admin--isabella-one.garaio.com(194.230.65.129)--SSL Disabled System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__#tbllabelview_____7FCC985B'. Cannot insert duplicate key in object 'dbo.#tbllabelview'.
The statement has been terminated.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.AddLabel(VaultSqlConn conn, Int32 nRepID, Int32 nUserID, VaultLabelItem vLabel, Int64& nLabelID, Int64& nObjID, String& strExistingRootPath) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.AddLabel(VaultSqlConn conn, Int32 nRepID, Int32 nUserID, VaultLabelItem vLabel, Int64& nLabelID, Int64& nObjID, String& strExistingRootPath)
----08.01.2007 16:00:36 admin--isabella-one.garaio.com(194.230.65.129)--SSL Disabled AddLabel returned: FailDBInsert

We restarted the server but did not notice any improvement.

Showing labels does not work for this one folder, child folders below it and its parent folders; however, it still does work for all sibling folders.

Please advise on how we can fix this. It is breaking our continuous integration/build cycle and therefore quite hurting.

Thanks in advance

Leo

lbauer · Post by **lbauer** » Tue Jan 09, 2007 8:17 am

What version of Vault are you currently using?

When you first started using Vault, what version was it?

vonwyss · Post by **vonwyss** » Wed Jan 10, 2007 3:46 am

lbauer wrote:What version of Vault are you currently using?

When you first started using Vault, what version was it?

We are now running Vault 3.5.1, we started in summer 2005 with 3.0.x (can't find the exact version right now).

Regards,

Leo

lbauer · Post by **lbauer** » Wed Jan 10, 2007 5:17 pm

There may be an inconsistency in the database and we might need to take a look at it here.

Would you contact me via support at sourcegear.com ATTN Linda, and we'll pursue this further.