Sybase 15.0.2 - Manual (Page 123)

CHAPTER 7 Troubleshooting
Installation Guide 109
2 Perform the necessary actions to fix the problem.
For example, if the error log indicates that the upgrade failed because your
existing databases do not contain enough space, use the
alter database
command to increase the available space.
3 You may need to shut down Adaptive Server.
Shutting down the server enables the installation program to start the
server and re-run the upgrade session.
4 Start Server Config from the Sybase program folder.
5 Select Upgrade Adaptive Server, and proceed with the upgrade.
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.