Project Configurator: java.lang.NumberFormatException: null

[Loic]

Hello everyone

I'm using the Project Configurator add-on in order to import complete projects from instance A (15 projects) to instance B (35 projects)

The Jira version is v7.2.4 on both instances

The instance A has a PostgresSQL database, while the instance B has a SQL database

I'm exporting all projects, and move the backup file created from the instance A to the instance B

During the global import, the first project (CON) is well imported, but the import fails while importing the second project (COR). No other projects are imported then.

Here is the import trace:

Data import for project with key: CON
INFO 14:24:53,056 Project Import: Parsing the backup file '/opt/atlassian/jira/temp/com.awnaba.projectconfigurator1542720258843/data/data.zip' to obtain a Backup Overview.
INFO 14:25:05,583 Project Import: Backup Overview was successfully extracted from '/opt/atlassian/jira/temp/com.awnaba.projectconfigurator1542720258843/data/data.zip'.
INFO 14:25:31,132 Project Import: Mapping the backed up data to data in the current system, and validating the mappings...
INFO 14:25:31,220 Project Import: No validation errors were found and the import can continue.
INFO 14:25:31,221 Starting project import for project 'CON'.
INFO 14:25:31,221 Creating missing users. Attempting to create 0 users.
INFO 14:25:31,221 Finished creating missing users. 0 users created.
INFO 14:25:31,324 Creating the issues.
INFO 14:25:35,369 Finished creating the issues.
INFO 14:25:35,395 Creating the issue-related data.
INFO 14:25:38,297 Finished creating the issue-related data.
INFO 14:25:38,297 Creating the change item data.
INFO 14:25:38,495 Finished creating the change item data.
INFO 14:25:38,495 Creating the attachments.
INFO 14:25:38,687 Finished creating the attachments.
INFO 14:25:38,696 Creating custom field values.
INFO 14:25:38,785 Finished creating custom field values.
INFO 14:25:38,785 Importing Non Issue data.
INFO 14:25:39,311 Finished creating custom field values.
INFO 14:25:47,213 Generated 1000 out of 3738 ranks (0 errors)
INFO 14:25:50,080 Generated 2000 out of 3738 ranks (0 errors)
INFO 14:25:52,770 Generated 3000 out of 3738 ranks (0 errors)
INFO 14:25:54,909 Generated 3738 out of 3738 ranks (0 errors)
INFO 14:26:07,918 Creating change item entities.
INFO 14:26:10,055 Finished creating the change item data.
INFO 14:26:10,056 Re-indexing the Project.
INFO 14:26:10,658 Re-indexing is 1% complete. Current index:
INFO 14:26:11,219 Re-indexing is 2% complete. Current index:
INFO 14:26:11,704 Re-indexing is 3% complete. Current index:
INFO 14:26:12,171 Re-indexing is 4% complete. Current index:
INFO 14:26:12,673 Re-indexing is 5% complete. Current index:
INFO 14:26:13,145 Re-indexing is 6% complete. Current index:
INFO 14:26:13,623 Re-indexing is 7% complete. Current index:
INFO 14:26:14,107 Re-indexing is 8% complete. Current index:
INFO 14:26:14,613 Re-indexing is 9% complete. Current index:
INFO 14:26:15,078 Re-indexing is 10% complete. Current index:
INFO 14:26:15,548 Re-indexing is 11% complete. Current index:
INFO 14:26:16,039 Re-indexing is 12% complete. Current index:
INFO 14:26:16,499 Re-indexing is 13% complete. Current index:
INFO 14:26:16,974 Re-indexing is 14% complete. Current index:
INFO 14:26:17,446 Re-indexing is 15% complete. Current index:
INFO 14:26:17,967 Re-indexing is 16% complete. Current index:
INFO 14:26:18,435 Re-indexing is 17% complete. Current index:
INFO 14:26:18,881 Re-indexing is 18% complete. Current index:
INFO 14:26:19,351 Re-indexing is 19% complete. Current index:
INFO 14:26:19,838 Re-indexing is 20% complete. Current index:
INFO 14:26:20,338 Re-indexing is 21% complete. Current index:
INFO 14:26:20,817 Re-indexing is 22% complete. Current index:
INFO 14:26:21,319 Re-indexing is 23% complete. Current index:
INFO 14:26:21,800 Re-indexing is 24% complete. Current index:
INFO 14:26:22,319 Re-indexing is 25% complete. Current index:
INFO 14:26:22,774 Re-indexing is 26% complete. Current index:
INFO 14:26:23,261 Re-indexing is 27% complete. Current index:
INFO 14:26:23,744 Re-indexing is 28% complete. Current index:
INFO 14:26:24,225 Re-indexing is 29% complete. Current index:
INFO 14:26:24,720 Re-indexing is 30% complete. Current index:
INFO 14:26:25,174 Re-indexing is 31% complete. Current index:
INFO 14:26:25,641 Re-indexing is 32% complete. Current index:
INFO 14:26:26,155 Re-indexing is 33% complete. Current index:
INFO 14:26:26,694 Re-indexing is 34% complete. Current index:
INFO 14:26:27,179 Re-indexing is 35% complete. Current index:
INFO 14:26:27,675 Re-indexing is 36% complete. Current index:
INFO 14:26:28,208 Re-indexing is 37% complete. Current index:
INFO 14:26:28,698 Re-indexing is 38% complete. Current index:
INFO 14:26:29,156 Re-indexing is 39% complete. Current index:
INFO 14:26:29,629 Re-indexing is 40% complete. Current index:
INFO 14:26:30,109 Re-indexing is 41% complete. Current index:
INFO 14:26:30,568 Re-indexing is 42% complete. Current index:
INFO 14:26:31,022 Re-indexing is 43% complete. Current index:
INFO 14:26:31,522 Re-indexing is 44% complete. Current index:
INFO 14:26:31,990 Re-indexing is 45% complete. Current index:
INFO 14:26:32,439 Re-indexing is 46% complete. Current index:
INFO 14:26:32,891 Re-indexing is 47% complete. Current index:
INFO 14:26:33,418 Re-indexing is 48% complete. Current index:
INFO 14:26:33,888 Re-indexing is 49% complete. Current index:
INFO 14:26:34,363 Re-indexing is 50% complete. Current index:
INFO 14:26:34,905 Re-indexing is 51% complete. Current index:
INFO 14:26:35,358 Re-indexing is 52% complete. Current index:
INFO 14:26:35,823 Re-indexing is 53% complete. Current index:
INFO 14:26:36,274 Re-indexing is 54% complete. Current index:
INFO 14:26:36,777 Re-indexing is 55% complete. Current index:
INFO 14:26:37,276 Re-indexing is 56% complete. Current index:
INFO 14:26:37,760 Re-indexing is 57% complete. Current index:
INFO 14:26:38,257 Re-indexing is 58% complete. Current index:
INFO 14:26:38,720 Re-indexing is 59% complete. Current index:
INFO 14:26:39,173 Re-indexing is 60% complete. Current index:
INFO 14:26:39,631 Re-indexing is 61% complete. Current index:
INFO 14:26:40,138 Re-indexing is 62% complete. Current index:
INFO 14:26:40,613 Re-indexing is 63% complete. Current index:
INFO 14:26:41,083 Re-indexing is 64% complete. Current index:
INFO 14:26:41,578 Re-indexing is 65% complete. Current index:
INFO 14:26:42,045 Re-indexing is 66% complete. Current index:
INFO 14:26:42,505 Re-indexing is 67% complete. Current index:
INFO 14:26:42,965 Re-indexing is 68% complete. Current index:
INFO 14:26:43,505 Re-indexing is 69% complete. Current index:
INFO 14:26:43,971 Re-indexing is 70% complete. Current index:
INFO 14:26:44,430 Re-indexing is 71% complete. Current index:
INFO 14:26:44,946 Re-indexing is 72% complete. Current index:
INFO 14:26:45,409 Re-indexing is 73% complete. Current index:
INFO 14:26:45,890 Re-indexing is 74% complete. Current index:
INFO 14:26:46,358 Re-indexing is 75% complete. Current index:
INFO 14:26:46,853 Re-indexing is 76% complete. Current index:
INFO 14:26:47,315 Re-indexing is 77% complete. Current index:
INFO 14:26:47,798 Re-indexing is 78% complete. Current index:
INFO 14:26:48,308 Re-indexing is 79% complete. Current index:
INFO 14:26:48,778 Re-indexing is 80% complete. Current index:
INFO 14:26:49,237 Re-indexing is 81% complete. Current index:
INFO 14:26:49,709 Re-indexing is 82% complete. Current index:
INFO 14:26:50,194 Re-indexing is 83% complete. Current index:
INFO 14:26:50,661 Re-indexing is 84% complete. Current index:
INFO 14:26:51,119 Re-indexing is 85% complete. Current index:
INFO 14:26:51,613 Re-indexing is 86% complete. Current index:
INFO 14:26:52,111 Re-indexing is 87% complete. Current index:
INFO 14:26:52,561 Re-indexing is 88% complete. Current index:
INFO 14:26:53,023 Re-indexing is 89% complete. Current index:
INFO 14:26:53,518 Re-indexing is 90% complete. Current index:
INFO 14:26:53,985 Re-indexing is 91% complete. Current index:
INFO 14:26:54,454 Re-indexing is 92% complete. Current index:
INFO 14:26:54,999 Re-indexing is 93% complete. Current index:
INFO 14:26:55,504 Re-indexing is 94% complete. Current index:
INFO 14:26:55,978 Re-indexing is 95% complete. Current index:
INFO 14:26:56,488 Re-indexing is 96% complete. Current index:
INFO 14:26:56,939 Re-indexing is 97% complete. Current index:
INFO 14:26:57,421 Re-indexing is 98% complete. Current index:
INFO 14:26:57,883 Re-indexing is 99% complete. Current index:
INFO 14:26:58,369 Re-indexing is 100% complete. Current index:
INFO 14:26:58,375 Finished re-indexing the Project.
INFO 14:26:58,375 Finished project import for project 'CON'.
INFO 14:26:58,434 The project import took '87213' ms to run.
INFO 14:26:58,435 The project import created '24' project components.
INFO 14:26:58,436 The project import created '35' project versions.
INFO 14:26:58,436 The project import created '24' project components.
INFO 14:26:58,436 The project import created '35' project versions.
INFO 14:26:58,436 The project import created '0' out of '0' users.
INFO 14:26:58,436 The project import created '3738' out of '3738' issues.
INFO 14:26:58,436 The project import created '1199' out of 1199' attachments.

