nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Upgrade 3.2r2 to 3.3 ERROR [admin.patch.PatchExecuter] 03130

yzenezy

Hi,

I've just tried to upgrade from 3.2r2 to 3.3 and have encountered an error with PatchExecutor. I think it may have something to do with WCM which we weren't using in 3.2r2 so I'm not sure if it was even configured previously. I'm a total newbie to Alfresco but even after searching through the forums I can't find anything like the error I have. We can't run Alfresco at the moment as this error is preventing access to the site.

Here are the errors summarised and below that is the full log dump:

ERROR [admin.patch.PatchExecuter] 03130001 org.alfresco.service.cmr.repository.XPathException: 03130000 Error executing xpath:
xpath: /app:company_home/${spaces.wcm_deployed.childname}

Caused by: org.jaxen.XPathSyntaxException: Expected one of '.', '..', '@', '*', <QName>

16:58:59,066  INFO  [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /srv/alf_data
16:58:59,179  INFO  [admin.patch.PatchExecuter] Checking for patches to apply …
16:58:59,620  INFO  [admin.patch.PatchExecuter]         Applying patch 'patch.wcmDeployed' (null).
16:58:59,638  ERROR [admin.patch.PatchExecuter] 03130001 org.alfresco.service.cmr.repository.XPathException: 03130000 Error executing xpath: 
   xpath: /app:company_home/${spaces.wcm_deployed.childname}
        at org.alfresco.repo.search.impl.NodeSearcher.selectNodes(NodeSearcher.java:178)
        at org.alfresco.repo.search.impl.lucene.ADMLuceneSearcherImpl.selectNodes(ADMLuceneSearcherImpl.java:698)
        at org.alfresco.repo.search.SearcherComponent.selectNodes(SearcherComponent.java:107)
        at org.alfresco.repo.search.AbstractSearcherComponent.selectNodes(AbstractSearcherComponent.java:66)
        at org.alfresco.repo.admin.patch.impl.GenericBootstrapPatch.applyInternal(GenericBootstrapPatch.java:103)
        at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:409)
        at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:403)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:327)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:234)
        at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:435)
        at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:399)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:514)
        at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:439)
        at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:302)
        at org.alfresco.repo.admin.patch.PatchServiceImpl.access$200(PatchServiceImpl.java:56)
        at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:231)
        at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:229)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:327)
        at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:234)
        at org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:168)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy74.applyOutstandingPatches(Unknown Source)
        at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:89)
        at org.alfresco.repo.admin.patch.PatchExecuter.onBootstrap(PatchExecuter.java:132)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
        at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:627)
        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.jaxen.XPathSyntaxException: Expected one of '.', '..', '@', '*', <QName>
        at org.jaxen.BaseXPath.<init>(BaseXPath.java:132)
        at org.jaxen.BaseXPath.<init>(BaseXPath.java:153)
        at org.alfresco.repo.search.NodeServiceXPath.<init>(NodeServiceXPath.java:115)
        at org.alfresco.repo.search.impl.NodeSearcher.selectNodes(NodeSearcher.java:137)
        … 67 more
Caused by: class org.jaxen.saxpath.XPathSyntaxException: /app:company_home/${spaces.wcm_deployed.childname}: 18: Expected one of '.', '..', '@', '*', <QName>
        at org.jaxen.saxpath.base.XPathReader.createSyntaxException(XPathReader.java:1120)
        at org.jaxen.saxpath.base.XPathReader.steps(XPathReader.java:535)
        at org.jaxen.saxpath.base.XPathReader.absoluteLocationPath(XPathReader.java:408)
        at org.jaxen.saxpath.base.XPathReader.locationPath(XPathReader.java:364)
        at org.jaxen.saxpath.base.XPathReader.pathExpr(XPathReader.java:199)
        at org.jaxen.saxpath.base.XPathReader.unionExpr(XPathReader.java:1044)
        at org.jaxen.saxpath.base.XPathReader.unaryExpr(XPathReader.java:1032)
        at org.jaxen.saxpath.base.XPathReader.multiplicativeExpr(XPathReader.java:981)
        at org.jaxen.saxpath.base.XPathReader.additiveExpr(XPathReader.java:951)
        at org.jaxen.saxpath.base.XPathReader.relationalExpr(XPathReader.java:898)
        at org.jaxen.saxpath.base.XPathReader.equalityExpr(XPathReader.java:867)
        at org.jaxen.saxpath.base.XPathReader.andExpr(XPathReader.java:847)
        at org.jaxen.saxpath.base.XPathReader.andExpr(XPathReader.java:847)
        at org.jaxen.saxpath.base.XPathReader.orExpr(XPathReader.java:825)
        at org.jaxen.saxpath.base.XPathReader.expr(XPathReader.java:818)
        at org.jaxen.saxpath.base.XPathReader.parse(XPathReader.java:113)
        at org.jaxen.BaseXPath.<init>(BaseXPath.java:127)
        … 70 more

