AnsweredAssumed Answered

Alfresco 4.2c contra Oracle 11g

Question asked by farreri on Dec 20, 2012
Latest reply on Dec 27, 2012 by lexcorp
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.jar

Para instalar contra Oracle he realizado los siguientes pasos:

1-Descargar el plugin "oracle-alfresco-4.0_b.amp" para dar soporte Oracle a la versión Community
http://forge.alfresco.com/gf/project/oracle/frs/

2-He añadido la configuración al fichero de propiedades
db.driver=oracle.jdbc.OracleDriver
db.username=XXXXXXXX
db.password=XXXXXXXX
db.name=XXXXXXXX
db.url=jdbc:oracle:thin:@<IP>:<PORT>:<SID>

3-He añadido el plugin al war de Alfresco (No lo arranqué por defecto)

java -jar /opt/alfresco-4.2.c/bin/alfresco-mmt.jar  install ~/oracle-alfresco-4.0_b.amp /opt/alfresco-4.2.c/tomcat/webapps/alfresco.war

4-He arrancado y he obtenido lo siguiente la primera vez (Error al crear las tablas):

2012-12-19 16:05:44,001  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbc:oracle:thin:@XXXXXX:XXXXXX:XXXXXX, UserName=XXXXXX, Oracle JDBC driver
2012-12-19 16:05:44,002  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect.
Dec 19, 2012 4:05:44 PM org.activiti.engine.impl.ProcessEngineImpl <init>
INFO: ProcessEngine activitiBootstrapEngine created
Dec 19, 2012 4:05:44 PM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource
INFO: performing create on engine with resource org/activiti/db/create/activiti.oracle.create.engine.sql
Dec 19, 2012 4:05:48 PM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource
INFO: performing create on history with resource org/activiti/db/create/activiti.oracle.create.history.sql
Dec 19, 2012 4:05:48 PM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource
INFO: performing create on identity with resource org/activiti/db/create/activiti.oracle.create.identity.sql
2012-12-19 16:06:19,298  INFO  [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.
2012-12-19 16:06:19,298  INFO  [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.
2012-12-19 16:06:19,298  INFO  [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.
2012-12-19 16:06:19,299  INFO  [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.
2012-12-19 16:06:19,346  INFO  [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).
2012-12-19 16:06:21,477  INFO  [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).
2012-12-19 16:06:21,670  INFO  [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).
2012-12-19 16:06:22,684  INFO  [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).
2012-12-19 16:06:23,121  INFO  [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).
2012-12-19 16:06:23,245  INFO  [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).
2012-12-19 16:06:24,062  INFO  [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).
2012-12-19 16:06:24,264  INFO  [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).
2012-12-19 16:06:24,306  INFO  [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).
2012-12-19 16:06:24,359  ERROR [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed
java.lang.NullPointerException
   at org.alfresco.repo.domain.schema.SchemaBootstrap.getScriptInputStream(SchemaBootstrap.java:1070)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:980)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:802)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1539)
   


Las sucesivas veces me sale el siguiente error:

2012-12-20 13:23:48,941  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbc:oracle:thin:@XXXXXX:XXXXXX:XXXXXX, UserName=XXXXXX, Oracle JDBC driver
2012-12-20 13:23:48,942  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect.
2012-12-20 13:25:09,354  ERROR [domain.schema.SchemaBootstrap] [localhost-startStop-1] Unable to dump schema to directory /opt/alfresco-4.2.d/tomcat/temp/Alfresco
java.lang.RuntimeException: Unable to execute export.
   at org.alfresco.util.schemacomp.ExportDb.execute(ExportDb.java:178)
   at org.alfresco.util.schemacomp.DbToXML.execute(DbToXML.java:70)


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.

¿Alguien sabe qué puede estar pasando? mis teorías son….

1-El Plugin es de una versión antigua y a lo mejor hay tablas nuevas
2-Permisos del usuario de DB, aunque realmente me garantizan que tienen los necesarios.

Muchísimas gracias por anticipado, Miguel.

Outcomes