This is a migrated thread and some comments may be shown as answers.

Unexpected error while installing

1 Answer 71 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Mehmet
Top achievements
Rank 1
Mehmet asked on 29 Jul 2010, 08:16 AM
I am trying to install standard edition of TeamPulse and getting an unexpected error. Using Windows Server 2008 R2 and SQL Server Express R2.

Thanks,

-Mehmet

Executing sql script DatabaseExtensions.TeamPulse_CreateSchema.sql on connection server=(local)\sqlexpress;Integrated Security=true;DATABASE=master
MSI (s) (1C!04) [10:10:32:112]: Closing MSIHANDLE (118) of type 790531 for thread 5892
MSI (s) (1C!04) [10:10:33:917]: Creating MSIHANDLE (119) of type 790531 for thread 5892
Failed to execute sql, exception details: Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Invalid column name 'projectid'.
Invalid column name 'iterationid'.
   at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
   --- End of inner exception stack trace ---
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand)
   at DatabaseExtensions.CustomActions.ExecuteSQL(Session session, String connectionString, String sql)
   at DatabaseExtensions.CustomActions.ExecuteSqlContent(Session session, String contentName)
MSI (s) (1C!04) [10:10:33:919]: Closing MSIHANDLE (119) of type 790531 for thread 5892
MSI (s) (1C!04) [10:10:33:919]: PROPERTY CHANGE: Adding INSTALLERROR property. Its value is '**********'.




1 Answer, 1 is accepted

Sort by
0
Accepted
David Harris
Telerik team
answered on 29 Jul 2010, 03:18 PM
Hi Mehmet,

Unfortunately we appear to have a bug in our database creation script in that it is not specifying the database collation when creating the TeamPulse database. Without specifying the collation it appears to be inheriting the collation default of the server it is installed on, which I presume is Case-Sensitive in your scenario. The TeamPulse database needs to be Case-Insensitive for our scripts and queries to run, hence the error you are seeing.

We will rectify this situation in an upcoming service pack, however the only workaround I can see at this time is for you to select a SQL Server instance that is configured to use a default Case-Insensitive (CI) collation value.

Best wishes,
David Harris
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
General Discussions
Asked by
Mehmet
Top achievements
Rank 1
Answers by
David Harris
Telerik team
Share this question
or