16:58:59,643  WARN  [admin.patch.PatchExecuter] Patch description is not available: Patch[ id=patch.wcmDeployed, description=patch.wcmDeployed.description, fixesFromSchema=0, fixesToSchema=3300, targetSchema=10000]
16:58:59,742  ERROR [admin.patch.PatchExecuter] 
=== Failed to apply patch         === 
ID: patch.wcmDeployed
RESULT: 
03130001 org.alfresco.service.cmr.repository.XPathException: 03130000 Error executing xpath: 
   xpath: /app:company_home/${spaces.wcm_deployed.childname}
        at org.alfresco.repo.search.impl.NodeSearcher.selectNodes(NodeSearcher.java:178)
        at org.alfresco.repo.search.impl.lucene.ADMLuceneSearcherImpl.selectNodes(ADMLuceneSearcherImpl.java:698)
        at org.alfresco.repo.search.SearcherComponent.selectNodes(SearcherComponent.java:107)
        at org.alfresco.repo.search.AbstractSearcherComponent.selectNodes(AbstractSearcherComponent.java:66)
        at org.alfresco.repo.admin.patch.impl.GenericBootstrapPatch.applyInternal(GenericBootstrapPatch.java:103)
        at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:409)
        at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:403)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:327)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelpe…
=====================================
16:58:59,744  ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 03130002 Not all patches could be applied
        at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:124)
        at org.alfresco.repo.admin.patch.PatchExecuter.onBootstrap(PatchExecuter.java:132)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
        at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:627)
        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Apr 13, 2010 4:58:59 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Apr 13, 2010 4:58:59 PM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Here's my alfresco-global.properties:

###############################
## Common Alfresco Properties #
###############################

#
# Sample custom content and index data location
#————-
dir.root=/srv/alf_data

#
# Sample database connection properties
#————-
db.name=alfresco
db.username=alfresco
db.password=alfresco
db.host=localhost
db.port=3306

#
# External locations
#————-
ooo.exe=/opt/openoffice.org3/program/soffice.bin
#ooo.user=/srv/alf_data/oouser
img.root=/usr
#img.exe=/usr/bin/convert
swf.exe=/usr/local/bin/pdf2swf

#
# MySQL connection
#————-
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

#
# PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)
#
#db.driver=org.postgresql.Driver
#db.url=jdbc:postgresql://localhost:5432/alfresco

#
# Index Recovery Mode
#————-
#index.recovery.mode=Auto

#
# Outbound Email Configuration
#————-
#mail.host=
#mail.port=25
#mail.username=anonymous
#mail.password=
#mail.encoding=UTF-8
#mail.from.default=alfresco@alfresco.org
#mail.smtp.auth=false

#
# Alfresco Email Service and Email Server
#————-

# Enable/Disable the inbound email service.  The service could be used by processes other than
# the Email Server (e.g. direct RMI access) so this flag is independent of the Email Service.
#————-
#email.inbound.enabled=true

# Email Server properties 
#————-
#email.server.enabled=true
#email.server.port=25
#email.server.domain=alfresco.com
#email.inbound.unknownUser=anonymous

