OLA SQL maintenance job reports failure for DIFF and LOG backups

[gonzaa12]

Using DellEMC ddboost plugin version 19.8 (latest) for S SQL. Steps parameters:

EXECUTE [dbo].[DatabaseBackup]
@databases = 'USER_DATABASES',
@BackupType = 'DIFF',
@Cleanuptime = 720,
@Checksum = 'Y',
@LogToTable = 'Y',
@backupsoftware = 'DATA_DOMAIN_BOOST',
@DataDomainBoostHost = 'xxxxx.xxxxx.xxxx',
@DataDomainBoostUser = 'xxxxxxx',
@DataDomainBoostDevicePath = '/DDBOOSTSQL',
@DataDomainBoostLockboxPath = 'C:\Program Files\DPSAPPS\common\lockbox'

The command parsed is (from the dbo.commandlog table, Data Domain name, ddboost user and SQL hostname replaced with X):

DECLARE @returncode int EXECUTE @returncode = dbo.emc_run_backup ' -c X -l diff -y +30d -k -S 1 -a "NSR_DFA_SI_DD_HOST=X" -a "NSR_DFA_SI_DD_USER=X" -a "NSR_DFA_SI_DEVICE_PATH=/DDBOOSTSQL" -a "NSR_DFA_SI_DD_LOCKBOX_PATH=C:\Program Files\DPSAPPS\common\lockbox" -a "NSR_SKIP_NON_BACKUPABLE_STATE_DB=TRUE" "MSSQL:MYDATABASE"' IF @returncode <> 0 RAISERROR('Error performing Data Domain Boost backup.', 16, 1)

If I use the same command as above in the following T-SQL script and replace the step command with it, the job reports success:

USE [master]
GO
DECLARE @returncode int
EXEC @returncode = dbo.emc_run_backup ' -c X -l diff -y +30d -k -S 1 -a "NSR_DFA_SI_DD_HOST=X" -a "NSR_DFA_SI_DD_USER=X" -a "NSR_DFA_SI_DEVICE_PATH=/DDBOOSTSQL" -a "NSR_DFA_SI_DD_LOCKBOX_PATH=C:\Program Files\DPSAPPS\common\lockbox" -a "NSR_SKIP_NON_BACKUPABLE_STATE_DB=TRUE" "MSSQL:MYDATABASE"'
IF @returncode <> 0
BEGIN
RAISERROR ('Fail!', 16, 1)
END

The message content from the failed job:

