I downloaded the zip file from Bob. I'm not quite sure what to make of the output as it seems significantly different than the "-debug 3" output I get when I run it in the lab environment:
neal.stack@Neal-Stacks-MacBook-Pro dxtoolkit2 % ./dx_get_dsourcesize -engine neal1800 -debug 3
Dxtoolkit version 2.4.20
-Entering Engine::constructor
-Entering Engine::load_config
Loading engines from /Users/neal.stack/Downloads/dxtoolkit2/dxtools.conf
-Loading engine neal1800
-Loading engine intact
-Loading engine Landshark2
# Delphix can automatically calculate the usage for Oracle, SQL Server and ASE databases for each Delphix Engine.
# For other databases, and before the source is connected to the Delphix Engine
# you will need to run a query on the source system for the relevant data.
-Entering Engine::dlpx_connect
-Login type: password
-Cookie file /var/folders/qs/t716yhb17bjct0t54jzwftyh0000gp/T/cookies.neal.stack.neal1800
connecting to: neal1800 ( IP/name : neal1800.dcol2.delphix.com )
-Entering Engine::getJSONResult
GET: http://neal1800.dcol2.delphix.com:80/resources/json/delphix/session
** GET http://neal1800.dcol2.delphix.com:80/resources/json/delphix/session ==> 200 OK (1s)
-Entering Engine::getEngineName
...etc...
I don't see any output like this in the files you provided so I am not sure what you did.
Original Message:
Sent: 01-12-2024 05:06:29 PM
From: Vijayender Singidi
Subject: dx_get_dsourcesize.exe returning dsource size in string format
Could pls check with Bob,Tener to have the logs shared with you from our box
\Box\Delphix (External from USAA)\Logs\dx_get_dsourcesize_debug3.zip
------------------------------
Vijayender Singidi
Original Message:
Sent: 01-12-2024 04:49:12 PM
From: Neal Stack
Subject: dx_get_dsourcesize.exe returning dsource size in string format
Hello,
That looks like the raw JSON output. I can't tell which one caused the problem without the "-debug 3" output and/or trying to narrow the problem down by excluding/including certain dSources using the filter.
If I had to guess the problem would be related to a plugin based dSource. I see your account has license for MSSQL Backup Ingestion plugin. I'm not sure if you specify a filter to specific dSources, you can narrow down which one is causing the problem.
Thanks,
Neal
------------------------------
Neal Stack
Senior Principal Technical Support Engineer
Delphix
Original Message:
Sent: 01-12-2024 04:42:34 PM
From: Vijayender Singidi
Subject: dx_get_dsourcesize.exe returning dsource size in string format
Hi Neal,
yes, we have MSSQL d-source , for those also having problem.
{
"results" : [
{
"Size [GB]" : " 0.18",
"Appliance" : "devdel6xsat",
"Env name" : "DEVSQL135W",
"Group" : "AMC1_Source",
"Enabled" : "enabled",
"Database" : "AdventureWorks",
"Status" : "RUNNING"
},
{
"Env name" : "DEVSQL282WSAT",
"Group" : "AMC1_Source",
"Status" : "RUNNING",
"Enabled" : "enabled",
"Database" : "AzureNewInstanceCadence",
"Size [GB]" : " 6.74",
"Appliance" : "devdel6xsat"
},
{
"Appliance" : "devdel6xsat",
"Size [GB]" : " 0.12",
"Status" : "RUNNING",
"Database" : "AzureNewInstanceCadenceAttachments",
"Enabled" : "enabled",
"Env name" : "DEVSQL282WSAT",
"Group" : "AMC1_Source"
},
{
"Database" : "AzureNewInstanceCadenceLogging",
"Enabled" : "enabled",
"Status" : "RUNNING",
"Group" : "AMC1_Source",
"Env name" : "DEVSQL282WSAT",
"Appliance" : "devdel6xsat",
"Size [GB]" : " 2.84"
},
------------------------------
Vijayender Singidi
Original Message:
Sent: 01-12-2024 04:33:42 PM
From: Neal Stack
Subject: dx_get_dsourcesize.exe returning dsource size in string format
Hello,
It looks like the engine is returning "NA" but the expected return value should be numeric.
Do you have any plugin based dSources (MSSQL, PostgreSQL, MongoDB, Oracle Backup Ingestion, etc.)?
Can you run with the "-debug" command to get a little more information (you may have to specify "-debug 3" to get the most verbose logging)?
Can you use any of the filter options to filter out any of the plugin based dSources to help narrow down the problem?
-group Group Name
-name Database Name
-host Host Name
-envname Environment name
Thanks,
Neal
------------------------------
Neal Stack
Senior Principal Technical Support Engineer
Delphix
Original Message:
Sent: 01-12-2024 04:13:45 PM
From: Vijayender Singidi
Subject: dx_get_dsourcesize.exe returning dsource size in string format
dx_get_dsourcesize.exe returning dsource size in string format
dx_get_dsourcesize.exe -all -format json |Set-Content -Path .\Downloads\dx_get_dsourcesize.json
Argument "NA" isn't numeric in multiplication (*) at %AppData%\Local\Temp\1\par-504c5932313532\cache-bbcbc85347457129602706692e981ea68fdc23a0\inc\lib/Toolkit_helpers.pm line 982.
Argument "NA" isn't numeric in multiplication (*) at %AppData%\Local\Temp\1\par-504c5932313532\cache-bbcbc85347457129602706692e981ea68fdc23a0\inc\lib/Toolkit_helpers.pm line 982.
Argument "NA" isn't numeric in multiplication (*) at %AppData%\Local\Temp\1\par-504c5932313532\cache-bbcbc85347457129602706692e981ea68fdc23a0\inc\lib/Toolkit_helpers.pm line 982.
Argument "NA" isn't numeric in multiplication (*) at %AppData%\Local\Temp\1\par-504c5932313532\cache-bbcbc85347457129602706692e981ea68fdc23a0\inc\lib/Toolkit_helpers.pm line 982.
Argument "NA" isn't numeric in multiplication (*) at %AppData%\Local\Temp\1\par-504c5932313532\cache-bbcbc85347457129602706692e981ea68fdc23a0\inc\lib/Toolkit_helpers.pm line 982.
Argument "NA" isn't numeric in multiplication (*) at %AppData%\Local\Temp\1\par-504c5932313532\cache-bbcbc85347457129602706692e981ea68fdc23a0\inc\lib/Toolkit_helpers.pm line 982.
Argument "NA" isn't numeric in multiplication (*) at %AppData%\Local\Temp\1\par-504c5932313532\cache-bbcbc85347457129602706692e981ea68fdc23a0\inc\lib/Toolkit_helpers.pm line 982.
Argument "NA" isn't numeric in multiplication (*) at %AppData%\Local\Temp\1\par-504c5932313532\cache-bbcbc85347457129602706692e981ea68fdc23a0\inc\lib/Toolkit_helpers.pm line 982.
Argument "NA" isn't numeric in multiplication (*) at %AppData%\Local\Temp\1\par-504c5932313532\cache-bbcbc85347457129602706692e981ea68fdc23a0\inc\lib/Toolkit_helpers.pm line 982.
Argument "NA" isn't numeric in multiplication (*) at %AppData%\Local\Temp\1\par-504c5932313532\cache-bbcbc85347457129602706692e981ea68fdc23a0\inc\lib/Toolkit_helpers.pm line 982.
Dx_toolkit version : 2.4.19.2
------------------------------
Vijayender Singidi
------------------------------