10 Replies Latest reply on Jul 12, 2020 7:31 PM by Adrian_Popescu-Oracle

    ODI Domain Creation Using Python Script Failed - Encountered exceptions in retrieving the schema component data from database server

    4080076

      I am using a Python script to create in silent mode ODI domain for Standalone agent but I am getting an error message

       

      2020-07-06 13:39:04,550 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - succeed: set obj12 attribute Value to "TST_STB"

      2020-07-06 13:39:04,554 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - create Machine(UnixMachine) "LocalODIMachine" as obj13

      2020-07-06 13:39:04,563 INFORMATION [1] com.oracle.cie.domain.assignment.impl.AssignmentServiceInternalImpl - Notifying listeners about AssignmentServiceEvent{type=DOMAIN_UPDATED}

      2020-07-06 13:39:04,564 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - succeed: create Machine(UnixMachine) "LocalODIMachine" as obj13

      2020-07-06 13:39:04,572 WARNUNG [1] com.oracle.cie.domain.aspect.XBeanConfigAspect - Unable to locate property:Machines on type:class com.oracle.cie.domain.xml.configxb.impl.DomainTypeImpl

      2020-07-06 13:39:04,572 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - find Machines "LocalODIMachine" as obj14

      2020-07-06 13:39:04,578 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - create Machine!NodeManager "LocalODIMachine!LocalODIMachine" as obj15

      2020-07-06 13:39:04,602 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - succeed: create Machine!NodeManager "LocalODIMachine!LocalODIMachine" as obj15

      2020-07-06 13:39:04,608 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - set obj15 attribute ListenAddress to "dev_unix_server"

      2020-07-06 13:39:04,613 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - succeed: set obj15 attribute ListenAddress to "dev_unix_server"

      2020-07-06 13:39:04,614 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - set obj15 attribute ListenPort to "5556"

      2020-07-06 13:39:04,622 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - succeed: set obj15 attribute ListenPort to "5556"

      2020-07-06 13:39:04,623 WARNUNG [1] com.oracle.cie.domain.aspect.XBeanConfigAspect - Unable to locate property:Servers on type:class com.oracle.cie.domain.xml.configxb.impl.DomainTypeImpl

      2020-07-06 13:39:04,623 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - find Servers "AdminServer" as obj16

      2020-07-06 13:39:04,633 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - set obj3 attribute Machine to "LocalODIMachine"

      2020-07-06 13:39:04,653 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - succeed: set obj3 attribute Machine to "LocalODIMachine"

      2020-07-06 13:39:04,654 WARNUNG [1] com.oracle.cie.domain.aspect.XBeanConfigAspect - Unable to locate property:Servers on type:class com.oracle.cie.domain.xml.configxb.impl.DomainTypeImpl

      2020-07-06 13:39:04,654 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - find Servers "ODI_server1" as obj17

      2020-07-06 13:39:04,655 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - find Server "ODI_server1" as obj18

      2020-07-06 13:39:04,657 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - succeed: find Server "ODI_server1" as obj18

      2020-07-06 13:39:04,658 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - set obj18 attribute Machine to "LocalODIMachine"

      2020-07-06 13:39:04,673 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - succeed: set obj18 attribute Machine to "LocalODIMachine"

      2020-07-06 13:39:04,674 WARNUNG [1] com.oracle.cie.domain.aspect.XBeanConfigAspect - Unable to locate property:Servers on type:class com.oracle.cie.domain.xml.configxb.impl.DomainTypeImpl

      2020-07-06 13:39:04,676 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - find Servers "ODI_server1" as obj19

      2020-07-06 13:39:04,678 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - set obj18 attribute ListenAddress to "dev_unix_server"

      2020-07-06 13:39:04,689 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - succeed: set obj18 attribute ListenAddress to "dev_unix_server"

      2020-07-06 13:39:04,689 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - set obj18 attribute ListenPort to "20913"

      2020-07-06 13:39:04,707 INFORMATION [1] com.oracle.cie.domain.script.ScriptExecutor - succeed: set obj18 attribute ListenPort to "20913"

      2020-07-06 13:39:06,660 SCHWERWIEGEND [1] com.oracle.cie.domain.script.ScriptExecutor - Unable to execxute getDatabaseDefaults

      com.oracle.cie.common.CommonException: Encountered exceptions in retrieving the schema component data from database server:

      Root Cause: com.oracle.cie.rcu.external.ComponentSchemaInfoException: SQLException thrown

          at com.oracle.cie.domain.jdbc.CommonDBHelper.bindShadowTableData(CommonDBHelper.java:709)

          at com.oracle.cie.domain.script.ScriptExecutor.getDatabaseDefaults(ScriptExecutor.java:40

       

       

       

      The respective py script contains this code:

       

      ls('/SecurityConfiguration');

      cd('/SecurityConfiguration/'+'odi_standalone_domain') # domain is odi_standalone_domain until saved as otherwise

      cmo.setUseKSSForDemo(false)

       

      #create(agent_machine, 'Machine'); # exists in the template

      cd('/Machine/' + agent_machine);

      create(agent_machine, 'NodeManager');

      cd('NodeManager/' + agent_machine);

      set('ListenAddress', host_name);

       

      # domain creation will fail if there is no user in the Admin group.

      createWLSUser('odi_standalone_domain', wls_user, wls_pass); # domain is odi_standalone_domain until saved as otherwise

      createDataSource('LocalSvcTblDataSource', service_db_user, service_db_pass, service_db_url, service_db_driver);

      #createDataSource(master_db_datasource, master_db_user, master_db_pass, master_db_url, master_db_driver);

      createODIInstance(odi_instance, agent_machine, odi_listen_address, odi_port, odi_supervisor, odi_supervisor_pass, master_db_datasource)

      getDatabaseDefaults(); # service_db, master_db, (and opss) definitions from service_db

       

       

      Any reason for such error?