Forum Discussion

JunBinghay's avatar
JunBinghay
New Contributor II
3 years ago

Trapping WF Import/Validate/Load Errors

Does anyone have any sample code they can share to see how to trap errors during an automated dataload process?  Currently, all I can see is that the dataload process executed and completed but it do...
Data Integration
Workflow
JunBinghay's avatar
JunBinghay
New Contributor II

Thank you Koemets and Gidon_Albert  for sharing your ideas.  These helped a lot.  I was able to figure out how to handle if the autoload process encountered an error by using the statement below:

Dim state = brapi.Workflow.Status.GetWorkflowStatus(si, si.WorkflowClusterPk, True)

 If state.HasErrors = "True"
'Do Something
End If

 

 

Mustafa_A's avatar
Mustafa_A
Contributor II
3 years ago

Hi Jun, 

Did you build this rule within Extensibility rule?

 

    • Mustafa_A's avatar
      Mustafa_A
      Contributor II
      3 years ago

      Thanks!

      I'm trying this out for curiosity. Did you set this BR as a sequence within your load data management?

       

      Here is the code. Would appreciate some feedback/comment. 

       

      'Define the Workflow unit cluster
      Dim wfClusterPk As WorkflowUnitClusterPk = BRApi.Workflow.General.GetWorkflowUnitClusterPk(si, "Mgmt Process Load.Import", "Actual", "2021M12")

      Dim state = BRApi.Workflow.Status.Getworkflowstatus(si, wfClusterPk, False)

      If state.HasErrors = "True" Then

      'Connection to the mail server (Defined in Application Server setup)
      Dim emailConnectionName As String = "OneStreamEmail"

      'Email content (Subject & Body)
      Dim subject As String = "Test Test Test "

      Dim messageBody As String = "You've got error"

      'Add email addresses
      Dim toEmail As New List(Of String)
      Dim userEmailAddress1 As String = "makbar@xyz.com"
      toEmail.Add(userEmailAddress1)

      'Send the message
      BRApi.Utilities.SendMail(si, emailConnectionName, toEmail, subject, messageBody, Nothing)


      Else Return Nothing


      End If

       

      • JunBinghay's avatar
        JunBinghay
        New Contributor II
        3 years ago

        I believe this would work.   I would go ahead and create a DM job to test this.  If you are not getting to the email component during your test, I'd throw out exceptions to see what's going on.