Error 3470

Severity

10

Message text

Versions earlier than 15.0:

SQL Server could not completely upgrade database '%.*s', but the database was online when upgrade began, so it will be left online.

Version 15.0 and later:

ASE could not completely upgrade database '%.*s', but the database was online when upgrade began, so it will be left online.

Explanation

When Adaptive Server tries to bring an already online database to the online state and it finds that some elements of the database have not been upgraded, it tries to complete the database upgrade. Error 3470 occurs when that attempt to upgrade the database fails.

Action

  1. Determine the current upgrade version for the database. For example, to determine the upgrade version of a database called test_db, use the following commands:

    1> load database testdb from 'test.dump' with headeronly 
    2> go
    
    
    
    Backup Server session id is:  48.  Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server. Backup Server: 6.28.1.1: Dumpfile name 'testdb0726708DD9 ' section number 1 mounted on disk file '/tmp/testdb.out' This is a database dump of database ID 4, name 'testdb', from Sep 24 2007 10:05AM. ASE version: Adaptive Server Enterprise/15.0.2/EBF 14328/P/Sun_svr4/OS 5.8/ase1502/2486/64-bit/FBO/Thu May 24 12:. Backup Server version: Backup Server/15.0/EBF 13443 ESD#2/Sun_svr4/OS 5.8/ase15x/2603/32-bit/OPT/Fri Mar 24 03:05:01 2006. Database page size is 2048. Database contains 15360 pages; checkpoint RID=(Rid pageid = 0x50f; row num = 0x18); next object ID=800002850; sort order ID=50, status=0; charset ID=1. ''Database log version=7; database upgrade version=35.''segmap: 0x00000007 lstart=0 vstart=[vpgdevno=0 vpvpn=11780] lsize=15360 unrsvd=14272
    
  2. Call Sybase Technical Support. Have the information ready that is listed in “Reporting errors”, including the output from step 1 and sp_configure "upgrade version".

Versions in which this error is raised

All versions