This discussion is archived
9 Replies Latest reply: Nov 20, 2012 6:21 AM by user544069 RSS

Agent Schedular not working

user544069 Newbie
Currently Being Moderated
Hi I am new in ODI.

I am getting the Error like:-- com.sunopsis.core.l: Cannot update scheduling - This agent is not a scheduler
I have tested the Agent from topology. Agent test is successful

Under master repository there are two work repository. 1> PCS_WORKREP and 2> PCS_WORKREP_PRD.
I am using 2> PCS_WORKREP_PRD
In ODIPARMS.BAT the workrepository details is below:--

rem
rem Repository Connection Information
rem
rem set ODI_SECU_DRIVER=org.hsqldb.jdbcDriver
rem set ODI_SECU_URL=jdbc:hsqldb:hsql://localhost
rem set ODI_SECU_USER=sa
rem set ODI_SECU_ENCODED_PASS=
rem set ODI_SECU_WORK_REP=WORKREP
rem set ODI_USER=SUPERVISOR
rem set ODI_ENCODED_PASS=LELKIELGLJMDLKMGHEHJDBGBGFDGGH

rem set ODI_SECU_DRIVER=oracle.jdbc.driver.OracleDriver
rem set ODI_SECU_URL=jdbc:oracle:thin:@10.100.9.203:1527:PETROBI
rem set ODI_SECU_USER=pcs_master
rem set ODI_SECU_ENCODED_PASS=fDyXKWJljfrQVVXWeSug
rem set ODI_SECU_WORK_REP=PCS_WORKREP
rem set ODI_USER=SUPERVISOR
rem set ODI_ENCODED_PASS=fDyXtCB5KrlOdPj6XzEr

set ODI_SECU_DRIVER=oracle.jdbc.driver.OracleDriver
set ODI_SECU_URL=jdbc:oracle:thin:@10.100.9.203:1527:PETROBI
set ODI_SECU_USER=pcs_master
set ODI_SECU_ENCODED_PASS=aYyHIA3wJyhcHRRW8Q6xsp
set ODI_SECU_WORK_REP=PCS_WORKREP_PRD
set ODI_USER=SUPERVISOR
set ODI_ENCODED_PASS=hZypubBYdOkQgNR0MvvGif

*** Schedular is created on the Scenarios properly and it is showing under the Logical agent in Operator also.

