alfresco-5.0.b - WQS unable to connect to repository: Not Found

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Member II

alfresco-5.0.b - WQS unable to connect to repository: Not Found

Hi all,

This is my Alfresco ECM production environment :

OS : Centos 6.4

Alfresco community 5.0.b (installed all in one step - alfresco-community-5.0.b-installer-linux-x64.bin) at /opt/alfresco-5.0.b

Database : mysql-server-5.1.73-8.el6_8.x86_64

/opt/alfresco-5.0.b/tomcat/shared/classes/alfresco-global.properties

dir.root=/opt/alfresco-5.0.b/alf_data
dir.contentstore=/opt/contentstore

The production is running normally.

Backup steps running at night :

- mysqldump database "alfresco"

- backup all directories /opt/alfresco-5.0.b and /opt/contentstore .

I attempt to update my ECM to latest version 201707 (community) so I want to test it first :

- I build a test Centos 6.4 server with mysql-server-5.1.73-8.el6_8.x86_64 as above

- Import a full dump of "alfresco" db into clone server

- clone directory /opt/alfresco-5.0.b from production server to test server by scp

- create /opt/contentstore on test server without data

After starting mysqld and alfresco on test server I cannot login to http://myecm/share , this is output of catalina.out :

2018-01-04 17:36:00,067  ERROR [solr.tracker.AbstractTracker] [SolrTrackerScheduler_Worker-1] Tracking failed
 org.alfresco.error.AlfrescoRuntimeException: 00040421 GetModelsDiff return status is 404
        at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1095)
        at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.java:245)
        at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:207)
        at org.alfresco.solr.tracker.ModelTracker.doTrack(ModelTracker.java:167)
        at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:155)
        at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:47)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
17:36:00,652 WARN  [org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl] WQS unable to connect to repository: Not Found
17:36:02,657 WARN  [org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl] WQS unable to connect to repository: Not Found

My intention is trying to upgrade ECM on test server from 5.0.b to latest version first, then do it on production server but it seems my restoration doesn't work or my backup steps was wrong or I did something wrong ?

Please give me some advice, thank you very much.

7 Replies
Highlighted
Established Member

Re: alfresco-5.0.b - WQS unable to connect to repository: Not Found

Please provide full log

Highlighted
Member II

Re: alfresco-5.0.b - WQS unable to connect to repository: Not Found

Hi rohit nikhade , thanks for your reply, this is full log (from startup to shutdown)

Jan 05, 2018 8:43:28 AM org.apache.catalina.core.AprLifecycleListener init
INFO: Loaded APR based Apache Tomcat Native library 1.1.29 using APR version 1.4.6.
Jan 05, 2018 8:43:28 AM org.apache.catalina.core.AprLifecycleListener init
INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
Jan 05, 2018 8:43:28 AM org.apache.catalina.core.AprLifecycleListener initializeSSL
INFO: OpenSSL successfully initialized (OpenSSL 0.9.8y 5 Feb 2013)
Jan 05, 2018 8:43:28 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-apr-80"]
Jan 05, 2018 8:43:28 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-apr-8009"]
Jan 05, 2018 8:43:28 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8443"]
Jan 05, 2018 8:43:28 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 682 ms
Jan 05, 2018 8:43:28 AM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Jan 05, 2018 8:43:28 AM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.53
Jan 05, 2018 8:43:28 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor /opt/alfresco-5.0.b/tomcat/conf/Catalina/localhost/solr4.xml
Jan 05, 2018 8:43:28 AM org.apache.catalina.startup.SetContextPropertiesRule begin
WARNING: [SetContextPropertiesRule]{Context} Setting property 'debug' to '0' did not find a matching property.
Jan 05, 2018 8:43:35 AM org.apache.catalina.core.ApplicationContext log
INFO: No Spring WebApplicationInitializer types detected on classpath
Jan 05, 2018 8:43:41 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive /opt/alfresco-5.0.b/tomcat/webapps/share.war
Jan 05, 2018 8:43:43 AM org.apache.catalina.core.ApplicationContext log
INFO: No Spring WebApplicationInitializer types detected on classpath
log4j:ERROR Could not find value for key log4j.appender.Console
log4j:ERROR Could not instantiate appender named "Console".
log4j:WARN No such property [datePattern] in org.apache.log4j.RollingFileAppender.
Jan 05, 2018 8:43:43 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
Jan 05, 2018 8:43:50 AM org.apache.catalina.core.ApplicationContext log
INFO: org.tuckey.web.filters.urlrewrite.UrlRewriteFilter INFO: loaded (conf ok)
Jan 05, 2018 8:43:50 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring FrameworkServlet 'Spring Surf Dispatcher Servlet'
Jan 05, 2018 8:43:50 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive /opt/alfresco-5.0.b/tomcat/webapps/awe.war
Jan 05, 2018 8:43:52 AM org.apache.catalina.core.ApplicationContext log
INFO: No Spring WebApplicationInitializer types detected on classpath
Jan 05, 2018 8:43:52 AM org.apache.catalina.core.ApplicationContext log
INFO: org.tuckey.web.filters.urlrewrite.UrlRewriteFilter INFO: loaded (conf ok)

