Job to execute database command

Hello:

We are getting an error when running jobs that execute database commands. The error on the debug.log file is:

checkTriggers
com.softtreetech.jscheduler.common.SchedException: D:\Program Files\24x7_Scheduler\Queue\[default]\8150.q (The system cannot find the file specified)

Every time we run this job, it creates varios 'Q' files in the Queue\[default] directory but none of them are called 8150.q.

Thanks in advace for your help to solve this problem

This error likely comes from the queue manager, not from that job. There must be some other phantom job hanging in the queue and whose associated work files got somehow deleted. Perhaps the scheduler got shutdown or killed previously before the queue manager had a change to finish some internal processing.

Try opening the queue monitor for that particular job queue and check for some jobs that it thinks are still running. Delete these jobs from the queue and the message should disappear.

Hello:

We did as instructed and restarted all services. The job still failed now, it did not create any of the 'Q' files. This is what appears on the debug.log file:

2007-03-27 14:46:16,937 [Thread-2207] DEBUG com.softtreetech.jscheduler.business.runner.RemoteJobRunner - runJob
com.softtreetech.jscheduler.common.SchedException
at com.softtreetech.jscheduler.business.agent.remote.RemoteAgentImpl.executeJob(Unknown Source)
at sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(Unknown Source)
at sun.rmi.transport.StreamRemoteCall.executeCall(Unknown Source)
at sun.rmi.server.UnicastRef.invoke(Unknown Source)
at com.softtreetech.jscheduler.business.agent.remote.RemoteAgentImpl_Stub.executeJob(Unknown Source)
at com.softtreetech.jscheduler.business.runner.RemoteJobRunner.runJob(Unknown Source)
at com.softtreetech.jscheduler.business.runner.AbstractJobRunner.oO0000(Unknown Source)
at com.softtreetech.jscheduler.business.runner.AbstractJobRunner.Object(Unknown Source)
at com.softtreetech.jscheduler.business.runner.AbstractJobRunner.execute(Unknown Source)
at com.softtreetech.jscheduler.business.runner.JobExecutorImpl.execute(Unknown Source)
at com.softtreetech.jscheduler.business.runner.JobExecutorImpl$1.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2007-03-27 14:46:16,937 [Thread-2207] DEBUG com.softtreetech.jscheduler.db.JobDbImpl - updateJob(JobProperties) : start
2007-03-27 14:46:16,937 [Thread-2207] DEBUG com.softtreetech.jscheduler.db.drivers.file.FileJobDbStorage - update(...) : start
2007-03-27 14:46:16,937 [Thread-2207] DEBUG com.softtreetech.jscheduler.db.drivers.file.FileJobDbStorage - update(...) : end
2007-03-27 14:46:16,937 [Thread-2207] DEBUG com.softtreetech.jscheduler.db.JobDbImpl - updateJob(JobProperties) : end
2007-03-27 14:46:16,937 [Thread-2207] DEBUG com.softtreetech.jscheduler.business.queue.JobQueue - QUEUE_UNLOCKED
2007-03-27 14:46:17,109 [Thread-2207] ERROR com.softtreetech.jscheduler.business.runner.JobExecutorImpl - Job errors: Remote job failed. Exit code: -1
2007-03-27 14:47:00,046 [Thread-2306] DEBUG com.softtreetech.jscheduler.business.queue.JobQueue - QUEUE_UNLOCKED

This indicates that you are attempting to run a remote job and that remote job is failing. What are you getting in the schedule.log or debug.log on the remote computer?

This is the error message on the scheduler.log file on the remote computer:

03/27/2007 02:46:16 PM 2 null 138 0040-test Remote job started.
03/27/2007 02:46:16 PM 2 null 138 0040-test Job started.
03/27/2007 02:46:16 PM 3 null 138 0040-test /usr/local/24x7_Scheduler/Queue/4453.tmp (No such file or directory)

------------------------------------------
The remote computer is a UNIX machine and there is no such folder file or directory (/usr/local/24x7_Scheduler/Queue/4453.tmp) on it. It seems the scheduler is creating that temp file but there is no such folder. All the queues are created on a Windows server machine running the scheduler application.

How can we solve the error?

This looks like the account running 24x7 doesn't have permissions to create subdirectories and workfiles.