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.?

Question

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 15

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 34,556 Reputation points Microsoft Employee Moderator

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 15 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 34,556 Reputation points Microsoft Employee Moderator

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 15 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.
Anonymous

2024-12-05T11:31:01.7433333+00:00

Im having the similar issue using REST connector. Did you get through this?

3 answers

Your answer

AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator

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 15 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 34,556 Reputation points Microsoft Employee Moderator

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 15 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.
Anonymous

2024-12-05T11:31:01.7433333+00:00

Im having the similar issue using REST connector. Did you get through this?

Answer 1

Nag 0

I have received same issue . Any suggestions and troubleshooting steps

George, Thomas 0 Reputation points

2024-08-01T17:56:38.9766667+00:00

I end up with this error in my azure data factory linked service to azure sql managed instance. Please let me know if there is any suggestions

Answer 2

George, Thomas 0

I also have the same issue for my data factory which use service principal authentication to managed instance. Please advise if you have any suggestion

Answer 3

George, Thomas 0

I have resolved the issue. In my data factory i was using autoresolve IR which has been replaced with selfhosted IR and that resolved the issue. Below link helped me to resolve the issue

https://stackoverflow.com/questions/76311217/azure-data-factory-unable-to-connect-to-sql-server-in-vm-error-11402

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.?

3 answers

Your answer