"01000:[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated" followed by "The Report Yielded No Data" when generating report in FRx

Entry Type: Program Issue

Product: FRx for Sage MAS 500 ERP

Application: FRx Desktop

Version Reported: 6.7.4031

Status:

For current information on this issue, please click the Engineering Status' link above. To record the occurrence of this issue, respond Yes to the question, "Did this answer help you?"

Subject:

"01000:[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated" followed by "The Report Yielded No Data" occurs when generating a report in FRx.

Steps to Duplicate:

1. Open FRx Designer, and select the default company.
2. In the Control Panel, select Catalog.
3. Select the catalog.
4. Generate the report, and error "01000:[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated" followed by "The Report Yielded No Data" occurs.

Expected Behavior:

Generating FRx reports should not cause an error message.

Possible Workaround:

1. Open Sage MAS 500.
2. Expand General Ledger, Maintenance, and GL Setup. Double-click Set Up Account Structure.
3. Change one of the segments, and click Save.
4. Reset the segment to the original form, and click Save.
5. Generate the FRx report.