Receive Schema Mismatch Error When Trying to Create a New Database in Actian Control Center
Released Date: 02/07/2025
Version: PSQL 15 & Up
Q - I tried adding a data source on our new server with PSQL 15. I copied the DDF path and data as it appeared in the old server. But it gives
us a “schema mismatch” error and doesn’t work. We don’t really know what to do
past that.
A - Please see the
following KB article on how to create a new database:
Substitute the
proper DDF and data path when creating the database. What likely happened was that the checkbox “Long metadata (V2 metadata)” was enabled, which is PSQL
15’s default behavior. You need to uncheck that option. See sample screen below:
EMK
Related Articles
Create a New Database in the PCC for Relational Engine Access
Release Date: 12/15/2017 Modified Date: 02/07/2025 Elliott Business Software relies on PSQL database engines. PSQL consists of two types of engines: transactional and relational. The transactional engine used to be called "Btrieve," which is a record ...Cannot Create DDFs Due to Metadata Version Mismatch
Release Date: 11/28/2022 Version: 8.5 or Higher Q - We recently upgraded to Actian PSQL 15. I wanted to create a new ODBC database. So I go to PSQL Control Center, right click on the "Database" node and choose "New" to create the database, but it is ...Create New Company in Elliott Control Center with Not on This Machine Error Message
Release Date: 01/31/2024 Version: 8.x & Up Q - I login as the SUPERVISOR in Elliott. In the Elliott Control Center, when I right click on the node "Elliott Business Software" and choose "ADD NEW COMPANY," I receive the following message: Elliott Root ...How to Use EL850DB.EXE Utility to Create PSQL Databases
Release Date: 12/4/2018 Modified Date: 06/20/2020 Version: Elliott 8.5 Elliott 8.5 includes an EL850DB.EXE utility to make it easy to create PSQL databases. The new utility EL850DB.EXE is included in the Elliott 8.5 release, and you can find it in ...I Do Not See Adding New Company Option in Elliott Control Center
Release Date: 01/31/2024 Version: 8.x & Up Q - I am trying to set up a new company. But when I right click on Elliott Business Software node in Elliott Control Center, I do not get the option to ADD NEW COMPANY. See sample screen below: Do I not have ...