Unable to find files

[archana_bonkanp]

Hi,

I uploaded some files into a folder long back.
suddenly a exception occured and im unable to view anyone of the files present in that folder.

The following error occured and no files were visible in that folder ,but we are able to open folder.

ERROR [ui.common.Utils] A system error happened during the operation: Non-root node has no primary parent:
   child: workspace://SpacesStore/7c0d7864-9ad2-11dd-9914-d3602a71a469
org.springframework.dao.DataIntegrityViolationException: Non-root node has no pr
imary parent:
   child: workspace://SpacesStore/7c0d7864-9ad2-11dd-9914-d3602a71a469
        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getPa
rentAssocs(HibernateNodeDaoServiceImpl.java:1079)
        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getPr
imaryParentAssoc(HibernateNodeDaoServiceImpl.java:1101)
        at sun.reflect.GeneratedMethodAccessor243.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:281)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:187)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:154)
        at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(Tran
sactionalDaoInterceptor.java:68)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:210)
        at $Proxy1.getPrimaryParentAssoc(Unknown Source)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.getPrimaryParent(DbNodeSe
rviceImpl.java:1244)
        at sun.reflect.GeneratedMethodAccessor169.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:281)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:187)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:154)
        at org.alfresco.repo.transaction.TransactionResourceInterceptor.invoke(T
ransactionResourceInterceptor.java:138)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:210)
        at $Proxy2.getPrimaryParent(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor169.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 $Proxy3.getPrimaryParent(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor169.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:281)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:187)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:154)
        at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterce
ptor.java:211)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:210)
        at $Proxy2.getPrimaryParent(Unknown Source)
        at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl$Nod
eTest.evaluate(PermissionServiceImpl.java:744)
        at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl$Nod
eTest.evaluate(PermissionServiceImpl.java:733)
        at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl$Nod
eTest.evaluate(PermissionServiceImpl.java:670)
        at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl.has
Permission(PermissionServiceImpl.java:377)
        at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl.has
Permission(PermissionServiceImpl.java:564)
        at org.alfresco.repo.security.permissions.impl.acegi.ACLEntryAfterInvoca
tionProvider.decide(ACLEntryAfterInvocationProvider.java:577)
        at org.alfresco.repo.security.permissions.impl.acegi.ACLEntryAfterInvoca
tionProvider.decide(ACLEntryAfterInvocationProvider.java:224)
        at net.sf.acegisecurity.afterinvocation.AfterInvocationProviderManager.d
ecide(AfterInvocationProviderManager.java:107)
        at net.sf.acegisecurity.intercept.AbstractSecurityInterceptor.afterInvoc
ation(AbstractSecurityInterceptor.java:329)
        at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInter
ceptor.invoke(MethodSecurityInterceptor.java:82)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethod
Interceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
        at org.alfresco.repo.audit.AuditComponentImpl.auditImpl(AuditComponentIm
pl.java:256)
        at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.j
ava:191)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInte
rceptor.java:69)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:107)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:210)
        at $Proxy40.list(Unknown Source)
        at org.alfresco.web.bean.BrowseBean.queryBrowseNodes(BrowseBean.java:619
)
        at org.alfresco.web.bean.BrowseBean.getNodes(BrowseBean.java:431)
        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.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolv
erImpl.java:457)
        at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverI
mpl.java:85)
        at org.apache.myfaces.el.ELParserHelper$MyPropertySuffix.evaluate(ELPars
erHelper.java:535)
        at org.apache.commons.el.ComplexValue.evaluate(ComplexValue.java:145)
        at org.apache.myfaces.el.ValueBindingImpl.getValue(ValueBindingImpl.java
:386)
        at org.alfresco.web.ui.common.component.data.UIRichList.getValue(UIRichL
ist.java:154)
        at org.alfresco.web.ui.common.component.data.UIRichList.getDataModel(UIR
ichList.java:506)
        at org.alfresco.web.ui.common.component.data.UIRichList.bind(UIRichList.
java:449)
        at org.alfresco.web.ui.common.renderer.data.RichListRenderer.encodeChild
