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 the wrong DDFs for your database ELI86DATA98 on LAP-RDS01. You will not be able to run this report until the DDFs are corrected.
On the other hand, when I run the same UDR report for company #03 and company #09, they work correctly. The ELI86DATA98 definition of the DDF folder is same as ELI86DATA03 and ELI86DATA09. Do you know why?
A - After further research, we found out that there are DDF files in the DATA_98 folder that cause this issue. There is a PSQL quirk: when it tries to locate the DDF, if the DDF files exist in the corresponding data folder, it will get them from there. So the solution in this case is to delete the *.DDF files from the <ElliottRoot>\DATA_98 folder. There were some legacy reasons why the DDF was stored in the DATA* folders. But there is no reason why we still need DDF files in DATA* folders.
Note: What also make this confusing is when you use the PSQL (Zen) Control Center to access database ELI86DATA98, you can see the table APDSTHST without any problem. So it seems the PSQL Control Center uses a different method than Elliott's Report Desk. We are not sure of this at this moment.
Please also see the following related KB articles:
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 ...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 ...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 ...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 ...