Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.

AcuXDBC error adding XFD "Error: Empty condition tablename, condition 1"

AcuXDBC error adding XFD "Error: Empty condition tablename, condition 1"

Problem:

Using version 9.0.0 or newer, when attempting to add an XFD to the AcuXDBC system catalog an error is reported "Error: Empty condition tablename, condition 1".  Previous versions of AcuXDBC added this XFD without error.

Resolution:

The XFD involved was generated from old code and used the XFD WHEN directive to distinguish multiple record types in the FD. 

For the first record type it specifies:

$XFD WHEN RECORD-TYPE=5 TABLENAME=USERFILE

The FD also included this directive:

$XFD WHEN RECORD-TYPE=OTHER

The requirement is that if the TABLENAME clause is used it must be defined for all of the WHEN conditions.  So the 'OTHER' condition is missing the TABLENAME clause.  Previous versions were not strict about this and reported no error. 

To resolve add a table name:

$XFD WHEN RECORD-TYPE=OTHER TABLENAME=OTHERTABLE

Then generate a new XFD add that to the system catalog.

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2018-03-28 19:42
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.