Question

State machine – lock (?) problem

  • 22 November 2021
  • 0 replies
  • 29 views

Badge +2

Hi,

I’ve got strange problem with state machine. I’m using standard message to change state for selected row (this is master-detail form, state machine defined for master LU):

 

Sal.SendMsg(Sys.hWndForm, Ifs.Fnd.ApplicationForms.Const.PM_DataRecordStateEvent, Ifs.Fnd.ApplicationForms.Const.METHOD_Execute, ((SalString)"Confirm").ToHandle());

 

This calls single function from LU: Confirm__. There is no ‘magic’ inside, in Finit_State_Machine___ procedure there is only check if all necessary fields are filled with value. However after calling function application hangs for 15+ minutes (usually, sometimes hangs for longer period of time). I’ve noticed (in Pl/SQL Developer) that there is possible locking problem:

 

As I mentioned ‘Confirm’ event is really simple – it does not affect any other rows or tables, works on single row in L_CUST_ORD_LINE_PROT_TAB.

Any help, please?

Regards,

/PC


This topic has been closed for comments