Import failure - Unexpected failure occurred. Importer will stop immediately.

[Nick Cherrill]

Hi all,

Trying to setup Jira SD for the first time, importing data from a .tsv is failing after importing everything up to the issues successfully. Can anyone assist diagnosing the import exception? It looks like SQL may be causing it when the insert command is run.

I see DataAccessException and GenericEntityException along with a couple of others. It only imports 23 of the 2,000 + issues from our SolarWinds WHD.

2018-09-06 17:10:51,130 INFO - ------------------------------
2018-09-06 17:10:51,130 INFO - Finished Importing : Issues
2018-09-06 17:10:51,130 INFO - ------------------------------
2018-09-06 17:10:51,130 ERROR - Unexpected failure occurred. Importer will stop immediately. Data may be in an unstable state
com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:IssueType][name,Hardware : Peripheral (Monitors, mice, personal printers, etc.)][iconurl,/images/icons/issuetypes/genericissue.png][description,][style,null][id,10103] (SQL Exception while executing the following:INSERT INTO dbo.issuetype (ID, SEQUENCE, pname, pstyle, DESCRIPTION, ICONURL, AVATAR) VALUES (?, ?, ?, ?, ?, ?, ?) (String or binary data would be truncated.))
	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:299)
	at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:172)
	at com.atlassian.jira.config.AbstractIssueConstantsManager.createConstant(AbstractIssueConstantsManager.java:43)
	at com.atlassian.jira.config.DefaultIssueTypeManager.createIssueTypeAndAddToDefaultScheme(DefaultIssueTypeManager.java:146)
	at com.atlassian.jira.config.DefaultIssueTypeManager.createIssueTypeAndAddToDefaultScheme(DefaultIssueTypeManager.java:171)
	at com.atlassian.jira.config.DefaultIssueTypeManager.createIssueType(DefaultIssueTypeManager.java:98)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)
	at com.sun.proxy.$Proxy35.createIssueType(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
	at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)
	at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)
	at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
	at com.sun.proxy.$Proxy1089.createIssueType(Unknown Source)
	at com.atlassian.jira.plugins.importer.managers.CreateConstanstManagerImpl.addNewIssueType(CreateConstanstManagerImpl.java:89)
	at com.atlassian.jira.plugins.importer.managers.CreateConstanstManagerImpl.addConstant(CreateConstanstManagerImpl.java:74)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.translateIssueConstants(DefaultJiraDataImporter.java:1115)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.createIssue(DefaultJiraDataImporter.java:900)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.importIssues(DefaultJiraDataImporter.java:797)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:414)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:26)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:15)
	at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:458)
	at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:426)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:216)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:IssueType][name,Hardware : Peripheral (Monitors, mice, personal printers, etc.)][iconurl,/images/icons/issuetypes/genericissue.png][description,][style,null][id,10103] (SQL Exception while executing the following:INSERT INTO dbo.issuetype (ID, SEQUENCE, pname, pstyle, DESCRIPTION, ICONURL, AVATAR) VALUES (?, ?, ?, ?, ?, ?, ?) (String or binary data would be truncated.))
	at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:206)
	at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:171)
	at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:89)
	at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:562)
	at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:548)
	at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:114)
	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:296)
	... 47 more
Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO dbo.issuetype (ID, SEQUENCE, pname, pstyle, DESCRIPTION, ICONURL, AVATAR) VALUES (?, ?, ?, ?, ?, ?, ?) (String or binary data would be truncated.)
	at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:570)
	at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:198)
	... 53 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:467)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:409)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2478)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:356)
	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
	at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:562)
	... 54 more

Any help will be appreciated, I'm not familiar enough with SQL exceptions to diagnose this and the answers on this forum I've read don't seem to address it.

Thanks,

N

[Keri]

Hi Nick, 

Welcome to the Atlassian Community! 

It looks like your issuetype name is "Hardware : Peripheral (Monitors, mice, personal printers, etc.)"

Issue types are set to a maximum of 60 characters and this is 63 so this may be causing the issue. 

I'd recommend you try updating the issuetype name to something a little shorter and trying again. 

Cheers,

Keri

[Nick Cherrill]

Thanks, I'll give that a go. Appreciate the answer.

What is the best way to see the character limits for each field in Jira?