Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Hyland Connect
- Enterprise Platforms
- Alfresco
- Alfresco Archive
- SQL grammar/WAR deployment error on Win/MySQL bund...
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
SQL grammar/WAR deployment error on Win/MySQL bundle install
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-01-2007 03:58 PM
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.
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)
Labels:
- Labels:
-
Archive
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-02-2007 04:17 AM
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
Thanks,
Kevin
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-02-2007 11:23 AM
Thank you, but I'm afraid it ends up the same when I try it.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-04-2007 01:39 AM
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
Related Content
- Alfresco Community Edition 23.4 Release Notes in Alfresco Blog
- System Administrator error in Alfresco Forum
- Alfresco Dockerfiles Bakery: Streamlining Container Builds for Alfresco Products in Alfresco Blog
- How to create doclib with custom T-Engine in Alfresco Forum
- Something's wrong with this page...When login share in Alfresco Forum
Getting started
Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.
