Issues after upgrade from 4.0.2 to 4.2.c

[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