topic error at first start up in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-at-first-start-up/m-p/58521#M35807 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>I deployed the war file and when i tried to run it i got the error</SPAN><BR /><BR /><SPAN>—————————————————————————————————-</SPAN><BR /><SPAN>org.alfresco.error.AlfrescoRuntimeException: Failed to authenticate as Guest user.</SPAN><BR /><SPAN>caused by:</SPAN><BR /><SPAN>org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not initialize a collection: [org.alfresco.repo.domain.hibernate.NodeImpl.parentAssocs#24]; bad SQL grammar [select parentasso0_.child_node_id as child3_1_, parentasso0_.id as id1_, parentasso0_.id as id4_0_, parentasso0_.parent_node_id as parent2_4_0_, parentasso0_.child_node_id as child3_4_0_, parentasso0_.type_qname as type4_4_0_, parentasso0_.qname as qname4_0_, parentasso0_.child_node_name as child6_4_0_, parentasso0_.child_node_name_crc as child7_4_0_, parentasso0_.is_primary as is8_4_0_, parentasso0_.assoc_index as assoc9_4_0_ from alf_child_assoc parentasso0_ where parentasso0_.child_node_id=?]; nested exception is java.sql.SQLException: Table 'alfresco.alf_child_assoc' doesn't exist</SPAN><BR /><SPAN>caused by:</SPAN><BR /><SPAN>java.sql.SQLException: Table 'alfresco.alf_child_assoc' doesn't exist</SPAN><BR /><SPAN>—————————————————————————————————-</SPAN><BR /><BR /><SPAN>Here is the detail of the error</SPAN><BR /><BR /><SPAN>—————————————————————————————————-</SPAN><BR /><BR /><SPAN>org.alfresco.error.AlfrescoRuntimeException: Failed to authenticate as Guest user.</SPAN><BR /><SPAN>at org.alfresco.web.app.servlet.AuthenticationHelper.authenticate(AuthenticationHelper.java:209)</SPAN><BR /><SPAN>at org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:67)</SPAN><BR /><SPAN>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)</SPAN><BR /><SPAN>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)</SPAN><BR /><SPAN>at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)</SPAN><BR /><SPAN>at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)</SPAN><BR /><SPAN>at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)</SPAN><BR /><SPAN>at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)</SPAN><BR /><SPAN>at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)</SPAN><BR /><SPAN>at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)</SPAN><BR /><SPAN>at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)</SPAN><BR /><SPAN>at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)</SPAN><BR /><SPAN>at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)</SPAN><BR /><SPAN>at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)</SPAN><BR /><SPAN>at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)</SPAN><BR /><SPAN>at java.lang.Thread.run(Thread.java:595)</SPAN><BR /><SPAN>Caused by: org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not initialize a collection: [org.alfresco.repo.domain.hibernate.NodeImpl.parentAssocs#24]; bad SQL grammar [select parentasso0_.child_node_id as child3_1_, parentasso0_.id as id1_, parentasso0_.id as id4_0_, parentasso0_.parent_node_id as parent2_4_0_, parentasso0_.child_node_id as child3_4_0_, parentasso0_.type_qname as type4_4_0_, parentasso0_.qname as qname4_0_, parentasso0_.child_node_name as child6_4_0_, parentasso0_.child_node_name_crc as child7_4_0_, parentasso0_.is_primary as is8_4_0_, parentasso0_.assoc_index as assoc9_4_0_ from alf_child_assoc parentasso0_ where parentasso0_.child_node_id=?]; nested exception is java.sql.SQLException: Table 'alfresco.alf_child_assoc' doesn't exist</SPAN><BR /><SPAN>at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:223)</SPAN><BR /><SPAN>at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)</SPAN><BR /><SPAN>at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:411)</SPAN><BR /><SPAN>at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:370)</SPAN><BR /><SPAN>at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:445)</SPAN><BR /><SPAN>at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:439)</SPAN><BR /><SPAN>at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getNodeStatus(HibernateNodeDaoServiceImpl.java:316)</SPAN><BR /><SPAN>at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getNode(HibernateNodeDaoServiceImpl.java:406)</SPAN><BR /><SPAN>at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source)</SPAN><BR /><SPAN>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)</SPAN><BR /><SPAN>at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)</SPAN><BR /><SPAN>at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)</SPAN><BR /><SPAN>at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:60)</SPAN><BR /><SPAN>at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)</SPAN><BR /><SPAN>at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)</SPAN><BR /><SPAN>at $Proxy1.getNode(Unknown Source)</SPAN><BR /><SPAN>at org.alfresco.repo.node.db.DbNodeServiceImpl.exists(DbNodeServiceImpl.java:136)</SPAN><BR /><SPAN>at sun.reflect.GeneratedMethodAccessor124.invoke(Unknown Source)</SPAN><BR /><SPAN>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:213)</SPAN><BR /><SPAN>at $Proxy2.exists(Unknown Source)</SPAN><BR /><SPAN>at org.alfresco.repo.security.person.PersonServiceImpl.getPersonOrNull(PersonServiceImpl.java:149)</SPAN><BR /><SPAN>at org.alfresco.repo.security.person.PersonServiceImpl.getPerson(PersonServiceImpl.java:104)</SPAN><BR /><SPAN>at org.alfresco.web.app.servlet.AuthenticationHelper.authenticate(AuthenticationHelper.java:165)</SPAN><BR /><SPAN>… 15 more</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: Table 'alfresco.alf_child_assoc' doesn't exist</SPAN><BR /><SPAN>at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)</SPAN><BR /><SPAN>at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)</SPAN><BR /><SPAN>at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)</SPAN><BR /><SPAN>at com.mysql.jdbc.Connection.execSQL(Connection.java:3004)</SPAN><BR /><SPAN>at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1128)</SPAN><BR /><SPAN>at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1222)</SPAN><BR /><SPAN>at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)</SPAN><BR /><SPAN>at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)</SPAN><BR /><SPAN>at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)</SPAN><BR /><SPAN>at org.hibernate.loader.Loader.doQuery(Loader.java:662)</SPAN><BR /><SPAN>at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)</SPAN><BR /><SPAN>at org.hibernate.loader.Loader.loadCollection(Loader.java:1919)</SPAN><BR /><SPAN>at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)</SPAN><BR /><SPAN>at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:520)</SPAN><BR /><SPAN>at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)</SPAN><BR /><SPAN>at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1676)</SPAN><BR /><SPAN>at org.hibernate.collection.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:454)</SPAN><BR /><SPAN>at org.hibernate.engine.StatefulPersistenceContext.initializeNonLazyCollections(StatefulPersistenceContext.java:755)</SPAN><BR /><SPAN>at org.hibernate.event.def.DefaultLoadEventListener.assembleCacheEntry(DefaultLoadEventListener.java:547)</SPAN><BR /><SPAN>at org.hibernate.event.def.DefaultLoadEventListener.loadFromSecondLevelCache(DefaultLoadEventListener.java:474)</SPAN><BR /><SPAN>at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:328)</SPAN><BR /><SPAN>at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:123)</SPAN><BR /><SPAN>at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:177)</SPAN><BR /><SPAN>at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:87)</SPAN><BR /><SPAN>at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:862)</SPAN><BR /><SPAN>at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:830)</SPAN><BR /><SPAN>at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:266)</SPAN><BR /><SPAN>at org.hibernate.type.ManyToOneType.assemble(ManyToOneType.java:177)</SPAN><BR /><SPAN>at org.hibernate.type.TypeFactory.assemble(TypeFactory.java:398)</SPAN><BR /><SPAN>at org.hibernate.cache.entry.CacheEntry.assemble(CacheEntry.java:96)</SPAN><BR /><SPAN>at org.hibernate.cache.entry.CacheEntry.assemble(CacheEntry.java:82)</SPAN><BR /><SPAN>at org.hibernate.event.def.DefaultLoadEventListener.assembleCacheEntry(DefaultLoadEventListener.java:520)</SPAN><BR /><SPAN>at org.hibernate.event.def.DefaultLoadEventListener.loadFromSecondLevelCache(DefaultLoadEventListener.java:474)</SPAN><BR /><SPAN>at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:328)</SPAN><BR /><SPAN>at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:123)</SPAN><BR /><SPAN>at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:177)</SPAN><BR /><SPAN>at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:87)</SPAN><BR /><SPAN>at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:862)</SPAN><BR /><SPAN>at org.hibernate.impl.SessionImpl.get(SessionImpl.java:799)</SPAN><BR /><SPAN>at org.hibernate.impl.SessionImpl.get(SessionImpl.java:792)</SPAN><BR /><SPAN>at org.springframework.orm.hibernate3.HibernateTemplate$1.doInHibernate(HibernateTemplate.java:451)</SPAN><BR /><SPAN>at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:365)</SPAN><BR /><SPAN>… 38 more</SPAN><BR /><SPAN>————————————————————————————————–</SPAN><BR /><BR /><SPAN>Can any body tell me why i got this error and&nbsp; how can i make this application run?</SPAN><BR /><BR /><SPAN>Thanks and Regards</SPAN><BR /><SPAN>Tushar</SPAN></BODY></HTML> Wed, 27 Sep 2006 12:24:12 GMT gandotratushar 2006-09-27T12:24:12Z error at first start up https://connect.hyland.com/t5/alfresco-archive/error-at-first-start-up/m-p/58521#M35807 HiI deployed the war file and when i tried to run it i got the error—————————————————————————————————-org.alfresco.error.AlfrescoRuntimeException: Failed to authenticate as Guest user.caused by<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not initialize a collection: [ Wed, 27 Sep 2006 12:24:12 GMT https://connect.hyland.com/t5/alfresco-archive/error-at-first-start-up/m-p/58521#M35807 gandotratushar 2006-09-27T12:24:12Z Re: error at first start up https://connect.hyland.com/t5/alfresco-archive/error-at-first-start-up/m-p/58522#M35808 <HTML><HEAD></HEAD><BODY><SPAN>I'm a newbie, too. But looks like alfresco.alf_child_assoc' doesn't exist&nbsp; :wink: </SPAN><BR /><BR /><SPAN>Have you setup alfresco database properly?</SPAN><BR /><BR /><SPAN>Perhaps it might help in dropping and re-installing the 'alfresco' database.</SPAN></BODY></HTML> Thu, 28 Sep 2006 19:54:27 GMT https://connect.hyland.com/t5/alfresco-archive/error-at-first-start-up/m-p/58522#M35808 czaveri 2006-09-28T19:54:27Z Re: error at first start up https://connect.hyland.com/t5/alfresco-archive/error-at-first-start-up/m-p/58523#M35809 <HTML><HEAD></HEAD><BODY><SPAN>this is the first thing i checked. The script to create the database is just to create the database only not the tables. Tables are created by hibernate ans springs working in the war file. So this is not a problem…I think this is some other issue with the war file!!!</SPAN></BODY></HTML> Fri, 29 Sep 2006 05:11:11 GMT https://connect.hyland.com/t5/alfresco-archive/error-at-first-start-up/m-p/58523#M35809 gandotratushar 2006-09-29T05:11:11Z