Question

what is the use of mm_message_out table in FSM?

  • 12 January 2021
  • 1 reply
  • 122 views

Userlevel 4
Badge +8

what is the use of mm_message_out table in FSM?

mm_message_out table is writing  2 million records daily and it is causing my table space to be increased by 40 GB per day oracle SYSLOB Segment.

 what is the use of this table.

 Need your support in finding the root cause of this issue.


This topic has been closed for comments

1 reply

Userlevel 3
Badge +7

Hi 

mm_message_out stores the data produced by mobile sync rules until the mobile device syncs with the server and downloads them, after this they should be removed. So it’s a purley transactional data table.

 

If you have to million records then yes you have some investigation to complete.

 

Do you have many mobile users active which are not being used? The mobile dashboard will tell you this. Also do not fall into the trap of assuming the baseline sync rules are fit for all solutions, it is normal process to de-activate some rules and refine the ones which are in use.

 

Hope this helps.