Procedure Failing - "Index out of range"

Ben Campbell

I have a procedure that fails on the overnight schedule but works fine when I run it manually. Error message is "Index was out of range. Must be non-negative and less that the size of the collections. Parameter name: Index"

 

The only time I've seen this message before was when a step of the procedure is for a Data Reader that has been deleted. This is not the case here.

 

The procedure has been working well on the overnight schedule for over a year, but now I've had this error (which stops the procedure) for 3 days in a row. Board v10.1.3.

 

Any ideas?

 

Thanks,

Ben

Alexander Kappes

Dear Ben Campbell,

 

did you have checked the Log File, which steps of the procedures are excuted and on which step the procedure fails?

 

Did you have checked the mailbox of the user, who executes if there is any further information and the step where it crashes?

 

 

Perhaps this may help you.

Sorry that I have not detailized answer for you, but the problem can be due to several reasons. When it stops at sql datareader, perhaps the sql table or view isn´t available at this moment, ...

 

Hope it helps by investigating your case

 

thanks and regards

 

Alex