It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Excel Connector issue logging in Edited



I am having an issue with the Excel Connector add-on. I am generating an issue list in JIRA, exporting to Excel and then attempting to login to JIRA from the spreadsheet from the Excel Connector add-on tab in Excel.

I am getting the following error message

11/07/2014 12:00:02 Connecting to JIRA at as ddaly.
11/07/2014 12:00:05 Connected to JIRA successfully.
11/07/2014 12:00:28 ERROR: com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID FROM customfield WHERE cfname =  ?  (Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=')
11/07/2014 12:00:28    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Excel2JIRA.JiraSoapService.Excel2JiraSOAPService.getDropDowns(String in0, String[] in1, String[] in2, String in3)
   at Excel2JIRA.JiraConnector.GetDropDowns(String[] issueKeys, String[] columnNames)
   at Excel2JIRA.ExcelPopulator.RefreshSheetNew()
   at Excel2JIRA.RefreshWindow.RefreshWindow_Shown(Object sender, EventArgs e)

It seems to connect alright, but when I attempt to refresh I get a similar error message.

Can anyone help me?

2 answers

Hello Donncha,

Which language do you use in your JIRA and Excel?

English in both

0 votes

You're getting a collation error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE

Seems you need to switch your excel to use the same colation as JIRA which is UTF8.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Align

Best Practices in Jira Align

Hello Jira Align customers! In order to better serve you on your journey with Jira Align, the Community team has worked with the Jira Align team to curate the content in this collection to better s...

67 views 0 2
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you