"A Direct Link Error has occurred while retrieving transaction information from the database" when generating a report

Entry Type: Program Issue

Product: FRx

Application: FRx Desktop

Version Reported: 6.5.199

Status:
Resolved with FR6004-T

Subject:

"A Direct Link Error has occurred while retrieving transaction information from the database" occurs when generating a report.

Steps to Duplicate:

Note: Sage Software Support cannot duplicate this issue with demo data. The following steps are based on a reported case.

  1. Setup a new company in FRx for company ESS.
  2. Open File / New / Row Format. Select natural account '111' in the 'Link to General Ledger' section. Save the row format.
  3. Open File / New / Column. Create a column layout containing the following:
    Column A :desc
    Column B: GL,Actual, Base, Base, CUR
    Column C: GL, Actual, Base, Base, YTD  
  4. Create a catalog, using the building blocks from the previous steps.
  5. Generate the report to the transaction level for 04/31/2004.
  6. Note that the error occurs.
  7. Click 'OK'.
  8. Note that the report generates and the DrillDown Viewer launches.
  9. Drill down into the transaction level of the first account listed (111-00-0100).
  10. Note that transaction detail is not included in the report.

Expected Behavior:

The report should generate without errors.

Possible Workaround:

None

Related Link:
FR6004-T (Sage MAS 90 and 200 4.00 - FRx v6.5)