Symptoms
When you try to print any report in Microsoft Dynamics SL 2011, you receive the following error:
ROI.EXE has stopped working
Cause
The RI_ID value in the RPTRUNTIME table has exceeded the limit of 32,767.
Resolution
Clear the records in the RPTRUNTIME table to reset the RI_ID value back to 1. To do this, follow these steps:
-
Verify that all users have logged 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
More Information
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. Ocassionally a record may be stranded in this table which can increase the chances of maxing out the RI_ID values.