Error 3454

Severity

10

Message text

Versions earlier than 15.0:

Database '%.*s': SQL Server could not completely upgrade this database; upgrade item %d could not be installed.

Version 15.0 and later:

Database '%.*s': ASE could not completely upgrade this database; upgrade item %d could not be installed.

Explanation

Databases can be upgraded during an online database command or when you are using the sybinit upgrade utility. Error 3454 is an informational message telling you that Adaptive Server could not completely upgrade the database listed in the message. The 3454 error is preceded by other errors that show why the upgrade failed.

You cannot bring the database named in the error message online until you resolve the problem that led to the 3454 error.

In the following example, these messages appeared during start-up, when Adaptive Server attempted to bring a database online but failed to upgrade it:

00:2006/11/21 18:34:36.51 server Database 'test' appears to be at an older revision than the present installation; SQL Server will assess it, and upgrade it as required.00:2006/11/21 18:34:36.59 server Error: 1105, Severity: 17, State: 1 00:2006/11/21 18:34:36.61 server Can't allocate space for object 'sysattributes' in database 'test' because the 'system' segment is full. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.00:2006/11/21 18:34:36.63 server Error: 3460, Severity: 20, State: 1 00:2006/11/21 18:34:36.65 server  Database 'test': upgrade could not record the installation of upgrade item '80'. Please refer to previous error messages to determine the problem. Fix the problem, then try again.00:2006/11/21 18:34:36.68 server Error: 3451, Severity: 20, State: 1 00:2006/11/21 18:34:36.70 server Database 'test': upgrade has failed for this database.  Please refer to previous messages for the cause of the failure, correct the problem and try again.00:2006/11/21 18:34:36.73 server Error: 3454, Severity: 20, State: 1 00:2006/11/21 18:34:36.75 server Database 'test': SQL Server could not completely upgrade this database; upgrade item 80 could not be installed.00:2006/11/21 18:34:36.76 server SQL Server could not bring database 'test' online.

Action

  1. Look at the error messages preceding the 3454 error message to determine what happened.

  2. Refer to the recovery steps suggested for those errors.

  3. Correct the problem.

  4. If the error occurred when you were running online database, issue the online database command for that database after the problem is fixed. Adaptive Server will automatically try to finish the upgrade.

    If the error occurred during an Adaptive Server upgrade, follow the recovery directions in the Adaptive Server installation and configuration guide for your platform.

Versions in which this error is raised

All versions