Data import for project with key: COR
Data import failed with exception: null
java.lang.NumberFormatException: null
at java.lang.Long.parseLong(Long.java:552)
at java.lang.Long.valueOf(Long.java:803)
at com.atlassian.greenhopper.imports.SprintImportHandler.endTable(SprintImportHandler.java:105)
at com.atlassian.jira.imports.project.ao.handler.ChainedAoSaxHandler.endTable(ChainedAoSaxHandler.java:263)
at com.atlassian.jira.imports.project.ao.handler.ChainedAoSaxHandler.endElement(ChainedAoSaxHandler.java:190)
at com.atlassian.jira.imports.project.ao.handler.ChainedAoSaxHandler.endElement(ChainedAoSaxHandler.java:151)
at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at com.atlassian.security.xml.RestrictedXMLReader.parse(RestrictedXMLReader.java:103)
at com.atlassian.jira.imports.xml.DefaultBackupXmlParser$XmlParser.parseXml(DefaultBackupXmlParser.java:115)
at com.atlassian.jira.imports.xml.DefaultBackupXmlParser.parse(DefaultBackupXmlParser.java:64)
at com.atlassian.jira.imports.xml.DefaultBackupXmlParser.parseXml(DefaultBackupXmlParser.java:52)
at com.atlassian.jira.imports.xml.DefaultBackupXmlParser.parseAoBackupXml(DefaultBackupXmlParser.java:46)
at com.atlassian.jira.imports.project.DefaultProjectImportManager.importAoData(DefaultProjectImportManager.java:712)
at com.atlassian.jira.imports.project.DefaultProjectImportManager.doImport(DefaultProjectImportManager.java:660)
at com.atlassian.jira.bc.imports.project.DefaultProjectImportService.doImport(DefaultProjectImportService.java:416)
at com.awnaba.projectconfigurator.transporter.engine.JiraDataImporter.jiraImportData(JiraDataImporter.java:288)
at com.awnaba.projectconfigurator.transporter.engine.JiraDataImporter.importData(JiraDataImporter.java:154)
at com.awnaba.projectconfigurator.transporter.engine.JiraDataImporter$DataImportCallable.call(JiraDataImporter.java:446)
at com.awnaba.projectconfigurator.transporter.engine.JiraDataImporter.importDataSynchronously(JiraDataImporter.java:416)
at com.awnaba.projectconfigurator.operationsapi.impl.ProjectCompleteImporterImpl.executeNextPhase(ProjectCompleteImporterImpl.java:302)
at com.awnaba.projectconfigurator.operationsapi.impl.ProjectCompleteImporterImpl.doCompleteImport(ProjectCompleteImporterImpl.java:195)
at com.awnaba.projectconfigurator.operationsapi.impl.ProjectCompleteImporterImpl.access$0(ProjectCompleteImporterImpl.java:188)
at com.awnaba.projectconfigurator.operationsapi.impl.ProjectCompleteImporterImpl$CompleteImporterTask.call(ProjectCompleteImporterImpl.java:145)
at com.awnaba.projectconfigurator.operationsapi.impl.ProjectCompleteImporterImpl$CompleteImporterTask.call(ProjectCompleteImporterImpl.java:1)
at com.awnaba.projectconfigurator.longrunningtasks.TaskHelperImpl$WrappingTask.call(TaskHelperImpl.java:67)
at com.awnaba.projectconfigurator.longrunningtasks.TaskHelperImpl$WrappingTask.call(TaskHelperImpl.java:1)
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:745)

Did someone face this error and could give me a fix, please ?

Best

[Jay Kantaria]

Hi how did you resolve this issue?  I am running into same issue. 

Adpativist.  please help!!!

[Weixing Xu]

please refer the document.

https://confluence.atlassian.com/jirakb/project-import-fails-with-numberformatexception-in-jira-server-816686500.html?_ga=2.83047632.797311013.1561711291-360729985.1552393188