The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

JunBinghay's avatar
JunBinghay
New Contributor II
4 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
4 years ago

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
    4 years ago

    Hi Jun, 

    Did you build this rule within Extensibility rule?

     

      • Mustafa_A's avatar
        Mustafa_A
        Contributor II
        4 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 = "[email protected]"
        toEmail.Add(userEmailAddress1)

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


        Else Return Nothing


        End If