Using Microsoft's SQL Server Migration Assistant for MySQL, I've run a successful import but when starting Confluence getting the error below:
com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.plugins.authentication.atlassian-authentication-plugin]
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:95)
caused by: java.lang.IllegalStateException: TABLE: AO_ED669C_IDP_CONFIG: ADDITIONAL_JIT_SCOPES - ADDITIONAL_SCOPES - AUTHORIZATION_ENDPOINT - BUTTON_TEXT - CLIENT_ID - CLIENT_SECRET - ENABLED - ENABLE_REMEMBER_ME - ID - INCLUDE_CUSTOMER_LOGINS - ISSUER - LAST_UPDATED - MAPPING_DISPLAYNAME - MAPPING_EMAIL - MAPPING_GROUPS - NAME - SAML_IDP_TYPE - SIGNING_CERT - SSO_TYPE - SSO_URL - TOKEN_ENDPOINT - USERNAME_ATTRIBUTE - USERNAME_CLAIM - USER_INFO_ENDPOINT - USER_PROVISIONING_ENABLED - USE_DISCOVERY - can't find type 5 (precision=5) in field ENABLED
at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:104)
com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.plugins.authentication.atlassian-authentication-plugin] at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:95) at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:86) at com.atlassian.sal.core.executor.ThreadLocalDelegateCallable.call(ThreadLocalDelegateCallable.java:38) at com.atlassian.confluence.impl.vcache.VCacheRequestContextManager.doInRequestContextInternal(VCacheRequestContextManager.java:84) at com.atlassian.confluence.impl.vcache.VCacheRequestContextManager.doInRequestContext(VCacheRequestContextManager.java:68) at com.atlassian.confluence.vcache.VCacheRequestContextOperations.lambda$withRequestContext$1(VCacheRequestContextOperations.java:59) 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: TABLE: AO_ED669C_IDP_CONFIG: ADDITIONAL_JIT_SCOPES - ADDITIONAL_SCOPES - AUTHORIZATION_ENDPOINT - BUTTON_TEXT - CLIENT_ID - CLIENT_SECRET - ENABLED - ENABLE_REMEMBER_ME - ID - INCLUDE_CUSTOMER_LOGINS - ISSUER - LAST_UPDATED - MAPPING_DISPLAYNAME - MAPPING_EMAIL - MAPPING_GROUPS - NAME - SAML_IDP_TYPE - SIGNING_CERT - SSO_TYPE - SSO_URL - TOKEN_ENDPOINT - USERNAME_ATTRIBUTE - USERNAME_CLAIM - USER_INFO_ENDPOINT - USER_PROVISIONING_ENABLED - USE_DISCOVERY - can't find type 5 (precision=5) in field ENABLED at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:104) at net.java.ao.schema.ddl.SchemaReader.readFields(SchemaReader.java:126) at net.java.ao.schema.ddl.SchemaReader.readTable(SchemaReader.java:110) at net.java.ao.schema.ddl.SchemaReader.access$000(SchemaReader.java:62) at net.java.ao.schema.ddl.SchemaReader$1.apply(SchemaReader.java:99) at net.java.ao.schema.ddl.SchemaReader$1.apply(SchemaReader.java:97) at com.google.common.collect.Iterators$6.transform(Iterators.java:785) at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:47) at com.google.common.collect.Iterators.addAll(Iterators.java:358) at com.google.common.collect.Lists.newArrayList(Lists.java:147) at com.google.common.collect.Lists.newArrayList(Lists.java:133) at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:97) at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:88) at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:81) at net.java.ao.schema.SchemaGenerator.generateImpl(SchemaGenerator.java:107) at net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:84) at net.java.ao.EntityManager.migrate(EntityManager.java:131) at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:52) at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.lambda$create$0(AbstractActiveObjectsFactory.java:73) at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:21) at com.atlassian.sal.spring.component.SpringHostContextAccessor.lambda$doInTransaction$0(SpringHostContextAccessor.java:70) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) at com.atlassian.sal.spring.component.SpringHostContextAccessor.doInTransaction(SpringHostContextAccessor.java:68) at com.atlassian.confluence.spring.transaction.interceptor.ConfluenceSpringHostContextAccessor.access$001(ConfluenceSpringHostContextAccessor.java:21) at com.atlassian.confluence.spring.transaction.interceptor.ConfluenceSpringHostContextAccessor.lambda$doInTransaction$3(ConfluenceSpringHostContextAccessor.java:72) at com.atlassian.confluence.impl.vcache.VCacheRequestContextManager.doInRequestContextInternal(VCacheRequestContextManager.java:84) at com.atlassian.confluence.impl.vcache.VCacheRequestContextManager.doInRequestContext(VCacheRequestContextManager.java:68) at com.atlassian.confluence.spring.transaction.interceptor.ConfluenceSpringHostContextAccessor.doInTransaction(ConfluenceSpringHostContextAccessor.java:72) at com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:18) at jdk.internal.reflect.GeneratedMethodAccessor293.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.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26) at com.sun.proxy.$Proxy272.execute(Unknown Source) at jdk.internal.reflect.GeneratedMethodAccessor293.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) 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:186) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) 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:186) at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) at com.sun.proxy.$Proxy1086.execute(Unknown Source) at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:70) at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:32) at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:91) ... 9 more
Does anyone else have experience migrating from a MySQL DB to MS SQL Server? I've got an open ticket with Atlassian Support. That ticket identified at least one column that is not the right datatype.
I've found the MS migration assistant to be mostly useless (and not just for Atlassian stuff). The only method that works reliably for Jira or Confluence is to use their native export/import tools.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.