DB Error while starting

javauser007 — Tue, 21 Apr 2009 07:24:43 GMT

Hi friends,I'm using alfresco ecm 3.0… Whenever i try to restart the server i'm getting the following error.12:51:31,308 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failedorg.hibernate.exception.GenericJDBCException: could not get table metadata: JBPM_VARIABLEINSTANCE at org.hib

Re: DB Error while starting

mrogers — Tue, 21 Apr 2009 07:34:08 GMT

Can't create/write to file 'C:\WINDOWS\TEMP\#sql_298_0.MYI' (Errcode: 17)

You have database problems. Are you out of disk space? And does the database have permissions to access the filesystem.

Re: DB Error while starting

javauser007 — Tue, 21 Apr 2009 09:33:36 GMT

Hi Mrogers,
Thanks for ur reply..
Yes i'm having enough memory (i.e nearly 2GB)in my 'C' drive where i installed my Alfresco and mysql.
And even i'm having nearly 1.5 GB of free space in 'D' drive as well.
But I don't know about the file access permissions to the Data Base.. But i'm having the Administration permissions on my machine.

Can u explain more about this…

thaks again for ur support.

Re: DB Error while starting

mrogers — Tue, 21 Apr 2009 10:13:00 GMT

2GB of free disk space may not be enough to run your O.S. let alone a database! Try to free up some more disk space.

Re: DB Error while starting

mikeh — Tue, 21 Apr 2009 10:40:38 GMT

The other reason for this error is if an anti-virus app is interfering with MySQL's file access - try disabling it.

Mike

Re: DB Error while starting

javauser007 — Tue, 21 Apr 2009 13:38:02 GMT

Hi mike,
I disabled the fire wall and increased the c-drive space upto 3GB. and maded some changes in the following files.

1)c:\Program Files\Alfresco\tomcat\shared\classes\alfresco\extension\custom-repository.properties

#
# MySQL connection
#
#db.driver=org.gjt.mm.mysql.Driver
#newly added
db.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://localhost:3306/alfresco

2)c:\Program Files\Alfresco\tomcat\shared\classes\alfresco\extension\custom-hibernate-dialect.properties

#
# MySQL dialect (default)
#
#hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

#newly added
hibernate.dialect=org.hibernate.dialect.MySQLDialect

and i'm using the my sql version 5.0.18 and i placed the following jar file in the following directory.

C:\Program Files\Alfresco\tomcat\lib

mysql-connector-java-3.1.12-bin.jar

and i have restarted my server but still i'm getting the following error.

Caused by: org.springframework.beans.factory.BeanCreationException: Error creati
ng bean with name 'sqlMapClient' defined in file [C:\Program Files\Alfresco\tomc
at\shared\classes\alfresco\extension\custom-activities-feed-context.xml]: Invoca
tion of init method failed; nested exception is java.lang.RuntimeException: Erro
r occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.
Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.
Cause: java.io.IOException: Could not find resource alfresco/activities/org.hibe
rnate.dialect.MySQLDialect/ActivityPost.xml
Caused by: java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common
.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Er
ror parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not
 find resource alfresco/activities/org.hibernate.dialect.MySQLDialect/ActivityPo
st.xml
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapC
onfigParser.java:109)
        at com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMap
ClientBuilder.java:90)
        at org.springframework.orm.ibatis.SqlMapClientFactoryBean.buildSqlMapCli
ent(SqlMapClientFactoryBean.java:326)
        at org.springframework.orm.ibatis.SqlMapClientFactoryBean.afterPropertie
sSet(SqlMapClientFactoryBean.java:280)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1201)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1171)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:425)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:251)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:156)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:248)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:160)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:261)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:861)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:421)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:251)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:156)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:248)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:160)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:261)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:861)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:421)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:251)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:156)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:248)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:160)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.
preInstantiateSingletons(DefaultListableBeanFactory.java:287)
        at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:352)
        at org.springframework.web.context.ContextLoader.createWebApplicationCon
text(ContextLoader.java:244)
        at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:187)
        at org.springframework.web.context.ContextLoaderListener.contextInitiali
zed(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3843)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
342)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77
1)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)

        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)

        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719
)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490
)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:117)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
)
        at org.apache.catalina.core.StandardService.start(StandardService.java:5
16)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710
)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
        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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: ja
va.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: ja
va.io.IOException: Could not find resource alfresco/activities/org.hibernate.dia
lect.MySQLDialect/ActivityPost.xml
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:62)
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapC
onfigParser.java:106)
        … 57 more
Caused by: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap
'.  Cause: java.io.IOException: Could not find resource alfresco/activities/org.
hibernate.dialect.MySQLDialect/ActivityPost.xml
        at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java
:123)
        at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:84)
        at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102)
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:72)
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:60)
        … 58 more
Caused by: java.io.IOException: Could not find resource alfresco/activities/org.
hibernate.dialect.MySQLDialect/ActivityPost.xml
        at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.j
ava:108)
        at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.j
ava:93)
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$11.process(Sq
lMapConfigParser.java:383)
        at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java
:121)
        … 62 more
Apr 21, 2009 7:04:24 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Apr 21, 2009 7:04:24 PM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class
 reloading, using NOPLoggerRepository.
Apr 21, 2009 7:04:28 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive share.war
19:04:41,160  INFO  [web.site.FrameworkHelper] Successfully Initialized Web Fram
ework
Apr 21, 2009 7:04:42 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Apr 21, 2009 7:04:42 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 97303 ms‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

i'm using alfresco Alfresco-Enterprise-3.0.0-Full-Setup

But don't know the problem.
thanks in advane for ur support.

topic Re: DB Error while starting in Alfresco Archive

DB Error while starting

Re: DB Error while starting

Re: DB Error while starting

Re: DB Error while starting

Re: DB Error while starting

Re: DB Error while starting