ROI.EXE has stopped working error message in Microsoft Dynamics SL

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:

  1. Verify that all users have logged out of Microsoft Dynamics SL

  2. Start Microsoft SQL Server Management Studio

  3. 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. 

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×