What is the rootmemberid column in syn_view represents? and if it"s value is -1, what does it mean?

0 Likes

Problem:

What is the rootmemberid column in syn_view represents? and if it"s value is -1, what does it mean?

Resolution:

  • Product Name: StarTeam
  • Product Version: 2006/2008
  • Product Component: Database
  • Platform/OS Version: All Supported OS

Description:
What is the rootmemberid column in syn_view represents? and if it"s value is -1, what does it mean?


Answer/Solution:

"RootMemberID" in syn_view referes to the root view member id for this view to be based upon. A value of -1 basically indicates it was not set... ie the view never got fully created. If you find any record with rootmemberid as -1, then that view is corrupted & can not be deleted using ST client. To identify such views...run the below query

Select v.id ViewID, v.name ViewName, v.projectid ProjectID, p.name ProjectName
from syn_view v, syn_project p
where v.projectid = p.id
and v.rootmemberid = -1
and v.deletedtime = 0
and v.deleteduserid = -1



If the query returns any records, please contact tech support for assistance to cleanup the corrupted data.




Author: Praveen Boyeneni

Old KB# 29017
Comment List
Related
Recommended