Pervasive PSQL
Slow PSQL Relational Engine Performance
Release Date: 12/15/2017 Many users encounter situations where a particular relational engine SQL query can sometimes be slow. This can be complicated to diagnose due to a lot of reasons. Sometimes it's because of a SQL SELECT statement that's not ...
IPV6 May Cause Problem for PSQL 11 Relational Query
Release Date: 01/20/19 IPV6 (Internet Protocol Version 6) is designed to eventually replace IPV4. IPV4 has an IP address like 192.168.1.1. Each segment can have a value from 0 - 255, so the theoretical maximum number of IPV4 addresses is a little ...
How to Create CPHSTTRX_VIEW with Left Join to CPINVHDR Due to Invoice Database Archive
Release Date: 12/6/2019 Version: All Q - I had to run Archive Invoices in the old fashioned way as the company ran out of invoice numbers and I didn’t have time to go to 8.5 (modifications). I ran the Archive procedure as outlined in the KB article ...
How to Access Elliott's Data by Using Query in Microsoft Office Excel 2019
Release Date: 06/30/2020 Version: 7.x & Up Elliott's data is based on the PSQL database engine. In Excel, you can access the PSQL database through an ODBC interface with the Microsoft "Query" function. The following procedure outlines how you can do ...
What Does Btrieve Error 080 Mean?
Release Date: 07/16/2020 Version: 7.x & up Q - I received the following error in Elliott Business Software: Btrieve Error 080 on Order Header File I looked up the KB article: ...
How to Enable PSQL Relational ODBC Security
Release: 04/29/2021 Version: 7.5 & Higher Q - At the moment, our PSQL ODBC access does not require login and everyone has full access to the Elliott database when they connect through ODBC. We are looking at a scenario where most users have read-only ...
Converting Elliott Physical Server to a Virtual Machine (VM)
Release: 4/29/2021 Version: 7.5 & Up Q - We are going to move our Elliott physical server to a Virtual Machine (VM). We would like to do this with minimal effort. One tool that we are evaluating to do this is called Disk2Vhd. Have you ever ...
Use Telnet to Diagnose PSQL Communication & Port Disabling Problem
Release Date: 08/02/2021 If you are running Elliott directly on the PSQL server console, and Elliott suddenly stops working and displays a file access error like 3XXXX for the SYSPASS.BTR file on a workstation while it is working, it is an indication ...
How to Fix and Protect Audit Master Data from Corruption
Release Date: 08/12/2021 Version: 7.x & Up In this article, we are going to talk about two issues related to Audit Master database corruption: How to fix the audit master data when it becomes corrupted How to prevent audit master data from becoming ...
Configure PSQL Server Memory Usage
Version: Any Release Date: 12/17/2021 Q - Can you tell us why PSQL process is taking up so much memory? Is there anything we can do? See sample screen below: A - PSQL server by default can take up about 60ish% of the server memory. This is ...
How to Download PSQL 15
Release Date: 02/18/2022 Version: 8.5 & Up Q - What is the download link for PSQL V15? A - Go to https://www.actian.com/ and choose “Download” on the top right. Under Product, choose “Actian Zen (PSQL).” Under Release, choose “v15 Production.” Under ...
Restart PSQL Engine to Fix Slow IO Performance Issue
Release Date: 03/26/2022 Version: PSQL 13 Summary A slow Elliott IO scenario has been observed. After restarting the PSQL services, the problem is resolved. Scenario An Elliott user reported that an Elliott defer processing function used to take 10 ...
How to Retrieve Open Orders That Are Not Invoiced Through Query
Release Date: 05/04/2022 Version: 7.5 & Higher Q - I used the following SQL statement to get invoice history: SELECT INV_ITM_INV_DATE, INV_ITM_ITM_NO, INV_ITM_DESC_1, INV_ITM_DESC_2, INV_ITM_QTY_ORDER, INV_ITM_TOT_QTY_SHP, INV_ITM_UNIT_PRICE, ...
After Server Reboot, Elliott Stopped Working Due to PSQL Engines Not Starting
Release Date: 08/09/2022 Version: All Q - Our server has been rebooted for maintenance. Since the eboot, none of the Elliott users can use Elliott Business Software. A - This can happen if PSQL services did not start after the server reboot. We have ...
Elliott 8.6 to Distribute 4.4 PSQL Entity Framework Client
Release Date: 11/2/2022 Version: 8.6 & Up In Elliott 8.6, we distribute PSQL 4.4 Entity Framework Client for Avalara interface (national sales tax collection). You can expect to see the following DLL file in the Elliott BIN86 folder: ...
How Elliott 8.6 Works with Different Versions of the PSQL ADO.NET Client
Release Date: 11/4/2022 Version: 8.6 & Up Elliott V8.6 starts to use PSQL relational operations. Both Report Desk & PowerSearch features rely on the PSQL relational engine. To use these features, you should refer to the following KB article to set up ...
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 ...
How Do You Rebuild a Corrupt Elliott File?
Release Date: 05/02/2023 Version: 7. 0 & Up If a Btrieve data file is corrupt, you can use Butil to rebuild the file. The basic process is to make a copy of the file without any records and then copy all of the records out of the old file into the ...
A Case to Optimize PSQL Query Performance with INNER JOIN SYCONTCT & SYCONREL Tables
Release Date: 11/29/2023 Version: 7.x & Up Q - With our custom web application, we attempt to find an existing customer and associated contact when creating new customers via the Elliott web services. We are finding the customer just fine, but when I ...
How Can I Tell How Many Users Are Using PSQL?
Release Date: 02/08/2024 Versions: PSQL 13 and Up If you suspect you are running out of PSQL licenses or just want to know how many users are using PSQL, Actian has a utility that provides that information: Monitor. PSQL Monitor utility provides open ...
An Example of DDF Files in DATA Folder that Can Confuse PSQL
Release Date: 04/11/2024 Version: All Q - I tried to access Elliott Item master column ITEM_CASE_SIZE in Report Desk. In one of the Report Desk reports, I wanted to drag ITEM_CASE_SIZE to the report body. But I can't find that column under the ...
Why Does Elliott User's PSQL Connection Stay Open Even If User Is Out of Elliott?
Release Date: 05/09/2024 Version: All Q - We are using Elliott 8.6 PowerSearch and Report Desk. We have a separate PSQL Report Engine for those Elliott activities. I see a user connected to our Report Engine server that is not actively logged into ...