ADD Jira server Issue Collector Error

[Janaki.nimmala]

Hi ,

Could you please help with the error while trying to create Issue collector in Jira server. This is my first time creating.

Error

You cannot create an issue collector for this project, because the following fields are required on the project and those field types cannot be displayed to anonymous users. If the field is changed to be optional or a default value is provided, then an issue collector can be created for the project. Not allowed fields: Time status.

[Septa Cahyadiputra · Accepted solution]

Hi David,

First thing first, double check if there are any firewall in front of JIRA that might restrict any sql file to go trough as it might think that this is an SQL attack and the firewall trying to prevent it.

Second cause is due to incorrect MIME type reported to the browser. This might cause by pgSQL Admin on the victim machine had written a MIME type text\plain instead of text/plain into the Windows registry. Please try the following steps to fix it:

1. Open your regedit program on the Windows machine
2. Seach for the string "text\plain"
3. If found, check for the presence of PgSQL Admin and remove it

Hope it helps.

Cheers,
Septa Cahyadiputra

[David FALLAS]

Perfect! Hit the nail right on the head. It was the text\plain that caused the problem after installling pgAdmin III. I simply updated the Registry value as advised and I can now attach SQL files to JIRA issues again.

[David FALLAS]

Even more puzzling now after a little experimentation. Previously, the file I was attempting to attach had the file name V_SPECIMEN_ACTION_RECORDS.SQL. When I changed the name of the file to V_SPECIMEN_ACTION_RECORDS.SQL.TXT JIRA no longer throws the exception.