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.
Environment
-
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
Cause
-
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
Resolution
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"
See Also
Page 20:
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.
Keywords
Join Syntax, failure , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem