Batch Macros

[MukeshM]

Hi All,

Currently we have 3 workflows extracting data from SAP Tables, being processed and dumped to SQL Tables. We are now in the process of chaining and running these workflows, one after the other, by converting these workflows to Standard and Batch Macros. However, the issue is that, while running the workflows on its own, each one takes less than an hour, but, while running as macros, it takes more than 4 or 5 hours. So, while chaining these 3 macros together, it runs only for 10hrs due to the session timeout and gets cancelled. Can anyone help me with the same on how to optimize the macro to reduce the run time? Also, is there any other way to chain workflows in the Server (Crew macros does not waste; tried Events, Interface designer and don't know how to configure API).

Regards,

Mukesh.

[apathetichell]

Hi Mukesh - Quick questions - are you running via DVW connector (!) or API? Are you sure that you've grouped your control parameters you are feeding into your batch macro?

[MukeshM]

I am running through DVW Connector.

1. I have added a Macro Output to the end of the Standard Macro (1st workflow). 

2. Converted the next 2 workflows to Batch Macros, which have control parameters in itself.

3. Connected the 1st workflow to Block Until Done. And then connected the 2nd workflow to 1st point of Block Until Done, 3rd workflow to the 2nd one.

[apathetichell]

That sounds like too many macros and too many block until dones. What are you feeding into the control parameters of the batch macros? Variants?

[MukeshM]

Hi,

This is the setup I have now.

[apathetichell]

right but what is the control parameter mapped to an how many values are you feeding in? each control parameter value is a run

[MukeshM]

There is currently no control parameter. Batch Macro automatically had a control input which is connected to Block Until Done Tool. Each workflow pushes out about a million rows. Sorry, if I am missing something you want.

[MukeshM]

There is a Macro Output in the 1st workflow, is all there is extra from the usual workflow.

[apathetichell]

Hi Mukesh - you have a control parameter. The control parameter of a batch macro must be mapped to a field. This is how a batch macro works. If you click on your batch macros (the ones with the upside down question marks) take a look at the "questions" tab in the configuration pain. It is mapped to a field. That field has rows. If those rows have n entries - your batch macro will run n times.

[MukeshM]

Ok. Where can I find which field is the Batch Macro is mapped to? I can't find any in the Questions tab.