AnsweredAssumed Answered

I want to setup a web project

Question asked by danieltellez on May 29, 2007
Latest reply on Jul 16, 2007 by andreasg
Hello,

I'm a newbie in alfresco.
I'm trying to setup a web project on Alfresco over Tomcat5.5
When I follow http://wiki.alfresco.com/wiki/WSF steps (Installation section) all gone fine but when i create Site-Configuration (step 4) all crash.

I'm trying to startup tomcat again but it can't deploy alfresco:


10:07:38,411 ERROR [impl.lucene.AVMLuceneIndexerAndSearcherFactory] Creating AVMLuceneIndexerAndSearcherFactory
10:07:40,082 WARN  [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
10:07:41,757 WARN  [alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could not be established.
10:07:44,529 INFO  [domain.schema.SchemaBootstrap] Executing database script /home/danieltellez/opt/apache-tomcat-5.5.23/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-48513.sql (Copied from classpath:alfresco/dbscripts/upgrade/1.4/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoSchemaUpdate-1.4-PostgresFKIndexes.sql).
10:07:45,896 INFO  [domain.schema.SchemaBootstrap] Executing database script /home/danieltellez/opt/apache-tomcat-5.5.23/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-48514.sql (Generated).
10:07:47,383 INFO  [domain.schema.SchemaBootstrap] Executing database script /home/danieltellez/opt/apache-tomcat-5.5.23/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-48515.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.1/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoSchemaUpdate-2.1-JBPMData.sql).

10:07:47,406 ERROR [domain.schema.SchemaBootstrap] Statement execution failed:
   SQL:  UPDATE jbpm_task SET priority_ = 2
   Error: Table 'alfresco.jbpm_task' doesn't exist
   File: /home/danieltellez/opt/apache-tomcat-5.5.23/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-48515.sql
   Line: 10
10:07:47,409 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'alfresco.jbpm_task' doesn't exist
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3118)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3047)
        at com.mysql.jdbc.Statement.execute(Statement.java:692)
        at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:618)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:593)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:478)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.checkSchemaPatchScripts(SchemaBootstrap.java:449)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:407)

… and so on

When I get this error (not is the first time :oops:), I ever drop database and delete alf_data. But I suspect this solution is not the best… What will happen when I'll have a big amount of data on alfresco ??

Any solution ?

Outcomes