Can you put some debugging messages in the SP to verify you are hitting all the expected parts. You can use RAISERROR with a severity below 11 (informational only) to verify the expected parameters have been passed in and the different steps have been hit.