• Import documents error

  • We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #43230  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
import_error.png (21.74 KiB) Viewed 3004 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 :|.
 #43241  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 ?
 #43253  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
cms_prod.JPG (30.46 KiB) Viewed 2986 times
Thanks again!
 #43265  by jllort
 
Could you share the catalina.log file ( only I'm interested in stack trace log error not all the log )
 #43271  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!
 #43291  by openkm_user
 
This is the log just before the last import died,
Code: Select all
2017-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.
 #43295  by jllort
 
Seems like application going to shutdown
Code: Select all
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 ***
How did you started the application ? from command line, as a service ?
 #43303  by openkm_user
 
As a service.

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.