Pervasive PSQL
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 ...
A Case Where PSQL 13 Client Is Not Compatible with PSQL 15 Server
Release Date: 02/04/2025 Version: 8.6 Do Users Need to Upgrade to PSQL 15 Client When Upgrading PSQL Server? We were often asked in the past if our users should upgrade their PSQL 13 client when they upgrade to the PSQL 15 server. In our past ...
How to Optimize SQL SELECT Statement for BOMP Product Structure
Release Date: 11/29/2017 Q - I used the following SQL SELECT statement to retrieve product structure from the BOMP module. Generally speaking, it works. But the performance is not what I would like it to be. Is there anyway to make it run faster? ...
DDF Files in DATA Folder May Confuse PSQL
Release Date: 04/27/2018 Q - We recently noticed a strange phenomenon where if I try to access Elliott column names in the ARCUSFIL, I find the Customer AR account is defined as CUS_AR_ACCT_NO and it is 24 digits. See sample screen below: I have an ...
What to Do When PSQL 11 License Is Disabled
Release Date: 06/12/2018 Q - I recently migrated my workstation from one virtual server host to another for load balancing reasons. After the migration, the PSQL 11 Workgroup engine on the machine became disabled. When I started up Elliott, I ...
Quick Installation Guide for Audit Master
Release Date: 09/12/2018 Introduction Audit Master is an invaluable tool to diagnose problems with Elliott Business Software -- the types of problems that can happen due to users' mistakes or Elliott software bugs. While Elliott does provide auditing ...
Quick User Guide for Audit Master
Release Date: 09/12/2018 If you need help with installing Audit Master, please reference the following KB article: https://support.netcellent.com/portal/en/kb/articles/quick-installation-guide-for-audit-master Use Audit Master Viewer From your ...
PSQL 13, Micrsoft SQL Integration Service & Pervasive PSQL OLE DB Provider
Release Date: 3/26/2019 Version: PSQL 13 An Elliott user recently upgraded from PSQL 12 to PSQL 13 R2 (13.30.011. 000). The user also replicated Elliott data (in this particular case, the attribute database) to their MS SQL 2012 server by using ...
Your Firewall Needs to Allow Outbound Traffic to the Netherlands for PSQL Licensing Server Purposes
Release Date: 4/5/2019 It has been brought to our attention from one of our re-sellers that PSQL's licensing server resides in the Netherlands. Therefore, you need to make sure your firewall allows outbound traffic to the Netherlands to ensure the ...
A Case of Btrieve Error 046 on ARCRCLOG A/R Credit Card Log File
Release Date: 04/12/2019 Version: All Q - We are getting the following error in Elliott when we process a credit card transaction. It seems the credit card transaction did go through because we can see it in the payment portal. But we consistently ...
A Support Case of Migrating to Different Version of DDF
Release Date: 4/24/19 Version: All Q - I've been asked to set up UPS Worldship to access customer shipping addresses in Elliott. I've run into a problem mapping City, State, and Zip fields to Elliott. Looks like Elliott concatenates these fields to ...
How to Clear the Message "Unable to Read your Users record (9/068)"
Released Date: 05/06/2019 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 user's computer crashes or their session ends ...
Setup of the PSQL 13 Report Engine
Release Date: 8/14/2019 Version: PSQL 13 & up Benefits of PSQL 13 Report Engine The most significant feature in PSQL 13 is the report engine feature. Before PSQL 13, the Elliott application, web services and other third party applications that needed ...
2020 W-4 Employee Withholding Certificate Support
Release Date: 12/10/19 Version: 8.2 and up The IRS has issued a redesigned 2020 Form W-4 (Employee’s Withholding Certificate). The new form no longer uses withholding allowances. Instead, there is a five-step process for determining employee ...
Can I Dynamically Adjust Elliott / PSQL 11 Server Memory?
In the virtual server environment, it is very easy to adjust the server's memory in order to better suit your requirements and more efficiently use the server hardware. However, it is important for you to be aware that the PSQL 11 engine license can ...
Received "Your Computer Does Not Have PSQL 10 or 11 Client " Even though PSQL Client Is Just Installed
Q: I'm trying to install Elliott on a Windows 8.1 64-bit computer. I've installed both the 32- and 64-bit client version of PSQL v 11 and they both seemed to install fine. I then created the shortcut to EL700.exe on the server but when I click the ...
PSQL and Distributed File System (DFS)
People have asked if Elliott will work with the Distributed File System (DFS). The answer seems to be inconsistent. We have seen users that use Elliott on DFS without any issues, and we've also seen the opposite. The main culprit is PSQL, where you ...
Btrieve Error 161 on Password File When Starting Up Elliott
Q - We are receiving an Error 161: The maximum number of user count licenses has been reached. This happens to all users when starting up Elliott. We have rebooted all office computers and the PSQL server. There is no one is in Elliott. Yet we are ...
How Do I Turn on PSQL Relational Engine Security?
Q - I let my users use Crystal Report to access Elliott's data through ODBC. But they can access every single table in Elliott, including sensitive data in Payroll and General Ledger. How do I turn on PSQL's Relational Engine security so my users ...
Security Issue with Installing PSQL Client Remotely on User's Workstation
Q - I tried to install PSQL Client remotely on a user's workstation, when I received the following message: Pervasive PSQL requires administrative privileges or elevated privileges See the following sample screen. I recognize that this means I need ...
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 ...
Problems with Using Pervasive Rebuild Utility on APOPNFIL and AROPNFIL Tables
Q - Recently, we used Pervasive's rebuild utility to rebuild all Elliott database tables (i.e., all \Elliott7\DATA\*.BTR files). After the rebuild, we noticed some strange things happening to our A/P and A/R modules. For example, below is a sample of ...
PSQL Version Required by Each Elliott Version
Release Date: 09/22/2017 Revised on: 05/02/2023 Version: 7. 0 & up Q - We are thinking of either upgrading our current Elliott 7.3 to Elliott 7.5 or 8.2, but we are not sure about the PSQL requirement. We currently run on PSQL 8.6. Will it work for ...
Btrieve Error 025 on COP Open Order by Salesman Report
Q - When I run COP -> Reports -> Open Order by Salesman Report, I receive Btrieve Error 025. What causes this error? See sample screen below: A - Typically this is caused by a work file usage conflict. This means another user is in the middle of ...
Btrieve Error Codes 001 - 199
MicroKernel (Btrieve) Database Engine Status Codes This section describes status codes that the MicroKernel returns. All status codes are provided in 3-digit formats since the search on this website cannot search 1 or 2-digit words correctly. That is ...
Btrieve Error Codes 3100 - 3199
Network Services Layer Status Codes The following status codes originate from the Pervasive Network Services Layer (PNSL). 3103: Server name not found by Pervasive Network Services Layer The search for a target server name was unable to resolve an ...
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 ...
What Is the *.^01 File for My PSQL Btrieve Table?
Q - I see in my data folder, for my NOTE table, the corresponding data file is NOTE.BTR. But I also see another file NOTE.^01. See sample screen below. What is that file? Do I need to back up the NOTE.^01 file? A - The PSQL engine can create a ...
New Elliott PSQL Server Processor and RAM Suggestions
Q - We are going to upgrade to a new Windows Server 2012 R2 for PSQL 11 64-bit by the end of the year. Does PSQL take advantage of additional Intel processor cores and/or give some advice or algorithms on the amount of RAM that should be installed in ...
Suggested Files to be Monitored by Audit Master
Last Revised on 7/2/2019 Audit Master is an invaluable tool for the PSQL database. It helps to answer the question "what happened to my data?" For example, during day-to-day operation, if someone delete a sales order, you want to know who did it so ...
Do I Need to Change PSQL Server Engine Default Parameters After Installing It?
Q - I am installing a PSQL server engine for my client. Do I need to change any PSQL parameters after the installation? A - Generally speaking, you don't need to change PSQL parameters after the installation. There are two optional changes you can ...
Pervasive Backup Agent Is Not Compatible with Creating Work Files
Release Date: 09/12/2017 Q - After PSQL 11 SP2, are both Backup Agent or Volume Shadowing Service (VSS) included for my backup purposes? Which one should I use? A - Based on Pervasive's recommendation: Which Backup Solution Should I Use? If you are ...
Hardware Recommendations for Your PSQL Database Server
Release Date: 10/10/2017 This article was written by Bill Bach and is provided at the courtesy of Goldstar Software. Recommendations for hardware for your PSQL database environment One of the most common questions we get is “What kind of hardware ...
How to Optimize SQL SELECT Statement When Retrieving Data from Invoice History
'Release Date:11/29/2017 Q - I used the following SQL statement to retrieve invoice history data for a certain item within a certain date range. It took forever to run. Please help. SELECT CPINVLIN.INV_ITM_ITM_NO, CPINVLIN.INV_ITM_INV_DATE, ...
Elliott Database Naming Convention
Release Date: 06/30/20 Version: 7.x & Up Listed below are examples of standard Elliott database naming conventions for current and future versions of Elliott: ELLIOTTDATA V7.X DDF ELIDATA V8.0-8.2 DDF ELI85DATA V8.5 DDF ELI86DATA V8.6 DDF ELI86ROOT ...
New User-Defined Functions in Elliott DDF
Release Date: 12/6/17 Modified Date: 07/08/2024 Version: 8.5 & up In the future DDF (target to be released with Elliott 8.5,), we will add the following four user-defined functions: ELIDATE2SQL SQLDATE2ELI ELITIME2SQL SQLTIME2ELI For example, you can ...
How to Improve Query Performance When Retrieving Data from Notes & Invoice History
Release Date: 12/12/17 Q - I am trying to get all SHIP notes with related invoice information for a specific customer for a specific day. The speed of my attempts has been okay, but it feels like it could perform much faster. How can the below be ...
How to Retrieve Tracking Number for an Order from Notes
Release Date: 12/13/2017 Q - Can you let me know how the tracking number is stored in Elliott so I can use query to retrieve the information? A - Regarding how Elliott stores tracking numbers, please refer to the following Knowledge Base article: ...
Actian PSQL Not Started Automatically After Server Reboot
Release Date: 12/14/2017 Q - I restarted the server and for whatever reason the relational and transactional engines do not start, even though they are set to automatic. Have any idea why this is happening? A - Go to PSQL services –properties -- and ...
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 ...
Next page