Sybase ADAPTIVE 15.0.2 - Manual (Page 125)

CHAPTER 7 Troubleshooting
Installation Guide 109
If the cause of the failure is unknown
If the upgrade process fails again, and you cannot determine the cause of
failure, check the error log file to find out when and where the upgrade failed,
and contact Sybase Technical Support.
By default, the log file is located in
$SYBASE/$SYBASE_ASE/install/<servername>.log.
Upgrading compiled objects with dbcc upgrade_object
Adaptive Server version 11.9.3 introduced the process of upgrading compiled
objects based on their source text. Compiled objects are:
• Check constraints
• Defaults
• Rules
• Stored procedures (including extended stored procedures)
• Triggers
• Views
The source text of each compiled object is stored in the syscomments table,
unless it has been manually deleted. When you upgrade the server, the
existence of the source text in
syscomments is verified during that process.
However, the compiled objects are not actually upgraded until they are
invoked.
For example, if you have a user-defined stored procedure named list_proc , the
presence of source text for list_proc is verified when you upgrade to Adaptive
Server 15.0. The first time list_proc is invoked after the upgrade, Adaptive
Server detects that the list_proc compiled object has not been upgraded.
Adaptive Server recompiles list_proc , based on the source text in syscomments .
The newly compiled object is then executed.
Upgraded objects retain the same object ID and permissions that they used
before being upgraded.