Error: "Failed to retrieve data from the database" (PJ Purchase order forms)
Description
Cause

You can change the description of some Project Management purchase order header items by clicking in a field and clicking Change Desc. The Crystal purchase order forms on the Reports menu don’t work with the new descriptions until you modify the reports. This doesn’t affect subcontracts.

This error can also occur if:

  • You don't map the report correctly in PJ Settings and Change Management
  • You select a non-task report selected instead of a task report

If the descriptions on the commitment header match the canned/default descriptions, check PJ Settings. Verify you selected a task-based report and the report exists in the mapped location.

Resolution

Choose an option below to resolve the error.

Modify the report design

Use Crystal Reports to modify the report to use the new descriptions.

If you don’t own Crystal Reports or aren’t comfortable with changing the report, contact your Sage Consultant for assistance. You can also use the Change the Descriptions option below instead.

  1. Open the report in Crystal Reports.
  2. Use Set Location and Verify Database to update the report to the new names.

Change the descriptions

Change the descriptions back to the default.

The Commitment menu item can have a different name if you changed it in File, Company, Settings, Custom Descriptions.

  1. In Project Management, from the Contract Control menu, select Commitments.
  2. Click List.
  3. Select a commitment that is a purchase order.
  4. Click OK. Click OK again if the message "Invoices have been generated against this Commitment..." appears.
  5. Click Header.
  6. Click in the appropriate box and click Change Desc.
  7. Type the description exactly as it originally appears in the software using the lists below as guides.
    • Left column boxes:
    • Ordered by
    • Terms
    • Ship via
    • Free on board
    • Misc alpha 5
    • Right column boxes:
    • Delivery date
    • Misc date 2
    • Misc date 3
  8. Click OK after you type the description.
  9. Repeat steps 4-5 for all descriptions that you need to change. Click Save Commitment when done.

Update permissions

Grant the user ODBC access.

Steps to duplicate
Related Solutions

Error: "Failed to retrieve data from the Database" (Troubleshooting)