Created On:  21 October 2011

Problem:

StarTeam has an EOL setting available for each non-binary file, which determines if EOL conversion is carried out upon checkout.  The following settings are available:

  • Fixed CR / LF
  • Fixed CR
  • Fixed LF
  • Client Defined
Client defined is the preferred setting in most mixed environments.

If the EOL setting is set to a fixed type, problems can occur in a mixed environment.

Resolution:

In the event of EOL issues, files should be checked for a Fixed EOL setting.

Fixed CR / LF (Windows Carriage Return Linefeed)

Execute the following SQL code against the StarTeam database (databasename should be edited to the StarTeam database name):

USE databasename
SELECT f.Name as [File Name], v.Name as [view], p.Name as [Project Name]
FROM syn_file f, syn_view v, syn_project p
WHERE v.ID = f.ViewID AND f.EOL = 258 AND v.ProjectId = p.ID

Fixed LF (Unix Linefeed)

Execute the following SQL code against the StarTeam database (databasename should be edited to the StarTeam database name):

USE databasename
SELECT f.Name as [File Name], v.Name as [view], p.Name as [Project Name]
FROM syn_file f, syn_view v, syn_project p
WHERE v.ID = f.ViewID AND f.EOL = 259 AND v.ProjectId = p.ID

Fixed CR (Apple Carriage Return)

Execute the following SQL code against the StarTeam database (databasename should be edited to the StarTeam database name):

USE databasename
SELECT f.Name as [File Name], v.Name as [view], p.Name as [Project Name]
FROM syn_file f, syn_view v, syn_project p
WHERE v.ID = f.ViewID AND f.EOL = 257 AND v.ProjectId = p.ID

The query will output the following:

File Name View Name Project Name

To resolve issues with identified files

  1. Log into StarTeam
  2. Open the project and view identified by the script
  3. Click File | All Descendents
  4. Press CTRL F to search for the file by name
  5. Right click the file
  6. Select "Properties"
  7. Change EOL check-out format to "Client Defined"


Incident #2532562