Any body please help.
  • 1. Re: Agent Schedular not working
    SH Guru
    Currently Being Moderated
    I take it this is ODI 10g? If so there are two types of agent you can configure to run as service. Normal agent and scheduler agent. You use the same agent setup batch script but there are different switches -s for a scheduling agent -a for a normal agent. Did you set your agent up as a scheduling agent?
  • 2. Re: Agent Schedular not working
    user544069 Newbie
    Currently Being Moderated
    Thanks for your reply.

    I ran the below command before starting the agent to work as Scheduler agent.

    " agentscheduler.bat -NAME=PHYSICAL_AGENT ". My Physical Agent name is PHYSICAL_AGENT
    Is there any other way to configure the physical Agent as Schedular Agent.

    Please help me..
  • 3. Re: Agent Schedular not working
    SH Guru
    Currently Being Moderated
    If you are working on 10g

    Agentservice.bat –i –s AgentName AgentPort

    AgentName must be specified, only specify port if different from default 20910

    Also make sure you have uninstalled your old agent service
  • 4. Re: Agent Schedular not working
    496810 Explorer
    Currently Being Moderated
    Recheck your odiparams.bat..thats the key here...i got this error..before and solved this ..working on the odiparams..so good luck..
  • 5. Re: Agent Schedular not working
    user544069 Newbie
    Currently Being Moderated
    Thanks for your prompt reply.

    I stopped the Agent and the started the Agentschedular.bat with this Agent name and then started the Agent.bat.
    Now Update Scheduling is working fine and showing the message :-- Planning update is completed.
    But when I am trying to get Scheduling Information then I am getting Erro Message :-- Unable to retrive agent's schedule
    After clicking Ok it is opening the schedule where nothing is showing.
    Where as in Operator in Scheduling some Scenarios are scheduled and active.
    Then I don't know why this scheduling information is not coming to the Agent scheduling information.

    Yes I am using 10g.
    I checked ODIPARAMETERS..every thing is fine there...

    Please help in this regard.
  • 6. Re: Agent Schedular not working
    SutirthaRoy Guru
    Currently Being Moderated
    966489 wrote:
    Thanks for your prompt reply.

    I stopped the Agent and the started the Agentschedular.bat with this Agent name and then started the Agent.bat.
    Now Update Scheduling is working fine and showing the message :-- Planning update is completed.
    But when I am trying to get Scheduling Information then I am getting Erro Message :-- Unable to retrive agent's schedule
    I have seen this info many time .. you can ignore it.
    After clicking Ok it is opening the schedule where nothing is showing.
    In the schedule window you have option to change the date (to and from date) .
    Change from date to yesterday's date and to date to tomorrow's date .
    Now check if you get any info about the scenario scheduled
    Where as in Operator in Scheduling some Scenarios are scheduled and active.
    Then I don't know why this scheduling information is not coming to the Agent scheduling information.

    Yes I am using 10g.
    I checked ODIPARAMETERS..every thing is fine there...

    Please help in this regard.
  • 7. Re: Agent Schedular not working
    user544069 Newbie
    Currently Being Moderated
    Hi Sutirtha,

    Thanks for the Info..
    Now I change from date to yesterday's date and to date to tomorrow's date. an the ntried to update.
    but its showing Error:-- Could not update the scheduling. The agent may not be running
    java.lang.NullPointerException

    Then I closed Designer,Topology everything and opened and tested the agent it is running successfully.
    So i didnt understand why this error is coming instead of showing the scheduled jon in scheduling Information from the Physical Agent.

    Please help.
  • 8. Re: Agent Schedular not working
    SH Guru
    Currently Being Moderated
    If you open windows services what does your entry for your agent scheduler service say? please post entry as displayed
  • 9. Re: Agent Schedular not working
    user544069 Newbie
    Currently Being Moderated
    I could not find the Service name in the running sevices.
    With what name it should run. there is no service named agentschedular.
    I closed the window and run the comand again :-- agentscheduler.sh -PORT=20910 -NMAE=PHYSICAL_AGENT -v=5
    and after that i started the agent again.
    But agentschedular i ran with port 20910 and my agent port is also 20910...will this create any problem....
    This time after runnign Agentschedular i m gettign the below error in command prompt now ---


    11/20/2012 01:58:25 PM(DwgCmdExecutionThread): 10 - 43 -
    C
    11/20/2012 01:58:25 PM(DwgCmdExecutionThread): 11 - 4b -
    K
    11/20/2012 01:58:25 PM(DwgCmdExecutionThread): DwgCmdNetworkCall : Command Prepa
    rion
    11/20/2012 01:58:25 PM(DwgCmdExecutionThread): DwgCmdNetworkCall : Command Prepa
    rion OK
    11/20/2012 01:58:25 PM(DwgCmdExecutionThread): DwgCmdNetworkCall : Before Prepar
    e Prepare Command Ack
    11/20/2012 01:58:25 PM(DwgCmdExecutionThread): DwgCmdNetworkCall : Prepare Prepa
    re Command Ack sent !
    11/20/2012 01:58:25 PM(DwgCmdExecutionThread): DwgCmdNetworkCall : Berfore Execu
    te Command
    11/20/2012 01:58:25 PM(DwgCmdExecutionThread): DwgCmdNetworkCall : Commande Exec
    uted
    11/20/2012 01:58:25 PM(DwgCmdExecutionThread): Send frame:
    Index - Byte (hex) - Car.
    11/20/2012 01:58:25 PM(DwgCmdExecutionThread): 0 - 24 -

    Please let me know what message it should give after starting schedularagent.bat if some scenarios are scheduled ..

    After that i tested agent it is successful
    and I am able to update the schedular .it is showing planning update is completed.
    Please let me know if you need any more information.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points