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

[Sai-1411]

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

Document Libraryalfresco.log

Thanks & Regards

    Sai Kumar S

[angelborroy]

Review your Search Service (Solr 6) configuration.

[Sai-1411]

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

[angelborroy]

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

[Sai-1411]

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

[Sai-1411]

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

[angelborroy]

Increase the amount of RAM available for alfresco.war

[Sai-1411]

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).

 Network

Thanks & Regards

     Sai kumar S