Delphix Toolkits (dxToolkit and dxmToolkit)

 View Only
  • 1.  Delphix_Metadata_Users_Backup Failure following Upgrade

    Posted 02-28-2023 04:49:00 AM

    Hi

    Apologies, this is a duplicate post but thought this community is the better place for help.

    After the upgrade of Delphix to version 6.0.12.1, our Delphix_Metadata_Users_backup started to fail with the following error message.

    "23/02/2023 10:01:24.18 - Executing: F:\DXToolkit\dxtoolkit2-v2.4.11-win64-installer\dxtoolkit2\dx_get_db_env.exe -d vldeldvep001 -backup H:\Delphix_Metadata_Backups\202302231001\
    23/02/2023 10:01:26.97 - AN ERROR HAS OCCURRED DURING PROCESSING
    Exporting database IPOS_PROD hooks into  H:\Delphix_Metadata_Backups\202302231001\/IPOS_PROD.dbhooks
    Can't use an undefined value as an ARRAY reference at C:\Windows\TEMP\par-565744454c505353514c5030303124\cache-a1c7334daea171b4b1896365db328811bbda01c6\inc\lib/MSSQLVDB_obj.pm line 888."

    Below is the complete output from a successful run before the upgrade and the first failure, this has failed everyday since, any help gratefully received.

    22/02/2023 10:01:23.05 - ======================================
    22/02/2023 10:01:23.07 - Delphix_Metadata_Users_Backup.bat starting...
    22/02/2023 10:01:23.09 - Execution Timestamp: 202302221001
    22/02/2023 10:01:23.11 - ======================================
    22/02/2023 10:01:23.13 - Creating directory for backupfile location
    22/02/2023 10:01:23.16 - mkdir H:\Delphix_Metadata_Backups\202302221001\
    22/02/2023 10:01:23.20 - ======================================
    22/02/2023 10:01:23.22 - Purging log files older than 14 days
    "F:\DXLogs\Delphix_Metadata_Users_ScriptLog_202302081000.log"
    22/02/2023 10:01:23.47 - ======================================
    22/02/2023 10:01:23.50 - Purging Backup .csv files older than 14 days
    rd /Q /S "H:\Delphix_Metadata_Backups\202302081000"
    22/02/2023 10:01:23.81 - ======================================
    22/02/2023 10:01:23.83 - Executing: F:\DXToolkit\dxtoolkit2-v2.4.11-win64-installer\dxtoolkit2\dx_get_users.exe -d vldeldvep001 -export H:\Delphix_Metadata_Backups\202302221001\Delphix_Metadata_Users_Backup_DVE_202302221001.csv -profile H:\Delphix_Metadata_Backups\202302221001\Delphix_Metadata_Users_Profile_Backup_DVE_202302221001.csv
    22/02/2023 10:01:29.51 - Executing: F:\DXToolkit\dxtoolkit2-v2.4.11-win64-installer\dxtoolkit2\dx_get_users.exe -d vldelrepp001 -export H:\Delphix_Metadata_Backups\202302221001\ReplicationEngine\Delphix_Metadata_Users_Backup_REP_202302221001.csv -profile H:\Delphix_Metadata_Backups\202302221001\ReplicationEngine\Delphix_Metadata_Users_Profile_Backup_REP_202302221001.csv
    22/02/2023 10:01:34.81 - Executing: F:\DXToolkit\dxtoolkit2-v2.4.11-win64-installer\dxtoolkit2\dx_get_policy.exe -d vldeldvep001 -export -outdir H:\Delphix_Metadata_Backups\202302221001\ -mapping H:\Delphix_Metadata_Backups\202302221001\Delphix_Metadata_Policy_Backup_DVE_202302221001.csv
    22/02/2023 10:01:38.08 - Executing: F:\DXToolkit\dxtoolkit2-v2.4.11-win64-installer\dxtoolkit2\dx_get_policy.exe -d vldelrepp001 -export -outdir H:\Delphix_Metadata_Backups\202302221001\ReplicationEngine\ -mapping H:\Delphix_Metadata_Backups\202302221001\ReplicationEngine\Delphix_Metadata_Policy_Backup_REP_202302221001.csv
    22/02/2023 10:01:42.05 - Executing: F:\DXToolkit\dxtoolkit2-v2.4.11-win64-installer\dxtoolkit2\dx_get_env.exe –d vldeldvep001 -backup H:\Delphix_Metadata_Backups\202302221001\
    22/02/2023 10:01:44.08 - Executing: F:\DXToolkit\dxtoolkit2-v2.4.11-win64-installer\dxtoolkit2\dx_get_env.exe –d vldelrepp001 -backup H:\Delphix_Metadata_Backups\202302221001\ReplicationEngine\
    22/02/2023 10:01:46.03 - Executing: F:\DXToolkit\dxtoolkit2-v2.4.11-win64-installer\dxtoolkit2\dx_get_db_env.exe -d vldeldvep001 -backup H:\Delphix_Metadata_Backups\202302221001\
    22/02/2023 10:01:48.67 - Executing: F:\DXToolkit\dxtoolkit2-v2.4.11-win64-installer\dxtoolkit2\dx_get_db_env.exe -d vldelrepp001 -backup H:\Delphix_Metadata_Backups\202302221001\ReplicationEngine\
    22/02/2023 10:01:51.64 - Executing: F:\DXToolkit\dxtoolkit2-v2.4.11-win64-installer\dxtoolkit2\dx_get_js_containers.exe -d vldelrepp001 -backup H:\Delphix_Metadata_Backups\202302221001\ReplicationEngine\
    22/02/2023 10:01:56.41 - ======================================
    22/02/2023 10:01:56.44 - Delphix_Metadata_Users_Backup.bat ending...
    22/02/2023 10:01:56.47 - Script return Error Code: 0
    22/02/2023 10:01:56.50 - ====================================== 

    23/02/2023 10:01:01.06 - ======================================
    23/02/2023 10:01:01.09 - Delphix_Metadata_Users_Backup.bat starting...
    23/02/2023 10:01:01.11 - Execution Timestamp: 202302231001
    23/02/2023 10:01:01.13 - ======================================
    23/02/2023 10:01:01.15 - Creating directory for backupfile location
    23/02/2023 10:01:01.17 - mkdir H:\Delphix_Metadata_Backups\202302231001\
    23/02/2023 10:01:01.20 - ======================================
    23/02/2023 10:01:01.22 - Purging log files older than 14 days
    "F:\DXLogs\Delphix_Metadata_Users_ScriptLog_202302091000.log"
    23/02/2023 10:01:01.50 - ======================================
    23/02/2023 10:01:01.51 - Purging Backup .csv files older than 14 days
    rd /Q /S "H:\Delphix_Metadata_Backups\202302091000"
    23/02/2023 10:01:01.77 - ======================================
    23/02/2023 10:01:01.79 - Executing: F:\DXToolkit\dxtoolkit2-v2.4.11-win64-installer\dxtoolkit2\dx_get_users.exe -d vldeldvep001 -export H:\Delphix_Metadata_Backups\202302231001\Delphix_Metadata_Users_Backup_DVE_202302231001.csv -profile H:\Delphix_Metadata_Backups\202302231001\Delphix_Metadata_Users_Profile_Backup_DVE_202302231001.csv
    23/02/2023 10:01:07.59 - Executing: F:\DXToolkit\dxtoolkit2-v2.4.11-win64-installer\dxtoolkit2\dx_get_users.exe -d vldelrepp001 -export H:\Delphix_Metadata_Backups\202302231001\ReplicationEngine\Delphix_Metadata_Users_Backup_REP_202302231001.csv -profile H:\Delphix_Metadata_Backups\202302231001\ReplicationEngine\Delphix_Metadata_Users_Profile_Backup_REP_202302231001.csv
    23/02/2023 10:01:12.91 - Executing: F:\DXToolkit\dxtoolkit2-v2.4.11-win64-installer\dxtoolkit2\dx_get_policy.exe -d vldeldvep001 -export -outdir H:\Delphix_Metadata_Backups\202302231001\ -mapping H:\Delphix_Metadata_Backups\202302231001\Delphix_Metadata_Policy_Backup_DVE_202302231001.csv
    23/02/2023 10:01:16.60 - Executing: F:\DXToolkit\dxtoolkit2-v2.4.11-win64-installer\dxtoolkit2\dx_get_policy.exe -d vldelrepp001 -export -outdir H:\Delphix_Metadata_Backups\202302231001\ReplicationEngine\ -mapping H:\Delphix_Metadata_Backups\202302231001\ReplicationEngine\Delphix_Metadata_Policy_Backup_REP_202302231001.csv
    23/02/2023 10:01:20.39 - Executing: F:\DXToolkit\dxtoolkit2-v2.4.11-win64-installer\dxtoolkit2\dx_get_env.exe –d vldeldvep001 -backup H:\Delphix_Metadata_Backups\202302231001\
    23/02/2023 10:01:22.40 - Executing: F:\DXToolkit\dxtoolkit2-v2.4.11-win64-installer\dxtoolkit2\dx_get_env.exe –d vldelrepp001 -backup H:\Delphix_Metadata_Backups\202302231001\ReplicationEngine\
    23/02/2023 10:01:24.18 - Executing: F:\DXToolkit\dxtoolkit2-v2.4.11-win64-installer\dxtoolkit2\dx_get_db_env.exe -d vldeldvep001 -backup H:\Delphix_Metadata_Backups\202302231001\
    23/02/2023 10:01:26.97 - AN ERROR HAS OCCURRED DURING PROCESSING
    Exporting database IPOS_PROD hooks into  H:\Delphix_Metadata_Backups\202302231001\/IPOS_PROD.dbhooks
    Can't use an undefined value as an ARRAY reference at C:\Windows\TEMP\par-565744454c505353514c5030303124\cache-a1c7334daea171b4b1896365db328811bbda01c6\inc\lib/MSSQLVDB_obj.pm line 888.
    23/02/2023 10:01:27.01 - ======================================
    23/02/2023 10:01:27.03 - Delphix_Metadata_Users_Backup.bat ending...
    23/02/2023 10:01:27.06 - Script return Error Code: 2
    23/02/2023 10:01:27.08 - ====================================== 

    Thanks



    ------------------------------
    Nick Tripp
    Principal Database Administrator
    Camelot UK Lotteries Limited
    ------------------------------


  • 2.  RE: Delphix_Metadata_Users_Backup Failure following Upgrade
    Best Answer

    Posted 03-03-2023 04:53:00 AM

    Hi

    As a solution.  I've upgraded DXToolKit to the current version v2.4.18 and dx_get_db_env.exe is running successfully.

    Thanks



    ------------------------------
    Nick Tripp
    Principal Database Administrator
    Camelot UK Lotteries Limited
    ------------------------------