Error: "Failed to retrieve data from database" when previewing Billing invoice (Error in BLNP or BLCP)

Solution Properties

Solution ID:

225924150078620

Last Modified Date:

Wed Apr 05 13:24:09 UTC 2023

Taxonomy Path:

Category//Reporting//Printing

Author:

LegacyAuthorUS

Error: "Failed to retrieve data from database" when previewing Billing invoice (Error in BLNP or BLCP)

Description

Cause

This is a known issue that will be fixed in a future update. This may only occur on invoice formats that are based off of the subreports instead of portable crystal designs.

Resolution

Error only occurs when opened from the Billing application. Instead, launch Contract based Invoices or Invoice Formats from the Sage Desktop.

Error: "Failed to retrieve data from the database Details: [Database Vendor Code: 10001]" (Previewing an invoice in Billing)
Error: "Report is not a valid Crystal report design" (CryptoPrevent)
Error: "Failed to retrieve data from the Database" (Troubleshooting)

Steps to duplicate