Unlocking Locked Messages in Inbox

From support-works
Revision as of 10:30, 30 January 2018 by Pamelal (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

To Unlock Messages


STOP SwSQLServer and Related Services and take a backup of the sw_messagestore database. Thereafter restart the Swsql server service.

Run the Interactive SQL utility on the Supportworks Server and type the following:

 use sw_messagestore;


 update shared__helpdesk_mailbox set msglockedby ='' where msglockedby !='';
 

where ‘shared__helpdesk_mailbox’ should be replaced by your mail box name

Start all Supportworks services.

Risks / Recommendations: 1. We advise this whole process to be tested on test Server first before migrating to the Production Server 2. Take the backup of all files before starting this exercise 3. Testing is suggested once you carry out each step