Many Microsoft Dynamics CRM users also use Scribe Insight for integration/migration services. – While it’s a great tool, one warning that I see occasionally is:
Subject: System alert: Scribe EventManager - The job was terminated because the Message Processor is unresponsive.
Unfortunately after this, other jobs fail and nothing seems to work until the Scribe Services are restarted.
The root of this issue is a long-running query in one of the Scribe DTSs – The Scribe Event Manager terminates job processing with a fatal error if a source row or a post DTS script takes longer than 60 seconds to process. This happens because Scribe Insight assumes that the process is hung and should be terminated.
The best fix is to review your source queries and see which ones are taking a long time to run and fixing those. Many times these queries can be optimized to improve their performance with just a few tweaks or indexes – or by converting the query to a View in SQL and then using the view as the source – my preference.
A workaround is to increase the time Scribe waits before giving up on the slow source query. (I’d still look to improve the performance of the source query, but sometimes you have to get it running now, then resolve the cause later...)
I found this in the Scribe forums recently (https://openmind.scribesoftware.com/) – I verified with Scribe support that it is still valid way to increase the timeout for the message processor. (At least through Insight version 6.5)
Warning: Always be sure to back up your Registry before attempting to use Registry Editor. If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Scribe cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use the Registry Editor at your own risk.
Steps
1. On the Scribe server open the Registry Editor and go to HKEY_LOCAL_MACHINE\SOFTWARE\Scribe\EventManager\Settings.
2. Right-click on the Settings folder, on the shortcut menu, point to New and then click DWORD Value.
3. Name the new value ProcHangTimeout.
4. Right-click on the new value, on the shortcut menu, click Modify.
5. In the Edit DWORD Value dialog box, in the Value data box, type 600. This is the amount of time, in seconds, to wait before terminating the process.
6. In the Base box, choose the Decimal.
7. Restart the Scribe services for this setting to take effect* Be aware that Scribe Insight Updates can wipe out these keys, so make sure to check post-upgrade to see if they need to be re-added.
Comments