CODEWITHSUNDEEP
postgresqlalfrescocitus
Kitty WANG
Kitty WANG

Reputation: 1

org.alfresco.error.AlfrescoRuntimeException: 02020037 Not all patches could be applied

I recently use Alfresco CE 23.2 version and try to extend it with distribution features.

My environment:

I have created corresponding files of SQL in the source code "alfresco-community-repo" to distribute tables to other worker nodes; however, when I run this "alfresco.war" in my environment, I get the following errors:

2025-03-02T02:41:38,300 [] ERROR [admin.patch.PatchExecuter] [main] 02020036 patch.schemaUpgradeScript.err.not_executed - [classpath:alfresco/dbscripts/upgrade/23.2/${db.script.dialect}/distribute-all-tables.sql]
2025-03-02T02:41:38,314 [] INFO  [admin.patch.PatchExecuter] [main] === Applied patch                 === ID: patch.db-V3.4-UsageTablesRESULT: Script completed=====================================
2025-03-02T02:41:38,315 [] INFO  [admin.patch.PatchExecuter] [main] === Applied patch                 === ID: patch.db-V4.0-TenantTablesRESULT: Script completed=====================================
2025-03-02T02:41:38,315 [] INFO  [admin.patch.PatchExecuter] [main] === Applied patch                 === ID: patch.db-V4.1-AuthorizationTablesRESULT: Script completed=====================================
2025-03-02T02:41:38,316 [] INFO  [admin.patch.PatchExecuter] [main] === Applied patch                 === ID: patch.db-V5.0-ContentUrlEncryptionTablesRESULT: Script completed=====================================
2025-03-02T02:41:38,316 [] ERROR [admin.patch.PatchExecuter] [main] === Failed to apply patch         === ID: patch.db-v23.2-distribute-all-tablesRESULT: 02020036 patch.schemaUpgradeScript.err.not_executed - [classpath:alfresco/dbscripts/upgrade/23.2/${db.script.dialect}/distribute-all-tables.sql]=====================================
2025-03-02T02:41:38,316 [] ERROR [web.context.ContextLoader] [main] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 02020037 Not all patches could be applied
        at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:118) ~[alfresco-repository-23.2.2.3.jar:23.2.2.3]
        at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:131) ~[alfresco-repository-23.2.2.3.jar:23.2.2.3]
        at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:1) ~[alfresco-repository-23.2.2.3.jar:23.2.2.3]
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:602) ~[alfresco-data-model-23.2.2.3.jar:23.2.2.3]
        at org.alfresco.repo.admin.patch.PatchExecuter.onBootstrap(PatchExecuter.java:135) ~[alfresco-repository-23.2.2.3.jar:23.2.2.3]
        at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56) ~[spring-surf-core-9.0.jar:9.0]
        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:232) ~[alfresco-repository-23.2.2.3.jar:23.2.2.3]
        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:197) ~[alfresco-repository-23.2.2.3.jar:23.2.2.3]
        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:217) ~[alfresco-repository-23.2.2.3.jar:23.2.2.3]
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:445) ~[spring-context-6.0.14.jar:6.0.14]
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:378) ~[spring-context-6.0.14.jar:6.0.14]
        at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:969) ~[spring-context-6.0.14.jar:6.0.14]
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:619) ~[spring-context-6.0.14.jar:6.0.14]
        at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:394) ~[spring-web-6.0.14.jar:6.0.14]
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:274) [spring-web-6.0.14.jar:6.0.14]
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:102) [spring-web-6.0.14.jar:6.0.14]
        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:70) [classes/:23.2.2.3]
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4008) [catalina.jar:10.1.33]
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4436) [catalina.jar:10.1.33]
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) [catalina.jar:10.1.33]
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:599) [catalina.jar:10.1.33]
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:571) [catalina.jar:10.1.33]
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:654) [catalina.jar:10.1.33]
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:969) [catalina.jar:10.1.33]
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1911) [catalina.jar:10.1.33]
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) [?:?]
        at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
        at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [tomcat-util.jar:10.1.33]
        at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:123) [?:?]
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:771) [catalina.jar:10.1.33]
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:423) [catalina.jar:10.1.33]
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1629) [catalina.jar:10.1.33]
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:303) [catalina.jar:10.1.33]
        at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:109) [catalina.jar:10.1.33]
        at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:389) [catalina.jar:10.1.33]
        at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:336) [catalina.jar:10.1.33]
        at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:776) [catalina.jar:10.1.33]
        at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:772) [catalina.jar:10.1.33]
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) [catalina.jar:10.1.33]
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1203) [catalina.jar:10.1.33]
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1193) [catalina.jar:10.1.33]
        at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
        at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [tomcat-util.jar:10.1.33]
        at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145) [?:?]
        at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:749) [catalina.jar:10.1.33]
        at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:203) [catalina.jar:10.1.33]
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) [catalina.jar:10.1.33]
        at org.apache.catalina.core.StandardService.startInternal(StandardService.java:415) [catalina.jar:10.1.33]
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) [catalina.jar:10.1.33]
        at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:870) [catalina.jar:10.1.33]
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) [catalina.jar:10.1.33]
        at org.apache.catalina.startup.Catalina.start(Catalina.java:757) [catalina.jar:10.1.33]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
        at java.lang.reflect.Method.invoke(Method.java:569) ~[?:?]
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:345) [bootstrap.jar:10.1.33]
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:473) [bootstrap.jar:10.1.33]
Mar 02, 2025 2:41:38 AM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class [org.alfresco.web.app.ContextLoaderListener]

I wonder how can I fix it. Thanks for everyone who helps.

Upvotes: 0

Views: 22

Answers (0)

Related Questions