Jan 05, 2018 8:43:52 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring FrameworkServlet 'Spring Surf Dispatcher Servlet'
Jan 05, 2018 8:43:54 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive /opt/alfresco-5.0.b/tomcat/webapps/alfresco.war
Jan 05, 2018 8:44:02 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/core_rt is already defined
Jan 05, 2018 8:44:02 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/core is already defined
Jan 05, 2018 8:44:02 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/core is already defined
Jan 05, 2018 8:44:02 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/fmt_rt is already defined
Jan 05, 2018 8:44:02 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/fmt is already defined
Jan 05, 2018 8:44:02 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/fmt is already defined
Jan 05, 2018 8:44:02 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/functions is already defined
Jan 05, 2018 8:44:02 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/permittedTaglibs is already defined
Jan 05, 2018 8:44:02 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/scriptfree is already defined
Jan 05, 2018 8:44:02 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/sql_rt is already defined
Jan 05, 2018 8:44:02 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/sql is already defined
Jan 05, 2018 8:44:02 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/sql is already defined
Jan 05, 2018 8:44:02 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/xml_rt is already defined
Jan 05, 2018 8:44:02 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/xml is already defined
Jan 05, 2018 8:44:02 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/xml is already defined
Jan 05, 2018 8:44:02 AM org.apache.catalina.core.ApplicationContext log
INFO: No Spring WebApplicationInitializer types detected on classpath
log4j:WARN No such property [datePattern] in org.apache.log4j.RollingFileAppender.
Jan 05, 2018 8:44:02 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
05 Jan 2018 08:44:05,236  INFO  [alfresco.repo.admin] Using database URL 'jdbc:mysql://192.168.7.21:3306/alfresco?useUnicode=yes&characterEncoding=UTF-8&autoReconnect=true' with user 'alfresco'.
05 Jan 2018 08:44:05,456  INFO  [alfresco.repo.admin] Connected to database MySQL version 5.1.73-log
05 Jan 2018 08:44:10,160  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]

