Skip to main content
Solved

Outbbound messge failed.

  • June 25, 2025
  • 5 replies
  • 77 views
R
Hero (Customer)
Forum|alt.badge.img+10

Hi,

 

I got a process flow that is scheduled to check if there are failed outbound message and send a mail with the tx id.

Now we manually go to outbound message end do a resubmit.

I want to do this automatically from the triggert process flow.

 

I try to call this action, to call the resubmit, but this does not work.

<root xmlns:dt="urn:schemas-microsoft-com:datatypes">
  <session email="" alias="">
    <state bc_name="service_order">
      <action name="execquery">
        <attribute in_var="" out_var="" entity_name="state_from_events" query_name="state_from_event_resubmit" />
        <attribute dtype="string" in_var="" name="transaction_ids" value="a592ef22-7a91-4e6b-ba71-a835aa64c3f8" operator="=" />
      </action>
    </state>
  </session>
</root>

 

Is there a macro available or other way to resubmit the failed outbound message in a Process Flow?

 

Thanks,

Robin

Best answer by robinsch

Hi Phil,

 

It seems there is a stored procedure available: sp_eventbroker_resubmit

When I call this from Process flow like this:

<root>
	<session email="" alias="">
		<state bc_name="Service_Order">
			<action name="execstoredprocedure">
				<attribute in_var="" out_var="" sp_name="sp_eventbroker_resubmit" />
				<attribute dtype="string" value="a592ef22-7a91-4e6b-ba71-a835aa64c3f8" name="txnid"/>
                <attribute dtype="integer" value="1" name="retryNum"/>
			</action>
		</state>
	</session>
</root>

The Failed message will be resubmitted.

 

This is what the Stored Procedure does:

update state_from_events set delivery_dt = null , retry_count = @retryNum where txnid = @txnid

I got it work, so it is now auto resubmitting. :)

 

Thanks.

You cannot change the road if you do not know the map.

5 replies

Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+24
  • Phil Seifert
  • Ultimate Hero (Employee)
  • June 25, 2025

Hi Robin,

If I recall right, you may be able to clear the state_from_events.delivery_dt and state_from_events.ack_dt and the next iteration that process outbound messages will pick up and send again.

 

Please mark any comments which answered your question as Best Answer so the topic is easier recognised as answered and closed.
R
Hero (Customer)
Forum|alt.badge.img+10
  • robinsch
  • Author
  • Hero (Customer)
  • June 25, 2025

Hi Phil,

 

Yes, if i check the DAL file: state_from_event_resubmit

I need to      

      update [state_from_events]
      set [delivery_dt]=null , [ack_dt]=null ,last_modified_by = '@last_modified_by' , retry_count = 0, error_msg = null , row_status = 2
      where [txnid] in (@transaction_ids)

But i was hoping by just calling the DAL file from the process flow, the update statement would be execute.

It seems i cannot clear the fields from the process flow it self. I can create a store procedure and call the store procedure from the process flow

You cannot change the road if you do not know the map.
R
Hero (Customer)
Forum|alt.badge.img+10
  • robinsch
  • Author
  • Hero (Customer)
  • Answer
  • June 25, 2025

Hi Phil,

 

It seems there is a stored procedure available: sp_eventbroker_resubmit

When I call this from Process flow like this:

<root>
	<session email="" alias="">
		<state bc_name="Service_Order">
			<action name="execstoredprocedure">
				<attribute in_var="" out_var="" sp_name="sp_eventbroker_resubmit" />
				<attribute dtype="string" value="a592ef22-7a91-4e6b-ba71-a835aa64c3f8" name="txnid"/>
                <attribute dtype="integer" value="1" name="retryNum"/>
			</action>
		</state>
	</session>
</root>

The Failed message will be resubmitted.

 

This is what the Stored Procedure does:

update state_from_events set delivery_dt = null , retry_count = @retryNum where txnid = @txnid

I got it work, so it is now auto resubmitting. :)

 

Thanks.

You cannot change the road if you do not know the map.
    Phil Seifert
    Ultimate Hero (Employee)
    Forum|alt.badge.img+24
    • Phil Seifert
    • Ultimate Hero (Employee)
    • June 25, 2025

    Hi Robin,

    Great… glad to see there is something like that as I did not yet look for it but you found it! 

    However, I would be careful on when you call it… for example after how many attempts otherwise you risk trying to send out for a while while the failure cause is investigate/resolved.  Imagine the other endpoint has a problem with their web service for example and may take some amount of time to fix the issue.

     

     

     

    Please mark any comments which answered your question as Best Answer so the topic is easier recognised as answered and closed.
    R
    Hero (Customer)
    Forum|alt.badge.img+10
    • robinsch
    • Author
    • Hero (Customer)
    • June 25, 2025

    Hi Phil,

     

    Yes good point, i get still triggert with de total of retry count, if retry count exceeds 2, than i have to investigate it manually and it will not auto resubmit.

     

    thanks.

    You cannot change the road if you do not know the map.
    Terms & ConditionsCookie settingsAccessibility statement