Issues after upgrade from 4.0.2 to 4.2.c

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

ashwini

Hello All ,

I have upgraded alfresco from 4.0.2 to Alf 4.2.c.
Environment is as below:
Ubuntun 10.04
Alfresco 4.2.c bundelled
Mysql 5.5
used LUCENE Indexing system


After upgrade , I can access Alfresco/share but I can see some errors in log file :
1. java.io.FileNotFoundException: /opt/alfresco-4.2.c/alf_data/solr/apache-solr-1.4.1.war

   As I looked arround I found /opt/alfresco-4.2.c/tomcat/conf/Catalina/localhost/solr.xml which try to access apache-solr-1.4.1.war and throwing file not found exception . Is it necessary to use this war even if we are using Lucene indexing system ?

2.Some Database related issues :

2013-03-13 15:27:40,423  WARN  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 14 potential problems, results written to: /opt/alfresco-4.2.c/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-alf_-2964843931754703117.txt
2013-03-13 15:27:40,578  WARN  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 5 potential problems, results written to: /opt/alfresco-4.2.c/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-avm_-8940001863637539025.txt
2013-03-13 15:27:40,837  WARN  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 1 potential problems, results written to: /opt/alfresco-4.2.c/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-jbpm_-3948950977270428228.txt
2013-03-13 15:27:41,163  WARN  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 30 potential problems, results written to: /opt/alfresco-4.2.c/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-act_-634984300346284183.txt
2013-03-13 15:30:02,499  WARN  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 12 potential problems, results written to: /opt/alfresco-4.2.c/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Post-Upgrade-act_-8891220271332612840.txt

    I just upgraded mysql5.1 to Mysql 5.5 and restore the DB. Dont know why I am getting these Warning messages.

3. Some issues with Contents/nodes like :

2013-03-13 15:31:44,830  ERROR [node.ibatis.NodeDAOImpl$MySQL] [indexTrackerThread2] ALF-13066: Orphan child node has been re-homed under lost_found: (266495, workspace://SpacesStore/f75a8ed4-2bf1-4462-a998-6a6d9137e852)
2013-03-13 15:31:52,592  ERROR [node.ibatis.NodeDAOImpl$MySQL] [indexTrackerThread1] ALF-13066: Orphan child node has been re-homed under lost_found: (278562, workspace://SpacesStore/eea1ca34-5bb2-4e79-8841-777ac2324402)
2013-03-13 15:32:07,904  ERROR [node.ibatis.NodeDAOImpl$MySQL] [indexTrackerThread3] ALF-13066: Orphan child node has been re-homed under lost_found: (293789, workspace://SpacesStore/69aa6644-8ab0-48f1-a11e-f75012def95b)

    Getting many more times above error message , as I full indexing contents.

4. Error While Applying patch 'patch.updateMimetypesVISIO' (Fix mimetype for Microsoft Visio).

2013-03-13 15:33:43,491  ERROR [repo.action.AsynchronousActionExecutionQueueImpl] [defaultAsyncAction1] Failed to execute asynchronous action: Action[ id=bb211618-9316-46ab-af98-1a1e0778a8e9, node=workspace://SpacesStore/bb211618-9316-46ab-af98-1a1e0778a8e9 ]: 02130003 Transformer for 'text/plain' source mime type and 'image/png' target mime type was not found. Operation can't be performed
org.alfresco.service.cmr.rendition.RenditionServiceException: 02130003 Transformer for 'text/plain' source mime type and 'image/png' target mime type was not found. Operation can't be performed
   at org.alfresco.repo.rendition.executer.AbstractTransformationRenderingEngine.render(AbstractTransformationRenderingEngine.java:115)
   at org.alfresco.repo.rendition.executer.AbstractRenderingEngine.executeRenditionImpl(AbstractRenderingEngine.java:501)
   at org.alfresco.repo.rendition.executer.AbstractRenderingEngine$1.doWork(AbstractRenderingEngine.java:425)
   at org.alfresco.repo.rendition.executer.AbstractRenderingEngine$1.doWork(AbstractRenderingEngine.java:408)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:529)
   at org.alfresco.repo.rendition.executer.AbstractRenderingEngine.executeImpl(AbstractRenderingEngine.java:407)
   at org.alfresco.repo.rendition.executer.AbstractRenderingEngine.executeImpl(AbstractRenderingEngine.java:369)
   at org.alfresco.repo.action.executer.ActionExecuterAbstractBase.execute(ActionExecuterAbstractBase.java:241)
   at org.alfresco.repo.action.ActionServiceImpl.directActionExecution(ActionServiceImpl.java:822)
   at org.alfresco.repo.action.ActionServiceImpl.executeActionImpl(ActionServiceImpl.java:723)
   at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper$1$1.execute(AsynchronousActionExecutionQueueImpl.java:405)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:433)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:304)
   at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper$1.doWork(AsynchronousActionExecutionQueueImpl.java:414)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:529)
   at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper.run(AsynchronousActionExecutionQueueImpl.java:417)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
   at java.lang.Thread.run(Thread.java:722)


