問題

If an invalid character (like a line separator) is part of one or more project names, the Jira External Import for CSV will not be able to render the Project List, as seen on the following screenshot:

再現手順

To reproduce this issue you will need to create a new project and add an non-ASCII character into it, as per instructions below. An example of an invalid project name that contains a line separator appended to its end:

Invalid Character Project


1. Go to Jira Administration (cog icon).
2. Click on External System Import and then select the CSV option.
3. Select a source file and click Next.
4. Select a project on the Import to Project combo box.

5. The combo box will show No Matches and the following appears in the browser Console:

Uncaught Error: AJS.Descriptor: expected property [label] but was undefined

診断

Run the following query to identify non-ASCII characters on the project names:

select pname from project where not pname ~ ( '^('||
$$[\09\0A\0D\xA1-\xFF]|$$||               -- ASCII ext')*$' );

Alternative diagnostic steps

1. Run a select on the projects table, to extract the entire list of projects:

   SELECT pname FROM project;

2. Export the results and open using a text editor like TextMate or Sublime.
3. Look around for any invalid characters. On TextMate these show up on a different color and within _<>_ characters.h3. Work-around

原因

There is the character <U+2028> on the name of the project. You should be able to check it upon copying/pasting the project nameto a text editor like TextMate or Sublime.

ソリューション

Find the projects with invalid characters by running the Diagnostics steps and rename it using the "Edit Project" option in the Project Administration section. No reindex or downtime is needed.