Page 1 of 1
Import documents error
PostPosted:Wed Feb 15, 2017 7:13 pm
by openkm_user
Hi,
We have kicked off a batch of documents (approximately 750000 documents) for importing (we are still trying to figure out jillort's other idea on mass importing documents). While this is going on document import died and returned with the following error,
import_error.png (21.74 KiB) Viewed 3833 times
And another error,
Error: could not insert: [com.openkm.dao.bean.NodeFolder]
Please explain what is going on, we have been having a lots of problems in different places lately
.
Re: Import documents error
PostPosted:Fri Feb 17, 2017 11:22 am
by jllort
I need to see catalina.log file for understanding what has happened.
Which is your hardware configuration ?
Did you configured MySQL or another database support for OpenKM ?
Re: Import documents error
PostPosted:Mon Feb 20, 2017 11:32 am
by openkm_user
Hi,
Thanks for all the answers, we are testing everything in our end and get back to you with more details. We are using MySQL database in all environments.
Hardware configuration,
cms_prod.JPG (30.46 KiB) Viewed 3815 times
Thanks again!
Re: Import documents error
PostPosted:Tue Feb 21, 2017 7:32 pm
by jllort
Could you share the catalina.log file ( only I'm interested in stack trace log error not all the log )
Re: Import documents error
PostPosted:Wed Feb 22, 2017 8:43 am
by openkm_user
I will have to check through the log file to get the exact logs, I will get it to you soon.
Your help is highly appreciated!
Re: Import documents error
PostPosted:Fri Feb 24, 2017 9:21 am
by openkm_user
This is the log just before the last import died,
Code: Select all2017-02-23 19:30:00,024 [Thread-99] INFO com.openkm.core.UserMailImporter- *** User mail importer activated ***
2017-02-23 19:44:03,701 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Shutting down OpenOffice manager ***
2017-02-23 19:44:03,701 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Shutting down UI Notification... ***
2017-02-23 19:44:03,702 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Shutting down cron... ***
2017-02-23 19:44:03,702 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Shutting down update info... ***
2017-02-23 19:44:03,702 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Shutting pending task executor... ***
2017-02-23 19:44:03,702 [localhost-startStop-2] INFO com.openkm.util.pendtask.PendingTaskExecutor- ### All threads shutdown requested ###
2017-02-23 19:44:03,702 [localhost-startStop-2] INFO com.openkm.util.pendtask.PendingTaskExecutor- ### All threads have finished ###
2017-02-23 19:44:03,702 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Shutting down repository... ***
2017-02-23 19:44:03,702 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Repository shutted down ***
2017-02-23 19:44:03,702 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Execute stop script ***
2017-02-23 19:44:03,702 [localhost-startStop-2] WARN com.openkm.util.ExecutionUtils- Unable to read script: E:\apache-tomcat-7.0.73\stop.bsh
2017-02-23 19:44:03,702 [localhost-startStop-2] WARN com.openkm.util.ExecutionUtils- Unable to read jar: E:\apache-tomcat-7.0.73\stop.jar
2017-02-23 19:44:03,703 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Execute stop SQL ***
2017-02-23 19:44:03,703 [localhost-startStop-2] WARN com.openkm.servlet.RepositoryStartupServlet- Unable to read sql: E:\apache-tomcat-7.0.73\stop.sql
2017-02-23 19:44:03,703 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Shutting down workflow engine... ***
2017-02-23 19:44:03,742 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Hibernate shutdown ***
2017-02-23 19:44:04,274 [Update Info] ERROR com.openkm.core.RepositoryInfo- The com.openkm.dao.bean.NodeBase Cache is not alive.
com.openkm.core.RepositoryException: The com.openkm.dao.bean.NodeBase Cache is not alive.
at com.openkm.module.db.DbStatsModule.getNodesByContext(DbStatsModule.java:110)
at com.openkm.module.db.DbStatsModule.getMailsByContext(DbStatsModule.java:57)
at com.openkm.api.OKMStats.getMailsByContext(OKMStats.java:78)
at com.openkm.core.RepositoryInfo.runAs(RepositoryInfo.java:66)
at com.openkm.core.RepositoryInfo.run(RepositoryInfo.java:52)
at com.openkm.core.UpdateInfo.run(UpdateInfo.java:37)
at java.util.TimerThread.mainLoop(Timer.java:555)
at java.util.TimerThread.run(Timer.java:505)
Caused by: java.lang.IllegalStateException: The com.openkm.dao.bean.NodeBase Cache is not alive.
at net.sf.ehcache.Cache.checkStatus(Cache.java:2438)
at net.sf.ehcache.Cache.get(Cache.java:1541)
at net.sf.ehcache.hibernate.regions.EhcacheTransactionalDataRegion.get(EhcacheTransactionalDataRegion.java:105)
at net.sf.ehcache.hibernate.strategy.AbstractReadWriteEhcacheAccessStrategy.putFromLoad(AbstractReadWriteEhcacheAccessStrategy.java:90)
at net.sf.ehcache.hibernate.nonstop.NonstopAwareEntityRegionAccessStrategy.putFromLoad(NonstopAwareEntityRegionAccessStrategy.java:180)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:195)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:982)
at org.hibernate.loader.Loader.doQuery(Loader.java:857)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at com.openkm.dao.NodeBaseDAO.getSubtreeCountHelper(NodeBaseDAO.java:1677)
at com.openkm.dao.NodeBaseDAO.getSubtreeCountHelper(NodeBaseDAO.java:1682)
at com.openkm.dao.NodeBaseDAO.getSubtreeCountHelper(NodeBaseDAO.java:1682)
at com.openkm.dao.NodeBaseDAO.getSubtreeCountHelper(NodeBaseDAO.java:1682)
at com.openkm.dao.NodeBaseDAO.getSubtreeCountHelper(NodeBaseDAO.java:1682)
at com.openkm.dao.NodeBaseDAO.getSubtreeCount(NodeBaseDAO.java:1647)
at com.openkm.module.db.DbStatsModule.getNodesByContext(DbStatsModule.java:85)
... 7 more
2017-02-23 19:44:04,274 [Update Info] INFO com.openkm.core.UpdateInfo- *** UpdateInfo activated ***
Let me know if you need any more information.
Re: Import documents error
PostPosted:Fri Feb 24, 2017 4:08 pm
by jllort
Seems like application going to shutdown
Code: Select all2017-02-23 19:44:03,701 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Shutting down OpenOffice manager ***
2017-02-23 19:44:03,701 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Shutting down UI Notification... ***
2017-02-23 19:44:03,702 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Shutting down cron... ***
2017-02-23 19:44:03,702 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Shutting down update info... ***
2017-02-23 19:44:03,702 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Shutting pending task executor... ***
2017-02-23 19:44:03,702 [localhost-startStop-2] INFO com.openkm.util.pendtask.PendingTaskExecutor- ### All threads shutdown requested ###
2017-02-23 19:44:03,702 [localhost-startStop-2] INFO com.openkm.util.pendtask.PendingTaskExecutor- ### All threads have finished ###
2017-02-23 19:44:03,702 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Shutting down repository... ***
2017-02-23 19:44:03,702 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Repository shutted down ***
2017-02-23 19:44:03,702 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Execute stop script ***
2017-02-23 19:44:03,702 [localhost-startStop-2] WARN com.openkm.util.ExecutionUtils- Unable to read script: E:\apache-tomcat-7.0.73\stop.bsh
2017-02-23 19:44:03,702 [localhost-startStop-2] WARN com.openkm.util.ExecutionUtils- Unable to read jar: E:\apache-tomcat-7.0.73\stop.jar
2017-02-23 19:44:03,703 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Execute stop SQL ***
2017-02-23 19:44:03,703 [localhost-startStop-2] WARN com.openkm.servlet.RepositoryStartupServlet- Unable to read sql: E:\apache-tomcat-7.0.73\stop.sql
2017-02-23 19:44:03,703 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Shutting down workflow engine... ***
2017-02-23 19:44:03,742 [localhost-startStop-2] INFO com.openkm.servlet.RepositoryStartupServlet- *** Hibernate shutdown ***
How did you started the application ? from command line, as a service ?
Re: Import documents error
PostPosted:Sun Feb 26, 2017 3:30 pm
by openkm_user
As a service.
import_error.png (21.74 KiB) Viewed 3833 times
And another error,