# A comma separated list of email REGEX patterns of allowed senders.
# If there are any values in the list then all sender email addresses
# must match.  For example:
#   .*\@alfresco\.com, .*\@alfresco\.org
# Allow anyone:
#————-
#email.server.allowed.senders=.*

#
# The default authentication chain
# To configure external authentication subsystems see:
# http://wiki.alfresco.com/wiki/Alfresco_Authentication_Subsystems
#————-
authentication.chain=alfrescoNtlm1:alfrescoNtlm,passthru1:passthru
#alfrescoNtlm1
ntlm.authentication.sso.enabled=false
alfresco.authentication.authenticateCIFS=false
#passthru1
ntlm.authentication.sso.enabled=false
passthru.authentication.servers=192.168.0.7
passthru.authentication.domain=
passthru.authentication.userLocalServer=false
passthru.authentication.authenticateCIFS=true


#
# IMAP
#————-
#imap.server.enabled=true
#imap.server.port=143
#imap.server.host=localhost

# URL Generation Parameters (The ${localname} token is replaced by the local server name)
#————-
#alfresco.context=alfresco
#alfresco.host=${localname}
#alfresco.port=8080
#alfresco.protocol=http
#

#
# Share Point
#————-
#vti.server.port=7070
#vti.alfresco.deployment.context=/alfresco
vti.alfresco.alfresoHostWithPort=http://ducati.motec.com.au:8080
vti.share.shareHostWithPort=http://ducati.motec.com.au:8080
#vti.share.shareContext=/share
#vti.share.siteInBrowser=/page/site/…/dashboard
#vti.share.siteSettings=/page/site/…/customise-site
#vti.share.siteGroupMembership=/page/site/…/site-members
#vti.share.userInformation=/page/user/…/profile
#vti.share.documentLibrary=/page/site/…/documentlibrary
#vti.share.documentDetails=/page/site/…/document-details

#share.context=share
#share.host=${localname}
#share.port=8080
#share.protocol=http

#
# CIFS
#————-
cifs.enabled=true
cifs.serverName=${localname}
cifs.domain=MOTEC
cifs.broadcast=192.168.0.255
cifs.hostannounce=true‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Any pointers would be greatly appreciated.

Regards,

Tom

Find more posts tagged with

Comments

mrogers

You should have a value for.

spaces.wcm_deployed.childname in your repository.properties file. Are you missing it? If so how did you install 3.3?

yzenezy

Thanks for taking a look. Originally I installed 3.2r2 into /opt/Alfresco. To upgrade, I ran Alfresco-Community-3.3-Linux-x86-Install to install into /opt/Alfresco so it has over-written what was there.

I did some digging before I got your post and found the repository.properties but didn't know what to do with it:

# pwd
/opt/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco
# ls -l repository.properties
-rw-r–r– 1 root root 16538 Apr 13 17:03 repository.properties
# grep wcm repository.properties
spaces.wcm.childname=app:wcm
spaces.wcm_content_forms.childname=app:wcm_forms

The timestamp coincides with the install time

I also got HEAD from svn to see what the diffs where:

# diff repository.properties /usr/src/Alfresco/HEAD/root/projects/repository/config/alfresco/repository.properties

