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 ...Btrieve Error Codes 3000 - 3099
MicroKernel Router Status Codes This section lists the status codes you can receive from the MicroKernel router, which receives requests from the Btrieve requesters and routes them to the correct version of the MicroKernel. 3000: The MicroKernel ...An Example of Debugging NOTE_ORD_VIEW PSQL Expression Evaluation Error
Q - When I try to access the NOTE_ORD_VIEW in the PSQL control center, I get this error: "[LNA][Pervasive][ODBC Engine Interface]Expression evaluation error." See sample screen below. It does not display any results, but it does display the create ...Elliott Startup Btrieve Error 196 or 3012 on S/M Users File
Release Date: 11/16/2022 Version: 8.5 & Up Q - I try to access Elliott software and I get this error on my startup: EL860CC: Btrieve Error 196 on S/M Users File (32-Bit) If I click on the "Details," I see the status code 3012 when I try to access ...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 ...