Failed batch macro

kempo1981

Hi,

I receive a mixture of errors when i try to submit my workflow (attached).

The dataset is network utilisation (target MAX) and i'm looking to forecast the next months figure. It works perfectly fine individually in the batch macro wen i change the control parameter 'instance', but fails when i then try and perform multiple instances.

Any help is greatly appreciated!

Thanks

Mark

Macro.png

(NEW) Cap Mgt Batch Macro.yxmc

Workflow.png

Errors.png

danilang

Hi @kempo1981 

It looks like your action tool isn't properly configured

The Replace a specific string: command looks for the string in the input and replaces it with the control parameter.  Your filter is 

[instance] = "" AND [region]="AP"

and the Action tool is looking for 

[instance] = "AUABFPROW0002R GigabitEthernet0/0"

"AUABFPROW0002R GigabitEthernet0/0" doesn't exist in the filter string, so nothing changes and your entire data set is passed to the ETS tools which complains because of the duplicated date values.  

I assume that what you want to do is insert the control parameter value (similar to "AUABFPROW0002R GigabitEthernet0/0")  into the quotes following "[instance] =" .  Change your filter to 

[instance] = "AUABFPROW0002R GigabitEthernet0/0" AND [region]="AP"

 and change the config of the Action tool to this 

This will replace the AUAxx value in the Filter with the current control parameter for this iteration of the macro

Dan

(NEW) Cap Mgt Batch Macro v2.yxmc