ren(RichListRenderer.java:83)
        at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.
java:527)
        at javax.faces.webapp.UIComponentTag.encodeChildren(UIComponentTag.java:
483)
        at javax.faces.webapp.UIComponentTag.doEndTag(UIComponentTag.java:364)
        at org.apache.jsp.jsp.browse.browse_jsp._jspx_meth_a_005frichList_005f0(
browse_jsp.java:2207)
        at org.apache.jsp.jsp.browse.browse_jsp._jspx_meth_a_005fpanel_005f5(bro
wse_jsp.java:2106)
        at org.apache.jsp.jsp.browse.browse_jsp._jspService(browse_jsp.java:831)

        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:328)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
15)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:691)
        at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applica
tionDispatcher.java:469)


16:44:25,237 ERROR [ui.common.Utils] A system error happened during the operatio
n: Non-root node has no primary parent:
   child: workspace://SpacesStore/7c0d7864-9ad2-11dd-9914-d3602a71a469
org.springframework.dao.DataIntegrityViolationException: Non-root node has no pr
imary parent:
   child: workspace://SpacesStore/7c0d7864-9ad2-11dd-9914-d3602a71a469
        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getPa
rentAssocs(HibernateNodeDaoServiceImpl.java:1079)
        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getPr
imaryParentAssoc(HibernateNodeDaoServiceImpl.java:1101)
        at sun.reflect.GeneratedMethodAccessor243.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:281)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:187)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:154)
        at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(Tran
sactionalDaoInterceptor.java:68)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:210)
        at $Proxy1.getPrimaryParentAssoc(Unknown Source)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.getPrimaryParent(DbNodeSe
rviceImpl.java:1244)
        at sun.reflect.GeneratedMethodAccessor169.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:281)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:187)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:154)
        at org.alfresco.repo.transaction.TransactionResourceInterceptor.invoke(T
ransactionResourceInterceptor.java:138)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:210)
        at $Proxy2.getPrimaryParent(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor169.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 $Proxy3.getPrimaryParent(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor169.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:281)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:187)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:154)
        at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterce
ptor.java:211)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:210)
        at $Proxy2.getPrimaryParent(Unknown Source)
        at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl$Nod
eTest.evaluate(PermissionServiceImpl.java:744)
        at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl$Nod
eTest.evaluate(PermissionServiceImpl.java:733)
        at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl$Nod
eTest.evaluate(PermissionServiceImpl.java:670)
        at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl.has
Permission(PermissionServiceImpl.java:377)
        at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl.has
Permission(PermissionServiceImpl.java:564)
        at org.alfresco.repo.security.permissions.impl.acegi.ACLEntryAfterInvoca
tionProvider.decide(ACLEntryAfterInvocationProvider.java:577)
        at org.alfresco.repo.security.permissions.impl.acegi.ACLEntryAfterInvoca
tionProvider.decide(ACLEntryAfterInvocationProvider.java:224)
        at net.sf.acegisecurity.afterinvocation.AfterInvocationProviderManager.d
ecide(AfterInvocationProviderManager.java:107)
        at net.sf.acegisecurity.intercept.AbstractSecurityInterceptor.afterInvoc
ation(AbstractSecurityInterceptor.java:329)
        at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInter
ceptor.invoke(MethodSecurityInterceptor.java:82)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethod
Interceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
        at org.alfresco.repo.audit.AuditComponentImpl.auditImpl(AuditComponentIm
pl.java:256)
        at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.j
ava:191)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInte
rceptor.java:69)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:107)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:210)
        at $Proxy40.list(Unknown Source)
        at org.alfresco.web.bean.BrowseBean.queryBrowseNodes(BrowseBean.java:619
)
        at org.alfresco.web.bean.BrowseBean.getNodes(BrowseBean.java:431)
        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.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolv
