JIRA duplicated none custom fields deletion

tw_633n02

Hi support team,

I have an issue of none-custom fields appearing on JIRA issues screen.

There are two fields called Attachments now, one which is right another one which might be left of recently add-on installed and uninstalled for trail reasons. Also, a 2nd field called Issue Deployment, that is left for same reason. Have a look at screenshots attached.

Both are none custom fields, so far cannot be eliminated easily. Even by JIRA update there is no chance of having vanished both.

Since they both appear in every project and every issue, those fields seem to be database persistent. I am still using the JIRA internal H2 db.

My question now would be how to eliminate both fields of the H2 db?

 

Thanks in advance for supporting.

 

Regards

tw

 

Earl McCutcheon

Hi Tobias,

The H2 Database is highly volatile as susceptible to corruption as it is an in memory database, and any hiccup in the memory can completely cripple the data, which is why H2 is only recommended to front end system evaluation only.  When errors occur on a H2 database the best course of action is to delete the instance and start over.  And on the surface this looks like data corruption has occurred.

If this is production data accidentally stored on an H2 database, I would recomend attempting to migrate the data to an alternate database supported by the platform, the process to do this is covered in the documentation "Switching databases" as your best coarse of action.

Alternatively, and I do not have any specific examples of the syntax for this but if you wanted to attempt to correct the error in the h2 DB, steps to access the database can be found In this KB, and then refer to the H2 documentation for the syntax to do a Delete on the duplicate value from the 'customfield' table 'H2 Documentation can be found here'

Regards,
Earl