9,10d8
< web.application.context.url=http://localhost:8080/alfresco
< 
139a138,148
> # The number of days to keep orphaned content in the content stores.
> #    This has no effect on the 'deleted' content stores, which are not automatically emptied.
> system.content.orphanProtectDays=14
> # The CRON expression to trigger the deletion of resources associated with orphaned content.
> system.content.orphanCleanup.cronExpression=0 0 4 * * ?
> # The CRON expression to trigger content URL conversion.  This process is not intesive and can
> #    be triggered on a live system.  Similarly, it can be triggered using JMX on a dedicated machine.
> system.content.contentUrlConverter.cronExpression=* * * * * ? 2099
> system.content.contentUrlConverter.threadCount=2
> system.content.contentUrlConverter.batchSize=500
> system.content.contentUrlConverter.runAsScheduledJob=false
179c188,189
< lucene.indexer.mergerMinMergeDocs=1000
—
> lucene.indexer.mergerMaxBufferedDocs=-1
> lucene.indexer.mergerRamBufferSizeMb=16
186c196,197
< lucene.indexer.writerMinMergeDocs=1000
—
> lucene.indexer.writerMaxBufferedDocs=-1
> lucene.indexer.writerRamBufferSizeMb=16
193a205,207
> lucene.indexer.maxRamInMbForInMemoryMerge=16
> lucene.indexer.maxDocsForInMemoryIndex=10000
> lucene.indexer.maxRamInMbForInMemoryIndex=16
242a257,261
> audit.repository.enabled=true
> audit.cmischangelog.enabled=true
> # Setting this flag to true will cause alfresco/auditConfig.xml to be ignored
> # when audit is enabled. When false both alfresco/auditConfig.xml and
> # alfresco/audit/*.xml will be used.
245,257d263
< # Email configuration
< mail.host=
< mail.port=25
< mail.username=anonymous
< mail.password=
< # Set this value to UTF-8 or similar for encoding of email messages as required
< mail.encoding=UTF-8
< # Set this value to 7bit or similar for Asian encoding of email headers as required
< mail.header=
< mail.from.default=alfresco@alfresco.org
< mail.smtp.auth=false
< mail.smtp.timeout=30000
< 
302a309,315
> spaces.rendition.rendering_actions.childname=app:rendering_actions
> spaces.wcm_deployed.childname=cm:wcm_deployed
> spaces.transfers.childname=app:transfers
> spaces.transfer_groups.childname=app:transfer_groups
> spaces.transfer_temp.childname=app:temp
> spaces.inbound_transfer_records.childname=app:inbound_transfer_records
> spaces.outbound_transfer_records.childname=app:outbound_transfer_records
402d414
< imap.server.host=localhost
434a447,449
> # Transfer Service
> transferservice.receiver.enabled=true
> transferservice.receiver.stagingDir=${java.io.tmpdir}/alfresco-transfer-staging
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

# grep wcm /usr/src/Alfresco/HEAD/root/projects/repository/config/alfresco/repository.properties
spaces.wcm.childname=app:wcm
spaces.wcm_content_forms.childname=app:wcm_forms
spaces.wcm_deployed.childname=cm:wcm_deployed

Should I use the one from HEAD? Or should I do a complete re-install into a clean /opt/Alfresco? Even if I fix the repository.properties file is there a chance that something will bite me again later?

Thanks again

mrogers

http://wiki.alfresco.com/wiki/General_Upgrade_Process

Your repository.properties file is not correct so its unlikely to be the only problem,

What you should have done is to backup your system (just in case) and then replace the alfresco.war file with the new version.

Then after you restart, tomcat will unpack the war into <tomcat>/webapps/alfresco and you should be upgraded. That's why its important to have all your custom configuration out of the way in <tomcat>/shared/classes.

So yes I'd go for a complete reinstall into /opt/Alfresco2.

You should then be able to migrate any changes you made from /opt/Alfresco to /opt/Alfresco2 and as and when /opt/Alfresco2 is finished you can move /opt/Alfresco2 back to /opt/Alfresco

yzenezy

Nothing like doing it the right way! Well almost anyway… 😜

I've moved the original /opt/Alfresco aside and re-installed 3.3 using the installer. I already have a backup of the repository so I let the 3.3 code have it's way with the data there. The new code patched the repository and the applications came up fist time without error. After copying in my configs (alfresco-global.properties) and installing the vti-module.amp for sharepoint Alfresco looks like it's back to normal.

Initial startup log running admin.patch.PatchExecuter

