SAP Knowledge Base Article - Preview

2848201 - Error "Failed to retrieve data from the database" when refreshing a report based off Rocket U2 DB in Crystal Reports

Symptom

  • Failed to add a second table to report
  • After joining two tables in Crystal Reports received the following error:

Failed to retrieve data from the database.

Details: S1000:[Rocket U2][U2ODBC][1401263]Error ID: 29

Severity: ERROR Facility: FPSRVERR - Line 1, column 206

(around "INNER"): Syntax error.


Read more...

Environment

  • SAP Crystal Reports 2016
  • Rocket U2 database
  • U2 ODBC driver

Product

SAP Crystal Reports 2016

Keywords

Join Syntax, failure , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.