Original Message:
Sent: 04-17-2025 03:33:52 AM
From: Syed Rahil Akil Shahi
Subject: Hi Getting below error while running dx_get_instance
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
Original Message:
Sent: 04-16-2025 11:15:06 AM
From: Neal Stack
Subject: Hi Getting below error while running dx_get_instance
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
Original Message:
Sent: 04-16-2025 09:48:42 AM
From: Syed Rahil Akil Shahi
Subject: Hi Getting below error while running dx_get_instance
[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
Original Message:
Sent: 04-16-2025 09:38:20 AM
From: Neal Stack
Subject: Hi Getting below error while running dx_get_instance
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
Original Message:
Sent: 04-16-2025 09:36:04 AM
From: Syed Rahil Akil Shahi
Subject: Hi Getting below error while running dx_get_instance
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
Original Message:
Sent: 04-16-2025 09:22:53 AM
From: Neal Stack
Subject: Hi Getting below error while running dx_get_instance
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
Original Message:
Sent: 04-16-2025 04:32:31 AM
From: Syed Rahil Akil Shahi
Subject: Hi Getting below error while running dx_get_instance
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
Original Message:
Sent: 04-15-2025 09:28:18 AM
From: Neal Stack
Subject: Hi Getting below error while running dx_get_instance
Hello,
Can you try running with the "-all" argument? For example:
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
Original Message:
Sent: 04-15-2025 01:33:55 AM
From: Syed Rahil Akil Shahi
Subject: Hi Getting below error while running dx_get_instance
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
Original Message:
Sent: 04-14-2025 12:37:21 PM
From: Neal Stack
Subject: Hi Getting below error while running dx_get_instance
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
Original Message:
Sent: 04-14-2025 12:19:37 PM
From: Syed Rahil Akil Shahi
Subject: Hi Getting below error while running dx_get_instance
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
------------------------------