Ytukyg

This may be related to this issue but the symptoms are different. Set Variable activity Azure Data Factory v2

What I am trying to do is simply increment a counter (CurrentOffset) that will cause the parent "until" activity to repeat until it reaches a value defined in the pipeline parameter (NumberOfDays).

I can see the variable I want to set (this is different to the above reported issue) but when I debug or run, it throws a 500 error with no error or message (see further below).

Here is a stripped down example.

{

"name": "RunWithDateArray",

"properties": {

        {

            "name": "Until",

            "type": "Until",

            "typeProperties": {

                "expression": {

                    "value": "@equals(pipeline().parameters.NumberOfDays,variables('CurrentOffset'))",

                    "type": "Expression"

                },

                "activities": [

                    {

                        "name": "Set Variable1",

                        "type": "SetVariable",

                        "typeProperties": {

                            "variableName": "CurrentOffset",

                            "value": {

                                "value": "@{add(int(variables('CurrentOffset')),1)}",

                                "type": "Expression"

                            }

                        }

                    }

                ],

                "timeout": "7.00:00:00"

            }

        }

    ],

    "parameters": {

        "NumberOfDays": {

            "type": "String",

            "defaultValue": "3"

        }

    },

    "variables": {

        "CurrentOffset": {

            "type": "String",

            "defaultValue": "0"

        }

    }

},

"type": "Microsoft.DataFactory/factories/pipelines"

}

This is the resulting error

{"headers":{"normalizedNames":{},

"lazyUpdate":null},

"status":500,

"statusText":"Internal Server Error",

"url":"https://management.azure.com/subscriptions/8d******-****-****-****-********1469/resourcegroups/datawarehouse/providers/Microsoft.DataFactory/factories/TVLDFACTORY02/pipelines/RunWithDateArray631f7f37-a858-4fdf-9fd8-89adf581a63e/sandbox/create?sandboxId=ada11f9e-a604-42ba-8571-f58ac84958c3&api-version=2017-09-01-preview",

"ok":false,

"name":"HttpErrorResponse",

"message":"Http failure response for https://management.azure.com/subscriptions/8d******-****-****-****-********1469/resourcegroups/datawarehouse/providers/Microsoft.DataFactory/factories/TVLDFACTORY02/pipelines/RunWithDateArray631f7f37-a858-4fdf-9fd8-89adf581a63e/sandbox/create?sandboxId=ada11f9e-a604-42ba-8571-f58ac84958c3&api-version=2017-09-01-preview: 500 Internal Server Error",

"error":"{

  "code":"InternalServerError",

  "message":"InternalServerError executing request",

  "target":"pipeline/RunWithDateArray631f7f37-a858-4fdf-9fd8-89adf581a63e/runid/7c666c38-67a6-4743-a068-fff623176f23",

  "details":null,

  "error":null}"

}

Is there a work around for looping on a variable where that variable is updated in a nested activity? Note that I can successfully loop an array because this is defined in the outer activity.

Thanks, Mark.