05 Jan 2018 08:44:10,181  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
05 Jan 2018 08:44:10,222  INFO  [domain.schema.SchemaBootstrap] Ignoring script patch (post-Hibernate): patch.db-V4.2-metadata-query-indexes
05 Jan 2018 08:44:15,882  INFO  [extensions.webscripts.TemplateProcessorRegistry] Registered template processor Repository Template Processor for extension ftl
05 Jan 2018 08:44:15,883  INFO  [extensions.webscripts.ScriptProcessorRegistry] Registered script processor Repository Script Processor for extension js
05 Jan 2018 08:44:17,334  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]
05 Jan 2018 08:44:17,360  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted] complete
05 Jan 2018 08:44:17,371  INFO  [domain.schema.SchemaBootstrap] Connecting to database: jdbc:mysql://192.168.7.21:3306/alfresco?useUnicode=yes&characterEncoding=UTF-8&autoReconnect=true, UserName=alfresco@ecm-test.itlvn.com, MySQL-AB JDBC Driver
05 Jan 2018 08:44:17,371  INFO  [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
05 Jan 2018 08:44:17,669  INFO  [domain.schema.SchemaBootstrap] No changes were made to the schema.
05 Jan 2018 08:44:18,176  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'Authentication' subsystem, ID: [Authentication, managed, alfinst]
05 Jan 2018 08:44:18,264  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'Authentication' subsystem, ID: [Authentication, managed, alfinst] complete
05 Jan 2018 08:44:18,265  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'Authentication' subsystem, ID: [Authentication, managed, ldap1]
05 Jan 2018 08:44:18,313  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'Authentication' subsystem, ID: [Authentication, managed, ldap1] complete
05 Jan 2018 08:44:18,617  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'thirdparty' subsystem, ID: [thirdparty, default]
05 Jan 2018 08:44:18,694  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'thirdparty' subsystem, ID: [thirdparty, default] complete
05 Jan 2018 08:44:18,694  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'OOoDirect' subsystem, ID: [OOoDirect, default]
05 Jan 2018 08:44:18,893  WARN  [alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
05 Jan 2018 08:44:18,897  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'OOoDirect' subsystem, ID: [OOoDirect, default] complete
05 Jan 2018 08:44:18,899  INFO  [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /opt/alfresco-5.0.b/alf_data
05 Jan 2018 08:44:18,899  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'Search' subsystem, ID: [Search, managed, solr4]
05 Jan 2018 08:44:19,087  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'Search' subsystem, ID: [Search, managed, solr4] complete
05 Jan 2018 08:44:19,099  ERROR [repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: System content not found in content store.
05 Jan 2018 08:44:19,099  ERROR [repo.admin.ConfigurationChecker] Ensure that the 'dir.root' property is pointing to the correct data location.
05 Jan 2018 08:44:19,101  ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 00050001 Ensure that the 'dir.root' property is pointing to the correct data location.
        at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:256)
        at org.alfresco.repo.admin.ConfigurationChecker.access$000(ConfigurationChecker.java:64)
        at org.alfresco.repo.admin.ConfigurationChecker$1$1.doWork(ConfigurationChecker.java:179)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
        at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationChecker.java:175)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:454)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:342)
        at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(ConfigurationChecker.java:185)
        at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)
        at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:948)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)

        at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4973)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Jan 05, 2018 8:44:19 AM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextLoaderListener
org.alfresco.error.AlfrescoRuntimeException: 00050001 Ensure that the 'dir.root' property is pointing to the correct data location.
        at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:256)
        at org.alfresco.repo.admin.ConfigurationChecker.access$000(ConfigurationChecker.java:64)
        at org.alfresco.repo.admin.ConfigurationChecker$1$1.doWork(ConfigurationChecker.java:179)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
        at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationChecker.java:175)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:454)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:342)
        at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(ConfigurationChecker.java:185)
        at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)
        at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:948)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
        at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4973)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)

        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)

Jan 05, 2018 8:44:19 AM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener
org.alfresco.error.AlfrescoRuntimeException: 00050001 Ensure that the 'dir.root' property is pointing to the correct data location.
        at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:256)
        at org.alfresco.repo.admin.ConfigurationChecker.access$000(ConfigurationChecker.java:64)
        at org.alfresco.repo.admin.ConfigurationChecker$1$1.doWork(ConfigurationChecker.java:179)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
        at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationChecker.java:175)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:454)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:342)
        at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(ConfigurationChecker.java:185)
        at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)
        at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:948)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
        at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4973)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)


Jan 05, 2018 8:44:19 AM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class org.alfresco.repo.webdav.WebDAVSessionListener
org.alfresco.error.AlfrescoRuntimeException: 00050001 Ensure that the 'dir.root' property is pointing to the correct data location.
        at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:256)
        at org.alfresco.repo.admin.ConfigurationChecker.access$000(ConfigurationChecker.java:64)
        at org.alfresco.repo.admin.ConfigurationChecker$1$1.doWork(ConfigurationChecker.java:179)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
        at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationChecker.java:175)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:454)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:342)
        at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(ConfigurationChecker.java:185)
        at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)
        at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:948)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
        at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4973)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)

Jan 05, 2018 8:44:19 AM com.sun.xml.ws.transport.http.servlet.WSServletContextListener contextInitialized
INFO: WSSERVLET12: JAX-WS context listener initializing
Jan 05, 2018 8:44:22 AM com.sun.xml.ws.transport.http.servlet.WSServletDelegate <init>
INFO: WSSERVLET14: JAX-WS servlet initializing
Jan 05, 2018 8:44:23 AM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error listenerStart
Jan 05, 2018 8:44:23 AM org.apache.catalina.core.StandardContext startInternal

