Delphix Toolkits (dxToolkit and dxmToolkit)

 View Only
Expand all | Collapse all

Hi Getting below error while running dx_get_instance

  • 1.  Hi Getting below error while running dx_get_instance

    Posted 4 days ago

    Use of uninitialized value $refrence in hash element at /tmp/par-6f7261636c65/cache-5c65fea96caa2d6ea912826d31ea485a7fedd7db/inc/lib/Databases.pm line 327.
    Can't call method "getInstances" on an undefined value at script/dx_get_instance.pl line 145.



    ------------------------------
    Syed Rahil Akil Shahi
    Delphix Community Members
    ------------------------------


  • 2.  RE: Hi Getting below error while running dx_get_instance

    Posted 4 days ago

    Hello,

    Can you provide more information?

    What version of dxtoolkit are you using?

    What was the full command line you executed?

    Thanks,

    Neal



    ------------------------------
    Neal Stack
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------



  • 3.  RE: Hi Getting below error while running dx_get_instance

    Posted 4 days ago

    dxtoolkit-2.4.24.2

    [oracle@ttraflocoe04n01 dxtoolkit2 ]$ ./dx_get_instance | grep -i dtraflocodel
    Use of uninitialized value $refrence in hash element at /tmp/par-6f7261636c65/cache-5c65fea96caa2d6ea912826d31ea485a7fedd7db/inc/lib/Databases.pm line 327.
    Can't call method "getInstances" on an undefined value at script/dx_get_instance.pl line 145.
    [oracle@ttraflocoe04n01 dxtoolkit2 ]$



    ------------------------------
    Syed Rahil Akil Shahi
    Delphix Community Members
    ------------------------------



  • 4.  RE: Hi Getting below error while running dx_get_instance

    Posted 3 days ago

    Hello,

    Can you try running with the "-all" argument? For example:

    • ./dx_get_instance -all

    If I run it with no arguments, it does not seem to iterate through all of the entires in my "dxtools.conf" file.

    Thanks,

    Neal



    ------------------------------
    Neal Stack
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------



  • 5.  RE: Hi Getting below error while running dx_get_instance

    Posted 3 days ago

    same error

    [oracle@ttraflocoe04n01 dxtoolkit2 ]$ ./dx_get_instance -all
    Use of uninitialized value $refrence in hash element at /tmp/par-6f7261636c65/cache-5c65fea96caa2d6ea912826d31ea485a7fedd7db/inc/lib/Databases.pm line 327.
    Can't call method "getInstances" on an undefined value at script/dx_get_instance.pl line 145.
    [oracle@ttraflocoe04n01 dxtoolkit2 ]$



    ------------------------------
    Syed Rahil Akil Shahi
    Delphix Community Members
    ------------------------------



  • 6.  RE: Hi Getting below error while running dx_get_instance

    Posted 2 days ago

    Hi Syed,

    If I understand the code correctly where it is throwing the exception ( https://github.com/delphix/dxtoolkit/blob/49814dd4546ad4a84d546d787498f72748000b50/bin/dx_get_instance.pl#L145 ), it has gotten a list of Delphix Engines from your "conf" file and then it is trying to fetch the Oracle instances via the getInstances() function.

    Can you run the command with the "-engine" argument and specify each Delphix Engine from the conf file individually to narrow down the problematic one?

    Another thing you could do is run with the "-debug 3" argument and capture the output to a file. We can see what might be returned that is causing the issue.

    Thanks,

    Neal



    ------------------------------
    Neal Stack
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------



  • 7.  RE: Hi Getting below error while running dx_get_instance

    Posted 2 days ago

    delphix engine dtraflocodel12 has problem

    [oracle@ttraflocoe04n01 dxtoolkit2 ]$ ./dx_get_instance -engine dtraflocodel12
    Use of uninitialized value $refrence in hash element at /tmp/par-6f7261636c65/cache-5c65fea96caa2d6ea912826d31ea485a7fedd7db/inc/lib/Databases.pm line 327.
    Can't call method "getInstances" on an undefined value at script/dx_get_instance.pl line 145.
    [oracle@ttraflocoe04n01 dxtoolkit2 ]$



    ------------------------------
    Syed Rahil Akil Shahi
    Delphix Community Members
    ------------------------------



  • 8.  RE: Hi Getting below error while running dx_get_instance

    Posted 2 days ago

    Hello,

    Can you now run it with "-debug 3" and capture the output so we can see what value is being returned such that it is undefined value at script/dx_get_instance.pl line 145?

    Thanks,

    Neal



    ------------------------------
    Neal Stack
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------



  • 9.  RE: Hi Getting below error while running dx_get_instance

    Posted 2 days ago
    [oracle@ttraflocoe04n01 dxtoolkit2 ]$ ./dx_get_instance -engine dtraflocodel12 -debug 3
    Dxtoolkit version 2.4.24.2
    -Entering Engine::constructor
    -Entering Engine::load_config
    Loading engines from /app/dba/public/delphix/dxtoolkit-2.4.24.2/dxtoolkit2/dxtools.conf
     -Loading engine dtraflocodel01
     -Loading engine dtraflocodel02
     -Loading engine dtraflocodel03
     -Loading engine dtraflocodel04
     -Loading engine dtraflocodel05
     -Loading engine dtraflocodel06
     -Loading engine dtraflocodel07
     -Loading engine dtraflocodel08
     -Loading engine dtraflocodel09
     -Loading engine dtraflocodel99
     -Loading engine dtraflocodel10
     -Loading engine dtraflocodel11
     -Loading engine dtraflocodel12
     -Loading engine dtraflocodel15
     -Loading engine dtraflocodel13
     -Loading engine dtraflocodel14
     -Loading engine dtraflocodel98
    -Entering Engine::dlpx_connect
    -Login type: password
     -Cookie file /tmp/cookies.oracle.dtraflocodel12
    connecting to: dtraflocodel12 ( IP/name : 172.21.6.25 )
    -Entering Engine::getJSONResult
    -Entering Engine::getEngineName
    Session exists.
    -Entering Engine::getCurrentUser
    -Entering Engine::getJSONResult
    -Entering Engine::getEngineName
    -Entering Engine::getUsername
    -Entering Databases::constructor
    -Entering Source_obj::constructor
    -Entering Source_obj::getSourceList
    -Entering Engine::getJSONResult
    -Entering Engine::getEngineName
    -Entering SourceConfig_obj::constructor
    -Entering SourceConfig_obj::getSourceConfigList
    -Entering Engine::getJSONResult
    -Entering Engine::getEngineName
    -Entering Repository_obj::constructor
    -Entering Repository_obj::listRepositoryList
    -Entering Engine::getJSONResult
    -Entering Engine::getEngineName
    -Entering Environment_obj::constructor
    -Entering Environment_obj::getEnvironmentList
    -Entering Engine::getJSONResult
    -Entering Engine::getEngineName
    -Entering Engine::getJSONResult
    -Entering Engine::getEngineName
    -Entering Engine::getJSONResult
    -Entering Engine::getEngineName
    -Entering Environment_obj::listEnvironmentUsers
    -Entering Engine::getJSONResult
    -Entering Engine::getEngineName
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getPrimaryUser
    -Entering Environment_obj::getEnvironmentListeners
    -Entering Engine::getJSONResult
    -Entering Engine::getEngineName
    -Entering Host_obj::constructor
    -Entering Host_obj::loadHostList
    -Entering Engine::getJSONResult
    -Entering Engine::getEngineName
    -Entering Namespace_obj::constructor
    -Entering Namespace_obj::loadNamespaceList
    -Entering Engine::getJSONResult
    -Entering Engine::getEngineName
    -Entering Databases::LoadDBList
    -Entering Toolkit_obj.pm::constructor
    -Entering Toolkit_obj::LoadToolkit
    -Entering Engine::getJSONResult
    -Entering Engine::getEngineName
    -Entering Engine::getJSONResult
    -Entering Engine::getEngineName
    -Entering OracleVDB_obj::constructor
    -Entering VDB_obj::constructor
     -db name jupiter_dev99
     -source ref ORACLE_DB_CONTAINER-1442
    -Entering Source_obj::getSource
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getStaging
    -Entering Engine::getApi
     -config name - ORACLE_PDB_CONFIG-1560
     -Source config to assign
    -Entering SourceConfig_obj::getSourceConfig
     -$VAR1 = {
              'services' => [
                              {
                                'jdbcConnectionString' => 'jdbc:oracle:thin:@(DESCRIPTION=(ENABLE=broken)(ADDRESS=(PROTOCOL=tcp)(HOST=10.206.43.111)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=JUPC019_PDB23_01.global.trafigura.com)))',
                                'type' => 'OracleService',
                                'discovered' => bless( do{\(my $o = 1)}, 'JSON::PP::Boolean' )
                              }
                            ],
              'namespace' => undef,
              'databaseName' => 'JUPC019_PDB23_01',
              'user' => 'c##delphix_user',
              'repository' => 'ORACLE_INSTALL-21',
              'nonSysUser' => undef,
              'credentials' => {
                                 'type' => 'PasswordCredential',
                                 'password' => '********'
                               },
              'environmentUser' => 'HOST_USER-16',
              'type' => 'OraclePDBConfig',
              'cdbConfig' => 'ORACLE_SINGLE_CONFIG-678',
              'nonSysCredentials' => undef,
              'name' => 'JUPC019_PDB23_01',
              'linkingEnabled' => $VAR1->{'services'}[0]{'discovered'},
              'discovered' => $VAR1->{'services'}[0]{'discovered'},
              'reference' => 'ORACLE_PDB_CONFIG-1560'
            };
     
    -Entering SourceConfig_obj::getSourceConfig
    -Entering SourceConfig_obj::getRepository
     -repository name - ORACLE_INSTALL-21
    -Entering Repository_obj::getRepository
    -Entering Repository_obj::getEnvironment
     -environment name - UNIX_HOST_ENVIRONMENT-14
    -Entering Environment_obj::getEnvironment
    -Entering Environment_obj::getHost
     -host name - UNIX_HOST-30
    -Entering Host_obj::getHost
    -Entering VDB_obj::getDBType
    -Entering OracleVDB_obj::getInstances
    -Entering OracleVDB_obj::getCDBContainerRef
    -Entering Source_obj::getSourceByConfig
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi



    ------------------------------
    Syed Rahil Akil Shahi
    Delphix Community Members
    ------------------------------



  • 10.  RE: Hi Getting below error while running dx_get_instance

    Posted 2 days ago

    Hello,

    I don't see any errors in the output you posted. The "-debug 3" flag should create a "debug.log" and some indvidual debug directories for each Delphix Engine. For example:

    drwxr-xr-x  20 neal.stack  staff       640 Apr 16 09:58 debug_mars
    drwxr-xr-x  10 neal.stack  staff       320 Apr 16 09:58 debug_masking
    drwxr-xr-x  20 neal.stack  staff       640 Apr 16 09:59 debug_saturn
    -rw-r--r--   1 neal.stack  staff    280915 Apr 16 09:59 debug.log
    drwxr-xr-x  10 neal.stack  staff       320 Apr 16 09:59 debug_venus

    Can you zip up the debug.log and directory for the problematic engine and email it to me (neal dot stack at perforce dot com)?

    Thanks,

    Neal



    ------------------------------
    Neal Stack
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------



  • 11.  RE: Hi Getting below error while running dx_get_instance

    Posted 2 days ago

    Hi Neal, The debug is running in the problematic engine from last 1 hrs with the below output.

    Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others
    -Entering Source_obj::getSourceConfig
    -Entering Engine::getApi
    -Entering Engine::getApi
     -getSourceConfig - API >= 1.11.12 - others



    ------------------------------
    Syed Rahil Akil Shahi
    Delphix Community Members
    ------------------------------



  • 12.  RE: Hi Getting below error while running dx_get_instance

    Posted 2 days ago

    Hello,

    Do you mean it is just hanging?

    Is it not writing debug log directories/files as I illustrated?

    Thanks,

    Neal



    ------------------------------
    Neal Stack
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------