AnsweredAssumed Answered

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

Question asked by dumpsterkitty on Feb 1, 2007
Latest reply on Feb 4, 2007 by rdanner
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 doBody
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Mer
ger mergeIndexes
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Mer
ger mergeDeletions
Feb 1, 2007 3:43:06 PM org.apache.catalina.core.AprLifecycleListener lifecycleEv
ent
INFO: The Apache Portable Runtime which allows optimal performance in production
environments was not found on the java.library.path: C:\Program Files\Alfresco
ECMS Community Network\java\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Program File
s\Alfresco ECMS Community Network\java/bin;C:\Program Files\Alfresco ECMS Commun
ity 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:\Progr
am Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\s
ystem32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\QuickTime\QTSystem\
;"C:\Program Files\Zone Labs\ZoneAlarm\MailFrontier";C:\Program Files\Microsoft
SQL 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 Stu
dio 8\Common7\IDE\PrivateAssemblies\;C:\Program Files\MySQL\MySQL Server 4.1\bin

Feb 1, 2007 3:43:07 PM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Feb 1, 2007 3:43:07 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 4727 ms
Feb 1, 2007 3:43:07 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Feb 1, 2007 3:43:07 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.12
Feb 1, 2007 3:43:07 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Feb 1, 2007 3:43:15 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive alfresco.war
15:46:11,599 ERROR [quartz.core.JobRunShell] Job DEFAULT.org.springframework.sch
eduling.quartz.JobDetailBean#5bf624 threw an unhandled 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
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'alfresco.alf_node_st
atus' 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.ja
va:1149)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
1262)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.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(Lo
ader.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.ja
va: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.j
ava:749)
        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl$13.do
InHibernate(HibernateNodeDaoServiceImpl.java:1031)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:365)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:333)
        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getLa
stTxn(HibernateNodeDaoServiceImpl.java:1034)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:335)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:181)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:148)
        at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(Tran
sactionalDaoInterceptor.java:60)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:170)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:176)
        at $Proxy1.getLastTxn(Unknown Source)
        at org.alfresco.repo.node.index.FullIndexRecoveryComponent.reindexImpl(F
ullIndexRecoveryComponent.java:120)
        at org.alfresco.repo.node.index.AbstractReindexComponent$1.doWork(Abstra
ctReindexComponent.java:209)
        at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(Tr
ansactionUtil.java:168)
        at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransactio
n(TransactionUtil.java:74)
        at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(Abstrac
tReindexComponent.java:213)
        at org.alfresco.repo.node.index.IndexRecoveryJob.execute(IndexRecoveryJo
b.java:31)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:191)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:516)
15:46:11,609 ERROR [quartz.core.ErrorLogger] Job (DEFAULT.org.springframework.sc
heduling.quartz.JobDetailBean#5bf624 threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exc
eption: org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: co
uld 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 nod
estatus0_.transaction_id=transactio1_.id]; nested exception is com.mysql.jdbc.ex
ceptions.MySQLSyntaxErrorException: Table 'alfresco.alf_node_status' doesn't exi
st]
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:516)
* Nested Exception (Underlying Cause) —————
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
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'alfresco.alf_node_st
atus' 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.ja
va:1149)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
1262)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.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(Lo
ader.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.ja
va: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.j
ava:749)
        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl$13.do
InHibernate(HibernateNodeDaoServiceImpl.java:1031)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:365)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:333)
        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getLa
stTxn(HibernateNodeDaoServiceImpl.java:1034)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:335)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:181)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:148)
        at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(Tran
sactionalDaoInterceptor.java:60)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:170)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:176)
        at $Proxy1.getLastTxn(Unknown Source)
        at org.alfresco.repo.node.index.FullIndexRecoveryComponent.reindexImpl(F
ullIndexRecoveryComponent.java:120)
        at org.alfresco.repo.node.index.AbstractReindexComponent$1.doWork(Abstra
ctReindexComponent.java:209)
        at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(Tr
ansactionUtil.java:168)
        at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransactio
