Solved

what is the purpose of mm_message_receipt in FSM mobile

  • 6 November 2023
  • 3 replies
  • 41 views

Userlevel 2
Badge +8

Hi, 

We see many lines in this table mm_message_receipt, what is the exact function of this table?

Is it there to handle the PO Receipt process?

Thanks/ KM.

 

icon

Best answer by roklde 6 November 2023, 12:33

View original

3 replies

Userlevel 6
Badge +23

Hi Kasun,

this table is related to FSM Mobile functionality and logs the IDs of successfully delivered messages to the respective person and device combination.

 

Best regards
Roman

Userlevel 2
Badge +8

Hi @roklde ,

One question, We can see many locks in this table even after we take care of index and pagelocks to true. What is the best practice for this table to stop locks from occurring?

 

Thanks

Kasun

Userlevel 6
Badge +23

Could you identify what exaclty is causing the db locks? Which transactions in particular?

Best regards
Roman

Reply