Specific field value has been lost in jira issues, how to recover that value?

[Pramod Kumar Reddy]

Hello Community Team,

Specific field value has been lost in jira issues due to wrong scriptrunner script. 

In the issue create and edit screen, we have a list field called “Basket”; that is the mandatory field.

It was working as expected, due to script malfunction We got up with a problem where the basket value was not updated for issue and was getting bypassed as optional (null) on some updated Jira issues, and existing data on the basket in issue was lost. 

for existing value of the field, there is no observation on history.

Now, how to recover the values of specific field for existing issues ?

[Tiago Comasseto]

Hi Rahul,

I see this message in this stack trace "Unable to esablish a connection with the database", it seems to me related to a database connection issue. Do you have a validation query set in your instance? You may want to see this documentation.

Cheers

[Rahul Aich [Nagra]]

Hi Tiago...i am on 4.1.2 so i have server.xml and in it i have validationQuery="select 1"/>.

What else can be the source of the issue.

Rahul