Change the CATCH to show the line number of the error to help you at least narrow it down to a section of the code. You might also check all the logging the proc is doing. If it starts up a certain section according to the log and nothing follows that, you've probably just found the bad section.
--Jeff Moden
Change is inevitable... Change for the better is not.