I want to setup a web project

[danieltellez]

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 ops, 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 ?

[kvc]

Are you working with a nightly build? 

If you are working with a nightly build, there may be issues related to stability, completeness, etc.  Nightly builds are the latest and greatest, straight from the labs, builds of our source tree.  Looking at the error (AVMLuceneIndexer) would seem to indicate that you are working with the 2.1.0 codeline (HEAD) - as search against a web project isn't available in either our 2.0.0 Community release or 2.0.1E maintenance release.

If you are opening a new project, I would recommend doing so on either our 2.0.0 Community release (if you are a non-subscribing customer) or 2.0.1E release (if you on subscription).  The 2.1.0 codeline at any given day may have issues - it is useful to download to trial new emerging 2.1.0 features, but not as a stable platform for development until we release our Community release at the end of June.

Let me know if you have any more questions.

Kevin

[andreasg]

Hi,
I have had the same problem.
I fixed it by:

cd ALF_HOME\tomcat/webapps/alfresco/WEB-INF/classes/alfresco/dbscripts/upgrade/2.1/org.hibernate.dialect.Dialect\

and edited "AlfrescoSchemaUpdate-2.1-JBPMData.sql" making the Table names "jbpm_task" and so on uppercase to "JBPM_TASK"
‍‍‍‍‍

that was it for me.

Andreas