n(TransactionUtil.java:74)
        at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(Abstrac
tReindexComponent.java:213)
        at org.alfresco.repo.node.index.IndexRecoveryJob.execute(IndexRecoveryJo
b.java:31)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:191)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:516)
15:50:11,083 ERROR [quartz.core.JobRunShell] Job DEFAULT.org.springframework.sch
eduling.quartz.JobDetailBean#1972e3a threw an unhandled Exception:
org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not
execute query; bad SQL grammar [select storeimpl0_.protocol as protocol6_, store
impl0_.identifier as identifier6_, storeimpl0_.root_node_id as root3_6_ from alf
_store storeimpl0_]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxEr
rorException: Table 'alfresco.alf_store' doesn't exist
com.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.ja
va:1149)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
1262)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.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(Lo
ader.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.ja
va: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.doI
nHibernate(HibernateNodeDaoServiceImpl.java:263)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:365)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:333)
        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getSt
ores(HibernateNodeDaoServiceImpl.java:266)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:335)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:181)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:148)
        at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(Tran
sactionalDaoInterceptor.java:60)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:170)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:176)
        at $Proxy1.getStores(Unknown Source)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.getStores(DbNodeServiceIm
pl.java:161)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvoc
ationHandler.invoke(StoreRedirectorProxyFactory.java:213)
        at $Proxy2.getStores(Unknown Source)
        at org.alfresco.repo.node.index.MissingContentReindexComponent.reindexIm
pl(MissingContentReindexComponent.java:56)
        at org.alfresco.repo.node.index.AbstractReindexComponent$1.doWork(Abstra
ctReindexComponent.java:209)
        at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(Tr
ansactionUtil.java:168)
        at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransactio
n(TransactionUtil.java:74)
        at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(Abstrac
tReindexComponent.java:213)
        at org.alfresco.repo.node.index.IndexRecoveryJob.execute(IndexRecoveryJo
b.java:31)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:191)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:516)
15:50:11,093 ERROR [quartz.core.ErrorLogger] Job (DEFAULT.org.springframework.sc
heduling.quartz.JobDetailBean#1972e3a threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exc
eption: org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: co
uld 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.MySQL
SyntaxErrorException: Table 'alfresco.alf_store' doesn't exist]
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:516)
* Nested Exception (Underlying Cause) —————
org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not
execute query; bad SQL grammar [select storeimpl0_.protocol as protocol6_, store
impl0_.identifier as identifier6_, storeimpl0_.root_node_id as root3_6_ from alf
_store storeimpl0_]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxEr
rorException: Table 'alfresco.alf_store' doesn't exist
com.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.ja
va:1149)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
1262)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.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(Lo
ader.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.ja
va: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.doI
nHibernate(HibernateNodeDaoServiceImpl.java:263)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:365)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:333)
        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getSt
ores(HibernateNodeDaoServiceImpl.java:266)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:335)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:181)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:148)
        at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(Tran
sactionalDaoInterceptor.java:60)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:170)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:176)
        at $Proxy1.getStores(Unknown Source)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.getStores(DbNodeServiceIm
pl.java:161)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvoc
ationHandler.invoke(StoreRedirectorProxyFactory.java:213)
        at $Proxy2.getStores(Unknown Source)
        at org.alfresco.repo.node.index.MissingContentReindexComponent.reindexIm
pl(MissingContentReindexComponent.java:56)
        at org.alfresco.repo.node.index.AbstractReindexComponent$1.doWork(Abstra
ctReindexComponent.java:209)
        at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(Tr
ansactionUtil.java:168)
        at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransactio
n(TransactionUtil.java:74)
        at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(Abstrac
tReindexComponent.java:213)
        at org.alfresco.repo.node.index.IndexRecoveryJob.execute(IndexRecoveryJo
b.java:31)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:191)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:516)

Outcomes