SEVERE: Context [/alfresco] startup failed due to previous errors
Jan 05, 2018 8:44:23 AM com.sun.xml.ws.transport.http.servlet.WSServletDelegate destroy
INFO: WSSERVLET15: JAX-WS servlet destroyed
Jan 05, 2018 8:44:23 AM com.sun.xml.ws.transport.http.servlet.WSServletContextListener contextDestroyed
INFO: WSSERVLET13: JAX-WS context listener destroyed
Jan 05, 2018 8:44:23 AM org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext
05 Jan 2018 08:44:23,059  WARN  [context.support.XmlWebApplicationContext] Exception thrown from ApplicationListener handling ContextClosedEvent
java.lang.NullPointerException
        at org.alfresco.repo.workflow.activiti.ActivitiEngineInitializer.onShutdown(ActivitiEngineInitializer.java:57)
        at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:67)
        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:185)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)
        at org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:1049)
        at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:1010)
        at org.springframework.web.context.ContextLoader.closeWebApplicationContext(ContextLoader.java:586)
        at org.springframework.web.context.ContextLoaderListener.contextDestroyed(ContextLoaderListener.java:143)
        at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:5014)
        at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5659)
        at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:232)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:160)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
05 Jan 2018 08:44:23,491  WARN  [factory.support.DisposableBeanAdapter] Invocation of destroy method 'close' failed on bean with name 'solrSqlSessionTemplate': java.lang.UnsupportedOperationException: Manual close is not allowed over a Spring managed SqlSession
05 Jan 2018 08:44:23,492  WARN  [factory.support.DisposableBeanAdapter] Invocation of destroy method 'close' failed on bean with name 'activitiesSqlSessionTemplate': java.lang.UnsupportedOperationException: Manual close is not allowed over a Spring managed SqlSession
05 Jan 2018 08:44:23,494  INFO  [management.subsystems.ChildApplicationContextFactory] Stopping 'OOoDirect' subsystem, ID: [OOoDirect, default]
05 Jan 2018 08:44:23,494  INFO  [management.subsystems.ChildApplicationContextFactory] Stopped 'OOoDirect' subsystem, ID: [OOoDirect, default]
05 Jan 2018 08:44:23,494  INFO  [management.subsystems.ChildApplicationContextFactory] Stopping 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]
05 Jan 2018 08:44:23,495  INFO  [management.subsystems.ChildApplicationContextFactory] Stopped 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]
05 Jan 2018 08:44:23,797  INFO  [management.subsystems.ChildApplicationContextFactory] Stopping 'Search' subsystem, ID: [Search, managed, solr4]
05 Jan 2018 08:44:23,993  INFO  [management.subsystems.ChildApplicationContextFactory] Stopped 'Search' subsystem, ID: [Search, managed, solr4]
05 Jan 2018 08:44:24,025  WARN  [factory.support.DisposableBeanAdapter] Invocation of destroy method 'close' failed on bean with name 'locksSqlSessionTemplate': java.lang.UnsupportedOperationException: Manual close is not allowed over a Spring managed SqlSession
05 Jan 2018 08:44:24,026  WARN  [factory.support.DisposableBeanAdapter] Invocation of destroy method 'close' failed on bean with name 'propertyValueSqlSessionTemplate': java.lang.UnsupportedOperationException: Manual close is not allowed over a Spring managed SqlSession
05 Jan 2018 08:44:24,028  INFO  [management.subsystems.ChildApplicationContextFactory] Stopping 'thirdparty' subsystem, ID: [thirdparty, default]
05 Jan 2018 08:44:24,028  INFO  [management.subsystems.ChildApplicationContextFactory] Stopped 'thirdparty' subsystem, ID: [thirdparty, default]
05 Jan 2018 08:44:24,028  WARN  [factory.support.DisposableBeanAdapter] Invocation of destroy method 'close' failed on bean with name 'auditSqlSessionTemplate': java.lang.UnsupportedOperationException: Manual close is not allowed over a Spring managed SqlSession
05 Jan 2018 08:44:24,030  INFO  [management.subsystems.ChildApplicationContextFactory] Stopping 'Authentication' subsystem, ID: [Authentication, managed, alfinst]
05 Jan 2018 08:44:24,030  INFO  [management.subsystems.ChildApplicationContextFactory] Stopped 'Authentication' subsystem, ID: [Authentication, managed, alfinst]
05 Jan 2018 08:44:24,030  INFO  [management.subsystems.ChildApplicationContextFactory] Stopping 'Authentication' subsystem, ID: [Authentication, managed, ldap1]
05 Jan 2018 08:44:24,030  INFO  [management.subsystems.ChildApplicationContextFactory] Stopped 'Authentication' subsystem, ID: [Authentication, managed, ldap1]
05 Jan 2018 08:44:24,031  WARN  [factory.support.DisposableBeanAdapter] Invocation of destroy method 'close' failed on bean with name 'contentSqlSessionTemplate': java.lang.UnsupportedOperationException: Manual close is not allowed over a Spring managed SqlSession
05 Jan 2018 08:44:24,031  INFO  [management.subsystems.ChildApplicationContextFactory] Stopping 'sysAdmin' subsystem, ID: [sysAdmin, default]
05 Jan 2018 08:44:24,032  INFO  [management.subsystems.ChildApplicationContextFactory] Stopped 'sysAdmin' subsystem, ID: [sysAdmin, default]
05 Jan 2018 08:44:24,034  WARN  [factory.support.DisposableBeanAdapter] Invocation of destroy method 'close' failed on bean with name 'repoSqlSessionTemplate': java.lang.UnsupportedOperationException: Manual close is not allowed over a Spring managed SqlSession
Jan 05, 2018 8:44:24 AM org.apache.catalina.core.ApplicationContext log
INFO: Shutting down log4j
Jan 05, 2018 8:44:24 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive /opt/alfresco-5.0.b/tomcat/webapps/wcmqs.war
Jan 05, 2018 8:44:26 AM org.apache.catalina.core.ApplicationContext log
INFO: No Spring WebApplicationInitializer types detected on classpath
08:44:26,186 WARN  [org.apache.myfaces.shared_impl.util.LocaleUtils] Locale name in faces-config.xml null or empty, setting locale to default locale : en_US
Jan 05, 2018 8:44:26 AM org.apache.catalina.core.ApplicationContext log
INFO: org.tuckey.web.filters.urlrewrite.UrlRewriteFilter INFO: loaded (conf ok)
Jan 05, 2018 8:44:26 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring FrameworkServlet 'Spring MVC Dispatcher Servlet'
Jan 05, 2018 8:44:29 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /opt/alfresco-5.0.b/tomcat/webapps/manager
Jan 05, 2018 8:44:29 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /opt/alfresco-5.0.b/tomcat/webapps/ROOT
Jan 05, 2018 8:44:29 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /opt/alfresco-5.0.b/tomcat/webapps/host-manager
Jan 05, 2018 8:44:29 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-apr-80"]
Jan 05, 2018 8:44:29 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-apr-8009"]
Jan 05, 2018 8:44:29 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8443"]
Jan 05, 2018 8:44:29 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 61004 ms
08:44:29,717 WARN  [org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl] WQS unable to connect to repository: Not Found

