Issue

Orchestration Framework Services not starting getting following message in loggingsevices.log

2016-04-05 14:38:00,908 [8] ERROR OrchFwrk.General [(null)] - Failed to start OF shepherd: The following exception was thrown:Invalid column name 'XFlags'.Exception-ToString():System.Data.OleDb.OleDbException: Invalid column name 'XFlags'.

   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)

   at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()

   at BSI.Orchestration.Shepherd.Shepherd.registerInstalledApplications()

   at BSI.Orchestration.Shepherd.Shepherd.StartThreadMain()Exception-Message:Invalid column name 'XFlags'.Exception-InnerException:Exception-type:System.Data.OleDb.OleDbException Exception-Source:Microsoft OLE DB Provider for SQL Server

Exception-TargetSite:System.Data.OleDb.OleDbDataReader ExecuteReaderInternal(System.Data.CommandBehavior, System.String)

Exception-HelpLink:Exception-Process:Shepherd.exeException-StackTrace:at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)

at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()

at BSI.Orchestration.Shepherd.Shepherd.registerInstalledApplications()

 at BSI.Orchestration.Shepherd.Shepherd.StartThreadMain()

Solution:

When creating a new OF database it will use the default Collation of the SQL server. If the SQL server has collation like for example “Latin1_General_bin” OF database will also use it. And this will cause OF to fail because of the wrong collation. It is recommended to use “Latin1_General_100_CP1_CI_AS” collation (collation that has CI AS) in the OF and PW databases. And if the SQL server has other collation – then create new OF database in the SQL Management Studio and set right collation.

Environment: Windows server 2008R2

SQL Server: 2012

ProjectWise version: CONNECT edition 10.00.00.20