You’re offline. This is a read only version of the page.
Hi, good morning, recently we had a problem with ROI and the message: "ROI.exe has stopped working", the problem was presented in the main server and to all clients, the help in the internet suggested setting a default printer and thus could continue printing reports, this solution did not help me because all clients had a default printer and the error message indicated an overflow
Share
ReportAfter reviewing the RptRuntime tables, we noticed that the print jobs were not being erased from there, and the RI_ID was increasing more and more
The RI_ID field is of type smallint and the maximum value is 32767
In my case the value of RI_ID had increased so much that it did not allow me to print anything
*This post is locked for comments
ROI.EXE has stopped working error message in Microsoft Dynamics SL
Applies to: Dynamics SL 2011Microsoft Dynamics SL 2011 Service Pack 1
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.
#1
André Arnaud de Cal...
294,217
Super User 2025 Season 1
#2
Martin Dráb
232,978
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
All responses (
Answers (
