how to fix 'WQS unable to connect to repository: Unauthorized' error?

[srinivasr]

Hi,

I have installed Alfresco Community - 5.1.0 (r122274-b3) and migrated the data from older version of alfresco. I could login to the server and could see all the data but seeing lot of solr error messages.

Did anyone came across these errors?

<code>
org.alfresco.error.AlfrescoRuntimeException: 03140486 Initial transaction not found with correct timestamp
        at org.alfresco.solr.tracker.MetadataTracker.checkRepoAndIndexConsistency(MetadataTracker.java:214)
        at org.alfresco.solr.tracker.MetadataTracker.trackRepository(MetadataTracker.java:132)
        at org.alfresco.solr.tracker.MetadataTracker.doTrack(MetadataTracker.java:103)
        at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:185)
        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)
2016-04-14 14:40:30,099  ERROR [solr.tracker.AbstractTracker] [SolrTrackerScheduler_Worker-40] Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 03140487 Initial acl transaction not found with correct timestamp
        at org.alfresco.solr.tracker.AclTracker.checkRepoAndIndexConsistency(AclTracker.java:361)
        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:185)
        at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:47)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:216
14:40:46,522 WARN  [org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl] WQS unable to connect to repository: Unauthorized
14:40:48,555 WARN  [org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl] WQS unable to connect to repository: Unauthorized
14:40:50,588 WARN  [org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl] WQS unable to connect to repository: Unauthorized
14:40:52,617 WARN  [org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl] WQS unable to connect to repository: Unauthorized
14:40:54,649 WARN  [org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl] WQS unable to connect to repository: Unauthorized
14:40:56,678 WARN  [org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl] WQS unable to connect to repository: Unauthorized
14:40:58,707 WARN  [org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl] WQS unable to connect to repository: Unauthorized
2016-04-14 14:41:00,062  ERROR [solr.tracker.MetadataTracker] [SolrTrackerScheduler_Worker-8] First transaction was not found with the correct timestamp.
<code>

[niketapatel]

Hi, "WQS unable to connect to repository: Unauthorized" and Solr error both are different one.

For Solr related error, You may try re-indexing.

For WQS unable to connect to repository, you must have installed web quick start module. Make sure you have provided correct admin password in wqsapi-custom.properties located at \tomcat\shared\classes\alfresco\extension.

wcmqs.api.alfresco=http://127.0.0.1:8080/alfresco
#wcmqs.api.user=admin
wcmqs.api.password=admin
‍‍‍‍‍

[srinivasr]

Thanks Niketa for your response. I updated the password in wqsapi.properties and i no longer see wqs error message.

We are upgrading alfresco to a newer version and seeing lot of JSON errors in the logs. Not sure if these are related to solr index. Do you have any idea about these errors?

I deleted all the indexes from solr directory so that the indexes will be regenerated.

Caused by: org.alfresco.repo.search.impl.lucene.LuceneQueryParserException: 03180005 Request failed 404 /solr/alfresco/alfresco?wt=json&fl=DBID%2Cscore&rows=1000&df=TEXT&start=0&locale=en_US&alternativeDic=DEFAULT_DICTIONARY&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON
   at org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.postQuery(SolrQueryHTTPClient.java:694)
   at org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.postSolrQuery(SolrQueryHTTPClient.java:644)
   at org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.executeQuery(SolrQueryHTTPClient.java:605)
   at org.alfresco.repo.search.impl.solr.SolrQueryLanguage.executeQuery(SolrQueryLanguage.java:51)
   at org.alfresco.repo.search.impl.solr.SolrSearchService.query(SolrSearchService.java:348)
   at org.alfresco.repo.search.impl.solr.SolrSearchService.query(SolrSearchService.java:152)
   at org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:66)
   at org.alfresco.repo.search.AbstractSearcherComponent.query(AbstractSearcherComponent.java:53)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:497)
   at org.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:72)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at com.sun.proxy.$Proxy22.query(Unknown Source)
   at org.alfresco.repo.search.impl.SearchServiceSubSystemDelegator.query(SearchServiceSubSystemDelegator.java:91)
   at org.alfresco.module.org_alfresco_module_wcmquickstart.jobs.DynamicCollectionProcessor$1$1.execute(DynamicCollectionProcessor.java:245)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)
   at org.alfresco.module.org_alfresco_module_wcmquickstart.jobs.DynamicCollectionProcessor$1.doWork(DynamicCollectionProcessor.java:234)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.module.org_alfresco_module_wcmquickstart.jobs.DynamicCollectionProcessor.runInternal(DynamicCollectionProcessor.java:229)
   at org.alfresco.module.org_alfresco_module_wcmquickstart.jobs.DynamicCollectionProcessor.run(DynamicCollectionProcessor.java:192)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:497)
   at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:269)
   at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:312)
   … 3 more
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[niketapatel]

Yes its Solr related error and I think its due to webQuick start installation. There is open issue please check - https://issues.alfresco.com/jira/browse/ACE-4942

If you are not using WebQuickStart module then I would suggest to remove it.