problem facing in creating issue on jira 5.0.7

while creating the issue we are facing the problem called "Error creating issue:-Error occured while storing issue"


2 answers

1 vote

You will need to read the application log for more details on what the actual error is.

Also check the permissions in DB side.

After checking logs i can see this below error

Exception while executing the following:INSERT INTO jiraaction (ID, issueid, AUTHOR, actiontype, actionlevel, rolelevel, actionbody, CREATED, UPDATEAUTHOR, UPDATED, actionnum) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: *'\xD1\x82\xD0\xB5\xD1\x81...'* for column 'actionbody' at row 1))


So there's rubbish being put into a comment somehow. Check with the user to see what they are entering? I'd also check if you've got everything set up for utf-8 correctly

And, again, read the application logs - that database error is likely to be only part of the problem, and you need to know what all of it is.

What is the database type? MySQL? Like Nic said, check the character set for the database.

Read the command at - https://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+MySQL#ConnectingJIRAtoMySQL-2.CreateandConfiguretheMySQLDatabase

Suggest an answer

Log in or Sign up to answer
Community showcase
Published yesterday in Opsgenie

Getting the Most out of Atlassian and Opsgenie Together

We’re excited to invite you to this action-packed webinar where we will demonstrate how to integrate Opsgenie’s powerful alerting and on-call management tools with your entire Atlassian stack. Mar...

23 views 0 0
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you