Error appears when running certain 'CASE' statements using SAP HANA connector
Article ID: KB0075851
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | 10.3 |
Description
When running a query containing a 'CASE' statement using the SAP HANA connector, the error "The query is not supported in the external data source." appears.
Below are 2 examples of external errors that can appear:
1.
ERROR [42000] [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 sql syntax error: incorrect syntax near "-":line x col y
2.
ERROR [42000] [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 sql syntax error: incorrect syntax near "IN": line x col y
Environment
Windows
Resolution
This is a known issue in 10.3.
The errors appear when using CASE statements with relation expressions (for example A=B) together with 'WHEN' or 'THEN', or using CASE statements with 3 or more conditions (for example A=B or B=C or C=D).
This is fixed in 10.3.3 HF-014.
The errors appear when using CASE statements with relation expressions (for example A=B) together with 'WHEN' or 'THEN', or using CASE statements with 3 or more conditions (for example A=B or B=C or C=D).
This is fixed in 10.3.3 HF-014.
Issue/Introduction
Error "The query is not supported in the external data source." appears when running certain CASE statements using SAP HANA connector in TIBCO Spotfire 10.3.
Additional Information
Keywords: SAP HANA, CASE, The query is not supported in the external data source, ERROR [42000]
Feedback
Yes
No
Powered by
