Procedure text is required for upgrade

If you created any compiled objects or stored procedures in a pre-11.9.3 server, then removed the syscomments text, the upgrade succeeds but you will encounter runtime problems. To upgrade stored procedures, the stored procedure text must be available in syscomments.

To successfully upgrade to Adaptive Server version 15.0 you must either reinstall the procedures with text, or remove them and reinstall them after the upgrade. You can also hide the text with sp_hidetext.