2018-01-05 08:44:29,902  ERROR [solr.tracker.AbstractTracker] [SolrTrackerScheduler_Worker-2] Tracking failed
 org.alfresco.error.AlfrescoRuntimeException: 00050001 GetModelsDiff return status is 404
        at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1095)
        at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.java:245)
        at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:207)
        at org.alfresco.solr.tracker.ModelTracker.doTrack(ModelTracker.java:167)
        at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:155)
        at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:47)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2018-01-05 08:44:29,921  ERROR [solr.tracker.AbstractTracker] [SolrTrackerScheduler_Worker-1] Tracking failed
 org.alfresco.error.AlfrescoRuntimeException: 00050000 GetTransactions return status is 404
        at org.alfresco.solr.client.SOLRAPIClient.getTransactions(SOLRAPIClient.java:424)
        at org.alfresco.solr.tracker.MetadataTracker.checkRepoAndIndexConsistency(MetadataTracker.java:151)
        at org.alfresco.solr.tracker.MetadataTracker.trackRepository(MetadataTracker.java:117)
        at org.alfresco.solr.tracker.MetadataTracker.doTrack(MetadataTracker.java:93)
        at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:155)
        at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:47)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2018-01-05 08:44:29,936  ERROR [solr.tracker.AbstractTracker] [SolrTrackerScheduler_Worker-3] Tracking failed
 org.alfresco.error.AlfrescoRuntimeException: 00050002 api/solr/aclchangesets return status:404
        at org.alfresco.solr.client.SOLRAPIClient.getAclChangeSets(SOLRAPIClient.java:158)
        at org.alfresco.solr.tracker.AclTracker.checkRepoAndIndexConsistency(AclTracker.java:347)
        at org.alfresco.solr.tracker.AclTracker.trackRepository(AclTracker.java:313)
        at org.alfresco.solr.tracker.AclTracker.doTrack(AclTracker.java:104)
        at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:155)
        at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:47)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)

