After upgrading to StarTeam 2008 R2 the error "No such table or view "syn_ObjectSecurityLog"" is reported, and the Configuration fails to start.

0 Likes

Problem:

After upgrading to StarTeam 2008 R2 the error "No such table or view "syn_ObjectSecurityLog"" is reported, and the Configuration fails to start.

Resolution:


  • Product Name: StarTeam
  • Product Version: 2008 R2
  • Product Component: Server Upgrade
  • Platform/OS Version: All

This error can occur after upgrade if the StarTeam database views have become corrupted, or did not upgrade correctly. StarTeam should attempt to recreate these views automatically whenever the configuration is restarted. If however you consistently get this error, you can manually resolve this by performing the following.

Note: These steps below assume that SQL Server 2005 is in use, and that you have access to the SQL Server 2005 Management Studio - the options may not be available with SQL Server 2005 Express. Similar functionality should be available with Oracle.

  1. First of all ensure that the StarTeam database views do not exist
  2. To do this using the SQL Server Management Studio, expand the required StarTeam database until you can access the "Views" tree
  3. If any views are available, please contact Borland support for additional advice on resolving this error - this solution is only applicable if no views are shown.
  4. To continue, expand the "Programmability | Stored Procedures", and locate the dbo.install_database_views stored procedure (see image below)
  5. Right-click this procedure, and select "Execute Stored Procedure..." (this option is not available on SQL Server Express - in which case, you can use the "Script Stored Procedure as" option)
  6. When prompted, please ensure that you check the "Pass Null Value" parameter (see image at bottom of page).
  7. Press "OK" to execute this procedure - this will now recreated all the StarTeam Views.
  8. Refresh the SQL Server tree to ensure the views are created.
  9. Restart the StarTeam configuration to confirm that this has been successful.

install database views


If the problems continue to exist contact Borland Support.


Old KB# 30112
Comment List
Related
Recommended