Delphix Products

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

Hi Nick,

Welcome to the community. Sorry that you're hitting this issue.
I've forwarded your message internally and @Minna Miettinen will be in touch. When you have a solution, if you are able to share back more information on this thread, I'm sure the larger community would appreciate it.

Thank you!

Michael

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