Question

Health Check: Invoking a non-transactional xml from a transactional synchronous process may cause transaction dead-lock.

  • 4 March 2022
  • 2 replies
  • 142 views

Userlevel 4
Badge +11

a health check has been performed on our environment.

 

Some of results showed this recommendation:

 

The XML_Message of one of the BRs is:

<perform_batch>
<sequential_dependent>
<hierarchy_select result_name="select_result1">
   <primary_table>contract</primary_table>
  <attrs>
    <attr>contract.*</attr>
  </attrs>
  <from>
    <table>contract</table>
  </from>
  <where>
    <data_constraint>
      <constraint>
        <left_operand>contract.place_id_bill_to</left_operand>
        <operator>eq</operator>
        <right_operand>@place_id_owned_by</right_operand>
      </constraint>
    </data_constraint>
  </where>
</hierarchy_select>
<update_contr_product>
  <contr_product>
    <contract_id xpath_node="//contract_hierarchy_select_result[@result_name='select_result1']/contract/contract_id" />
    <contract_version xpath_node="//contract_hierarchy_select_result[@result_name='select_result1']/contract/contract_version" />
    <place_id xpath_node="//contract_hierarchy_select_result[@result_name='select_result1']/contract/place_id_bill_to" />     
     <contr_line_type>PRODUCT</contr_line_type>
    <product_id>@product_id</product_id>
    <coverage_start_dt>@mfg_installed_dt</coverage_start_dt>
    <coverage_eff_dt>@mfg_installed_dt</coverage_eff_dt>
    <contr_type>XXXX_BASIC_PM</contr_type>
    <model_id>@model_id</model_id>
    <insert is_initialized="False" />
  </contr_product>
</update_contr_product>
<perform_review_and_post_contract>
  <parameters>
    <contract_id xpath_node="//contract_hierarchy_select_result[@result_name='select_result1']/contract/contract_id" />
    <contract_version xpath_node="//contract_hierarchy_select_result[@result_name='select_result1']/contract/contract_version" />
  </parameters>
</perform_review_and_post_contract>
</sequential_dependent>
</perform_batch>

 

What does the recommendation mean?  

Does it mean,  the yellow highlighted line of above message should be changed with this line

<transaction_type>insert_update</transaction type> ?

Any feedback is very appreciated.

 

Best regards,

~Juni


This topic has been closed for comments

2 replies

Userlevel 7
Badge +24

@ruben.maas any ideas on this one?

Userlevel 4
Badge +8

Any solution for the above issue?