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:
Please see this related KB article:
EMK
Related Articles
An Example of DDF Files in DATA Folder Causing Report Desk or Power Search Issue
Release Date: 03/14/2025 Version: 8.6 & Up Q - When I tried to print a UDR report (i.e., AP Distribution History Report) from company # 98, I got the following error message: Cannot find definition of table APDSTHST in DDFs. You probably are using ...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 ...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 ...How to Investigate or Debug Report Desk Problem by Using SQL Statement
Released Date: 1/25/2025 Version: 8.6 & Higher Report Desk is based on the PSQL relational engine. It sends a SQL statement to the PSQL engine to retrieve data. Sometimes, you don't get the result back as you expected, so what next? For example, when ...How to Investigate or Debug Report Desk Problem by Using Registry Keys
Release Date: 01/25/2025 Version: 8.6 & Up Report Desk is based on the PSQL relational engine. It sends a SQL statement to PSQL engine to retrieve data. Sometimes, you don't get the result back that you expected, so what next? For example, when you ...