ADF data flow Error: at Source 'source1': java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: "ISV:%20runge,%20RLM%20version%2014.2%20BL2%22

Harpreet Saini 21

Hello,
I'm testing out Azure Data Factory and to process a space separated text file and been running into the following error:
Error:
at Source 'source1': java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: "ISV:%20runge,%20RLM%20version%2014.2%20BL2%22

Now I know that I can't have a colon (:) in the file name but this text is from the contents of the file. And it is not possible to remove every colon from the file contents.

ShaikMaheer-MSFT 38,441 Reputation points Microsoft Employee

2021-06-16T12:20:07.367+00:00
Hello @Harpreet Saini ,

I am not getting any error when I used a file which has : symbol in its data. Please check below screenshot for same.

Hence, Could you please help us on below clarifications, so that we can repro scenario to help you better

You said "but this text is from the contents of the file", It would be great help if you can provide sample content here to repro scenario.

Your Wildcard path under Source settings is not pointing to any file. Is that intentional ? Could you please check your Wildcard path is pointing to correct path.

Thank you.
Harpreet Saini 21 Reputation points

2021-06-16T14:18:43.287+00:00

Below is the sample file that might help reproduce the scenario. As I said earlier, it is space separated file

106256-sample-file.txt

----------

The wildcard path in source option is filled with name of the file, (in this case Teck1.rl.2021.06.14)

The error I am getting is from the second line of the text file
ShaikMaheer-MSFT 38,441 Reputation points Microsoft Employee

2021-06-17T11:24:07.277+00:00

Thank you @Harpreet Saini for sharing sample file.

It seems your file has some unwanted rows at the top. Kindly confirm is my understanding correct?
If yes, your file has some unwanted columns, then could you please share from which number of row your data starts.
Harpreet Saini 21 Reputation points

2021-06-17T13:44:21.717+00:00

The exact row number is 7
starting with "START ls28.rlmcloud.com 05/31/2021 00:00:51"
ShaikMaheer-MSFT 38,441 Reputation points Microsoft Employee

2021-06-21T05:47:14.477+00:00

Hi @Harpreet Saini ,

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know. Thank you.

Accepted answer

ShaikMaheer-MSFT 38,441 Reputation points Microsoft Employee

2021-06-18T11:39:51.18+00:00
Hi @Harpreet Saini ,

Thank you for sharing requested details.
I tried your sample file in Source transformation and tried to data preview its working fine. Below are the steps to follow

Step 1: Create a dataset for your file and make sure to use space as column delimitator

Step 2: In data flow, source transformation - add your dataset and if you have any rows to skip from file then mention that count as below. In my case I used lines to skip as 7

Hope this helps.

----------

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

Want a reminder to come back and check responses? Here is how to subscribe to a email-notifications
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

ADF data flow Error: at Source 'source1': java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: "ISV:%20runge,%20RLM%20version%2014.2%20BL2%22

0 additional answers

Your answer