Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.
0 votes
1 view
Hi,

Please provide information about the CRON scheduler?.. which you have used in knowage..
Environment Knowage 6.0.1,Linux UBuntu,Firefox & Chrome
closed with the note: This post does not follow most of our Q&A rules: A clear title. A reasonable explanation of what your question is. Add as much detail as you can. Any background research you've tried but wasn't enough to solve your problem. Correct use of English spelling and grammar to the best of your ability.
in Admin and Developer Functionalities by (940 points)
closed by

Hi,

I am getting this error, so i need information about CRON scheduler.

[localhost-startStop-1] 20 Dec 2017 11:44:25,360 ERROR it.eng.spagobi.tools.scheduler.init.CleanCacheQuartzInitializer.initCleanForTenant:110 - Error while initializing scheduler 
it.eng.spagobi.commons.dao.SpagoBIDAOException: An unexpected error occured while loading job [CleanCacheJob] in group [CleanCacheJob]
	at it.eng.spagobi.tools.scheduler.dao.quartz.QuarzSchedulerDAOImpl.loadJob(QuarzSchedulerDAOImpl.java:304)
	at it.eng.spagobi.tools.scheduler.init.CleanCacheQuartzInitializer.initCleanForTenant(CleanCacheQuartzInitializer.java:74)
	at it.eng.spagobi.tools.scheduler.init.CleanCacheQuartzInitializer.init(CleanCacheQuartzInitializer.java:58)
	at it.eng.spago.init.InitializerManager.init(InitializerManager.java:79)
	at it.eng.spago.configuration.ConfigServlet.init(ConfigServlet.java:115)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5198)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5481)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:634)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1230)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1876)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.quartz.JobPersistenceException: Couldn't retrieve job: Bad value for type long : \xaced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c770800000010000000027400116d65726765416c6c536e617073686f747374000566616c7365740010636f6c6c617465536e617073686f747371007e00087800 [See nested exception: org.postgresql.util.PSQLException: Bad value for type long : \xaced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c770800000010000000027400116d65726765416c6c536e617073686f747374000566616c7365740010636f6c6c617465536e617073686f747371007e00087800]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveJob(JobStoreSupport.java:1338)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport$7.execute(JobStoreSupport.java:1308)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3662)
	at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:93)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeWithoutLock(JobStoreSupport.java:3567)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveJob(JobStoreSupport.java:1305)
	at org.quartz.core.QuartzScheduler.getJobDetail(QuartzScheduler.java:1289)
	at org.quartz.impl.StdScheduler.getJobDetail(StdScheduler.java:551)
	at it.eng.spagobi.tools.scheduler.dao.quartz.QuarzSchedulerDAOImpl.loadJob(QuarzSchedulerDAOImpl.java:295)
	... 20 more
Caused by: org.postgresql.util.PSQLException: Bad value for type long : \xaced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c770800000010000000027400116d65726765416c6c536e617073686f747374000566616c7365740010636f6c6c617465536e617073686f747371007e00087800
	at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toLong(AbstractJdbc2ResultSet.java:2971)
	at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getLong(AbstractJdbc2ResultSet.java:2163)
	at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBlob(AbstractJdbc2ResultSet.java:378)
	at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBlob(AbstractJdbc2ResultSet.java:366)
	at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getBlob(DelegatingResultSet.java:565)
	at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getBlob(DelegatingResultSet.java:565)
	at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.getObjectFromBlob(StdJDBCDelegate.java:3461)
	at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectJobDetail(StdJDBCDelegate.java:907)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveJob(JobStoreSupport.java:1316)
	... 28 more
[http-bio-8070-exec-4] 20 Dec 2017 12:07:52,166 ERROR it.eng.spagobi.commons.dao.AbstractHibernateDAO.logException:254 - org.hibernate.ObjectNotFoundException No row with the given identifier exists: 
...