Finding Compiled Object Errors Before Production

Changes made in versions of SAP ASE earlier than 12.5.x may cause compiled objects to work differently once you upgrade to a later version.

Use dbcc upgrade_object to find the errors and potential problem areas that may require manual changes to achieve the correct behavior.

After reviewing the errors and potential problem areas, and fixing those that need to be changed, use dbcc upgrade_object to upgrade compiled objects manually instead of waiting for the server to upgrade the objects automatically. See the Reference Manual: Commands.

• Reserved Word Errors
  If dbcc upgrade_object finds a reserved word used as an object name in a compiled object, it returns an error, and that object is not upgraded.
• Missing, Truncated, or Corrupted Source Text
  If the source text in syscomments was deleted, truncated, or otherwise corrupted, dbcc upgrade_object may report syntax errors.
• Temporary Table References
  If a compiled object such as a stored procedure or trigger refers to a temporary table (#temp table_name) that was created outside the body of the object, the upgrade fails, and dbcc upgrade_object returns an error.
• Resolving select * Potential Problem Areas
  If dbcc upgrade_object finds a select * clause in the outermost query block of a stored procedure, it returns an error, and does not upgrade the object.