The ABAP Dataflow is taking long time to complete i

[Former Member]

The ABAP Dataflow (AAA) which is a part of the ETL Job'ABC' is taking long time to complete in SAP after the HANA Rehosting.

Thanks & Regards,

Bhargav

[Former Member]

I am verifying code once done I will let you know.

[former_member220897]

First, verify that the issue is on ABAP side, by going to the trace log and comparing the timestamps for starting and finishing the ABAP program. If that is the case, generate the ABAP program (right click on the ABAP dataflow) and switch to "Execute Preloaded" option in the datastore options, and you should be able to use ABAP Debugger tools in SAP GUI while running the job to narrow down the issue to specific queries to SAP HANA (unfortunately there is no debugger for ABAP Dataflow in Data Services).

[former_member198401]

What is your ABAP Data flow doing? Does it contain huge SAP Tables. You should be very careful while extracting SAP Table data.

Analyze the joins on tables.

Was the ABAP Data flow working previously or is it the first time you are accessing SAP Tables using ABAP Data flow

Regards

Arun Sasi

[Former Member]

I am new for data services, Please let me know answrer.