AnsweredAssumed Answered

Problemas con Alfresco 3.2

Question asked by abedoya on Dec 28, 2010
Latest reply on Jul 28, 2011 by cristinamr
Buenos días a todos y feliz navidad. Tras mis frustrados intentos de actualizar la versión 3.1 de alfresco a la 3.4 directamente, me he decidido actualizar paso a paso por todas la versiones intermedias.

El primer objetivo es llegar a la 3.2, cosa que consigo hacer con algunos errores que no consigo entender. Para más información deciros que uso Jboss y Oracle. El error despues del arranque es el siguiente:

10:53:15,311 INFO  [STDOUT] 10:53:15,311 User:System INFO  [service.descriptor.DescriptorService] Alfresco JVM - v1.6.0_20-b02; maximum heap size 973.250MB
10:53:15,422 INFO  [STDOUT] 10:53:15,422 User:System INFO  [service.descriptor.DescriptorService] Alfresco started (Community): Current version 3.2.0 (2039) schema 2019 - Installed version 3.0.0 (Stable 1526) schema 1002
10:53:19,306 INFO  [STDOUT] 10:53:19,082  ERROR [post.lookup.PostLookup] Exception during update of posts
com.ibatis.sqlmap.client.SqlMapException: There is no statement named select.activity.posts.by.status.only in this SqlMap.
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.getMappedStatement(SqlMapExecutorDelegate.java:231)
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:558)
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
        at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
        at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:94)
        at org.alfresco.repo.domain.activities.ibatis.ActivityPostDAOImpl.selectPosts(ActivityPostDAOImpl.java:49)
        at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:122)
        at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:56)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)

¿Alguna idea de como solucionarlo? He revisado el amp de Oracle que instale y si que aparece referencia a ese bean en el xml:

   <select id="select_activity_posts_by_status_only" parameterClass="ActivityPost" resultClass="ActivityPost">
      <![CDATA[
      select
         sequence_id as id,
         activity_data as activityData,
         activity_type as activityType,
         post_user_id as userId,
         post_date as postDate,
         job_task_node as jobTaskNode,
         site_network as siteNetwork,
         app_tool as appTool,
         status as status
      from
         alf_activity_post
      where
         status = #status#
      ]]>
   </select>

Gracias de antemano y un saludo.

Outcomes