Hyland Community
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Upgradation of alfresco community edition from 5.1 to alfresco community edition 6.2

Sai-1411
Confirmed Champ
Confirmed Champ

‎07-10-2023 07:11 AM

Hi,

Requirement: Upgradation of alfresco community edition from 5.1 to alfresco community edition 6.2 in Windows Server

I have used the following procedure for upgradation where particular sites document library in alfresco is give an error like No documents.

1. Where i have taken backup from 5.1 --> alf_data --> contentstore, contentstore.deleted

I have taken backup of database using pg_dump.exe

For restoring pasted the contentstore and contentstore.deleted in alf_data of alfresco 6.2

and restore the database data using psql.exe

2. I tried the same upgradation procedure for 5.1 --> 5.2 where no error i found in Alfresco 5.2, but when i took backup and restored the data from 5.2 to 6.2 using the above procedure i got the same issue where a particular site is showing No Document.

Below are the screenshots attached for the error i am facing.

am i missing any DB upgrade scripts/patches here? or missing anything else ?

if so, please suggest a proper upgradation procedure to follow to upgrade the Alfresco from 5.1 to 6.2 in Windows Server.

As i am using Community Edition Alfresco 5.1, where there is no proper procedure of Upgradation.

proper upgradation procedure is not available. is it intentional to bring community edition customers into Enterprise edition?

Or do we have any other method of support like subscription platform wher we can get support from the Alfresco Community

imageDocument Libraryimagealfresco.log

Thanks & Regards

    Sai Kumar S

Labels:
0 Kudos
7 REPLIES 7

angelborroy
Community Manager Community Manager
Community Manager

‎07-11-2023 06:08 AM

Review your Search Service (Solr 6) configuration.

Hyland Developer Evangelist
0 Kudos

Sai-1411
Confirmed Champ
Confirmed Champ
In response to angelborroy

‎07-11-2023 10:20 AM

Hi,

Thank you for your reply Sir 

I have implemented the Solr6 configuration according to this link "https://javaworld-abhinav.blogspot.com/2020/12/setup-acs62-ga-and-ass14-distribution-stepbystep.html" 

One more issue i am facing in Alfresco Community Edition 6.2 is that users login is taking more time i.e about 3 minutes to 5 minutes.

I have attached the screenshots of solr indexing error of alfresco community edition 6.2

Thanks & Regards

    Sai Kumar S imageimage

0 Kudos

angelborroy
Community Manager Community Manager
Community Manager
In response to Sai-1411

‎07-11-2023 10:31 AM

Are you re-indexing SOLR from scratch? Indexes from 5.1 are not usable in 6.2

Hyland Developer Evangelist
0 Kudos

Sai-1411
Confirmed Champ
Confirmed Champ
In response to angelborroy

‎07-12-2023 12:04 AM

Hi Sir,

Thank you for your reply sir 

Yes i have re-indexed solr from scratch for Solr6. I did not use any solr4 indexes.

Thank You

Sai Kumar S

0 Kudos

Sai-1411
Confirmed Champ
Confirmed Champ
In response to Sai-1411

‎07-13-2023 12:15 AM

Hi, 

As i have mentioned login issue that the users are taking more than 3 minutes to login alfresco, for this issue below are the screenshots attached.