erImpl.java:457)
        at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverI
mpl.java:85)
        at org.apache.myfaces.el.ELParserHelper$MyPropertySuffix.evaluate(ELPars
erHelper.java:535)
        at org.apache.commons.el.ComplexValue.evaluate(ComplexValue.java:145)
        at org.apache.myfaces.el.ValueBindingImpl.getValue(ValueBindingImpl.java
:386)
        at org.alfresco.web.ui.common.component.data.UIRichList.getValue(UIRichL
ist.java:154)
        at org.alfresco.web.ui.common.component.data.UIRichList.getDataModel(UIR
ichList.java:506)
        at org.alfresco.web.ui.common.component.data.UIRichList.bind(UIRichList.
java:449)
        at org.alfresco.web.ui.common.renderer.data.RichListRenderer.encodeChild
ren(RichListRenderer.java:83)
        at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.
java:527)
        at javax.faces.webapp.UIComponentTag.encodeChildren(UIComponentTag.java:
483)
        at javax.faces.webapp.UIComponentTag.doEndTag(UIComponentTag.java:364)
        at org.apache.jsp.jsp.browse.browse_jsp._jspx_meth_a_005frichList_005f0(
browse_jsp.java:2207)
        at org.apache.jsp.jsp.browse.browse_jsp._jspx_meth_a_005fpanel_005f5(bro
wse_jsp.java:2106)
        at org.apache.jsp.jsp.browse.browse_jsp._jspService(browse_jsp.java:831)

        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:328)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
15)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:691)
        at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applica
tionDispatcher.java:469)
        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD
ispatcher.java:403)
        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis
patcher.java:301)
        at org.apache.myfaces.context.servlet.ServletExternalContextImpl.dispatc
h(ServletExternalContextImpl.java:419)
        at org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspV
iewHandlerImpl.java:211)
        at org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderRes
ponseExecutor.java:41)
        at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:
132)
        at javax.faces.webapp.FacesServlet.service(FacesServlet.java:140)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
        at org.alfresco.web.app.servlet.NTLMAuthenticationFilter.doFilter(NTLMAu
thenticationFilter.java:329)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:210)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:174)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:117)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:151)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:870)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:665)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:528)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:81)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:685)
        at java.lang.Thread.run(Thread.java:595)


Thanks & Regards,
Archana

[derek]

Hi,
What version are you running?  Can you check that your tables are all InnoDB tables.
Regards

[archana_bonkanp]

no there are MYISAM

[archana_bonkanp]

we are using Alfresco 2.1,
DB : MYSQL
running on  windows 2003 enterprise editon
the engine type for tables is MYISAM

[rogier_oudshoor]

I think you cannot run Alfresco on MYSQL-MYISAM tables, since MYISAM doesn't support DB transactions.

[archana_bonkanp]

currently we running with MYISAM
how to change it to INNODB.
Currently w eneed to change it on the production server,does it effect any data if we change it to INNODB.
We currently u[plaoded 30 GB of data in production environment

[derek]

Hi,

30GB of data and no support contract?  Clearly it's not a valuable 30GB, then.

Run

show table status;‍

against your alfresco database. The Engine column MUST be "InnoDB" for all tables.  If not, then virtually every rollback (and they can occur for many, many reasons) will be leaving corrupt data lying around.

You will need to:

Shut Alfresco down
Alter the tables (http://dev.mysql.com/doc/refman/5.1/en/alter-table.html)
Configure in the correct Hibernate dialect for InnoDB
Restore to a backup that didn't have the (blocking) data corruption

Then, plan to:

Upgrade to 2.1 Enterprise
Upgrade to 3.0

If data issues exist, it'll take a bit more effort to fix the corruption(s).  Usually, the upgrade scripts identify these nicely.

Regards