Stored procedure activity ADF V2

Question

I'm using a stored procedure activity for ADF v2 pipeline. Now issue here is whenever the pipeline fails at the stored procedure activity I'm not getting the complete error details. Below is the JSON output of that stored procedure activity:

{
    "effectiveIntegrationRuntime": "DefaultIntegrationRuntime (West Europe)",
    "executionDuration": 416,
    "durationInQueue": {
        "integrationRuntimeQueue": 0
},
"billingReference": {
    "activityType": "ExternalActivity",
    "billableDuration": [
        {
            "meterType": "AzureIR",
            "duration": 0.11666666666666667,
            "unit": "Hours"
        }
    ]
}
}

Please let me know how do I get the error details for the stored procedure activity for ADF v2 pipeline?

Answer 1

You should throw the exception in your stored procedure code:

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/throw-transact-sql?view=sql-server-ver15