2023-07-11 10:11:39,830 INFO  [org.springframework.extensions.webscripts.connector.RemoteClient] [http-nio-8080-exec-19] Exception calling (GET) http://localhost:8080/alfresco/s/api/people/admin/sites?alf_ticket=TICKET_734abf90ef7e85991ea3b5848219cea73a2e76e6
java.net.SocketTimeoutException: Read timed out
    at java.base/java.net.SocketInputStream.socketRead0(Native Method)
    at java.base/java.net.SocketInputStream.socketRead(SocketInputStream.java:115)
    at java.base/java.net.SocketInputStream.read(SocketInputStream.java:168)
    at java.base/java.net.SocketInputStream.read(SocketInputStream.java:140)
    at org.apache.http.impl.io.SessionInputBufferImpl.streamRead(SessionInputBufferImpl.java:137)
    at org.apache.http.impl.io.SessionInputBufferImpl.fillBuffer(SessionInputBufferImpl.java:153)
    at org.apache.http.impl.io.SessionInputBufferImpl.readLine(SessionInputBufferImpl.java:280)
    at org.apache.http.impl.conn.DefaultHttpResponseParser.parseHead(DefaultHttpResponseParser.java:138)
    at org.apache.http.impl.conn.DefaultHttpResponseParser.parseHead(DefaultHttpResponseParser.java:56)
    at org.apache.http.impl.io.AbstractMessageParser.parse(AbstractMessageParser.java:259)
    at org.apache.http.impl.DefaultBHttpClientConnection.receiveResponseHeader(DefaultBHttpClientConnection.java:163)
    at org.apache.http.impl.conn.CPoolProxy.receiveResponseHeader(CPoolProxy.java:157)
    at org.apache.http.protocol.HttpRequestExecutor.doReceiveResponse(HttpRequestExecutor.java:273)
    at org.apache.http.protocol.HttpRequestExecutor.execute(HttpRequestExecutor.java:125)
    at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:272)
    at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:186)
    at org.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:89)



