Pushdown syntex Error in Data Services

[former_member438016]

Hi ,

When I am trying to Pushdown my data in Data services I am getting syntax error. I am taking HANA View as a source file.

syntax error: database name not allowed in single-container mode: line 1 col 265 (at pos 265)>. The SQL submitted is <SELECT "BODIVView1"."_BA1_C55YPER" , "BODIVView1"."_BA1_C40FTRAN" , "BODIVView1"."SK_Policy" FROM "_SYS_BIC"."IFP_Financials.SDL_RDL_Views/POC_MDM_PER" "BODIVView1" where IFP_Financials.SDL_TDL_View.POC_MDM_PER.SK_Policy IN (SELECT DISTINCT SK_Policy FROM IFP_Financial.SDL_RDL_VIEWS.POC_MDM_POL) >.Kindly Please help me on this.

Thanks

Naresh

[former_member208402]

Hi Naresh,

Problem is here i guess "FROM IFP_Financial.SDL_RDL_VIEWS.POC_MDM_POL"

try giving only "FROM SDL_RDL_VIEWS.POC_MDM_POL"