Page 1 of 1

Cront tab execution error

PostPosted:Fri Sep 05, 2014 1:10 am
by matt81
Hi Guys,
I am experiencing strange behaviour from the Cron tab process.
I upload a .jar file, and when I execute it, by clicking on the flash icon, the code is executed successfully. However when I activate it, and wait for the system to automatically call it, it doesn't work. Do yu know why they behave differently when it is the same code?

I am using com.openkm.servlet.frontend.DocumentServlet, and the following function doesn't work convertToPdf. It doesn't execute successfully

see error log below:
Code: Select all
2014-09-05 00:50:01,246 [Thread-1562] INFO  com.openkm.module.db.stuff.DbSimpleAccessManager- ***************************
2014-09-05 00:50:01,246 [Thread-1562] INFO  com.openkm.module.db.stuff.DbSimpleAccessManager- ***************************
2014-09-05 00:50:01,246 [Thread-1562] WARN  com.openkm.module.db.stuff.DbSimpleAccessManager- com.openkm.module.db.stuff.DbSimpleAccessManager -> isGranted (DbSimpleAccessManager.java:68)
2014-09-05 00:50:01,246 [Thread-1562] WARN  com.openkm.module.db.stuff.DbSimpleAccessManager- com.openkm.module.db.stuff.SecurityHelper -> checkRead (SecurityHelper.java:96)
2014-09-05 00:50:01,246 [Thread-1562] WARN  com.openkm.module.db.stuff.DbSimpleAccessManager- com.openkm.dao.NodeDocumentDAO -> findByPk (NodeDocumentDAO.java:252)
2014-09-05 00:50:01,246 [Thread-1562] WARN  com.openkm.module.db.stuff.DbSimpleAccessManager- com.openkm.dao.NodeDocumentDAO -> findByPk (NodeDocumentDAO.java:230)
2014-09-05 00:50:01,246 [Thread-1562] WARN  com.openkm.module.db.stuff.DbSimpleAccessManager- com.openkm.module.db.DbDocumentModule -> getProperties (DbDocumentModule.java:421)
2014-09-05 00:50:01,246 [Thread-1562] WARN  com.openkm.module.db.stuff.DbSimpleAccessManager- com.openkm.api.OKMDocument -> getProperties (OKMDocument.java:105)
2014-09-05 00:50:01,246 [Thread-1562] WARN  com.openkm.module.db.stuff.DbSimpleAccessManager- com.openkm.servlet.frontend.DocumentServlet -> convertToPdf (DocumentServlet.java:930)
2014-09-05 00:50:01,246 [Thread-1562] WARN  com.openkm.module.db.stuff.DbSimpleAccessManager- com.openkm.util.cl.ClassLoaderUtils -> invokeMethodFromClass (ClassLoaderUtils.java:113)
2014-09-05 00:50:01,246 [Thread-1562] WARN  com.openkm.module.db.stuff.DbSimpleAccessManager- com.openkm.util.ExecutionUtils -> runJar (ExecutionUtils.java:220)
2014-09-05 00:50:01,246 [Thread-1562] WARN  com.openkm.module.db.stuff.DbSimpleAccessManager- com.openkm.core.Cron$RunnerJar -> run (Cron.java:176)
2014-09-05 00:50:01,246 [Thread-1562] INFO  com.openkm.module.db.stuff.DbSimpleAccessManager- ***************************
2014-09-05 00:50:01,246 [Thread-1562] INFO  com.openkm.module.db.stuff.DbSimpleAccessManager- ***************************
2014-09-05 00:50:01,249 [Thread-1562] WARN  com.openkm.servlet.frontend.DocumentServlet- /okm:root/test/newone.pdf
com.openkm.core.PathNotFoundException: /okm:root/test/newone.pdf
	at com.openkm.dao.NodeBaseDAO.calculateUuidFromPath(NodeBaseDAO.java:262)
	at com.openkm.dao.NodeBaseDAO.calculateUuidFromPath(NodeBaseDAO.java:232)
	at com.openkm.dao.NodeBaseDAO.getUuidFromPath(NodeBaseDAO.java:122)
	at com.openkm.module.db.DbDocumentModule.delete(DbDocumentModule.java:300)
	at com.openkm.api.OKMDocument.delete(OKMDocument.java:96)
	at com.openkm.servlet.frontend.DocumentServlet.delete(DocumentServlet.java:208)
                at ConvertTest.deletePDFfromOpenKM(ConvertTest.java:311)
	at ConvertTest.processDocuments(ConvertTest.java:260)
	at ConvertTest.mkDirs(ConvertTest.java:140)
	at ConvertTest.cronTask(ConvertTest.java:78)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at com.openkm.util.cl.ClassLoaderUtils.invokeMethodFromClass(ClassLoaderUtils.java:113)
	at com.openkm.util.ExecutionUtils.runJar(ExecutionUtils.java:220)
	at com.openkm.core.Cron$RunnerJar.run(Cron.java:176)
	at java.lang.Thread.run(Thread.java:744)

