Symptom
Error running HANA Job and cannot export Data flow
(14.1) 06-01-13 01:12:05 (E) (1647:1570776144) DBS-070404: |Data flow <DF Name>|Reader Query
SQL submitted to ODBC data source <SAP HANA PROD> resulted in error <[SAP AG][LIBSDBOD SO][HDB] General error;257 sql syntax
error: zero-length delimited identifier""": line 1 col 1066 (at pos 1066)>. The SQL submitted is
<SELECT"yyyyView"."xxxxx" , "yyyyView"."xxxxx" , "yyyyView"."xxxxxx" , "yyyyView"."xxxxx"
, "yyyyView"."xxxxxx" , "yyyyView"."xxxxxx" , "yyyyView"."xxxxxx" ,"yyyyView"."xxxxxx" , "yyyyView"."xxxxxx" , "yyyyView"."xxxxxx" ,"yyyyView"."xxxxxx" , "yyyyView"."xxxxxx" ,
"yyyyView"."xxxxxx" ,"yyyyView"."xxxxxx" , "yyyyView"."xxxxxx" , "yyyyView"."xxxxxx" , "yyyyView"."xxxxxx" ,
"yyyyView"."xxxxxx" , "yyyyView"."xxxxxx" , "yyyyView"."xxxxxx" , "yyyyView"."xxxxxx"
, "yyyyView"."xxxxxx" , "yyyyView"."xxxxxx" , "yyyyView"."xxxxxx" ,
"yyyyView"."xxxxxx" , "yyyyView"."xxxxxx" , "yyyyView"."xxxxxx" ,
"yyyyView"."xxxxxx" , "yyyyView"."xxxxxx" , "yyyyView"."xxxxxx" , "yyyyView"."xxxxxx"
FROM "_SYS_BIC".""ooo.sap.oo/XYZXYZXYZXYZ"" "yyyyView" where ( "yyyyView"."xxxxxx" >= '201305') and ("yyyyView"."xxxxxx" <= '201305') >.
Read more...
Environment
- SAP Data Services 4.1
- All Supported platforms
- HANA version REV 55
Product
Keywords
KBA , EIM-DS , Data Services , 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.
SAP Knowledge Base Article - Preview