Problem:

"Msg = Cannot find either column "dbo" or the user-defined function or aggregate "dbo.ConvertSTTimestamp", or the name is ambiguous." in server log

Resolution:

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

Description:

"108 00000004 2008-03-24 16:02:45 Exception handled at CStServerUtils::InstallStoredProc_10: Class = CDBException, Code = 4294967295(0xffffffff)
Msg = Cannot find either column "dbo" or the user-defined function or aggregate "dbo.ConvertSTTimestamp", or the name is ambiguous.

[Function Name] = CStDatabase::InstallStoredProc
[Stored procedure path] = C:\Program Files\borland\StarTeam Server 2008\DBScripts\SqlServer_Scripts\DW\Create_Stored_Procedures\starteam_sqlserver_create_dw_workrecord.sql
[ODBC Error] = State:37000,Native:4121,Origin:[Microsoft][SQL Native Client][SQL Server]"

exception in server log upon startup.

Answer/Solution:

This issue is a result of the StarTeam database being in SQL Server 2000 (or SQL Server 7.0) compatibility mode within SQL Server 2005. To resolve this, open the SQL Server Management Studio, right-click the StarTeam database and select Properties. On the resulting screen, select "Options" from the left hand side then find the "Compatibility level: " drop down on the right hand side. Change this value to "SQL Server 2005 (90)". The reason for this is either the SQL Server 2000 instance was upgraded to SQL Server 2005 or the StarTeam database was exported from a SQL Server 2000 instance and imported into SQL Server 2005. Both of these results in the StarTeam database being in SQL Server 2005 but in SQL Server 2000 compatibility mode.