Hi
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
Camelot Database Administrator
Delphix Community Members
------------------------------