topic Alfresco 4.2c contra Oracle 11g in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-contra-oracle-11g/m-p/185082#M138212 <HTML><HEAD></HEAD><BODY><SPAN>Buenas tardes.</SPAN><BR /><BR /><SPAN>He instalado Alfresco 4.2c contra MySQL con éxito sobre CentOS 6.3, no obstante el SGBD final será Oracle 11g y al tratar de instalarlo me da miles de problemas. Tengo que añadir como información que en ambos casos parto de una instalación limpia. También he puesto el driver ojdbc14.jar</SPAN><BR /><BR /><SPAN>Para instalar contra Oracle he realizado los siguientes pasos:</SPAN><BR /><BR /><SPAN>1-Descargar el plugin "oracle-alfresco-4.0_b.amp" para dar soporte Oracle a la versión Community </SPAN><BR /><SPAN> </SPAN><A href="http://forge.alfresco.com/gf/project/oracle/frs/" rel="nofollow noopener noreferrer">http://forge.alfresco.com/gf/project/oracle/frs/</A><BR /><BR /><SPAN>2-He añadido la configuración al fichero de propiedades</SPAN><BR /><SPAN>db.driver=oracle.jdbc.OracleDriver</SPAN><BR /><SPAN>db.username=XXXXXXXX</SPAN><BR /><SPAN>db.password=XXXXXXXX</SPAN><BR /><SPAN>db.name=XXXXXXXX</SPAN><BR /><SPAN>db.url=jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@&lt;IP&gt;:&lt;PORT&gt;:&lt;SID&gt;</SPAN><BR /><BR /><SPAN>3-He añadido el plugin al war de Alfresco (No lo arranqué por defecto)</SPAN><BR /><BR /><SPAN>java -jar /opt/alfresco-4.2.c/bin/alfresco-mmt.jar&nbsp; install ~/oracle-alfresco-4.0_b.amp /opt/alfresco-4.2.c/tomcat/webapps/alfresco.war</SPAN><BR /><BR /><SPAN>4-He arrancado y he obtenido lo siguiente la primera vez (Error al crear las tablas):</SPAN><BR /><BR /><SPAN>2012-12-19 16:05:44,001&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@XXXXXX:XXXXXX:XXXXXX, UserName=XXXXXX, Oracle JDBC driver</SPAN><BR /><SPAN> 2012-12-19 16:05:44,002&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect.</SPAN><BR /><SPAN> Dec 19, 2012 4:05:44 PM org.activiti.engine.impl.ProcessEngineImpl &lt;init&gt;</SPAN><BR /><SPAN>INFO: ProcessEngine activitiBootstrapEngine created</SPAN><BR /><SPAN>Dec 19, 2012 4:05:44 PM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource</SPAN><BR /><SPAN>INFO: performing create on engine with resource org/activiti/db/create/activiti.oracle.create.engine.sql</SPAN><BR /><SPAN>Dec 19, 2012 4:05:48 PM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource</SPAN><BR /><SPAN>INFO: performing create on history with resource org/activiti/db/create/activiti.oracle.create.history.sql</SPAN><BR /><SPAN>Dec 19, 2012 4:05:48 PM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource</SPAN><BR /><SPAN>INFO: performing create on identity with resource org/activiti/db/create/activiti.oracle.create.identity.sql</SPAN><BR /><SPAN>2012-12-19 16:06:19,298&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/alfresco-4.2.d/tomcat/temp/Alfresco/Alfresco-schema-AlfrescoOracle9Dialect-pre-upgrade-alf_-3955841227321099819.xml.</SPAN><BR /><SPAN> 2012-12-19 16:06:19,298&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/alfresco-4.2.d/tomcat/temp/Alfresco/Alfresco-schema-AlfrescoOracle9Dialect-pre-upgrade-avm_-5589999180809715522.xml.</SPAN><BR /><SPAN> 2012-12-19 16:06:19,298&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/alfresco-4.2.d/tomcat/temp/Alfresco/Alfresco-schema-AlfrescoOracle9Dialect-pre-upgrade-jbpm_-7025709814602406474.xml.</SPAN><BR /><SPAN> 2012-12-19 16:06:19,299&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/alfresco-4.2.d/tomcat/temp/Alfresco/Alfresco-schema-AlfrescoOracle9Dialect-pre-upgrade-act_-8494083256309649132.xml.</SPAN><BR /><SPAN> 2012-12-19 16:06:19,346&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/alfresco-4.2.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-6927223873748884445.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-RepoTables.sql).</SPAN><BR /><SPAN> 2012-12-19 16:06:21,477&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/alfresco-4.2.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-3860934218899391398.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-LockTables.sql).</SPAN><BR /><SPAN> 2012-12-19 16:06:21,670&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/alfresco-4.2.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-6176405191228569587.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-ContentTables.sql).</SPAN><BR /><SPAN> 2012-12-19 16:06:22,684&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/alfresco-4.2.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-7494030910155495858.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-PropertyValueTables.sql).</SPAN><BR /><SPAN> 2012-12-19 16:06:23,121&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/alfresco-4.2.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-6171079455224028704.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-AuditTables.sql).</SPAN><BR /><SPAN> 2012-12-19 16:06:23,245&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/alfresco-4.2.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-138387599383027756.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-AvmTables.sql).</SPAN><BR /><SPAN> 2012-12-19 16:06:24,062&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/alfresco-4.2.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-5500106896623881050.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-ActivityTables.sql).</SPAN><BR /><SPAN> 2012-12-19 16:06:24,264&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/alfresco-4.2.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-405415472476103949.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-UsageTables.sql).</SPAN><BR /><SPAN> 2012-12-19 16:06:24,306&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/alfresco-4.2.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-7162307512227852032.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-SubscriptionTables.sql).</SPAN><BR /><SPAN> 2012-12-19 16:06:24,359&nbsp; ERROR [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed</SPAN><BR /><SPAN> java.lang.NullPointerException</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.getScriptInputStream(SchemaBootstrap.java:1070)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:980)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:802)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1539)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;</SPAN><BR /><BR /><BR /><SPAN>Las sucesivas veces me sale el siguiente error:</SPAN><BR /><BR /><SPAN>2012-12-20 13:23:48,941&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@XXXXXX:XXXXXX:XXXXXX, UserName=XXXXXX, Oracle JDBC driver</SPAN><BR /><SPAN> 2012-12-20 13:23:48,942&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect.</SPAN><BR /><SPAN> 2012-12-20 13:25:09,354&nbsp; ERROR [domain.schema.SchemaBootstrap] [localhost-startStop-1] Unable to dump schema to directory /opt/alfresco-4.2.d/tomcat/temp/Alfresco</SPAN><BR /><SPAN> java.lang.RuntimeException: Unable to execute export.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.util.schemacomp.ExportDb.execute(ExportDb.java:178)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.util.schemacomp.DbToXML.execute(DbToXML.java:70)</SPAN><BR /><BR /><BR /><SPAN>El caso es que accedo con SQLPLUS y sí me ha creado algunas tablas, pero parece ser que cuando trata de crear las tablas de AlfrescoCreate-SubscriptionTables.sql da algún problema y ya entonces no vuelve a arrancar. Puedo limpiar los objetos del usuario de Oracle las veces que haga falta que siempre sale lo mismo.</SPAN><BR /><BR /><SPAN>¿Alguien sabe qué puede estar pasando? mis teorías son….</SPAN><BR /><BR /><SPAN>1-El Plugin es de una versión antigua y a lo mejor hay tablas nuevas</SPAN><BR /><SPAN>2-Permisos del usuario de DB, aunque realmente me garantizan que tienen los necesarios.</SPAN><BR /><BR /><SPAN>Muchísimas gracias por anticipado, Miguel.</SPAN></BODY></HTML> Thu, 20 Dec 2012 15:22:03 GMT farreri 2012-12-20T15:22:03Z Alfresco 4.2c contra Oracle 11g https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-contra-oracle-11g/m-p/185082#M138212 Buenas tardes.He instalado Alfresco 4.2c contra MySQL con éxito sobre CentOS 6.3, no obstante el SGBD final será Oracle 11g y al tratar de instalarlo me da miles de problemas. Tengo que añadir como información que en ambos casos parto de una instalación limpia. También he puesto el driver ojdbc14.ja Thu, 20 Dec 2012 15:22:03 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-contra-oracle-11g/m-p/185082#M138212 farreri 2012-12-20T15:22:03Z Re: Alfresco 4.2c contra Oracle 11g https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-contra-oracle-11g/m-p/185083#M138213 <HTML><HEAD></HEAD><BODY><SPAN>He echado un vistazo al contenido del plugin de Alfresco y lleva dentro los scripts de creación de las tablas….</SPAN><BR /><BR /><SPAN>¿Han cambiado mucho entre 4.0b y 4.2c? ¿Hay algún otro Script para crear las tablas manualmente?</SPAN><BR /><BR /><SPAN>Gracias de nuevo.</SPAN></BODY></HTML> Thu, 20 Dec 2012 15:26:53 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-contra-oracle-11g/m-p/185083#M138213 farreri 2012-12-20T15:26:53Z Re: Alfresco 4.2c contra Oracle 11g https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-contra-oracle-11g/m-p/185084#M138214 <HTML><HEAD></HEAD><BODY><SPAN>Hola… estoy instalando alfresco 4.2c con mysql en centos 6.3 y recibo el siguiente mensaje:</SPAN><BR /><BR /><SPAN>16:11:26,018 ERROR [ContextLoader] Context initialization failed org.springframework.beans.factory.BeanCreationException: </SPAN><BR /><SPAN>Error creating bean with name 'schemaBootstrap' defined in class path resource [alfresco/bootstrap-context.xml]: </SPAN><BR /><SPAN>Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:</SPAN><BR /><SPAN>PropertyAccessException 1: org.springframework.beans.MethodInvocationException: </SPAN><BR /><SPAN>Property 'hibernateMaxExecutions' threw exception; nested exception is java.lang.NoSuchMethodError: </SPAN><BR /><SPAN>org.hibernate.engine.ActionQueue.setMAX_EXECUTIONS_SIZE(I)V</SPAN><BR /><BR /><SPAN>Comentas que lo haz instalado con exito quisiera saber si tuviste algun detalle como el que muestro…</SPAN></BODY></HTML> Fri, 21 Dec 2012 15:02:22 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-contra-oracle-11g/m-p/185084#M138214 lexcorp 2012-12-21T15:02:22Z Re: Alfresco 4.2c contra Oracle 11g https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-contra-oracle-11g/m-p/185085#M138215 <HTML><HEAD></HEAD><BODY><SPAN>Ningún paso especial, únicamente la configuración de la cadena de conexión e instalación del driver jdbc para MySQL.</SPAN><BR /><BR /><BR /><SPAN>### database connection properties ###</SPAN><BR /><SPAN>db.driver=org.gjt.mm.mysql.Driver</SPAN><BR /><SPAN>db.username=xxxxxx</SPAN><BR /><SPAN>db.password=xxxxxx</SPAN><BR /><SPAN>db.name=xxxxxx</SPAN><BR /><SPAN>db.url=jdbc:mysql://xxxxxx:xxxxxx/xxxxxx?useUnicode=yes&amp;characterEncoding=UTF-8</SPAN></BODY></HTML> Wed, 26 Dec 2012 09:37:18 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-contra-oracle-11g/m-p/185085#M138215 farreri 2012-12-26T09:37:18Z Re: Alfresco 4.2c contra Oracle 11g https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-contra-oracle-11g/m-p/185086#M138216 <HTML><HEAD></HEAD><BODY><SPAN>Gracias verificare nuevamente la configuracion…</SPAN><BR /><SPAN>Respecto a configurar la version 4.2.c con oracle definitivamente la solucion es el proyecto opracle for alfresco, pero tendrias que generar tu propio amp con la version actualizada del esquema de base de datos… me parece que el administrador del proyecto dejo una guia de como hacerlo…</SPAN></BODY></HTML> Thu, 27 Dec 2012 15:07:03 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-4-2c-contra-oracle-11g/m-p/185086#M138216 lexcorp 2012-12-27T15:07:03Z