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
- Content Management
- Alfresco
- Alfresco Archive
- Re: Problem in using mysql+alfresco
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
Problem in using mysql+alfresco
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-27-2009 06:06 AM
Hi team, from the last few days i'm facing a problem with configuring the mysql with alfresco.
Environment:
OS: windows XP professional edition
Alfresco: 3.0 labs stable version
My SQL: mysql-essential-5.0.18-win32
what i have done is, i installed My SQL sucessfully in my local machine.
custom-repository.properties
i kept mysql-connector-java-5.1.6-bin.jar as it is in tomcat/lib.
and even tried db.driver=com.mysql.jdbc.Driver and db.url=jdbc:mysql://localhost:3306/alfresco in custom-repository.properties.
custom-hibernate-dialect.properties
even i tried with hibernate.dialect=org.hibernate.dialect.MySQLDialect
NOTE: even i tired this jar mysql-connector-java-3.1.6-bin.jar and removed the existing jar and viceversa and i intslled alfresco and mysql in C:\ drive and still there is 3 gb free space avaiable in this drive.
But still no luck. any compatible issues.
any help is appriciated.
Environment:
OS: windows XP professional edition
Alfresco: 3.0 labs stable version
My SQL: mysql-essential-5.0.18-win32
what i have done is, i installed My SQL sucessfully in my local machine.
custom-repository.properties
db.driver=org.gjt.mm.mysql.Driver
#db.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://localhost:3306/alfrescoi kept mysql-connector-java-5.1.6-bin.jar as it is in tomcat/lib.
and even tried db.driver=com.mysql.jdbc.Driver and db.url=jdbc:mysql://localhost:3306/alfresco in custom-repository.properties.
custom-hibernate-dialect.properties
#
# MySQL dialect (default)
#
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
#hibernate.dialect=org.hibernate.dialect.MySQLDialecteven i tried with hibernate.dialect=org.hibernate.dialect.MySQLDialect
NOTE: even i tired this jar mysql-connector-java-3.1.6-bin.jar and removed the existing jar and viceversa and i intslled alfresco and mysql in C:\ drive and still there is 3 gb free space avaiable in this drive.
But still no luck. any compatible issues.
15:28:16,493 INFO [config.xml.XMLConfigService$PropertyConfigurer] Loading pro
perties file from class path resource [alfresco/file-servers.properties]
15:28:50,551 INFO [domain.schema.SchemaBootstrap] Schema managed by database d
ialect org.hibernate.dialect.MySQLInnoDBDialect.
15:28:56,443 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
org.hibernate.exception.GenericJDBCException: could not get table metadata: alf_
audit_fact
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException
(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:29)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(Database
Metadata.java:105)
at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configurat
ion.java:954)
at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBo
otstrap.java:649)
at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBoo
tstrap.java:1123)
at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLi
fecycleBean.java:62)
at org.springframework.context.event.SimpleApplicationEventMulticaster$1
.run(SimpleApplicationEventMulticaster.java:77)
at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecut
or.java:49)
at org.springframework.context.event.SimpleApplicationEventMulticaster.m
ulticastEvent(SimpleApplicationEventMulticaster.java:75)
at org.springframework.context.support.AbstractApplicationContext.publis
hEvent(AbstractApplicationContext.java:246)
at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:355)
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: java.sql.SQLException: Can't create/write to file 'C:\WINDOWS\TEMP\#s
ql_f0c_0.MYD' (Errcode: 17)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1625)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2291)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2226)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1159)
at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:890)
at org.hibernate.tool.hbm2ddl.TableMetadata.initColumns(TableMetadata.ja
va:146)
at org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:32
)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(Database
Metadata.java:90)
… 36 more
15:28:56,459 ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed
at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBoo
tstrap.java:1192)
at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLi
fecycleBean.java:62)
at org.springframework.context.event.SimpleApplicationEventMulticaster$1
.run(SimpleApplicationEventMulticaster.java:77)
at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecut
or.java:49)
at org.springframework.context.event.SimpleApplicationEventMulticaster.m
ulticastEvent(SimpleApplicationEventMulticaster.java:75)
at org.springframework.context.support.AbstractApplicationContext.publis
hEvent(AbstractApplicationContext.java:246)
at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:355)
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: org.hibernate.exception.GenericJDBCException: could not get table met
adata: alf_audit_fact
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException
(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:29)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(Database
Metadata.java:105)
at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configurat
ion.java:954)
at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBo
otstrap.java:649)
at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBoo
tstrap.java:1123)
… 33 moreany help is appriciated.
Labels:
- Labels:
-
Archive
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-27-2009 06:31 AM
I think this is causing the problem.
How to cross this?
Caused by: java.sql.SQLException: Can't create/write to file 'C:\WINDOWS\TEMP\#s
ql_f0c_0.MYD' (Errcode: 17)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1625)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2291)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2226)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1159How to cross this?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-27-2009 06:51 AM
Disable your McAfee (or other) virus scanner for .myd and .myi files.
Mike
Mike
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-27-2009 08:18 AM
Hi mike,
thanks for your quick reply.
Yes, you are right.
After disabling the McAfee the previous error was gone.
And there was some column lenght problem in a table.
the following error i'm getting now.
thanks for your quick reply.
Yes, you are right.
After disabling the McAfee the previous error was gone.
And there was some column lenght problem in a table.
the following error i'm getting now.
17:49:45,096 INFO [config.xml.XMLConfigService$PropertyConfigurer] Loading pro
perties file from class path resource [alfresco/file-servers.properties]
17:50:18,373 INFO [domain.schema.SchemaBootstrap] Schema managed by database d
ialect org.hibernate.dialect.MySQLInnoDBDialect.
17:50:22,077 INFO [domain.schema.SchemaBootstrap] No changes were made to the
schema.
17:51:10,359 User:System ERROR [web.context.ContextLoader] Context initializatio
n failed
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed
at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootst
rap.java:351)
at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBoot
strap.java:702)
at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLi
fecycleBean.java:62)
at org.springframework.context.event.SimpleApplicationEventMulticaster$1
.run(SimpleApplicationEventMulticaster.java:77)
at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecut
or.java:49)
at org.springframework.context.event.SimpleApplicationEventMulticaster.m
ulticastEvent(SimpleApplicationEventMulticaster.java:75)
at org.springframework.context.support.AbstractApplicationContext.publis
hEvent(AbstractApplicationContext.java:246)
at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:355)
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: org.springframework.dao.InvalidDataAccessResourceUsageException: coul
d not insert: [org.alfresco.repo.domain.hibernate.NodeImpl]; nested exception is
org.hibernate.exception.DataException: could not insert: [org.alfresco.repo.dom
ain.hibernate.NodeImpl]
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHiberna
teAccessException(SessionFactoryUtils.java:616)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernate
AccessException(HibernateAccessor.java:412)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:377)
at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTe
mplate.java:632)
at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.newNo
de(HibernateNodeDaoServiceImpl.java:859)
at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.creat
eStore(HibernateNodeDaoServiceImpl.java:635)
at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)
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:296)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:177)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:144)
at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(Tran
sactionalDaoInterceptor.java:68)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:166)
at org.alfresco.repo.domain.hibernate.DirtySessionMethodInterceptor.invo
ke(DirtySessionMethodInterceptor.java:381)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:166)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
at $Proxy2.createStore(Unknown Source)
at org.alfresco.repo.node.db.DbNodeServiceImpl.createStore(DbNodeService
Impl.java:214)
at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)
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:296)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:177)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:144)
at org.alfresco.repo.transaction.SingleEntryTransactionResourceIntercept
or.invokeInternal(SingleEntryTransactionResourceInterceptor.java:163)
at org.alfresco.repo.transaction.SingleEntryTransactionResourceIntercept
or.invoke(SingleEntryTransactionResourceInterceptor.java:138)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:166)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
at $Proxy7.createStore(Unknown Source)
at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)
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:296)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:177)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:144)
at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNo
deServiceInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:166)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
at $Proxy7.createStore(Unknown Source)
at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)
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:221)
at $Proxy8.createStore(Unknown Source)
at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)
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:296)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:177)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:144)
at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterce
ptor.java:306)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:166)
at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterce
ptor.java:306)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:166)
at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRe
fPropertyMethodInterceptor.java:274)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:166)
at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRe
fPropertyMethodInterceptor.java:274)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:166)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
at $Proxy7.createStore(Unknown Source)
at org.alfresco.repo.importer.ImporterBootstrap.doImport(ImporterBootstr
ap.java:376)
at org.alfresco.repo.importer.ImporterBootstrap.access$000(ImporterBoots
trap.java:72)
at org.alfresco.repo.importer.ImporterBootstrap$1$1.execute(ImporterBoot
strap.java:340)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransacti
on(RetryingTransactionHelper.java:320)
at org.alfresco.repo.importer.ImporterBootstrap$1.doWork(ImporterBootstr
ap.java:344)
at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(Au
thenticationUtil.java:437)
at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootst
rap.java:347)
… 34 more
Caused by: org.hibernate.exception.DataException: could not insert: [org.alfresc
o.repo.domain.hibernate.NodeImpl]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:77)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(Abstr
actReturningDelegate.java:40)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
tEntityPersister.java:2163)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
tEntityPersister.java:2643)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentit
yInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:322)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplic
ate(AbstractSaveEventListener.java:298)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(Abstrac
tSaveEventListener.java:181)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId
(AbstractSaveEventListener.java:107)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGene
ratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrR
equestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTran
sient(DefaultSaveOrUpdateEventListener.java:172)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(
DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpda
te(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
at org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate
(HibernateTemplate.java:635)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:372)
… 99 more
Caused by: java.sql.SQLException: Data too long for column 'node_deleted' at row
1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1625)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2226)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1812)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1906)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1831)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1693)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Del
egatingPreparedStatement.java:101)
at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAn
dExtract(IdentityGenerator.java:73)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(Abstr
actReturningDelegate.java:33)
… 116 more
Jul 27, 2009 5:51:10 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Jul 27, 2009 5:51:10 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.
Jul 27, 2009 5:51:17 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive share.war
17:51:40,870 INFO [web.site.FrameworkHelper] Successfully Initialized Web Fram
ework
Jul 27, 2009 5:51:41 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive studio.war
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-27-2009 09:02 AM
even i tried with a new (version) jar mysql-connector-java-5.1.7-bin.jar
but still no luck.
but still no luck.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-28-2009 01:05 AM
Hi team,
can anyone suggest me what is the solution for this problem?
can anyone suggest me what is the solution for this problem?
Related Content
- Alfresco Content Services cannot update atributes changing on Identity Service in Alfresco Forum
- Alfresco Developer Resources in Alfresco Blog
- Feedback - Could not refresh JMS Connection fo r destination 'acs-repo-transform-request' in Alfresco Forum
- Alfresco ansible setup issues !! in Alfresco Forum
- SOLR is still restarting 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.
