Forum Discussion

TT's avatar
TT
New Contributor III
8 months ago
Solved

Transformation Event Handler using Batch Load

When loading data through batch file, does transformation event handler invoked the same way as running through manual workflow steps? Also, how can I execute Workflow (import->validate->load) thro...
Workflow
ssmith-nova's avatar
ssmith-nova
New Contributor III
5 months ago

How do I catch failures here?  When I load a file if fails in the validation step.   Below is what I am catching so far.  Even with the validate stage failing, the batchinfo.TaskActivityItem.HasError is set to false.  

Dim detailString As New Text.StringBuilder
detailString .AppendLine($"Batch Name: {batchInfo.GetBatchName}")
detailString .AppendLine($"Load Group Name:{batchInfo.GetFileGroupName(fileGroupID)}")
detailString .AppendLine($"All Load Count:{batchInfo.GetFileCount(fileGroupID, False)}")
detailString .AppendLine($"Processed Load Count:{batchInfo.GetFileCount(fileGroupID, True)}")
detailString .AppendLine($"All Files Completed:{batchInfo.AllFilesCompleted(fileGroupID).ToString}")
detailString .AppendLine($"All Files Loaded:{batchInfo.AllFilesLoaded(fileGroupID).ToString}")
detailString .AppendLine($"All Files Can Process:{batchInfo.AllFilesCanProcess(fileGroupID).ToString}")
detailString .AppendLine($"All Files Processed:{batchInfo.AllFilesProcessed(fileGroupID).ToString}")
detailString .AppendLine($"Task Description:{batchInfo.TaskActivityItem.Description}")
detailString .AppendLine($"Task Activity Status:{batchinfo.TaskActivityItem.TaskActivityStatus}")
detailString .AppendLine($"Task Activity HasError?:{batchinfo.TaskActivityItem.HasError}")
detailString .AppendLine($"Task Activity ErrorLogId?:{batchinfo.TaskActivityItem.ErrorLogID}")