- 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]Error ID: 29
Severity: ERROR Facility: FPSRVERR - Line 1, column 206
(around "INNER"): Syntax error.
SAP Crystal Reports 2016
Rocket U2 database
U2 ODBC driver
Reproducing the Issue
Create a report with two tables in Crystal Reports
Join the tables
Refresh the report
The error comes from the Rocket U2 database, because of the standard table join syntax used in the SQL Query is not supported by Rocket U2 database.
- Incorrect driver configuration
Configure the Rocket U2 ODBC driver to change how the Table Join are performed
- Open 32 bit ODBC Administrator
- Configure the relevant DSN
- Click "Options" and check "U2 ODBC as 2.0"
Use U2 ODBC as 2.0 – Select this option to run U2 ODBC version 2.0. By default, ODBC runs in version 3.0. Sometimes, the SQL syntax generated by Crystal Reports or Microsoft SQL Server 2008 is not recognized by the UniVerse SQL engine. In those instances, users running Crystal Reports or Microsoft SQL Server 2008 will need to use U2 ODBC 2.0.
Join Syntax, failure , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem