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.
fatal error applying label - db insert fails
Moderator: SourceGear