Database cannot be started -- server must be upgraded to start (capability 40 missing)

[Former Member]

Need help with the following SQL Anywhere 12.0 error.

Log Name: Application Source: SQLANY64 12.0 Date: 11/15/2018 1:53:24 PM Event ID: 1 Task Category: None Level: Information Keywords: Classic User: N/A Computer: lumvm20.Lumberton.ISD Description: SQLANYs_TxEis: Starting service SQLANYs_TxEis Event Xml: <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <System> <Provider Name="SQLANY64 12.0" /> <EventID Qualifiers="0">1</EventID> <Level>4</Level> <Task>0</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2018-11-15T19:53:24.000000000Z" /> <EventRecordID>12504830</EventRecordID> <Channel>Application</Channel> <Computer>lumvm20.Lumberton.ISD</Computer> <Security /> </System> <EventData> <Data>SQLANYs_TxEis</Data> <Data>Starting service SQLANYs_TxEis</Data> </EventData> </Event>

Log Name: Application Source: SQLANY64 12.0 Date: 11/15/2018 1:53:24 PM Event ID: 1 Task Category: None Level: Error Keywords: Classic User: N/A Computer: lumvm20.Lumberton.ISD Description: SQLANYs_TxEis: Database cannot be started -- server must be upgraded to start "C:\Output\TxEisDB\DB100907.db" (capability 40 missing). Event Xml: <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <System> <Provider Name="SQLANY64 12.0" /> <EventID Qualifiers="0">1</EventID> <Level>2</Level> <Task>0</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2018-11-15T19:53:24.000000000Z" /> <EventRecordID>12504831</EventRecordID> <Channel>Application</Channel> <Computer>lumvm20.Lumberton.ISD</Computer> <Security /> </System> <EventData> <Data>SQLANYs_TxEis</Data> <Data>Database cannot be started -- server must be upgraded to start "C:\Output\TxEisDB\DB100907.db" (capability 40 missing). </Data> </EventData> </Event>

Log Name: Application Source: SQLANY64 12.0 Date: 11/15/2018 1:53:24 PM Event ID: 1 Task Category: None Level: Error Keywords: Classic User: N/A Computer: lumvm20.Lumberton.ISD Description: SQLANYs_TxEis: Could not start server Event Xml: <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <System> <Provider Name="SQLANY64 12.0" /> <EventID Qualifiers="0">1</EventID> <Level>2</Level> <Task>0</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2018-11-15T19:53:24.000000000Z" /> <EventRecordID>12504832</EventRecordID> <Channel>Application</Channel> <Computer>lumvm20.Lumberton.ISD</Computer> <Security /> </System> <EventData> <Data>SQLANYs_TxEis</Data> <Data>Could not start server</Data> </EventData> </Event>

[former_member186998]

I add the following documents to Chris's answer.

Unable to start specified database: '%1' must be upgraded to start with this server (capability %2 m...
Upgrades of version 10 and later databases

Thanks,
Atsushi

[chris_keating]

The database file is newer than the engine. Generally, you can run an older database file on a newer engine. You cannot run a newer database on an older engine.

In this case, the database is v17 (based on the capability bit) and is running on an engine that is older than v17. You will need to run that database on a v17 engine.