fatal error applying label - db insert fails

This forum is now locked, since Gold Support is no longer offered.

Moderator: SourceGear

Locked
bgreene
Posts: 3
Joined: Tue Jan 24, 2006 11:50 am

fatal error applying label - db insert fails

Post by bgreene » Thu May 18, 2006 8:52 pm

When labeling several folders in a particular folder I get the following error in the log:

Cannot insert the value NULL into column 'objversion', table 'sgvault.dbo.tblfsobjectlabels'; column does not allow nulls. INSERT fails.
The statement has been terminated.
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)

I noted there is another thread with a similar topic/same error message, but the resolution was offline.

This is happening in one particular repo, but not all of them. We'd like to get it resolved though.

Running vault 3.1.8 (upgraded from 3.1.6) on Win2003 server against SQLServer 2000 DB.

Looking forward to resolution.

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Post by lbauer » Fri May 19, 2006 9:08 am

We will need to take a look at your database. Please email linda at sourcegear.com for details.
Linda Bauer
SourceGear
Technical Support Manager

Locked