..........................................................................................

08:44:45,777 WARN  [org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl] WQS unable to connect to repository: Not Found
08:44:47,781 WARN  [org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl] WQS unable to connect to repository: Not Found
08:44:49,785 WARN  [org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl] WQS unable to connect to repository: Not Found
08:44:51,790 WARN  [org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl] WQS unable to connect to repository: Not Found
08:44:53,796 WARN  [org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl] WQS unable to connect to repository: Not Found
Jan 05, 2018 8:44:55 AM org.apache.catalina.core.StandardServer await
INFO: A valid shutdown command was received via the shutdown port. Stopping the Server instance.
Jan 05, 2018 8:44:55 AM org.apache.coyote.AbstractProtocol pause
INFO: Pausing ProtocolHandler ["http-apr-80"]
Jan 05, 2018 8:44:55 AM org.apache.coyote.AbstractProtocol pause
INFO: Pausing ProtocolHandler ["ajp-apr-8009"]
Jan 05, 2018 8:44:55 AM org.apache.coyote.AbstractProtocol pause
INFO: Pausing ProtocolHandler ["http-bio-8443"]
Jan 05, 2018 8:44:55 AM org.apache.catalina.core.StandardService stopInternal
INFO: Stopping service Catalina
Jan 05, 2018 8:44:55 AM org.apache.catalina.core.ApplicationContext log
INFO: Destroying Spring FrameworkServlet 'Spring Surf Dispatcher Servlet'
Jan 05, 2018 8:44:55 AM org.apache.catalina.core.ApplicationContext log
INFO: org.tuckey.web.filters.urlrewrite.UrlRewriteFilter INFO: destroy called
Jan 05, 2018 8:44:55 AM org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext
Jan 05, 2018 8:44:55 AM org.apache.catalina.core.ApplicationContext log
INFO: Destroying Spring FrameworkServlet 'Spring MVC Dispatcher Servlet'
Jan 05, 2018 8:44:55 AM org.apache.catalina.core.ApplicationContext log