Can Anybody  help me to resolve these problems ?

Regards,
Ashwini

ashwini

Has anybody faced this issue ?

I am not understanding , why i am getting specifically below issue:
2.Some Database related issues :

2013-03-27 15:35:05,143  WARN  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 14 potential problems, results written to: /opt/alfresco-4.2.c/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-alf_-4176530285609252313.txt
2013-03-27 15:35:05,232  WARN  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 5 potential problems, results written to: /opt/alfresco-4.2.c/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-avm_-262637848471301812.txt
2013-03-27 15:35:05,503  WARN  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 1 potential problems, results written to: /opt/alfresco-4.2.c/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-jbpm_-6075072479027962554.txt
2013-03-27 15:35:05,717  WARN  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 30 potential problems, results written to: /opt/alfresco-4.2.c/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-act_-4007153533602439583.txt
2013-03-27 15:37:25,724  WARN  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 12 potential problems, results written to: /opt/alfresco-4.2.c/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Post-Upgrade-act_-3732276890897904357.txt

When I open respective file from /tomcat/temp/Alfresco

it displayes messages something like :
Difference: expected column .ACT_RE_PROCDEF.REV_.order="2", but was .ACT_RE_PROCDEF.REV_.order="11" Difference: expected column .ACT_RE_PROCDEF.CATEGORY_.order="3", but was .ACT_RE_PROCDEF.CATEGORY_.order="2" Difference: expected column .ACT_RE_PROCDEF.NAME_.order="4", but was .ACT_RE_PROCDEF.NAME_.order="3" Difference: expected column .ACT_RE_PROCDEF.KEY_.order="5", but was .ACT_RE_PROCDEF.KEY_.order="4" Difference: expected column .ACT_RE_PROCDEF.VERSION_.order="6", but was .ACT_RE_PROCDEF.VERSION_.order="5" Difference: expected column .ACT_RE_PROCDEF.DEPLOYMENT_ID_.order="7", but was .ACT_RE_PROCDEF.DEPLOYMENT_ID_.order="6" Difference: expected column .ACT_RE_PROCDEF.RESOURCE_NAME_.order="8", but was .ACT_RE_PROCDEF.RESOURCE_NAME_.order="7" Difference: expected column .ACT_RE_PROCDEF.DGRM_RESOURCE_NAME_.order="9", but was .ACT_RE_PROCDEF.DGRM_RESOURCE_NAME_.order="8" Difference: expected column .ACT_RE_PROCDEF.HAS_START_FORM_KEY_.order="10", but was .ACT_RE_PROCDEF.HAS_START_FORM_KEY_.order="9" Difference: expected column .ACT_RE_PROCDEF.SUSPENSION_STATE_.order="11", but was .ACT_RE_PROCDEF.SUSPENSION_STATE_.order="10" Difference: expected column .ACT_RU_EXECUTION.IS_EVENT_SCOPE_.order="12", but was .ACT_RU_EXECUTION.IS_EVENT_SCOPE_.order="13" Difference: expected column .ACT_RU_EXECUTION.SUSPENSION_STATE_.order="13", but was .ACT_RU_EXECUTION.SUSPENSION_STATE_.order="12"


Please help me to resolve this issue