Error when using Reply or Forward on an Email record - Unhandled system exception: The given key is not present in the dictionary. Key "(newcli1)"

Version 1

    Details

    When trying to reply to an incoming email from the Incident view, we are receiving the following error:

    Unhandled system exception: The given key is not present in the dictionary. Key "(newcli1)"

    To replicate:
    1. Open incident in form view
    2. Select the activity history tab
    3. Open an incoming email
    4. Press the reply button in the edit email window 
    5. Page starts to load then (error is presented)


    Resolution

    This issue is due to a since-corrected bug from 2015.1.2 that left corrupt records in the Journal table in the database, and can be fixed via the following script. 


       select recid, * from journal where recid like '%newcli%'
     
    If there is one or more record returned, to fix this issue delete the record(s) using the following query :
     
       delete from journal where recid like '%newcli%'