nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Bug while creating issue

John Varghese_oz5k03

I am unable to add an issue in jira.

The following error message occured

Exception occurred: com.atlassian.plugins.rest.common.json.JsonMarshallingException: org.codehaus.jackson.map.JsonMappingException: Caught SQLException for select ACTION.id, ACTION.issueid, ACTION.author, ACTION.actiontype, ACTION.actionlevel, ACTION.rolelevel, ACTION.actionbody, ACTION.created, ACTION.updateauthor, ACTION.updated, ACTION.actionnum from dbo.jiraaction ACTION where ACTION.issueid = ? and ACTION.actiontype = ? order by ACTION.created asc, ACTION.id asc offset ? rows fetch next ? rows only (through reference chain: com.atlassian.jira.quickedit.rest.api.field.QuickEditFields["createdIssueDetails"]->com.atlassian.jira.rest.v2.issue.IssueBean["fields"]->java.util.HashMap["comment"])
URL:www.selectindia.com

Accepted answers

All comments

Nic Brough -Adaptavist-

My best guess is that you're on JIRA 7.2 or above and you have set it up with a MS-SQL Server 2008 database back-end. Is that right?

Gary Smith

Yes, I am (SQL2008R2 actually). Is this a known compatibility issue?

Nic Brough -Adaptavist-

Yes, the database driver in JIRA 7 is not compatible with MS-SQL2008. You can't use an older one which is compatible with 2008 because they don't work with the version of Java JIRA 7 requires.

You'll need to move on to a supported database.

Gary Smith

I wish the installer had prevented me from wasting my time by checking the version number of sql server.

If moving on to a JIRA supported database was only so easy (and cheap).

I can't see any mention that jTDS isn't compatible with a particular version of java. I think it's JIRA that isn't compatibile. Which is a shame because I'm pretty sure the install base of 2008/r2 is probably greater that that of 2012/2014 combined.