XML Database Import from Oracle to PostgreSQL fails at 20%

[mr test]

Hi,

we use JIRA Data Center 9.12.13. It has been running its database on a Oracle 19g Server. We would like to change that to an on premise PostgreSQL database server. I have been following the steps mentioned in these two articles:

https://confluence.atlassian.com/adminjiraserver0912/switching-databases-1346046855.html

https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-postgresql-938846851.html

When I try to import the xml.zip with the help of the setup wizard it start the import, gets to 20% and then fails. These are the errors I got:

2025-03-07 11:06:44,277+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [JIRA-STATS] [plugin-transaction] numberStartEvents:737, numberEndEvents:737, numberSendEvents:321, numberEventsInTransactions:19074, numberOfPluginEnableEvents:319 2025-03-07 11:06:50,453+0100 JiraImportTaskExecutionThread-1 INFO [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 18% complete... 2025-03-07 11:06:58,729+0100 JiraImportTaskExecutionThread-1 INFO [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 19% complete... 2025-03-07 11:07:05,569+0100 JiraImportTaskExecutionThread-1 INFO [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 20% complete... 2025-03-07 11:07:09,953+0100 JiraImportTaskExecutionThread-1 INFO [c.a.j.util.stats.JiraStats] [JIRA-STATS] [LOGIN-STORE-STATS] snapshot stats: duration=PT5M25.546S, statsOverhead=n/a, data={"_statsName":"LOGIN-STORE-STATS","_statsType":"snapshot","_time":"2025-03-07T10:07:09.883Z","_timestamp":1741342029883,"_duration":"PT5M25.546S","_invocations":9,"_statsOverhead":"n/a","settings":{"legacyMode":false,"flushIntervalInSeconds":30},"recordLoginAttemptSuccessfulInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"recordLoginAttemptFailedInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"updateLastLoginTimeInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"resetFailedLoginCountInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"getOrLoadLastKnownLoginInfoInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"delegateRecordLoginAttemptSuccessfulInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"delegateRecordLoginAttemptFailedInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"delegateUpdateLastLoginTimeInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"delegateResetFailedLoginCountInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"invalidateLastKnownLoginInfoCache":0,"flushDataToDBInMillis":{"count":8,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":8,"10":0,"100":0,"1000":0,"5000":0}},"flushUserAttemptsInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"flushRecordedSuccessfulLoginAttemptsMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"flushLastLoginTimesMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"unscheduledFlushUserAttemptsCount":0,"onClearCacheCount":0,"failedValidateRunningCount":0,"flushRecordedSuccessfulLoginAttemptsUnsuccessfulCount":0,"flushLastLoginTimesUnsuccessfulCount":0,"applicationUserToLastKnownLoginInfoMaxSize":0,"getLastKnownLoginInfoCacheCallCount":0,"getLastKnownLoginInfoCount":0,"usersFlushedToDB":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{}}} 2025-03-07 11:07:09,954+0100 JiraImportTaskExecutionThread-1 INFO [c.a.j.util.stats.JiraStats] [JIRA-STATS] [LOGIN-STORE-STATS] total stats: duration=PT5M25.616S, statsOverhead=n/a, data={"_statsName":"LOGIN-STORE-STATS","_statsType":"total","_time":"2025-03-07T10:07:09.883Z","_timestamp":1741342029883,"_duration":"PT5M25.616S","_invocations":9,"_statsOverhead":"n/a","settings":{"legacyMode":false,"flushIntervalInSeconds":30},"recordLoginAttemptSuccessfulInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"recordLoginAttemptFailedInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"updateLastLoginTimeInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"resetFailedLoginCountInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"getOrLoadLastKnownLoginInfoInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"delegateRecordLoginAttemptSuccessfulInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"delegateRecordLoginAttemptFailedInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"delegateUpdateLastLoginTimeInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"delegateResetFailedLoginCountInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"invalidateLastKnownLoginInfoCache":0,"flushDataToDBInMillis":{"count":8,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":8,"10":0,"100":0,"1000":0,"5000":0}},"flushUserAttemptsInMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"flushRecordedSuccessfulLoginAttemptsMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"flushLastLoginTimesMillis":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{"1":0,"10":0,"100":0,"1000":0,"5000":0}},"unscheduledFlushUserAttemptsCount":0,"onClearCacheCount":0,"failedValidateRunningCount":0,"flushRecordedSuccessfulLoginAttemptsUnsuccessfulCount":0,"flushLastLoginTimesUnsuccessfulCount":0,"applicationUserToLastKnownLoginInfoMaxSize":0,"getLastKnownLoginInfoCacheCallCount":0,"getLastKnownLoginInfoCount":0,"usersFlushedToDB":{"count":0,"min":0,"max":0,"sum":0,"avg":0,"distributionCounter":{}}} 2025-03-07 11:07:09,954+0100 JiraImportTaskExecutionThread-1 ERROR [c.a.event.internal.AsynchronousAbleEventDispatcher] There was an exception thrown trying to dispatch event [com.atlassian.jira.bc.dataimport.ImportStartedEvent@563c890f] from the invoker [com.atlassian.event.internal.ComparableListenerInvoker@fce0516] java.lang.RuntimeException: Executor Service has not been created. Listener: com.atlassian.servicedesk.plugins.base.internal.bootstrap.lifecycle.InternalBasePluginLauncher event: com.atlassian.jira.bc.dataimport.ImportStartedEvent at com.atlassian.event.internal.SingleParameterMethodListenerInvoker.invoke(SingleParameterMethodListenerInvoker.java:53) at com.atlassian.diagnostics.internal.platform.monitor.event.EventSystemMonitor.invokeMonitored(EventSystemMonitor.java:105) at com.atlassian.diagnostics.internal.platform.monitor.event.MonitoredListenerInvoker.invoke(MonitoredListenerInvoker.java:38) at com.atlassian.event.internal.ComparableListenerInvoker.invoke(ComparableListenerInvoker.java:48) at com.atlassian.event.internal.AsynchronousAbleEventDispatcher.lambda$null$0(AsynchronousAbleEventDispatcher.java:37) at com.atlassian.event.internal.AsynchronousAbleEventDispatcher.dispatch(AsynchronousAbleEventDispatcher.java:85) at com.atlassian.diagnostics.internal.platform.monitor.event.MonitoredEventDispatcher.dispatch(MonitoredEventDispatcher.java:36) at com.atlassian.event.internal.EventPublisherImpl.publish(EventPublisherImpl.java:114) at com.atlassian.event.internal.LockFreeEventPublisher.publish(LockFreeEventPublisher.java:40) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.broadcastEvent(DefaultDataImportService.java:1079) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:314) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.unsafeCall(DataImportAsyncCommand.java:82) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:64) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:30) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:177) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:149) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) Caused by: java.lang.IllegalStateException: Executor Service has not been created at com.atlassian.servicedesk.plugins.base.internal.events.offthreading.async.processing.ProcessorExecutorManagerImpl.lambda$getExecutorService$3(ProcessorExecutorManagerImpl.java:226) at io.atlassian.fugue.Option$None.getOrThrow(Option.java:409) at com.atlassian.servicedesk.plugins.base.internal.events.offthreading.async.processing.ProcessorExecutorManagerImpl.getExecutorService(ProcessorExecutorManagerImpl.java:226) at com.atlassian.servicedesk.plugins.base.internal.events.offthreading.async.processing.ProcessorExecutorManagerImpl.shutdown(ProcessorExecutorManagerImpl.java:129) at com.atlassian.servicedesk.plugins.base.internal.bootstrap.lifecycle.InternalBasePluginLauncher.onImportStarted(InternalBasePluginLauncher.java:117) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at com.atlassian.event.internal.SingleParameterMethodListenerInvoker.invoke(SingleParameterMethodListenerInvoker.java:42) ... 21 more 2025-03-07 11:07:09,955+0100 JiraImportTaskExecutionThread-1 INFO [c.a.j.index.ha.DefaultServerIndexRepairService] Pausing DefaultServerIndexRepairService 2025-03-07 11:07:09,971+0100 JiraImportTaskExecutionThread-1 DEBUG [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] startCleaning

This error seems to indicate an issue with this process:

com.atlassian.servicedesk.plugins.base.internal.bootstrap.lifecycle.InternalBasePluginLauncher

Is this a system plugin issue? I have disabled all manually installed plugins, sadly to no avail.

Thank you for reading

[Tuncay Senturk]

Hi @mr test 

java.lang.RuntimeException: Executor Service has not been created. 

this error points to a JSM service not properly initialized, possibly due to a dependency issue. Since this is related to JSM, I'd suggest disabling the JSM before importing the XML.

By the way, I am assuming that you have the correct dbconfig.xml configuration and you are using the right database charset to use UTF-8.