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.
2.
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
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.
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.
Additional Information
Keywords: SAP HANA, CASE, The query is not supported in the external data source, ERROR [42000]
Feedback
Yes
No
Powered by
