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 upgrade successfully to Adaptive Server version 15.0.2:
Reinstall the procedures with text, or
Remove them and reinstall them after the upgrade.
You can also hide the text using the sp_hidetext stored procedure.