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
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.
SAP Knowledge Base Article - Preview