INFO: Destroying Spring FrameworkServlet 'Spring MVC Dispatcher Servlet'
Jan 05, 2018 8:44:55 AM org.apache.catalina.core.ApplicationContext log
INFO: org.tuckey.web.filters.urlrewrite.UrlRewriteFilter INFO: destroy called
Jan 05, 2018 8:45:26 AM org.apache.catalina.core.ApplicationContext log
INFO: Destroying Spring FrameworkServlet 'Spring Surf Dispatcher Servlet'
Jan 05, 2018 8:45:26 AM org.apache.catalina.core.ApplicationContext log
INFO: org.tuckey.web.filters.urlrewrite.UrlRewriteFilter INFO: destroy called
Jan 05, 2018 8:45:26 AM org.apache.coyote.AbstractProtocol stop
INFO: Stopping ProtocolHandler ["http-apr-80"]
Exception in thread "Thread-24" java.lang.NoClassDefFoundError: org/apache/log4j/spi/ThrowableInformation
        at org.apache.log4j.spi.LoggingEvent.<init>(LoggingEvent.java:165)
        at org.apache.log4j.Category.forcedLog(Category.java:391)
        at org.apache.log4j.Category.log(Category.java:856)
        at org.apache.commons.logging.impl.Log4JLogger.error(Log4JLogger.java:229)
        at org.alfresco.wcm.client.impl.WebScriptCallerImpl.executeRequest(WebScriptCallerImpl.java:197)
        at org.alfresco.wcm.client.impl.WebScriptCallerImpl.get(WebScriptCallerImpl.java:147)
        at org.alfresco.wcm.client.impl.WebScriptCallerImpl.getTicket(WebScriptCallerImpl.java:117)
        at org.alfresco.wcm.client.util.impl.AlfrescoTicketCmisAuthenticationProvider.getTicket(AlfrescoTicketCmisAuthenticationProvider.java:77)
        at org.alfresco.wcm.client.util.impl.AlfrescoTicketCmisAuthenticationProvider.getPassword(AlfrescoTicketCmisAuthenticationProvider.java:56)
        at org.apache.chemistry.opencmis.client.bindings.spi.StandardAuthenticationProvider.setSession(StandardAuthenticationProvider.java:68)
        at org.apache.chemistry.opencmis.client.bindings.impl.CmisBindingImpl.<init>(CmisBindingImpl.java:165)
        at org.apache.chemistry.opencmis.client.bindings.CmisBindingFactory.createCmisAtomPubBinding(CmisBindingFactory.java:146)
        at org.apache.chemistry.opencmis.client.runtime.CmisBindingHelper.createAtomPubBinding(CmisBindingHelper.java:98)
        at org.apache.chemistry.opencmis.client.runtime.CmisBindingHelper.createBinding(CmisBindingHelper.java:56)
        at org.apache.chemistry.opencmis.client.runtime.SessionFactoryImpl.getRepositories(SessionFactoryImpl.java:131)
Jan 05, 2018 8:45:26 AM org.apache.coyote.AbstractProtocol stop
INFO: Stopping ProtocolHandler ["ajp-apr-8009"]
        at org.apache.chemistry.opencmis.client.runtime.SessionFactoryImpl.getRepositories(SessionFactoryImpl.java:120)
        at org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl.getRepository(GuestSessionFactoryImpl.java:144)
        at org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl.run(GuestSessionFactoryImpl.java:157)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.ClassNotFoundException: org.apache.log4j.spi.ThrowableInformation
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1720)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1571)
        ... 19 more
Jan 05, 2018 8:45:26 AM org.apache.coyote.AbstractProtocol stop
INFO: Stopping ProtocolHandler ["http-bio-8443"]
Jan 05, 2018 8:45:26 AM org.apache.coyote.AbstractProtocol destroy
INFO: Destroying ProtocolHandler ["http-apr-80"]
Jan 05, 2018 8:45:26 AM org.apache.coyote.AbstractProtocol destroy
INFO: Destroying ProtocolHandler ["ajp-apr-8009"]
Jan 05, 2018 8:45:26 AM org.apache.coyote.AbstractProtocol destroy
INFO: Destroying ProtocolHandler ["http-bio-8443"]

Highlighted
Member II

Re: alfresco-5.0.b - WQS unable to connect to repository: Not Found

Update : I have just imported db and clone running directory from production to test server again, still same error, can anyone give me some advice ?

Highlighted
Established Member

Re: alfresco-5.0.b - WQS unable to connect to repository: Not Found

org.alfresco.error.AlfrescoRuntimeException: 00050001 Ensure that the 'dir.root' property is pointing to the correct data location.

It seems like there is a problem in that property when you cloned directory /opt/alfresco-5.0.b from the production server to test server. For more info go to:

 - Configuring contentstore and SOLR indices in Alfresco 5 - zylk 

https://community.alfresco.com/thread/234916-alfresco-community-52-edition-alfdata-folder-moving.

 

Highlighted
Member II

Re: alfresco-5.0.b - WQS unable to connect to repository: Not Found

Hi rohit nikhade,

Yes I know there is a problem but I cannot figure it out since I clone db and running directory /opt/alfresco-5.0.b (all it need to run) from production to test server, I assume that it must run ok, this is /opt/alfresco-5.0.b/tomcat/shared/classes/alfresco-global.properties on test server (exactly same as production):


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

dir.root=/opt/alfresco-5.0.b/alf_data
dir.contentstore=/opt/contentstore

alfresco.context=alfresco
alfresco.host=ecm.mydomain.com
alfresco.port=80
alfresco.protocol=http

