That error rings a bell.

Try

Run the SP in SSMS. Any errors?

Strip the SP and run it outside of the SP.

Do all returned columns from SP have a proper name?

Are all parameters set correctly and match what is expected?