Error on upgrade Afresco CE 6.2 to 7.3

nx3 · ‎14 Aug 2023

Hi

currently I am trying to migrate and update our Alfresco CE from 6.2 in Docker to 7.3 with zip-install.

I successfully got the 7.3 zip-install running with all/most of the encryption running.

I successfully extracted the PostgreSQL-db and alf_data Folder from the Docker containers. After restoring the database and placing the contentstore in the appropriate location, I get the following error during startup:

2023-08-14 15:36:43,425 WARN [org.alfresco.heartbeat.datasender.HBDataSenderServiceBuilder] [main] Setting the Heartbeat sender cron with property 'heartbeat.sender.cronExpression' is no longer supported.
2023-08-14 15:36:43,540 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Ignoring script patch (post-Hibernate): patch.db-V4.2-metadata-query-indexes
2023-08-14 15:36:43,540 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Ignoring script patch (post-Hibernate): patch.db-V5.1-metadata-query-indexes
2023-08-14 15:36:43,540 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Ignoring script patch (post-Hibernate): patch.db-V5.2-remove-jbpm-tables-from-db
2023-08-14 15:36:43,540 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Ignoring script patch (post-Hibernate): patch.db-V7.1.0-remove-alf_server-table
2023-08-14 15:36:43,661 INFO [org.alfresco.repo.admin] [main] Using database URL 'jdbc:postgresql://localhost:5432/alfresco' with user 'alfresco'.
2023-08-14 15:36:43,662 INFO [org.alfresco.repo.admin] [main] Connected to database PostgreSQL version 15.3
2023-08-14 15:36:45,882 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [main] Starting 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]
2023-08-14 15:36:45,934 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [main] Startup of 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1] complete
2023-08-14 15:36:47,253 INFO [org.springframework.extensions.webscripts.TemplateProcessorRegistry] [main] Registered template processor Repository Template Processor for extension ftl
2023-08-14 15:36:47,255 INFO [org.springframework.extensions.webscripts.ScriptProcessorRegistry] [main] Registered script processor Repository Script Processor for extension js
2023-08-14 15:36:48,491 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [main] Starting 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]
2023-08-14 15:36:48,511 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [main] Startup of 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted] complete
2023-08-14 15:36:48,539 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Connecting to database: 533202381, URL=jdbc:postgresql://localhost:5432/alfresco, PostgreSQL JDBC Driver
2023-08-14 15:36:48,539 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Schema managed by database dialect org.alfresco.repo.domain.dialect.PostgreSQLDialect.
2023-08-14 15:36:48,557 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Applied patches detected: 223
2023-08-14 15:36:49,177 WARN [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Schema validation found 11 potential problems, results written to: /opt/alfresco/tomcat/temp/Alfresco/Alfresco-PostgreSQLDialect-Validation-Pre-Upgrade-alf_-16015494595050052602.txt
2023-08-14 15:36:49,450 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Compared database schema with reference schema (all OK): class path resource [alfresco/dbscripts/create/org.alfresco.repo.domain.dialect.PostgreSQLDialect/Schema-Reference-ACT.xml]
2023-08-14 15:36:50,120 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Normalized schema dumped to file /opt/alfresco/tomcat/temp/Alfresco/Alfresco-schema-PostgreSQLDialect-pre-upgrade-alf_-28499930790833528.xml.
2023-08-14 15:36:50,124 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Normalized schema dumped to file /opt/alfresco/tomcat/temp/Alfresco/Alfresco-schema-PostgreSQLDialect-pre-upgrade-act_-549642454024890146.xml.
2023-08-14 15:36:50,126 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Bootstrap started.
2023-08-14 15:36:50,126 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Executing database script /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-PostgreSQLDialect-Update-2671986179355046153.sql (Copied from classpath:alfresco/dbscripts/upgrade/6.3/org.alfresco.repo.domain.dialect.PostgreSQLDialect/add-indexes-node-transaction.sql).
2023-08-14 15:36:50,158 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Checking and patching Alfresco tables took 1601 ms
2023-08-14 15:36:50,159 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Activiti tables need to be checked for patches
2023-08-14 15:36:50,171 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Checking and patching Activiti tables took 12 ms
2023-08-14 15:36:50,189 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Checking that all patches have been applied took 18 ms
2023-08-14 15:36:50,189 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Updating the DB schema took 1649 ms
2023-08-14 15:36:50,190 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] All executed statements: /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-PostgreSQLDialect-All_Statements-9062337209961227066.sql.
2023-08-14 15:36:50,191 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Bootstrap completed.
2023-08-14 15:36:50,601 WARN [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Schema validation found 7 potential problems, results written to: /opt/alfresco/tomcat/temp/Alfresco/Alfresco-PostgreSQLDialect-Validation-Post-Upgrade-alf_-10902191867054520344.txt
2023-08-14 15:36:50,822 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Compared database schema with reference schema (all OK): class path resource [alfresco/dbscripts/create/org.alfresco.repo.domain.dialect.PostgreSQLDialect/Schema-Reference-ACT.xml]
2023-08-14 15:36:51,418 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Normalized schema dumped to file /opt/alfresco/tomcat/temp/Alfresco/Alfresco-schema-PostgreSQLDialect-post-upgrade-alf_-14492533606916673913.xml.
2023-08-14 15:36:51,419 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Normalized schema dumped to file /opt/alfresco/tomcat/temp/Alfresco/Alfresco-schema-PostgreSQLDialect-post-upgrade-act_-1020103042459949562.xml.
2023-08-14 15:36:51,502 ERROR [org.springframework.web.context.ContextLoader] [main] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 07140000 Keystores are invalid
at org.alfresco.encryption.EncryptionChecker$1.execute(EncryptionChecker.java:78)
at org.alfresco.encryption.EncryptionChecker$1.execute(EncryptionChecker.java:1)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:452)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:321)
at org.alfresco.encryption.EncryptionChecker.onBootstrap(EncryptionChecker.java:67)
at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:232)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:197)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:217)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:421)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:378)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:938)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:586)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:401)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:292)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:103)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:70)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4494)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4946)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:683)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:658)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:662)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:689)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1888)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:123)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:582)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1617)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:318)
at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123)
at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423)
at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366)
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:893)
at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:795)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1328)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1318)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866)
at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:249)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.StandardService.startInternal(StandardService.java:428)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:922)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.startup.Catalina.start(Catalina.java:772)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:347)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:478)
Caused by: org.alfresco.encryption.InvalidKeystoreException: The key with alias metadata has been changed, re-instate the previous keystore
at org.alfresco.encryption.AlfrescoKeyStoreImpl.validateKeys(AlfrescoKeyStoreImpl.java:930)
at org.alfresco.encryption.AlfrescoKeyStoreImpl.validateKeys(AlfrescoKeyStoreImpl.java:188)
at org.alfresco.encryption.KeyStoreChecker.validateKeyStores(KeyStoreChecker.java:49)
at org.alfresco.encryption.EncryptionChecker$1.execute(EncryptionChecker.java:73)
... 57 more
2023-08-14 15:36:51,511 WARN [org.springframework.web.context.support.XmlWebApplicationContext] [main] Exception thrown from ApplicationListener handling ContextClosedEvent
java.lang.NullPointerException: Cannot invoke "org.activiti.engine.impl.ProcessEngineImpl.getProcessEngineConfiguration()" because "this.processEngine" is null
at org.alfresco.repo.workflow.activiti.ActivitiEngineInitializer.onShutdown(ActivitiEngineInitializer.java:65)
at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:67)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:232)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:202)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:217)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:421)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:378)
at org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:1058)
at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:1021)
at org.springframework.web.context.ContextLoader.closeWebApplicationContext(ContextLoader.java:517)
at org.springframework.web.context.ContextLoaderListener.contextDestroyed(ContextLoaderListener.java:112)
at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4540)
at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5179)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:187)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:683)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:658)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:662)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:689)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1888)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:123)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:582)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1617)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:318)
at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123)
at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423)
at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366)
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:893)
at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:795)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1328)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1318)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866)
at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:249)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.StandardService.startInternal(StandardService.java:428)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:922)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.startup.Catalina.start(Catalina.java:772)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:347)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:478)
2023-08-14 15:36:51,563 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [main] Stopping 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]
2023-08-14 15:36:51,564 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [main] Stopped 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]
2023-08-14 15:36:52,098 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [main] Stopping 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]
2023-08-14 15:36:52,098 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [main] Stopped 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]

Could someone help me getting this running?

fedorow · ‎20 Aug 2023

Take keystore from 6.2 or just upgrade your docker-compose.yml with 7.3 images and configuration and continue use docker.

nx3 · ‎21 Aug 2023

@fedorow wrote:
Take keystore from 6.2

I'd like to do that, unfortunately I do not know where the keystore is located.
Could you tell me where or how I could find it? What is when there is none?

@fedorow wrote:
just upgrade your docker-compose.yml with 7.3 images and configuration and continue use docker.

This would certainly be a possibility, but unfortunately I have to dismiss it for several reasons:

I do not feel confident enough to continue support docker.
There are multiple docker-compose.yml on the system and the person originally deploying it cannot tell me which one he used.
As far as I can tell there is no actual volume for the alfresco contentstore (there seams to be no volume mounted to the repository container), which probably means redeploying will not work and actually break alfresco.
I did a clone of the original Machine (VM) and when trying to bring up the environment on the clone the containers where not able to talk to each other. I would like to avoid this kind of problems in the future.

nx3 · ‎19 Sep 2023

Hi

is someone able to help me here?

I'd like to find the keystore in my old installation if there is one, but I do not know where to find it.
If there is no keystore I would like to know how I can get my new installation to run with the old Data.

best Regads