share.context=share
share.host=ecm.mydomain.com
share.port=80
share.protocol=http

### database connection properties ###
#db.driver=org.postgresql.Driver
#db.username=admin
#db.password=******
#db.name=alfresco
#db.url=jdbcSmiley Tongueostgresql://localhost/alfresco

### Database connection Mysql server ##
db.name=alfresco
db.username=alfresco
db.password=*****
db.host=192.168.7.21   # only thing different
db.port=3306
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}?useUnicode=yes&characterEncoding=UTF-8&autoReconnect=true

# Note: your database must also be able to accept at least this many connections.  Please see your database documentation for instructions on how to configure this.
db.pool.max=275
db.pool.validate.query=SELECT 1

# The server mode. Set value here
# UNKNOWN | TEST | BACKUP | PRODUCTION
system.serverMode=UNKNOWN

### FTP Server Configuration ###
ftp.port=2121

### RMI registry port for JMX ###
alfresco.rmi.services.port=50500

### External executable locations ###
ooo.exe=/opt/alfresco-5.0.b/libreoffice/program/soffice
ooo.enabled=true
ooo.port=8100
img.root=/opt/alfresco-5.0.b/common
img.dyn=${img.root}/lib
img.exe=${img.root}/bin/convert
swf.exe=/opt/alfresco-5.0.b/common/bin/pdf2swf
swf.languagedir=/opt/alfresco-5.0.b/common/japanese

jodconverter.enabled=false
jodconverter.officeHome=/opt/alfresco-5.0.b/libreoffice
jodconverter.portNumbers=8100

# Determines if the JBPM engine is enabled
system.workflow.engine.jbpm.enabled=true
system.workflow.engine.jbpm.definitions.visible=true

### Initial admin password ###
alfresco_user_store.adminpassword=hash-of-something


### License location ###
dir.license.external=/opt/alfresco-5.0.b

### Solr indexing ###
index.subsystem.name=solr4
dir.keystore=${dir.root}/keystore
solr.port.ssl=8443

### BPM Engine ###
system.workflow.engine.jbpm.enabled=false

### Allow extended ResultSet processing
security.anyDenyDenies=false

The only thing different between production and test is "db.host" , I read 2 links above but they doesn't help, do I have to copy all data from dir.contentstore=/opt/contentstore from production to test to make it work ?

One more interesting thing : I watch catalina.out on production server when it starts and it also many this line:

WARN  [org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl] WQS unable to connect to repository: Unauthorized

but no "Tracking failed" and about "dir.root"

INFO  [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /opt/alfresco-5.0.b/alf_data

I'm quite confused.

Established Member

Re: alfresco-5.0.b - WQS unable to connect to repository: Not Found

Yeah, copy alf_data folder from production to test and configure the properties as given over here.

https://community.alfresco.com/external-link.jspa?url=https%3A%2F%2Fwww.zylk.net%2Fen%2Fweb-2-0%2Fbl... 

And let me know if that works.

Highlighted
Member II

Re: alfresco-5.0.b - WQS unable to connect to repository: Not Found

I copied alf_data folder from production to test since I scp -r /opt/alfresco-5.0.b from production to test.

It doesn't make sense, the above link talking about separating contentstore , contentstore.deleted , solr4 , solr4Backup from /opt/alfresco-5.0.b/alf_data which I didn't in my case, I just separate contentstore from /opt/alfresco-5.0.b/alf_data so directory structure is like this (now at production and test) :

/opt/alfresco-5.0.b
  contentstore (blank - without data)
  contentstore.deleted
  keystore
  oouser
  solr4
  solr4Backup /opt/contentstore (has data in sub folders : 2016 2017 2018)

However I configured the properties as given above link - I create directory structure exactly :

/opt/alfresco-5.0.b 
/opt/data  
  contentstore  
  contentstore.deleted
/opt/solr4Backup
/opt/solr4

I synced directory "/opt/contentstore/2018" from production to "/opt/data/contentstore/2018" at test (I cannot sync all others cause they are big) - still same error , same catalina.out except "dir.root" error code:

ERROR [repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: System content not found in content store.
ERROR [repo.admin.ConfigurationChecker] Ensure that the 'dir.root' property is pointing to the correct data location.
ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 00090001 Ensure that the 'dir.root' property is pointing to the correct data location.