12 Replies Latest reply: Apr 4, 2014 8:04 AM by Phanikanth RSS

    Agent Error - ODI-1436

    2645038

      Hi!!

       

      When i lunch my odi angent, i got this error:

       

      2014-04-01 16:21:13.442 NOTIFICATION ODI-1128 Agent VFQA_MainAgent is starting. Container: STANDALONE. Agent Version: 11.1.1.7.0 - 02/03/2013. Port: 10910. JMX Port: 11910.

      2014-04-01 16:21:26.621 WARNING ODI-1436 Error retrieving ID statistics for repository WORKREP.

      2014-04-01 16:21:26.642 NOTIFICATION ODI-1111 Agent VFQA_MainAgent started. Agent version: 11.1.1.7.0 - 02/03/2013. Port: 10910. JMX Port: 11910.

      2014-04-01 16:21:26.643 NOTIFICATION ODI-1136 Starting Schedulers on Agent VFQA_MainAgent.

      2014-04-01 16:21:27.004 WARNING agent.scheduler.pingAgent.failed

      2014-04-01 16:21:27.016 WARNING Agent is not reachable. Going to retry after inteval :30000

       

       

      I already change my odiparams.sh file and it had this information:

       

      if [ -z "${ODI_INSTANCE_HOME}" ]; then

      ODI_SECU_WORK_REP=WORKREP

      ODI_USER=SUPERVISOR

      ODI_ENCODED_PASS=aIyHwTdVQxEq12dJ4U.y

      ODI_MASTER_DRIVER=oracle.jdbc.driver.OracleDriver

      ODI_MASTER_URL=jdbc:oracle:thin:@172.21.24.10:1527:orcl

      ODI_MASTER_USER=DEV_ODI_REPO

      ODI_MASTER_ENCODED_PASS=d2yH.tJX52aoL851nuNeWE3g

      ODI_SUPERVISOR=SUPERVISOR

      ODI_SUPERVISOR_ENCODED_PASS=aIyHwTdVQxEq12dJ4U.y

       

      What am i doing wrong?

       

      Many thanks

      Carlos Nunes

        • 1. Re: Agent Error - ODI-1436
          $anty

          Hi Carlos,

           

            Can you paste the complete error log?

            Also try changing WORKREP to WORKREP1.

           

          Regards,

          Santy

          • 2. Re: Agent Error - ODI-1436
            2645038

            Hi Santy!!

             

            Of course!

             

            Here the entire log.

             

            [oracle@obieesample bin]$ ./agent.sh -NAME=VFQA_MainAgent -PORT=10910

            2014-04-01 17:15:49.473 NOTIFICATION ODI-1128 Agent VFQA_MainAgent is starting. Container: STANDALONE. Agent Version: 11.1.1.7.0 - 02/03/2013. Port: 10910. JMX Port: 11910.

            2014-04-01 17:16:02.229 WARNING ODI-1436 Error retrieving ID statistics for repository WORKREP.

            2014-04-01 17:16:02.235 NOTIFICATION ODI-1111 Agent VFQA_MainAgent started. Agent version: 11.1.1.7.0 - 02/03/2013. Port: 10910. JMX Port: 11910.

            2014-04-01 17:16:02.237 NOTIFICATION ODI-1136 Starting Schedulers on Agent VFQA_MainAgent.

            2014-04-01 17:16:02.608 WARNING agent.scheduler.pingAgent.failed

            2014-04-01 17:16:02.641 WARNING Agent is not reachable. Going to retry after inteval :30000

            2014-04-01 17:16:32.669 WARNING agent.scheduler.pingAgent.failed

            2014-04-01 17:16:32.675 WARNING Agent is not reachable. Going to retry after inteval :30000

            2014-04-01 17:17:02.697 WARNING agent.scheduler.pingAgent.failed

            2014-04-01 17:17:02.701 WARNING Agent is not reachable. Going to retry after inteval :30000

             

            ....

             

            I Change de ODI_SECU_WORK_REP=WORKREP to ODI_SECU_WORK_REP=WORKREP1 but i got the same result

             

            Thanks!

            • 3. Re: Agent Error - ODI-1436
              $anty
              2014-04-01 17:16:02.229 WARNING ODI-1436 Error retrieving ID statistics for repository WORKREP.

                  You should try changing WORKREP to WORKREP1 from ODI Studio as well, under Physical & Logical architecture.

                   Are all ODI components on same machine?

               

              Regards,

              Santy 

                

              • 4. Re: Agent Error - ODI-1436
                2645038

                Got the same error.

                 

                [oracle@obieesample bin]$ ./agent.sh -NAME=VFQA_MainAgent -PORT=10910

                2014-04-01 17:56:17.633 NOTIFICATION ODI-1128 Agent VFQA_MainAgent is starting. Container: STANDALONE. Agent Version: 11.1.1.7.0 - 02/03/2013. Port: 10910. JMX Port: 11910.

                2014-04-01 17:56:32.802 WARNING ODI-1436 Error retrieving ID statistics for repository WORKREP1.

                2014-04-01 17:56:32.808 NOTIFICATION ODI-1111 Agent VFQA_MainAgent started. Agent version: 11.1.1.7.0 - 02/03/2013. Port: 10910. JMX Port: 11910.

                2014-04-01 17:56:32.811 NOTIFICATION ODI-1136 Starting Schedulers on Agent VFQA_MainAgent.

                2014-04-01 17:56:33.186 WARNING agent.scheduler.pingAgent.failed

                2014-04-01 17:56:33.188 WARNING Agent is not reachable. Going to retry after inteval :30000

                 

                I've DB, a ODI server and Agent in one machine, and ODI studio in other machine.

                • 5. Re: Agent Error - ODI-1436
                  2645038

                  Any Idea? I don't know what to do

                  • 6. Re: Agent Error - ODI-1436
                    Phanikanth

                    Hi

                     

                    Please configured the below environment variable and try for testing youe ODI Agent

                     

                    ODI_JAVA_HOME=JDK path

                    JAVA_HOME= JDK path

                     

                    for eg:

                     

                       your JDK placed at  /java\JDK1.6.0_39

                     

                    export ODI_JAVA_HOME= /java\JDK1.6.0_39

                    export JAVA_HOME=  /java\JDK1.6.0_39

                     

                    Regards,

                    Phanikanth

                    • 7. Re: Agent Error - ODI-1436
                      2645038

                      Hi!!

                       

                      Got the same error.. I Will show you all the odiparams.sh

                       

                      #!/bin/sh

                      #

                      # Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

                      #

                      # PRODUCT

                      #   Oracle Data Integrator

                      #

                      # FILENAME

                      #   odiparams.sh

                      #

                      # DESCRIPTION

                      #   Configuration script. This script contains the parameters for starting

                      #   Oracle Data Integrator modules.

                      #

                      # VARIABLES DESCRIPTION

                      #

                      # The following variables should be configured in order to run operations

                      # requiring a repository connection (agent, agentstop, startscen, agentscheduler, etc.)

                      #

                      #   ODI_MASTER_DRIVER

                      #       JDBC driver used to connect the Master Repository.

                      #   ODI_MASTER_URL

                      #       JDBC URL used to connect the Master Repository.

                      #   ODI_MASTER_USER

                      #       Database account used to connect the Master Repository.

                      #   ODI_MASTER_ENCODED_PASS

                      #       Database account password. The password must be encoded with the

                      #       "encode.[sh|bat] <password>" command.

                      #

                      # The following variables should be configured.  They are user credentials

                      # used only by the agent startup program.

                      #

                      #   ODI_SUPERVISOR

                      #       OracleDI supervisor user name.

                      #   ODI_SUPERVISOR_ENCODED_PASS

                      #       OracleDI supervisor user password. The password must be encoded with the

                      #       "encode.[sh|bat] <password>" command.

                      #

                      # The following variables should be configured.  They are user credentials

                      # for all the tools (e.g. startscen, restartsession, agentstop, startcmd, etc.)

                      #

                      #   ODI_USER

                      #       OracleDI user used to launch a scenario.

                      #   ODI_ENCODED_PASS

                      #       OracleDI user password. The password must be encoded with the

                      #       "encode.[sh|bat] <password>" command.

                      #

                      # The following variables are required if HTTPS protocol is selected as incoming

                      # listening protocol on the ODI agent. All passwords must be encoded with the

                      # "encode.[sh|bat] <password>" command.

                      #

                      #   ODI_KEYSTORE_ENCODED_PASS

                      #       Keystore password, its value is mandatory.

                      #   ODI_KEY_ENCODED_PASS

                      #       Key password, its value is optional.

                      #   ODI_TRUSTSTORE_ENCODED_PASS

                      #       Truststore password, its value is optional.

                      # Additionally, -Djavax.net.ssl.keyStore, -Djavax.net.ssl.keyStoreType -Djavax.net.ssl.trustStore

                      # and -Djavax.net.ssl.trustStoreType may be configured through ODI_JAVA_OPTIONS variable.

                      #

                      # The following work repository name variable is required by startcmd (when the specified

                      # command needs to connects to the work repository), startscen, and restartsession scripts.

                      # The agent startup and agentstop programs do not need this variable.

                      #

                      #   ODI_SECU_WORK_REP

                      #       Name of the Work Repository to connect. This Work Repository must

                      #       be attached to the master repository.

                      #

                      # The following variables can be changed to tune OracleDI configuration.

                      #

                      #   ODI_INIT_HEAP

                      #       Initial java machine heap size used by OracleDI modules.

                      #   ODI_MAX_HEAP

                      #       Maximum java machine heap size used by OracleDI modules.

                      #   ODI_JAVA_HOME

                      #       Installation directory of the java virtual machine used for

                      #       OracleDI.

                      #   ODI_ADDITIONAL_JAVA_OPTIONS

                      #       Additional Java options, such as -Duser.language or -Duser.country.

                      #   ODI_ADDITIONAL_CLASSPATH

                      #       Classpath for additional classes (HP-UX Only)

                      #   ODI_HOME

                      #       Set this environment variable separately. If it is unset, the script can

                      #       be launched only from the ./bin directory. If running the setup

                      #       program, this variable is automatically set.

                      #   ODI_CONNECTION_RETRY_COUNT

                      #       The number of retries to re-establish master or work repository

                      #       connections during connection failures. If set to 0, no retry will

                      #       be performed.

                      #   ODI_CONNECTION_RETRY_DELAY

                      #       Time in milliseconds between the retries of master or work

                      #       repository connections.

                      #   ODI_JMX_PROTOCOL

                      #       Protocol used to access the ODI MBeans, its value can be either

                      #       rmi or iiop

                      #

                      # Other variables should be left unchanged.

                      #

                       

                       

                      #

                      # To check if INSTANCE parameter is passed or not

                      #

                             instance_check=`echo "${1}"|cut -f 1 -d '='`

                             if [ "$instance_check" = "-INSTANCE" ]; then

                                          ODI_INSTANCE_HOME=`echo "${1}"| cut -f 2 -d '='`

                                          export ODI_INSTANCE_HOME

                             fi

                       

                       

                      # Repository Connection Information

                       

                       

                      if [ -z "${ODI_INSTANCE_HOME}" ]; then

                       

                       

                       

                       

                      ODI_SECU_WORK_REP=WORKREP

                       

                       

                      ODI_USER=SUPERVISOR

                      ODI_ENCODED_PASS=aIyHwTdVQxEq12dJ4U.y

                       

                       

                      ODI_MASTER_DRIVER=oracle.jdbc.driver.OracleDriver

                      ODI_MASTER_URL=jdbc:oracle:thin:@172.21.24.10:1527:orcl

                      ODI_MASTER_USER=DEV_ODI_REPO

                      ODI_MASTER_ENCODED_PASS=d2yH.tJX52aoL851nuNeWE3g

                       

                       

                      #

                      # User credentials for agent startup program

                      #

                      ODI_SUPERVISOR=SUPERVISOR

                      ODI_SUPERVISOR_ENCODED_PASS=aIyHwTdVQxEq12dJ4U.y

                       

                       

                      #

                      # Keystore/Truststore credentials

                      #

                      ODI_KEYSTORE_ENCODED_PASS=

                      ODI_KEY_ENCODED_PASS=

                      ODI_TRUST_STORE_ENCODED_PASS=

                       

                       

                       

                       

                       

                       

                       

                       

                      #

                      # Config file position

                      ODI_JPS_CONFIG=./jps-config.xml

                      ODI_LOGGING_CONF_FILE=./ODI-logging-config.xml

                       

                       

                      #

                      # Additional Java Options

                      #

                      ODI_ADDITIONAL_JAVA_OPTIONS=

                       

                       

                      else

                        . "$ODI_INSTANCE_HOME"/instance.sh

                        shift   #to avoid passing the INSTANCE argument.

                      fi

                       

                       

                      #

                      # Connection retry parameters

                      #

                      ODI_CONNECTION_RETRY_COUNT=0

                      ODI_CONNECTION_RETRY_DELAY=7000

                       

                       

                      #

                      # Java virtual machine

                      #

                      #ODI_JAVA_HOME=/usr/java/jdk1.7.0_17/

                       

                       

                      export ODI_JAVA_HOME=/usr/java/jdk1.7.0_17/

                      export JAVA_HOME=/usr/java/jdk1.7.0_17/

                       

                       

                      #

                      # Other Parameters

                      #

                      ODI_INIT_HEAP=32m

                      ODI_MAX_HEAP=256m

                      ODI_JMX_PROTOCOL=rmi

                       

                       

                      # HP-UX users : Any package files added to the /drivers

                      # or /lib/scripting directory should be manually declared in the

                      # ODI_ADDITIONAL_CLASSPATH variable

                      if [ -z "$ODI_ADDITIONAL_CLASSPATH" ]; then

                        ODI_ADDITIONAL_CLASSPATH=

                      fi

                      # ODI_ADDITIONAL_CLASSPATH=$ODI_ADDITIONAL_CLASSPATH:/mydir/myfile.jar

                       

                       

                       

                       

                      # DO NOT EDIT BELOW THIS LINE !

                      # ----------------------------------------------------------------------------

                       

                       

                      umask 026

                       

                       

                      ODI_JAVA_EXE=$ODI_JAVA_HOME/bin/java

                      ODI_JAVAW_EXE=$ODI_JAVA_HOME/bin/java

                      ODI_JAVAC_EXE=$ODI_JAVA_HOME/bin/javac

                       

                       

                      # Testing the java virtual machine

                       

                       

                      if [ ! -x $ODI_JAVA_EXE ]; then

                        echo "The Java Virtual Machine was not found at the following location: $ODI_JAVA_HOME"

                        echo "The ODI_JAVA_HOME environment variable is not defined correctly."

                        echo "Please set this variable in odiparams.sh."

                      fi

                       

                       

                      if [ ! -x $ODI_JAVAC_EXE ]; then

                        echo "A JDK is required to execute Web Services with OracleDI. You are currently using a JRE."

                      fi

                       

                       

                      if [ "$ODI_HOME" = "" ]; then

                          ODI_HOME=..

                          export ODI_HOME

                      fi

                       

                       

                      # Change the current directory to $ODI_HOME/bin

                      cd "$ODI_HOME"/bin

                       

                       

                      # default classpath

                      # Note that it is important that the lib directory is first on the classpath.This is to ensure

                      # that any resources such as common-logging.properties will be picked up from this directory

                      ODI_CLASSPATH=$ODI_HOME/lib/.:$ODI_HOME/drivers/.

                      #

                      # Dynamic construction of the classpath for the JDBC drivers and scripting engines.

                      # To add a new driver or scripting engine, simple copy the .jar or .zip file to

                      # the $ODI_HOME/drivers or $ODI_HOME/lib/scripting directory.

                      #

                      if [ "OS400" = "`uname`" ]; then

                         # Expand *.jar classpaths explicitly, as Jdk6 on OS400 platform does not handle wildcard classpaths.

                         # User can also define ODI_EXPAND_CLASSPATH=true to force classpath expansion on other platforms.

                         ODI_EXPAND_CLASSPATH=true

                      fi

                       

                       

                      for a in $* ; do

                        al=`echo $a | wc -c`

                        b=`echo $a | sed 's%^..%-D%'`

                        if [  "$b" = "$a" ] ; then

                              if [ "$al" -gt 3 ] ; then

                                      ODI_ADDITIONAL_JAVA_OPTIONS="$ODI_ADDITIONAL_JAVA_OPTIONS $a"

                              fi

                        fi

                      done

                       

                       

                      for i in "$ODI_HOME"/../../odi_misc/*.zip; do

                         ODI_CLASSPATH=$ODI_CLASSPATH:$i

                      done

                      if [ "$ODI_EXPAND_CLASSPATH" = "true" ]; then

                         for i in "$ODI_HOME"/../../odi_misc/*.jar; do

                            ODI_CLASSPATH=$ODI_CLASSPATH:$i

                         done

                      else

                         ODI_CLASSPATH=$ODI_CLASSPATH:$ODI_HOME/../../odi_misc/*

                      fi

                       

                       

                      for i in "$ODI_HOME"/lib/*.zip; do

                        ODI_CLASSPATH=$ODI_CLASSPATH:$i

                      done

                       

                       

                      ODI_CLASSPATH=$ODI_CLASSPATH:$ODI_HOME/lib/oracle.odi-agent-jse_11.1.1.jar

                      ODI_CLASSPATH=$ODI_CLASSPATH:$ODI_HOME/../../setup/manual/oracledi-sdk/oracle.odi-sdk-jse_11.1.1.jar

                      ODI_CLASSPATH=$ODI_CLASSPATH:$ODI_HOME/../../modules/oracle.jps_11.1.1/jps-manifest.jar

                       

                       

                      for i in "$ODI_HOME"/drivers/*.zip; do

                        ODI_CLASSPATH=$ODI_CLASSPATH:$i

                      done

                      if [ "$ODI_EXPAND_CLASSPATH" = "true" ]; then

                         for i in "$ODI_HOME"/drivers/*.jar; do

                            ODI_CLASSPATH=$ODI_CLASSPATH:$i

                         done

                      else

                         ODI_CLASSPATH=$ODI_CLASSPATH:$ODI_HOME/drivers/*

                      fi

                       

                       

                      for i in "$ODI_HOME"/lib/scripting/*.zip; do

                        ODI_CLASSPATH=$ODI_CLASSPATH:$i

                      done

                      if [ "$ODI_EXPAND_CLASSPATH" = "true" ]; then

                         for i in "$ODI_HOME"/lib/scripting/*.jar; do

                            ODI_CLASSPATH=$ODI_CLASSPATH:$i

                         done

                      else

                          ODI_CLASSPATH=$ODI_CLASSPATH:$ODI_HOME/lib/scripting/*

                      fi

                       

                       

                      ODI_CLASSPATH=$ODI_CLASSPATH:$ODI_ADDITIONAL_CLASSPATH

                      ODI_PARAMS_JAVA_OPTION="-DODI_MASTER_DRIVER=$ODI_MASTER_DRIVER -DODI_MASTER_URL=$ODI_MASTER_URL -DODI_MASTER_USER=$ODI_MASTER_USER -DODI_MASTER_ENCODED_PASS=$ODI_MASTER_ENCODED_PASS -DODI_SECU_WORK_REP=$ODI_SECU_WORK_REP -DODI_SUPERVISOR=$ODI_SUPERVISOR -DODI_SUPERVISOR_ENCODED_PASS=$ODI_SUPERVISOR_ENCODED_PASS -DODI_USER=$ODI_USER -DODI_ENCODED_PASS=$ODI_ENCODED_PASS -DODI_JMX_PROTOCOL=$ODI_JMX_PROTOCOL"

                      ODI_JAVA_OPTIONS="-Doracle.security.jps.config=$ODI_JPS_CONFIG $ODI_PARAMS_JAVA_OPTION"

                      ODI_LOG_OPTIONS="-Dorg.mortbay.log.class=oracle.odi.logging.AgentJettyLogger -Doracle.core.ojdl.logging.config.file=$ODI_LOGGING_CONF_FILE -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration"

                      ODI_JAVAW_START0="$ODI_JAVA_EXE -Xms$ODI_INIT_HEAP -Xmx$ODI_MAX_HEAP $ODI_JAVA_OPTIONS $ODI_ADDITIONAL_JAVA_OPTIONS $ODI_LOG_OPTIONS"

                      ODI_JAVA_START0="$ODI_JAVA_EXE -Xms$ODI_INIT_HEAP -Xmx$ODI_MAX_HEAP $ODI_JAVA_OPTIONS $ODI_ADDITIONAL_JAVA_OPTIONS $ODI_LOG_OPTIONS"

                      ODI_JAVAW_START="$ODI_JAVAW_START0 -classpath $ODI_CLASSPATH"

                      ODI_JAVA_START="$ODI_JAVA_START0 -classpath $ODI_CLASSPATH"

                      ODI_REPOSITORY_PARAMS="-MASTER_DRIVER=$ODI_MASTER_DRIVER -MASTER_URL=$ODI_MASTER_URL -MASTER_USER=$ODI_MASTER_USER -MASTER_ENCODED_PASS=$ODI_MASTER_ENCODED_PASS -WORK_REPOSITORY=$ODI_SECU_WORK_REP -ODI_SUPERVISOR=$ODI_SUPERVISOR -ODI_SUPERVISOR_ENCODED_PASS=$ODI_SUPERVISOR_ENCODED_PASS -ODI_USER=$ODI_USER -ODI_ENCODED_PASS=$ODI_ENCODED_PASS -ODI_CONNECTION_RETRY_COUNT=$ODI_CONNECTION_RETRY_COUNT -ODI_CONNECTION_RETRY_DELAY=$ODI_CONNECTION_RETRY_DELAY -ODI_KEYSTORE_ENCODED_PASS=$ODI_KEYSTORE_ENCODED_PASS -ODI_KEY_ENCODED_PASS=$ODI_KEY_ENCODED_PASS -ODI_TRUST_STORE_ENCODED_PASS=$ODI_TRUST_STORE_ENCODED_PASS"

                       

                       

                      export ODI_HOME

                      export ODI_JAVA_HOME ODI_JAVA_EXE ODI_JAVAW_EXE

                      export ODI_CLASSPATH

                      export ODI_MASTER_DRIVER ODI_MASTER_URL ODI_MASTER_USER ODI_MASTER_ENCODED_PASS ODI_SECU_WORK_REP ODI_SUPERVISOR ODI_SUPERVISOR_ENCODED_PASS ODI_USER ODI_ENCODED_PASS

                      export ODI_INIT_HEAP ODI_MAX_HEAP ODI_JAVA_OPTIONS ODI_JMX_PROTOCOL

                      export ODI_JAVAW_START ODI_JAVA_START ODI_REPOSITORY_PARAMS

                       

                       

                      Thanks

                      Carlos Nunes

                      • 8. Re: Agent Error - ODI-1436
                        Sh!va

                        Hi Carlos,

                         

                        Is the agent and java is on same mount point??

                         

                        Also, can you give the OS version...A quick test as per error, i can do is take the backup of master repository and odiparam.sh file and try to create now work repository..just to make sure we have proper link between both repository...

                         

                        Cheers!

                         

                        Sh!va

                        • 9. Re: Agent Error - ODI-1436
                          Phanikanth

                          Hi

                           

                          Type below command and see is it giving same jdk1.7.0_17 version

                           

                          java -version

                           

                          Regards,

                          Phanikanth

                          • 10. Re: Agent Error - ODI-1436
                            2645038

                            Hi!!

                             

                            When i typed java -version i got.

                             

                            java version "1.7.0_17"

                            Java(TM) SE Runtime Environment (build 1.7.0_17-b02)

                            Java HotSpot(TM) 64-Bit Server VM (build 23.7-b01, mixed mode)

                             

                             

                            And yes, the agent is mounted in same mount point.

                             

                            My O.S Version

                             

                            Enterprise Linux Enterprise Linux Server release 5.9 (Carthage)

                            Oracle Linux Server release 5.9

                            Red Hat Enterprise Linux Server release 5.9 (Tikanga)

                             

                            Many Thanks!

                            Carlos Nunes

                            • 11. Re: Agent Error - ODI-1436
                              Sh!va

                              And by this you are sure that the id used to install is been used to start Agent and we have proper access permissions on all the important files and folders.

                               

                              I still feel something went wrong and Agent is unable to fetch the information of work repository from the master..

                               

                              Cheers!

                               

                              Sh!va

                              • 12. Re: Agent Error - ODI-1436
                                Phanikanth

                                HI

                                 

                                Is your DB RAC installed in your linux ?

                                 

                                Regards,

                                Phanikanth