FDA Extraction Workflow Error | Adobe Higher Education
Skip to main content
P
pradyumns539618
Level 2
August 13, 2021
Vraag

FDA Extraction Workflow Error

  • August 13, 2021
  • 2 reacties
  • 1153 Bekeken

Hi ,

I am facing some issue when trying to read / extract the data through SAP Hana FDA connection in AC .

FDA connection is successful but when trying to fetch the data from source system (SAP Hana) through workflow using RDBMS activity getting below error, does anyone know why this error wkf is throwing ? please let us know the workaround if anyone knows . @_manoj_kumar_ @jonathon_wodnicki @darren_bowers @krishnanunni @davidkangni @david--garcia @adhiyan @ericperrin @marcel_szimonisz @minakshis868318                                                                                                                            Thanks!

Er kunnen geen reacties meer worden geplaatst op dit onderwerp.

2 reacties

Marcel_Szimonisz
Community Advisor
Marcel_SzimoniszCommunity Advisor
Community Advisor
August 13, 2021

Hello @pradyumns539618 ,

Its saying syntax error. its your sql or its generated? 

Also is saying access violation. can you access with that user to the table?

 

marcel

P
pradyumns539618Auteur
Level 2
August 13, 2021

Hi @marcel_szimonisz  ,

Its workflow generated SQL , based on our condition in the RDBMS activity .

and yes User has access to the table , but it throwing the above error when we reading the data through workflow .

 

Thanks!

Kishore_Padamata
Adobe Employee
Kishore_PadamataAdobe Employee
Adobe Employee
August 19, 2021

Hello @pradyumns539618 
Believe the table name is not correctly provided.
Thinking the table name should be something like "SAPE5P"."06W:BIA:0PLANT"
Please correct the table name and retry.
Hope this helps!

    ForumvoorwaardenAccessibility statement

    Loading footer...