CompilerOracle: exclude org/apache/lucene/index/IndexReader$1.doBody
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger.mergeIndexes
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger.mergeDeletions
Apr 15, 2010 1:26:20 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Apr 15, 2010 1:26:21 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 11222 ms
Apr 15, 2010 1:26:21 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Apr 15, 2010 1:26:21 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
Apr 15, 2010 1:26:21 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive mobile.war
01:26:57,426  INFO  [extensions.webscripts.DeclarativeRegistry] Registered 51 Web Scripts (+0 failed), 58 URLs
01:26:57,428  INFO  [extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed) 
01:26:57,428  INFO  [extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed) 
01:26:57,449  INFO  [extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 3191.1907ms)
01:26:57,524  INFO  [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
01:26:57,640  INFO  [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
01:26:57,743  INFO  [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
01:26:57,749  INFO  [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
01:26:57,884  INFO  [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
01:26:57,890  INFO  [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
Apr 15, 2010 1:26:58 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive share.war
01:27:13,267  INFO  [extensions.webscripts.DeclarativeRegistry] Registered 225 Web Scripts (+0 failed), 232 URLs
01:27:13,269  INFO  [extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed) 
01:27:13,269  INFO  [extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed) 
01:27:13,339  INFO  [extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 2459.821ms)
01:27:13,408  INFO  [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
01:27:13,523  INFO  [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
01:27:13,664  INFO  [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
01:27:13,678  INFO  [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
01:27:13,900  INFO  [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
01:27:13,906  INFO  [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
Apr 15, 2010 1:27:15 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive alfresco.war
Apr 15, 2010 1:27:30 AM org.apache.catalina.core.StandardContext addApplicationListener
INFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignored.
01:27:41,022  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
01:27:41,024  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
01:27:41,024  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/opt/Alfresco/tomcat/shared/classes/alfresco-global.properties]
01:27:41,233  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
01:28:12,488  INFO  [extensions.webscripts.TemplateProcessorRegistry] Registered template processor Repository Template Processor for extension ftl
01:28:12,491  INFO  [extensions.webscripts.ScriptProcessorRegistry] Registered script processor Repository Script Processor for extension js
01:28:27,110  INFO  [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
01:28:32,723  INFO  [domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-610220989436067032.sql (Copied from classpath:alfresco/dbscripts/upgrade/3.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoSchemaUpdate-3.2-ContentTables2.sql).
01:28:35,663  INFO  [domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-2940842676542879827.sql (Copied from classpath:alfresco/dbscripts/upgrade/3.3/org.hibernate.dialect.MySQLInnoDBDialect/remove-VersionCount.sql).
01:28:35,741  INFO  [domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-4304636821340201534.sql (Copied from classpath:alfresco/dbscripts/upgrade/3.3/org.hibernate.dialect.MySQLInnoDBDialect/fix-Repo-seqs_1.sql).
01:28:35,759  INFO  [domain.schema.SchemaBootstrap] All executed statements:  /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-All_Statements-6779360231374819450.sql.
01:28:36,949  INFO  [domain.schema.SchemaBootstrap] Normalized schema (pre-bootstrap)  dumped to file /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-5055880530081931818-Startup.xml.
01:28:36,949  INFO  [domain.schema.SchemaBootstrap] Normalized schema (post-bootstrap) dumped to file /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-5230643649717382185.xml.
01:28:36,955  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
01:28:37,022  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
01:28:37,079  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
01:28:40,567  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'thirdparty' subsystem, ID: [thirdparty, default]
01:28:40,581  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
01:28:42,782  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'thirdparty' subsystem, ID: [thirdparty, default] complete
01:28:42,783  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'OOoDirect' subsystem, ID: [OOoDirect, default]
01:28:42,804  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
01:28:45,750  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'OOoDirect' subsystem, ID: [OOoDirect, default] complete
01:28:50,161  INFO  [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /srv/alf_data
01:28:50,362  INFO  [admin.patch.PatchExecuter] Checking for patches to apply …
01:28:50,682  INFO  [admin.patch.PatchExecuter]         Applying patch 'patch.redeployNominatedInvitationProcessWithPropsForShare' (Redeploy nominated invitation workflow).
01:28:50,987  INFO  [admin.patch.PatchExecuter]         Applying patch 'patch.rendition.rendering_actions' (Creates the Rendering Actions folder.).
01:28:51,365  INFO  [admin.patch.PatchExecuter]         Applying patch 'patch.thumbnailsAssocQName' (Update the 'cm:thumbnails' association QName to 'rn:rendition'.).
01:28:51,385  INFO  [admin.patch.PatchExecuter]         Applying patch 'patch.emailInviteAndNotifyTemplatesFolder' (Ensures the existence of the 'Email Invite Templates' and 'Email Notify Templates' folders.).
01:28:52,051  INFO  [admin.patch.PatchExecuter]         Applying patch 'patch.convertContentUrls' (Converts pre-3.2 content URLs to use the alf_content_data table.  The conversion work can also be done on a schedule; please contact Alfresco Support for further details.).
01:28:52,174 User:System INFO  [admin.patch.PatchExecuter] Content URL conversion progress:
01:28:52,174 User:System INFO  [admin.patch.PatchExecuter]      Processing ADM Content URLs.
01:28:53,208 User:System INFO  [admin.patch.PatchExecuter]      Finished processing ADM nodes up to ID 4,649.
01:28:53,284 User:System INFO  [admin.patch.PatchExecuter]      Processing AVM Content URLs.
01:28:54,592 User:System INFO  [admin.patch.PatchExecuter]      Finished processing AVM nodes up to ID 420.
01:28:55,649 User:System INFO  [admin.patch.PatchExecuter]      Reading content URLs from store FileContentStore[ root=/srv/alf_data/contentstore, allowRandomAccess=true, readOnly=false].
01:29:02,703 User:System INFO  [admin.patch.PatchExecuter]      Scheduled 3,807 content URLs for deletion from store: FileContentStore[ root=/srv/alf_data/contentstore, allowRandomAccess=true, readOnly=false]
01:29:04,877  INFO  [admin.patch.PatchExecuter]         Applying patch 'patch.transferServiceFolder' (Add transfer definitions folder to data dictionary.).
01:29:05,892  INFO  [admin.patch.PatchExecuter]         Applying patch 'patch.wcmDeployed' (null).
01:29:05,957  WARN  [admin.patch.PatchExecuter] Patch description is not available: Patch[ id=patch.wcmDeployed, description=patch.wcmDeployed.description, fixesFromSchema=0, fixesToSchema=4009, targetSchema=10000]
01:29:07,824  INFO  [admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.db-V3.2-ContentTables2
RESULT: 
Script completed
=====================================
01:29:07,825  INFO  [admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.redeployNominatedInvitationProcessWithPropsForShare
RESULT: 
Re-deployed 1 workflows. 
=====================================
01:29:07,825  INFO  [admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.db-V3.3-Remove-VersionCount
RESULT: 
Script completed
=====================================
01:29:07,825  INFO  [admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.rendition.rendering_actions
RESULT: 
Imported view into bootstrap location: /app:company_home/app:dictionary (workspace://SpacesStore/16149b04-7f6c-4364-a931-b8886d94884a)
=====================================
01:29:07,825  INFO  [admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.thumbnailsAssocQName
RESULT: 
Successfully updated the '{http://www.alfresco.org/model/content/1.0}thumbnails' QName to '{http://www.alfresco.org/model/rendition/1.0}rendition'.
=====================================
01:29:07,825  INFO  [admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.emailInviteAndNotifyTemplatesFolder
RESULT: 
The Email Notify Templates folder was successfully created: workspace://SpacesStore/1261d681-3927-4ead-be20-b0a8baf65b08; The Email Invite Templates folder was successfully created: workspace://SpacesStore/1261d681-3927-4ead-be20-b0a8baf65b08
=====================================
01:29:07,825  INFO  [admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.convertContentUrls
RESULT: 
Content URL conversion completed.
=====================================
01:29:07,825  INFO  [admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.db-V3.3-Fix-Repo-Seqs_1
RESULT: 
Script completed
=====================================
01:29:07,825  INFO  [admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.transferServiceFolder
RESULT: 
Imported view into bootstrap location: /app:company_home/app:dictionary (workspace://SpacesStore/16149b04-7f6c-4364-a931-b8886d94884a)
=====================================
01:29:07,826  INFO  [admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.wcmDeployed
RESULT: 
Imported view into bootstrap location: /app:company_home (workspace://SpacesStore/16149b04-7f6c-4364-a931-b8886d94884a)
=====================================
01:29:07,863 User:System INFO  [repo.module.ModuleServiceImpl] Found 0 module(s).
01:29:08,004 User:System WARN  [repo.module.ModuleServiceImpl] A previously-installed module 'org.alfresco.module.vti' (version 1.2) is not present in your distribution.
01:29:08,007  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'fileServers' subsystem, ID: [fileServers, default]
01:29:08,028  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
01:29:08,627  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]
01:29:08,644  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
01:29:10,627  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1] complete
01:29:10,627  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'Authentication' subsystem, ID: [Authentication, managed, passthru1]
01:29:10,731  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
01:29:10,919  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'Authentication' subsystem, ID: [Authentication, managed, passthru1] complete
01:29:11,006  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'fileServers' subsystem, ID: [fileServers, default] complete
01:29:11,006  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'imap' subsystem, ID: [imap, default]
01:29:11,044  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
01:29:11,112  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'imap' subsystem, ID: [imap, default] complete
01:29:11,112  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'email' subsystem, ID: [email, outbound]
01:29:11,145  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
01:29:11,311  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'email' subsystem, ID: [email, outbound] complete
01:29:11,312  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'email' subsystem, ID: [email, inbound]
01:29:11,355  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
01:29:11,404  WARN  [springframework.beans.GenericTypeAwarePropertyDescriptor] Invalid JavaBean property 'blockedSenders' being accessed! Ambiguous write methods found next to actually used [public void org.alfresco.email.server.EmailServer.setBlockedSenders(java.util.List)]: [public void org.alfresco.email.server.EmailServer.setBlockedSenders(java.lang.String)]
01:29:11,405  WARN  [springframework.beans.GenericTypeAwarePropertyDescriptor] Invalid JavaBean property 'allowedSenders' being accessed! Ambiguous write methods found next to actually used [public void org.alfresco.email.server.EmailServer.setAllowedSenders(java.util.List)]: [public void org.alfresco.email.server.EmailServer.setAllowedSenders(java.lang.String)]
01:29:11,544  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'email' subsystem, ID: [email, inbound] complete
01:29:11,621  INFO  [repo.usage.UserUsageTrackingComponent] Enabled - calculate missing user usages …
01:29:11,702  INFO  [repo.usage.UserUsageTrackingComponent] Found 0 users to recalculate
01:29:11,702  INFO  [repo.usage.UserUsageTrackingComponent] … calculated missing usages for 0 users
01:29:11,702  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'Synchronization' subsystem, ID: [Synchronization, default]
01:29:11,714  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
01:29:12,970  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'Synchronization' subsystem, ID: [Synchronization, default] complete
01:29:13,103  INFO  [service.descriptor.DescriptorService] Alfresco JVM - v1.6.0_17-b04; maximum heap size 506.313MB
01:29:13,104  INFO  [service.descriptor.DescriptorService] Alfresco started (Community): Current version 3.3.0 (2765) schema 4009 - Originally installed version 3.0.0 (Stable 1526) schema 1002
01:29:47,505 User:System INFO  [extensions.webscripts.DeclarativeRegistry] Registered 341 Web Scripts (+0 failed), 576 URLs
01:29:47,505 User:System INFO  [extensions.webscripts.DeclarativeRegistry] Registered 2 Package Description Documents (+0 failed) 
01:29:47,505 User:System INFO  [extensions.webscripts.DeclarativeRegistry] Registered 1 Schema Description Documents (+0 failed) 
01:29:47,508 User:System INFO  [extensions.webscripts.AbstractRuntimeContainer] Initialised Repository Web Script Container (in 23932.93ms)
01:29:47,508  INFO  [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
01:29:47,510  INFO  [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
01:29:48,396  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'wcm_deployment_receiver' subsystem, ID: [wcm_deployment_receiver, default]
01:29:48,438  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
01:29:49,081  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'wcm_deployment_receiver' subsystem, ID: [wcm_deployment_receiver, default] complete
Apr 15, 2010 1:29:52 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Apr 15, 2010 1:29:52 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 210906 ms
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Thanks for all your help.