2023-07-11 10:11:39,836 INFO  [org.springframework.extensions.webscripts.connector.RemoteClient] [http-nio-8080-exec-19] Error status 408 The stack details have been removed for security reasons.
java.net.SocketTimeoutException: Read timed out
    at java.base/java.net.SocketInputStream.socketRead0(Native Method)
    at java.base/java.net.SocketInputStream.socketRead(SocketInputStream.java:115)
    at java.base/java.net.SocketInputStream.read(SocketInputStream.java:168)
    at java.base/java.net.SocketInputStream.read(SocketInputStream.java:140)
    at org.apache.http.impl.io.SessionInputBufferImpl.streamRead(SessionInputBufferImpl.java:137)
    at org.apache.http.impl.io.SessionInputBufferImpl.fillBuffer(SessionInputBufferImpl.java:153)
    at org.apache.http.impl.io.SessionInputBufferImpl.readLine(SessionInputBufferImpl.java:280)
    at org.apache.http.impl.conn.DefaultHttpResponseParser.parseHead(DefaultHttpResponseParser.java:138)
    at org.apache.http.impl.conn.DefaultHttpResponseParser.parseHead(DefaultHttpResponseParser.java:56)
    at org.apache.http.impl.io.AbstractMessageParser.parse(AbstractMessageParser.java:259)
    at org.apache.http.impl.DefaultBHttpClientConnection.receiveResponseHeader(DefaultBHttpClientConnection.java:163)
    at org.apache.http.impl.conn.CPoolProxy.receiveResponseHeader(CPoolProxy.java:157)
    at org.apache.http.protocol.HttpRequestExecutor.doReceiveResponse(HttpRequestExecutor.java:273)
    at org.apache.http.protocol.HttpRequestExecutor.execute(HttpRequestExecutor.java:125)
    at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:272)
    at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:186)
    at org.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:89)
    at org.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:110)
    at org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:185)
    at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:83)
    at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:108)
    at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:56)
    at org.springframework.extensions.webscripts.connector.RemoteClient.service(RemoteClient.java:1167)
    at org.springframework.extensions.webscripts.connector.RemoteClient.service(RemoteClient.java:934)
    at org.springframework.extensions.webscripts.connector.RemoteClient.call(RemoteClient.java:657)
    at org.springframework.extensions.webscripts.connector.RemoteClient.call(RemoteClient.java:591)
    at org.springframework.extensions.webscripts.connector.HttpConnector.call(HttpConnector.java:70)
    at org.springframework.extensions.webscripts.RequestCachingConnector.call(RequestCachingConnector.java:91)
    at org.springframework.extensions.webscripts.connector.AuthenticatingConnector.call(AuthenticatingConnector.java:136)
    at org.springframework.extensions.webscripts.ScriptRemoteConnector.call(ScriptRemoteConnector.java:95)
    at org.springframework.extensions.webscripts.ScriptRemote.call(ScriptRemote.java:179)
    at jdk.internal.reflect.GeneratedMethodAccessor926.invoke(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:138)
    at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:226)
    at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:45)
    at org.mozilla.javascript.gen.file__G__DMS_BDC_tomcat_webapps_share_WEB_INF_classes_alfresco_site_webscripts_org_alfresco_components_dashlets_my_profile_get_js_8._c_main_2(file:/G:/DMS-BDC/tomcat/webapps/share/WEB-INF/classes/alfresco/site-webscripts/org/alfresco/components/dashlets/my-profile.get.js:18)
    at org.mozilla.javascript.gen.file__G__DMS_BDC_tomcat_webapps_share_WEB_INF_classes_alfresco_site_webscripts_org_alfresco_components_dashlets_my_profile_get_js_8.call(file:/G:/DMS-BDC/tomcat/webapps/share/WEB-INF/classes/alfresco/site-webscripts/org/alfresco/components/dashlets/my-profile.get.js)
    at org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:76)
    at org.mozilla.javascript.gen.file__G__DMS_BDC_tomcat_webapps_share_WEB_INF_classes_alfresco_site_webscripts_org_alfresco_components_dashlets_my_profile_get_js_8._c_script_0(file:/G:/DMS-BDC/tomcat/webapps/share/WEB-INF/classes/alfresco/site-webscripts/org/alfresco/components/dashlets/my-profile.get.js:95)
    at org.mozilla.javascript.gen.file__G__DMS_BDC_tomcat_webapps_share_WEB_INF_classes_alfresco_site_webscripts_org_alfresco_components_dashlets_my_profile_get_js_8.call(file:/G:/DMS-BDC/tomcat/webapps/share/WEB-INF/classes/alfresco/site-webscripts/org/alfresco/components/dashlets/my-profile.get.js)
    at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:409)
    at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3566)
    at org.mozilla.javascript.gen.file__G__DMS_BDC_tomcat_webapps_share_WEB_INF_classes_alfresco_site_webscripts_org_alfresco_components_dashlets_my_profile_get_js_8.call(file:/G:/DMS-BDC/tomcat/webapps/share/WEB-INF/classes/alfresco/site-webscripts/org/alfresco/components/dashlets/my-profile.get.js)
    at org.mozilla.javascript.gen.file__G__DMS_BDC_tomcat_webapps_share_WEB_INF_classes_alfresco_site_webscripts_org_alfresco_components_dashlets_my_profile_get_js_8.exec(file:/G:/DMS-BDC/tomcat/webapps/share/WEB-INF/classes/alfresco/site-webscripts/org/alfresco/components/dashlets/my-profile.get.js)

Thanks & Regards

     Sai Kumar S

0 Kudos

angelborroy
Community Manager Community Manager
Community Manager
In response to Sai-1411

‎07-13-2023 02:29 AM

Increase the amount of RAM available for alfresco.war

Hyland Developer Evangelist
0 Kudos

Sai-1411
Confirmed Champ
Confirmed Champ
In response to angelborroy

‎07-19-2023 06:51 AM

Hi Sir,

As you mentioned above i have set the java memory and solr memory to -Xms64g -Xmx128g but also the issue is not resolved.

I have re-indexed the Postgresql database fully but also the issue is not resolved.

I have debugged where this issue is coming, so when i try to inspect using chrome browser i came know in network panel that more time is used by the dashboard url so please support me to resolve this issue.(Below is a screenshot of the network panel which i have highlighted).

 imageNetwork

Thanks & Regards

     Sai kumar S

0 Kudos
Getting started

Explore our Alfresco products with the links below. Use labels to filter content by product module.

Copyright © 2024 Khoros, LLC