-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Highest
-
Affects Version/s: None
-
Component/s: Mantis
-
Environment:JIM 6.0.11 (also verified with 6.0.25)
JIRA 6.0.1
Mantis 1.2.8
PostgreSQL 9.0.12
When I fill all fields in correctly and the migration process starts, I get a vague exception (see below) which causes none of the Mantis ticket attachments to be imported.
Our Postgres db is logging everything, but no error is logged. This makes me believe the error is being generated by the JDBC driver, before a query is made.
- Is this a known error? (I believe not, as my search yielded to no results)
- Can I enable more logging at the Jira Importer level to provide you with more information? (I already enabled SQL logging, but did not find any relevant statements in there)
As this is blocking us in our Mantis migration, we would like to fix this urgently.
Thank you.
2013-09-30 16:42:31,161 ERROR - Failed to attach attachments to issue ABC-10 com.atlassian.jira.plugins.importer.SQLRuntimeException: Bad value for type long : \x at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:177) at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:146) at com.atlassian.jira.plugins.importer.imports.mantis.MantisDataBean.getAttachmentsForIssue(MantisDataBean.java:113) at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.createIssue(DefaultJiraDataImporter.java:979) at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.importIssues(DefaultJiraDataImporter.java:830) at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:415) 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:365) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:249) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: Bad value for type long : \x at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toLong(AbstractJdbc2ResultSet.java:2971) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getLong(AbstractJdbc2ResultSet.java:2163) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBlob(AbstractJdbc2ResultSet.java:378) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBlob(AbstractJdbc2ResultSet.java:366) at com.atlassian.jira.plugins.importer.imports.mantis.transformer.AttachmentTransformer.copyAttachment(AttachmentTransformer.java:67) at com.atlassian.jira.plugins.importer.imports.mantis.transformer.AttachmentTransformer.transform(AttachmentTransformer.java:52) at com.atlassian.jira.plugins.importer.imports.mantis.transformer.AttachmentTransformer.transform(AttachmentTransformer.java:25) at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:164) ... 15 more