SAP Knowledge Base Article - Preview

3800202 - Loading a Database dump from an older SAP ASE version onto a later version results in Msg 968 Database not upgraded and unavailable for access- SAP ASE

Symptom

When database dump taken from ASE 16.0 SPXX PLXX was loaded onto the target ASE 16.1 instance. Although the LOAD DATABASE operation completed successfully and the database was brought online, it is currently inaccessible and returning the following error: 

use <DB_name>
go
Msg 968, Level 16, State 1:
Server '<DB_Name>', Line 1:
Database 'database '<DB_Name>' (<DB_ID>)' is not upgraded and hence is not available
for access. Please retry your query after database has been upgraded.  

This indicates that the database was loaded successfully but has not yet been upgraded to the target ASE version. 
To confirm this and gather the necessary diagnostic data, please run the following commands and attach the output files to this case:

Verify installed scripts are up to date:
sp_version
go

Collect dbinfo and dbtable output:

dbcc traceon(3604)
go

dbcc dbinfo ('<DB_Name>')
go > dbinfo.out

dbcc dbtable ('<DB_Name>')
go > dbtable.outdbcc 

traceoff(3604)
go

The dbinfo.out file will allow us to inspect the ' offset 180=dbi_ASEvers  ' field . If this still reflects the source version ("e.g., 16004070 — 16.0 SP04 PL07"), it confirms that the database was loaded successfully but the internal version marker was not updated as expected during the upgrade process.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0
SAP Adaptive Server Enterprise (ASE) 16.1

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.1

Keywords

'Load to latest version instance' , ' Msg 968 ' ,' not upgraded and hence is not available
for access', 'db upgrade' ,'database not upgraded' ,'dbi_ASEvers' , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.