Based on all of this, can you provide DDL and DML that would reproduce the issue? Since the issue occurs when running the stored proc alone, there is no need to include a report. But having a look at the query that can cause the issue will provide tons of help.