Filter
Top Products
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.