Error in CalcCrRatioSlackTime Routine

Question

Trying to run Schedule Generation for the first time and i'm getting a few errors. 
 it was going through the steps and stopped at a work order. gave an "Error 5 occurred at frmmfzmn001 in Procedure cmdGenerateSched_Click. Invalid procedure call or argument. I checked the messages and saw 
 warnings for Slack Time may not be accurate for WorkOrder #####, start date is not within schedule board parameters 
 Error: "Error in CalcCrRatioSlackTime Routine' 
 
 it looks like some of the work orders have some issues (warnings) but I don't know what the Error means, anyone experienced this before?

Ramon M. · Accepted Answer

An error message like " Error 5 occurred at frmmfzmn001 in Procedure cmdGenerateSched_Click. Invalid procedure call or argument." means that the stored procedure (or embedded SQL code) likely blew up. Ideally, an "Error 5" message from Visual Basic" would never surface to an end user. It is likely that an unhandled situation has occurred in the stored procedure (or embedded SQL code) that is being called. 
 If you are a programmer type that is familiar with SQL Server, running the SQL Profiler can sometimes identify exceptions that occur in SQL code. To do this, crank up the Profiler and put it on pause. Then right before you click the Generate Schedule button, start the profiler and stop it when you get the message box and analyze the results. It is possible that it could be VB code too, but you would have to have source code to debug through that. 
 While most code attempts to check for a variety of conditions that will cause an error prior to it happening, not all situations are caught or dreamed up to catch. 
 If you are on a Sage maintenance plan, perhaps you may wish to contact Sage Support. If not, contact a partner or try the do-it-yourself route, which would include this forum. Perhaps some others who monitor this forum can help you with drilling down through the details.

Sage 500

Error in CalcCrRatioSlackTime Routine

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING