An Example of DDF Files in DATA Folder that Can Confuse PSQL

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 IMITMFIL node.  See example below:

On the other hand, I have confirmed that the EL850CF.EXE database tab points to the correct database (ELIDATA02) and that the database is configured to point to a DDF folder that has the latest Elliott DDF.  If I go to the PSQL Control Center, I can see that the IMITMFIL table has ITEM_CASE_SIZE column as well.  See sample screen below:


A - After investigating this case further, we found out that it is due to the fact that there are DDF files in the corresponding DATA folder.  The PSQL engine may be confused when the DDF files are found in the corresponding DATA folder.  By removing it, the ITEM_CASE_SIZE column shows up:



EMK


    • Related Articles

    • 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 ...

    • Login SUPERVISOR to Update DDF Files After Elliott 8.6 Installation

      Release Date: 8/17/2022 Version: Elliott V8.6 and Higher Background Most of Elliott Business Software uses the PSQL transactional database engine (Btrieve) to perform its work. However, some new features of Elliott V8.6 use the PSQL relational ...

    • A Comparison of Elliott 7.5, 8.2, 8.5, 8.6 and 8.6 V2 DDF Files

      Release Date: 11/15/2022 Last Updated: 06/25/2024 Version: 7.5 & Up DDF Files are used to define the PSQL database schema. Generally speaking, we distribute four different types of DDF files for different versions of Elliott releases: 7.5 DDF: These ...

    • 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 ...

    • 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 ...