Cannot read the next data row, but works after running ALTER sproc

Hi,

Thanks. Everything starts to work after I just run the ALTER sproc again without making any changes to the sproc. Then it again works for few weeks. So, it is as if the sproc would somehow be "jammed" and re-creating it using ALTER sproc would again release it.

Report itself is simple, showing about 30 rows of data with label and values for 5 years on each row. Sproc is equally simple, select with few inner joins and little bit of calculation (just simple percentage divisions).

There are no long-running queries, so it shouldn't be any lock-issue either, when it's broken, it's broken.

Anyway, will try to get the logs and see what they say. Don't have access to the environment so will take some time.