Hi,
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 https://jira.xxx.com:8400 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?