12 Replies Latest reply on Feb 14, 2019 9:33 AM by Adrian_Popescu-Oracle

ODI jobs not starting, have to run them manually

3236706 Feb 7, 2019 9:37 AM

Set ODI schedules are not running. When i check the agents schedules, the scheduled run of the processes appear at the right time, meaning it knows it should run. I now have to run the jobs manually and this is working well. Note, the agent is up and running. What could be the issue?

1. Re: ODI jobs not starting, have to run them manually

Adrian_Popescu-Oracle Feb 7, 2019 10:06 AM (in response to 3236706)

Hi,
What ODI version ?
What type of agent ?
Check in the agent log at the date and time the job should start, it has to be an error.

Adrian
Like Show 0 Likes(0)

Actions
2. Re: ODI jobs not starting, have to run them manually

3236706 Feb 7, 2019 12:32 PM (in response to 3236706)

ODI version - 12.1.3.0.0
Agent Type - oraclediagent
Like Show 0 Likes(0)

Actions
3. Re: ODI jobs not starting, have to run them manually

Adrian_Popescu-Oracle Feb 7, 2019 12:58 PM (in response to 3236706)

Hi,
Check in the agent log at the date and time the job should start, it has to be an error.
Agent type should be Standalone or JavaEE.
Adrian
Like Show 0 Likes(0)

Actions
4. Re: ODI jobs not starting, have to run them manually

3236706 Feb 7, 2019 1:33 PM (in response to 3236706)

Kindly guide on how to check the agent log
Agent type is Standalone
Like Show 0 Likes(0)

Actions
5. Re: ODI jobs not starting, have to run them manually

Adrian_Popescu-Oracle Feb 7, 2019 1:36 PM (in response to 3236706)

If it is a Standalone agent logs are here:
<ODI_HOME>\user_projects\domains\your_domain\system_components\ODI\your_agent\logs\oracledi\odiagent.log
Like Show 0 Likes(0)

Actions
6. Re: ODI jobs not starting, have to run them manually

3753403 Feb 11, 2019 9:38 PM (in response to 3236706)

Did you update the Schedule of agent in topology after creating a schedule?
Like Show 0 Likes(0)

Actions
7. Re: ODI jobs not starting, have to run them manually

3236706 Feb 12, 2019 7:01 AM (in response to 3236706)

Yes I did. I have even recreated some scenarios and schedules, regenerated the scenario and updated the schedule of agents and still, it does not work.
Like Show 0 Likes(0)

Actions
8. Re: ODI jobs not starting, have to run them manually

Adrian_Popescu-Oracle Feb 12, 2019 8:22 AM (in response to 3236706)

There must be a reason for this, check the ODI agent log at the time the job was supposed to start.
Like Show 0 Likes(0)

Actions
9. Re: ODI jobs not starting, have to run them manually

3236706 Feb 12, 2019 8:44 AM (in response to Adrian_Popescu-Oracle)

Have checked the log and I'm not able to identify where the issue is. Latest odiagent.log file shared on SR 3-19366834801. Kindly check it through also, you could spot where the issue could be
Like Show 0 Likes(0)

Actions
10. Re: ODI jobs not starting, have to run them manually

Adrian_Popescu-Oracle Feb 12, 2019 8:48 AM (in response to 3236706)

Hi,
There is an Action plan provided to you, follow up with the SR.
Adrian
Like Show 0 Likes(0)

Actions
11. Re: ODI jobs not starting, have to run them manually

3236706 Feb 14, 2019 6:26 AM (in response to 3753403)
Yes I did. i have even recreated some scenarios and schedules, regenerated
the scenario and updated the scheduler and still, it does not work.
Attached is the agent log

On Tue, 12 Feb 2019 at 00:39, community-admin <

Correct odiagent.log.zip 374.0 K
Like Show 0 Likes(0)

Actions
12. Re: ODI jobs not starting, have to run them manually

Adrian_Popescu-Oracle Feb 14, 2019 9:33 AM (in response to 3236706)

Hi,
Agent log shows errors like:
oracle.odi.runtime.agent.ExecutionException: java.lang.NullPointerException[[
at oracle.odi.runtime.agent.processor.impl.GetPlanningRequestProcessor.doExecuteSchedulerRequest(GetPlanningRequestProcessor.java:191)
.........
Caused by: java.lang.NullPointerException
at java.util.Calendar.setTime(Calendar.java:1118)
at com.sunopsis.timer.filterbased.SnpsBetweenHoursFilter.isBetweenBeginningAndEnd(SnpsBetweenHoursFilter.java:73)
...........

Follow note:
"Unable to retrieve agent's schedule, Unable to Connect To Agent" Messages, Or No Schedule Displays, Or Update/View Schedule Hangs When Viewing Schedules in ODI (Doc ID 458756.1)
Chapter:
"Case 4. May be an issue with the Java version used by the Agent."

Adrian
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.