Message
Executed as user: XXXXX\XXXXXX. ...000) Server: XXXXXX [SQLSTATE 01000] (Message 50000) Version: 15.0.4023.6 [SQLSTATE 01000] (Message 50000) Edition: Enterprise Edition: Core-based Licensing (64-bit) [SQLSTATE 01000] (Message 50000) Platform: Windows [SQLSTATE 01000] (Message 50000) Procedure: [master].[dbo].[DatabaseBackup] [SQLSTATE 01000] (Message 50000) Parameters: @databases = 'USER_DATABASES', @Directory = NULL, @BackupType = 'DIFF', @verify = 'N', @Cleanuptime = 720, @CleanupMode = 'AFTER_BACKUP', @compress = NULL, @copyonly = 'N', @ChangeBackupType = 'N', @backupsoftware = 'DATA_DOMAIN_BOOST', @Checksum = 'Y', @Blocksize = NULL, @BufferCount = NULL, @MaxTransferSize = NULL, @NumberOfFiles = NULL, @MinBackupSizeForMultipleFiles = NULL, @MaxFileSize = NULL, @CompressionLevel = NULL, @description = NULL, @threads = NULL, @Throttle = NULL, @Encrypt = 'N', @EncryptionAlgorithm = NULL, @ServerCertificate = NULL, @ServerAsymmetricKey = NULL, @EncryptionKey = NULL, @ReadWriteFileGroups = 'N', @OverrideBackupPreference = 'N', @NoRecovery = 'N', @url = NULL, @credential = NULL, @MirrorDirectory = NULL, @MirrorCleanupTime = NULL, @MirrorCleanupMode = 'AFTER_BACKUP', @MirrorURL = NULL, @AvailabilityGroups = NULL, @Updateability = 'ALL', @AdaptiveCompression = NULL, @ModificationLevel = NULL, @LogSizeSinceLastLogBackup = NULL, @TimeSinceLastLogBackup = NULL, @DataDomainBoostHost = 'XXXXXX', @DataDomainBoostUser = 'XXXXXX', @DataDomainBoostDevicePath = '/DDBOOSTSQL', @DataDomainBoostLockboxPath = 'C:\Program Files\DPSAPPS\common\lockbox', @DirectoryStructure = '{ServerName}${InstanceName}{DirectorySeparator}{DatabaseName}{DirectorySeparator}{BackupType}{Partial}{CopyOnly}', @AvailabilityGroupDirectoryStructure = '{ClusterName}${AvailabilityGroupName}{DirectorySeparator}{DatabaseName}{DirectorySeparator}{BackupType}{Partial}{CopyOnly}', @filename = '{ServerName}${InstanceName}{DatabaseName}{BackupType}{Partial}{CopyOnly}{Year}{Month}{Day}{Hour}{Minute}{Second}{FileNumber}.{FileExtension}', @AvailabilityGroupFileName = '{ClusterName}${AvailabilityGroupName}{DatabaseName}{BackupType}{Partial}{CopyOnly}{Year}{Month}{Day}{Hour}{Minute}{Second}{FileNumber}.{FileExtension}', @FileExtensionFull = NULL, @FileExtensionDiff = NULL, @FileExtensionLog = NULL, @Init = 'N', @Format = 'N', @ObjectLevelRecoveryMap = 'N', @StringDelimiter = ',... Version: 2020-01-26 14:06:53 [SQLSTATE 01000] (Message 50000) Source: https://ola.hallengren.com [SQLSTATE 01000] (Message 50000) [SQLSTATE 01000] (Message 50000) Date and time: 2021-05-13 08:00:00 [SQLSTATE 01000] (Message 50000) Database: [BI_RegionalReporting_Audit] [SQLSTATE 01000] (Message 50000) State: ONLINE [SQLSTATE 01000] (Message 50000) Standby: No [SQLSTATE 01000] (Message 50000) Updateability: READ_WRITE [SQLSTATE 01000] (Message 50000) User access: MULTI_USER [SQLSTATE 01000] (Message 50000) Recovery model: FULL [SQLSTATE 01000] (Message 50000) Encrypted: No [SQLSTATE 01000] (Message 50000) Is accessible: Yes [SQLSTATE 01000] (Message 50000) Differential base LSN: 45000000204300001 [SQLSTATE 01000] (Message 50000) Differential base is snapshot: No [SQLSTATE 01000] (Message 50000) Last log backup LSN: 45000000241900001 [SQLSTATE 01000] (Message 50000) Allocated extent page count: 376 (2.937500 MB) [SQLSTATE 01000] (Message 50000) Modified extent page count: 40 (0.312500 MB) [SQLSTATE 01000] (Message 50000) [SQLSTATE 01000] (Message 50000) Date and time: 2021-05-13 08:00:00 [SQLSTATE 01000] (Message 50000) Database context: [master] [SQLSTATE 01000] (Message 50000) Command: DECLARE @returncode int EXECUTE @returncode = dbo.emc_run_backup ' -c XXXXXX -l diff -y +30d -k -S 1 -a "NSR_DFA_SI_DD_HOST=XXXXXX" -a "NSR_DFA_SI_DD_USER=XXXXXX" -a "NSR_DFA_SI_DEVICE_PATH=/DDBOOSTSQL" -a "NSR_DFA_SI_DD_LOCKBOX_PATH=C:\Program Files\DPSAPPS\common\lockbox" -a "NSR... The step failed.

Question:

Where can I find why/how is the OLA script failing ?

Thanks.