cancel
Showing results for 
Search instead for 
Did you mean: 

SAP WebIDE Fullstack: How to monitor Flowgraph execution?

iashishsingh
Participant

We are using Smart Data Integration to load data from CSV files using a FileAdapter. The data preview can be seen using the virtual tables created for the data input. Next, to load the data from virtual tables to target HANA tables in the HDI instance, we are using Flowgraphs in the SAP WebIDE Fullstack. However, when executing a flowgraph, it is observed that many times it is stuck and no related information is seen under the 'Tasks' for the related HDI instance.

Is there a better way to monitor the Flowgraph execution?

The flowgraph execution appears stuck as follows:

1. When we execute the Flowgraph, a message can be seen in the WebIDE Console

15:53:23 (/MyApp/db) Start executing FG_BATCH_Customer....

No message for end of execution is seen.

2. Inside the HDI instance of the app opened via the Database Explorer, under Tasks, the Flowgraph is seen but when opened, no information is available:

Any information is highly appreciated.

Thanks!

0 Kudos

Hi Ashish

Did you solve this issue? I am with the same problem now.

Accepted Solutions (1)

Accepted Solutions (1)

iashishsingh
Participant
0 Kudos

Hi Renato,

There are a couple of things to be kept in mind:

1. When you start an execution, a start of execution message is printed in the WebIDE console. Please note the TASK ID of the execution task. You can also find the same information by logging into the DB Explorer > Select HDI Container > Tasks > Your task name.

2. If you think the task is stuck, you should cancel this task from the SQL console of the respective HDI container.

3. It depends on how big your HANA instance and the client machine is but we used to process at max 400MBs of files in a single execution. (Client 8GB RAM. HANA 32GB)

4. Execute only one tasks at a time.

5. When a task is running, its information can be seen in the Task information screen as found in DB Explorer > Select HDI Container > Tasks > Your task name.

6. Make sure your SDI Agent is connected to HANA instance

Answers (0)