What is causing Error code 11402 The value of the property '' is invalid: 'Value does not fall within the expected range.'. Value does not fall within the expected range.?

Rafael Hernandez 5

I am trying to connect to an API that I have validated works via Postman from the virtual machine. Whenever I create the linked service in Azure Data Factory, it returns the error below;

Error code11402

DetailsThe value of the property '' is invalid: 'Value does not fall within the expected range.'. Value does not fall within the expected range.

However, the message does not specify which property is causing the error nor indicate what needs to be corrected. Below is the JSON code for the connection.

Any help diagnosing and correcting this would be greatly appreciated.

{
    "name": "<Removed for security purposes>",
    "type": "Microsoft.DataFactory/factories/linkedservices",
    "properties": {
        "type": "RestService",
        "typeProperties": {
            "url": "<Removed for security purposes>",
            "enableServerCertificateValidation": true,
            "authenticationType": "Basic",
            "userName": <Removed for security purposes>,
            "encryptedCredential": <Removed for security purposes>,
            "requestBody": "{\n \"matnr_low\": \"000000000050000000\",\n \"matnr_high\": \"000000000050000009\"}"
        },
        "annotations": []
    }
}

AnnuKumari-MSFT 31,561 Reputation points Microsoft Employee

2023-02-28T18:41:45.9066667+00:00
Hi @Rafael Hernandez ,

Thankyou for using Microsoft Q&A platform and thanks for posting your question here.

As I understand your question , you are getting an error "Value does not fall within the expected range." while creating the REST API linked service in ADF .

It seems the error might be occurring due to the request body you have passed in properties json having some range values.

If you take a look at the official documentation, it expects the REST API json having basic authentication to be in this format:

{ "name": "RESTLinkedService", "properties": { "type": "RestService", "typeProperties": { "authenticationType": "Basic", "url" : "<REST endpoint>", "userName": "<user name>", "password": { "type": "SecureString", "value": "<password>" } }, "connectVia": { "referenceName": "<name of Integration Runtime>", "type": "IntegrationRuntimeReference" } } }

Here is the documentation link: Use basic authentication for REST connector

typeProperties JSON only expects authenticationType , url,userName and password. Kindly try providing these necessary values and check if it works fine for you. You can leverage web activity to send post,put,delete,path requests and provide request body there.

Hope it helps. Kindly mark it as answer as accepted answer helps community.
Rafael Hernandez 5 Reputation points

2023-02-28T19:45:27.4433333+00:00

Thank you for taking the time to look into this. However, specifying the integration runtime routine did not resolve the issue. It just created another one - it says it cannot find the reference. I have triple-checked and its entered correctly.
AnnuKumari-MSFT 31,561 Reputation points Microsoft Employee

2023-03-02T10:03:27.4133333+00:00

@Rafael Hernandez ,

The suggested approach is to remove the 'requestBody' json from the linked service in addition with adding IR configuration. Did you try testing the connection after removing the requestBody json from the advanced option.

It would be helpful if you could provide the screenshot of the linked service . Thanks
Rafael Hernandez 5 Reputation points

2023-03-02T13:34:07.54+00:00

I did - it yielded the exact same results. It continues to error out with "The value of the property '' is invalid: 'Value does not fall within the expected range.'. Value does not fall within the expected range.".

There has to be something wrong with the way Azure Data Factory interacts with the API that is causing this. A VM in the same subscription is able to call the API via Postman without any issues so I dont think its a TCP issue. Without seeing a more detailed log of the error, its hard to see exactly what causes it to fail. I really wished Azure/Microsoft would include a detailed debug feature.

1 answer

Nag 0 Reputation points

2023-06-24T17:40:15.6+00:00

I have received same issue . Any suggestions and troubleshooting steps
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Share via

What is causing Error code 11402 The value of the property '' is invalid: 'Value does not fall within the expected range.'. Value does not fall within the expected range.?

1 answer