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 Clear the Message "Unable to Read your Users record (9/068)"
Released Date: 05/06/2019 Revised Date: 05/19/2025 Version: PSQL 13 or Zen 15 Q: User KSWAYZE received the message "Unable to Read your Users record (9/068)" as shown below and was unable to clear the message or even restart the computer. A: If a ...EL800CC Elliott V8 Control Center
Elliott V8.0 Control Center The Control Center replaces the Elliott main menu and module menus from previous releases. From the Control Center, you can launch nearly every feature of Elliott into a new process, independent of all other Elliott ...