Thanks

Re: Cront tab execution error

PostPosted:Sat Sep 06, 2014 8:49 am
by jllort
I supect. When you execute ( flash icon ) are using your environement user ( token= null and take your user) but when is executed internally token is still null and not user logged. In api call you should use token = systemToken
Code: Select all
Sting systemToken = DbSessionManager.getInstance().getSystemToken();

Re: Cront tab execution error

PostPosted:Mon Sep 08, 2014 3:38 am
by matt81
Thanks for your reply.
Yes I am using the system token, and it doesn't work. It stops when it comes to the following method ConvertToPdf from DocumentServlet class.
Not sure why that would happen, as there is no difference whether you are using an environment or system variable.

Thanks

Re: Cront tab execution error

PostPosted:Mon Sep 08, 2014 11:44 am
by pavila
Please, tell me which OpenKM version are you using and post the source code for testing.

Re: Cront tab execution error

PostPosted:Wed Sep 10, 2014 11:25 pm
by matt81
Thanks for your reply.
I am using Comuunity version 6.3.0, see code below:
Code: Select all
public static void convertToPdf(String openkmPath, DocumentServlet cm){
		try {	
			cm.convertToPdf(openkmPath); 
		}catch (Exception e) {
			System.out.println("Exception: " + e.getMessage());
		}
Let me know what could be the problem, as I said it works perefectly fine when I click on the execute icon.

Thanks

Re: Cront tab execution error

PostPosted:Thu Sep 11, 2014 3:56 pm
by pavila
Please, upgrade to last version from http://integration.openkm.com/6.3/. Instructions at http://wiki.openkm.com/index.php/Migrat ... 3_to_6.3.1

Tell me if solves your problem.

Re: Cront tab execution error

PostPosted:Mon Sep 15, 2014 11:53 pm
by matt81
Thanks for your reply.
No it didn't work with the new nightly build.
I didn't get an error in the log file, but still it didn't work.
Code: Select all
2014-09-15 23:40:00,523 [Thread-30] WARN  com.openkm.module.db.stuff.DbSimpleAccessManager- com.openkm.module.db.stuff.SecurityHelper -> checkRead (SecurityHelper.java:96)
2014-09-15 23:40:00,523 [Thread-30] WARN  com.openkm.module.db.stuff.DbSimpleAccessManager- com.openkm.dao.NodeDocumentDAO -> findByPk (NodeDocumentDAO.java:252)
2014-09-15 23:40:00,523 [Thread-30] WARN  com.openkm.module.db.stuff.DbSimpleAccessManager- com.openkm.dao.NodeDocumentDAO -> findByPk (NodeDocumentDAO.java:230)
2014-09-15 23:40:00,523 [Thread-30] WARN  com.openkm.module.db.stuff.DbSimpleAccessManager- com.openkm.module.db.DbDocumentModule -> getProperties (DbDocumentModule.java:421)
2014-09-15 23:40:00,523 [Thread-30] WARN  com.openkm.module.db.stuff.DbSimpleAccessManager- com.openkm.util.impexp.RepositoryExporter -> exportDocument (RepositoryExporter.java:269)
2014-09-15 23:40:00,523 [Thread-30] WARN  com.openkm.module.db.stuff.DbSimpleAccessManager- com.openkm.util.cl.ClassLoaderUtils -> invokeMethodFromClass (ClassLoaderUtils.java:113)
2014-09-15 23:40:00,523 [Thread-30] WARN  com.openkm.module.db.stuff.DbSimpleAccessManager- com.openkm.util.ExecutionUtils -> runJar (ExecutionUtils.java:220)
2014-09-15 23:40:00,524 [Thread-30] WARN  com.openkm.module.db.stuff.DbSimpleAccessManager- com.openkm.core.Cron$RunnerJar -> run (Cron.java:176)
2014-09-15 23:40:00,524 [Thread-30] INFO  com.openkm.module.db.stuff.DbSimpleAccessManager- ***************************
2014-09-15 23:40:00,524 [Thread-30] INFO  com.openkm.module.db.stuff.DbSimpleAccessManager- ***************************

Re: Cront tab execution error

PostPosted:Tue Sep 16, 2014 6:56 am
by pavila
Did you delete the $TOMCAT_HOME/webapps/OpenKM directory before starting Tomcat again?

Re: Cront tab execution error

PostPosted:Tue Sep 16, 2014 11:13 pm
by matt81
Thanks for your reply.
I deleted the OpenKM.war file and that folder was deleted as well. And I still experience the same issue, it doesn't work.
Does OpenKM do any caching, and if so, what is the path to the folder?

Thanks

Re: Cront tab execution error

PostPosted:Wed Sep 17, 2014 9:35 am
by pavila
Please, attach or post the whole crontab script.