07-10-2023 04: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
Thanks & Regards
Sai Kumar S
07-11-2023 03:08 AM
Review your Search Service (Solr 6) configuration.
07-11-2023 07: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
07-11-2023 07:31 AM
Are you re-indexing SOLR from scratch? Indexes from 5.1 are not usable in 6.2
07-11-2023 09:04 PM
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
07-12-2023 09:15 PM
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
07-12-2023 11:29 PM
Increase the amount of RAM available for alfresco.war
07-19-2023 03: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).
Thanks & Regards
Sai kumar S
Explore our Alfresco products with the links below. Use labels to filter content by product module.