How to fix "Value does not fall within the expected range." error for ADF linked Service

Question

When we trying to connect to DB2 system using copy activity we are getting the below error. The Pipeline was working with out issue till yesterday.

Source:DB2

Sink: SQL Server

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

Value does not fall within the expected range.

Thanks

Naveen

Answer 1

Hi Jaladi, Venkata Naveen Chand

Thanks for reaching out to Microsoft Q&A.

possibly trying one of the below should work.

If you are using Autoresolve Integration runtime then you need to allow incoming connections from it's unknown ip address into your VM. A better way to do this is install self hosted runtime on to the VM with the SQL Server, and that will solve most of your network issues

(Or)

https://techcommunity.microsoft.com/t5/azure-database-support-blog/lesson-learned-296-the-value-of-the-property-is-invalid-value/ba-p/3721700

Please 'Upvote'(Thumbs-up) and 'Accept' as answer if the reply was helpful. This will be benefitting other community members who face the same issue.

Answer 2

@Jaladi, Venkata Naveen Chand Welcome to Microsoft Q&A forum and thanks for reaching out here.

I did some investigation regarding this issue and noticed that this issue is caused due to recent regression from product side. Looks like the product team has applied a fix and the issue should be auto resolved by now.

In case if the issue still persists for you kindly confirm your Azure IR region and ADF region so that I can double check with internal teams.

Hope this helps.

---

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.