Procedure Failing - "Index out of range"

Ben Campbell
Ben Campbell Customer
Third Anniversary 10 Comments Name Dropper
in Platform

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

Answers

  • Alexander Kappes
    Alexander Kappes Employee
    Fourth Anniversary 250 Likes 100 Comments 5 Answers
    edited March 2020

    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?

     

    image

     

    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

  • Ben Campbell
    Ben Campbell Customer
    Third Anniversary 10 Comments Name Dropper

    I retrieved the error message from the 'Messages' of the admin account. It fails on the very first step of the procedure. I've noticed that it is overlapping with another procedure on the same database so I have altered the timings.

Categories