java.lang.Exception on Scheduled process

Aziz Kayoueche

unread,

Dec 16, 2021, 1:41:02 AM12/16/21

to iDempiere

Hi every one

I have shedule process that it runs every day on background, but i get this error

please what does mean?.

thanks.

java.lang.Exception at org.compiere.util.Trx.setConnection(Trx.java:220) at org.compiere.util.Trx.getConnection(Trx.java:190) at org.compiere.util.Trx.getConnection(Trx.java:169) at org.compiere.db.PreparedStatementProxy.init(PreparedStatementProxy.java:62) at org.compiere.db.PreparedStatementProxy.(PreparedStatementProxy.java:45) at org.compiere.db.ProxyFactory.newCPreparedStatement(ProxyFactory.java:56) at org.compiere.util.DB.prepareStatement(DB.java:780) at org.compiere.util.DB.prepareStatement(DB.java:749) at org.dusfan.idempiere.watchair.process.ReadNotImportedAIR.getImportedAir(ReadNotImportedAIR.java:119) at org.dusfan.idempiere.watchair.process.ReadNotImportedAIR.doIt(ReadNotImportedAIR.java:72) at org.compiere.process.SvrProcess.process(SvrProcess.java:220) at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:154) at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:173) at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:140) at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:129) at org.compiere.process.ServerProcessCtl.startProcess(ServerProcessCtl.java:327) at org.compiere.process.ServerProcessCtl.run(ServerProcessCtl.java:234) at org.compiere.process.ServerProcessCtl.process(ServerProcessCtl.java:95) at org.compiere.server.Scheduler.runProcess(Scheduler.java:208) at org.compiere.server.Scheduler.doWork(Scheduler.java:127) at org.compiere.server.AdempiereServer.doRun(AdempiereServer.java:276) at org.compiere.server.AdempiereServer.run(AdempiereServer.java:255) at org.compiere.server.AdempiereServerMgr$LocalServerController.run(AdempiereServerMgr.java:752) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) java.lang.Exception at org.compiere.util.Trx.setConnection(Trx.java:220) at org.compiere.util.Trx.getConnection(Trx.java:190) at org.compiere.util.Trx.getConnection(Trx.java:169) at org.compiere.db.PreparedStatementProxy.init(PreparedStatementProxy.java:62) at org.compiere.db.PreparedStatementProxy.(PreparedStatementProxy.java:45) at org.compiere.db.ProxyFactory.newCPreparedStatement(ProxyFactory.java:56) at org.compiere.util.DB.prepareStatement(DB.java:780) at org.compiere.util.DB.prepareStatement(DB.java:749) at org.dusfan.idempiere.watchair.process.ReadNotImportedAIR.getImportedAir(ReadNotImportedAIR.java:119) at org.dusfan.idempiere.watchair.process.ReadNotImportedAIR.doIt(ReadNotImportedAIR.java:72) at org.compiere.process.SvrProcess.process(SvrProcess.java:220) at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:154) at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:173) at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:140) at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:129) at org.compiere.process.ServerProcessCtl.startProcess(ServerProcessCtl.java:327) at org.compiere.process.ServerProcessCtl.run(ServerProcessCtl.java:234) at org.compiere.process.ServerProcessCtl.process(ServerProcessCtl.java:95) at org.compiere.server.Scheduler.runProcess(Scheduler.java:208) at org.compiere.server.Scheduler.doWork(Scheduler.java:127) at org.compiere.server.AdempiereServer.doRun(AdempiereServer.java:276) at org.compiere.server.AdempiereServer.run(AdempiereServer.java:255) at org.compiere.server.AdempiereServerMgr$LocalServerController.run(AdempiereServerMgr.java:752) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829)

Nicolas Micoud

unread,

Dec 16, 2021, 2:00:22 AM12/16/21

to iDempiere

Hi,

Probably something wrong in your process, but without the code, is hard to answer.

Can you show us the content of org.dusfan.idempiere.watchair.process.ReadNotImportedAIR.java ?

That will probably help.

Regards,

Nicolas

Aziz Kayoueche

unread,

Dec 17, 2021, 6:06:21 AM12/17/21

to iDempiere

Hi Nicolas

When i connect from idempiere as normal user and run this process ReadNotImportedAIR there is no problem but the problem is when the process is started from schedule as background.