"ROI.EXE has stopped working" error in Microsoft Dynamics SL
This article provides a solution to an error that occurs when you try to print any report in Microsoft Dynamics SL 2011.
Applies to: Microsoft Dynamics SL 2011, Microsoft Dynamics SL 2011 Service Pack 1
Original KB number: 2721084
When you try to print any report in Microsoft Dynamics SL 2011, you receive the following error:
ROI.EXE has stopped working
The RI_ID value in the RPTRUNTIME table has exceeded the limit of 32,767.
Clear the records in the RPTRUNTIME table to reset the RI_ID value back to 1. To do it, follow these steps:
Verify that all users have signed out of Microsoft Dynamics SL.
Start Microsoft SQL Server Management Studio.
Run the following statement against the SL System database and the SL Application database(s).
delete from rptruntime
The RPTRUNTIME table contains temporary information that relates to an active print process. Typically, this table is empty when there are no users running a report. Occasionally, a record may be stranded in this table that can increase the chances of maxing out the RI_ID values.