SQL grammar/WAR deployment error on Win/MySQL bundle install

[dumpsterkitty]

Trying to get Alfresco set up for evaluation purposes; have spent my whole day on this and I give. Hope someone can give some pointers.

WinXP dev machine, which previously had older versions of Tomcat, JDK, MySQL, etc. etc. None of those were much needed so I deleted/disabled them (er: I think, I hope).

Trying to set up the full 1.4 Windows community bundle. I started off happy enough to stick with HSQL for eval but when I had problems I switched to MySQL. Got through a few issues, but I now appear to be stuck getting the Alfresco server started properly. The problems appear to begin at the "INFO: Deploying web application archive alfresco.war" point of the process; I end up with a long slew of exceptions which all appear to have to do with non-existent tables in the database. (The "alfresco" schema was properly created though.)

In case it's meaningful, it seems to take my console window forever to throw each database error.

My browser hangs forever if I try to go to any localhost:8080 URL.

I'll paste all my output below; can anyone assist with a jump start here? Thanks.

CompilerOracle: exclude org/apache/lucene/index/IndexReader$1 doBodyCompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger mergeIndexesCompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger mergeDeletionsFeb 1, 2007 3:43:06 PM org.apache.catalina.core.AprLifecycleListener lifecycleEventINFO: The Apache Portable Runtime which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\AlfrescoECMS Community Network\java\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Alfresco ECMS Community Network\java/bin;C:\Program Files\Alfresco ECMS Community Network\bin;C:\CFusionMX7\verity\k2\_nti40\bin;C:\Program Files\Java\jdk1.5.0_04\bin;C:\j2sdkee1.2.1\bin;C:windows;c:\windows\command;C:\Oracle\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\QuickTime\QTSystem\;"C:\Program Files\Zone Labs\ZoneAlarm\MailFrontier";C:\Program Files\MicrosoftSQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\;C:\Program Files\MySQL\MySQL Server 4.1\binFeb 1, 2007 3:43:07 PM org.apache.coyote.http11.Http11BaseProtocol initINFO: Initializing Coyote HTTP/1.1 on http-8080Feb 1, 2007 3:43:07 PM org.apache.catalina.startup.Catalina loadINFO: Initialization processed in 4727 msFeb 1, 2007 3:43:07 PM org.apache.catalina.core.StandardService startINFO: Starting service CatalinaFeb 1, 2007 3:43:07 PM org.apache.catalina.core.StandardEngine startINFO: Starting Servlet Engine: Apache Tomcat/5.5.12Feb 1, 2007 3:43:07 PM org.apache.catalina.core.StandardHost startINFO: XML validation disabledFeb 1, 2007 3:43:15 PM org.apache.catalina.startup.HostConfig deployWARINFO: Deploying web application archive alfresco.war15:46:11,599 ERROR [quartz.core.JobRunShell] Job DEFAULT.org.springframework.scheduling.quartz.JobDetailBean#5bf624 threw an unhandled Exception:org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could notexecute query; bad SQL grammar [select max(transactio1_.id) as col_0_0_ from alf_node_status nodestatus0_ inner join alf_transaction transactio1_ on nodestatus0_.transaction_id=transactio1_.id]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'alfresco.alf_node_status' doesn't existcom.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'alfresco.alf_node_status' 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:3124)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1262)        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)        at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)        at org.hibernate.loader.Loader.doQuery(Loader.java:662)        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)        at org.hibernate.loader.Loader.doList(Loader.java:2145)        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)        at org.hibernate.loader.Loader.list(Loader.java:2024)        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)        at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:749)        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl$13.doInHibernate(HibernateNodeDaoServiceImpl.java:1031)        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:365)        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:333)        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getLastTxn(HibernateNodeDaoServiceImpl.java:1034)        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)        at java.lang.reflect.Method.invoke(Method.java:585)        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)        at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:60)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)        at $Proxy1.getLastTxn(Unknown Source)        at org.alfresco.repo.node.index.FullIndexRecoveryComponent.reindexImpl(FullIndexRecoveryComponent.java:120)        at org.alfresco.repo.node.index.AbstractReindexComponent$1.doWork(AbstractReindexComponent.java:209)        at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:168)        at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.java:74)        at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(AbstractReindexComponent.java:213)        at org.alfresco.repo.node.index.IndexRecoveryJob.execute(IndexRecoveryJob.java:31)        at org.quartz.core.JobRunShell.run(JobRunShell.java:191)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)15:46:11,609 ERROR [quartz.core.ErrorLogger] Job (DEFAULT.org.springframework.scheduling.quartz.JobDetailBean#5bf624 threw an exception.org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute query; bad SQL grammar [select max(transactio1_.id) as col_0_0_from alf_node_status nodestatus0_ inner join alf_transaction transactio1_ on nodestatus0_.transaction_id=transactio1_.id]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'alfresco.alf_node_status' doesn't exist]        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)* Nested Exception (Underlying Cause) —————org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could notexecute query; bad SQL grammar [select max(transactio1_.id) as col_0_0_ from alf_node_status nodestatus0_ inner join alf_transaction transactio1_ on nodestatus0_.transaction_id=transactio1_.id]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'alfresco.alf_node_status' doesn't existcom.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'alfresco.alf_node_status' 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:3124)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1262)        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)        at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)        at org.hibernate.loader.Loader.doQuery(Loader.java:662)        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)        at org.hibernate.loader.Loader.doList(Loader.java:2145)        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)        at org.hibernate.loader.Loader.list(Loader.java:2024)        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)        at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:749)        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl$13.doInHibernate(HibernateNodeDaoServiceImpl.java:1031)        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:365)        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:333)        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getLastTxn(HibernateNodeDaoServiceImpl.java:1034)        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)        at java.lang.reflect.Method.invoke(Method.java:585)        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)        at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:60)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)        at $Proxy1.getLastTxn(Unknown Source)        at org.alfresco.repo.node.index.FullIndexRecoveryComponent.reindexImpl(FullIndexRecoveryComponent.java:120)        at org.alfresco.repo.node.index.AbstractReindexComponent$1.doWork(AbstractReindexComponent.java:209)        at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:168)        at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.java:74)        at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(AbstractReindexComponent.java:213)        at org.alfresco.repo.node.index.IndexRecoveryJob.execute(IndexRecoveryJob.java:31)        at org.quartz.core.JobRunShell.run(JobRunShell.java:191)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)15:50:11,083 ERROR [quartz.core.JobRunShell] Job DEFAULT.org.springframework.scheduling.quartz.JobDetailBean#1972e3a threw an unhandled Exception:org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could notexecute query; bad SQL grammar [select storeimpl0_.protocol as protocol6_, storeimpl0_.identifier as identifier6_, storeimpl0_.root_node_id as root3_6_ from alf_store storeimpl0_]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'alfresco.alf_store' doesn't existcom.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'alfresco.alf_store'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:3124)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1262)        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)        at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)        at org.hibernate.loader.Loader.doQuery(Loader.java:662)        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)        at org.hibernate.loader.Loader.doList(Loader.java:2145)        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)        at org.hibernate.loader.Loader.list(Loader.java:2024)        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl$3.doInHibernate(HibernateNodeDaoServiceImpl.java:263)        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:365)        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:333)        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getStores(HibernateNodeDaoServiceImpl.java:266)        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)        at java.lang.reflect.Method.invoke(Method.java:585)        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)        at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:60)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)        at $Proxy1.getStores(Unknown Source)        at org.alfresco.repo.node.db.DbNodeServiceImpl.getStores(DbNodeServiceImpl.java:161)        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)        at java.lang.reflect.Method.invoke(Method.java:585)        at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:213)        at $Proxy2.getStores(Unknown Source)        at org.alfresco.repo.node.index.MissingContentReindexComponent.reindexImpl(MissingContentReindexComponent.java:56)        at org.alfresco.repo.node.index.AbstractReindexComponent$1.doWork(AbstractReindexComponent.java:209)        at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:168)        at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.java:74)        at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(AbstractReindexComponent.java:213)        at org.alfresco.repo.node.index.IndexRecoveryJob.execute(IndexRecoveryJob.java:31)        at org.quartz.core.JobRunShell.run(JobRunShell.java:191)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)15:50:11,093 ERROR [quartz.core.ErrorLogger] Job (DEFAULT.org.springframework.scheduling.quartz.JobDetailBean#1972e3a threw an exception.org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute query; bad SQL grammar [select storeimpl0_.protocol as protocol6_, storeimpl0_.identifier as identifier6_, storeimpl0_.root_node_id as root3_6_from alf_store storeimpl0_]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'alfresco.alf_store' doesn't exist]        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)* Nested Exception (Underlying Cause) —————org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could notexecute query; bad SQL grammar [select storeimpl0_.protocol as protocol6_, storeimpl0_.identifier as identifier6_, storeimpl0_.root_node_id as root3_6_ from alf_store storeimpl0_]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'alfresco.alf_store' doesn't existcom.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'alfresco.alf_store'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:3124)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1262)        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)        at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)        at org.hibernate.loader.Loader.doQuery(Loader.java:662)        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)        at org.hibernate.loader.Loader.doList(Loader.java:2145)        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)        at org.hibernate.loader.Loader.list(Loader.java:2024)        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl$3.doInHibernate(HibernateNodeDaoServiceImpl.java:263)        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:365)        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:333)        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getStores(HibernateNodeDaoServiceImpl.java:266)        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)        at java.lang.reflect.Method.invoke(Method.java:585)        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)        at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:60)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)        at $Proxy1.getStores(Unknown Source)        at org.alfresco.repo.node.db.DbNodeServiceImpl.getStores(DbNodeServiceImpl.java:161)        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)        at java.lang.reflect.Method.invoke(Method.java:585)        at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:213)        at $Proxy2.getStores(Unknown Source)        at org.alfresco.repo.node.index.MissingContentReindexComponent.reindexImpl(MissingContentReindexComponent.java:56)        at org.alfresco.repo.node.index.AbstractReindexComponent$1.doWork(AbstractReindexComponent.java:209)        at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:168)        at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.java:74)        at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(AbstractReindexComponent.java:213)        at org.alfresco.repo.node.index.IndexRecoveryJob.execute(IndexRecoveryJob.java:31)        at org.quartz.core.JobRunShell.run(JobRunShell.java:191)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[kevinr]

Stop the server, delete the alfresco schema, recreate the alfresco schema and delete the alf_data directory. Then start the server again - does this help?

Thanks,

Kevin

[dumpsterkitty]

Thank you, but I'm afraid it ends up the same when I try it.

[rdanner]

Thank you, but I'm afraid it ends up the same when I try it.

Can you check this file for me?

{YOUR TOMCAT}\shared\classes\alfresco\extension\custom-hibernate-dialect.properties


Make sure the following line is commented out
#
# HSQL dialect
#
#hibernate.dialect=org.hibernate.dialect.HSQLDialect

And the following comment line is removed
#
# MySQL dialect (default)
#
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect