question

HarpreetSaini-3244 avatar image
0 Votes"
HarpreetSaini-3244 asked ShaikMaheer-MSFT commented

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

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.

105828-image.png
105829-image.png
105921-image.png


azure-data-factory
image.png (31.4 KiB)
image.png (30.2 KiB)
image.png (21.2 KiB)
· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @HarpreetSaini-3244 ,

I am not getting any error when I used a file which has : symbol in its data. Please check below screenshot for same.
106216-sourcetransfomation1.png
106078-sourcetransfomation2.png
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.

0 Votes 0 ·

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)
106273-image.png

The error I am getting is from the second line of the text file

0 Votes 0 ·

Thank you @HarpreetSaini-3244 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.

106651-image.png

0 Votes 0 ·
image.png (204.0 KiB)
Show more comments

Hi @HarpreetSaini-3244 ,

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.

0 Votes 0 ·

1 Answer

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered

Hi @HarpreetSaini-3244 ,

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
107102-datasetwithspacecoldelimitetor.gif

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
107048-sourcetransformationnew.gif

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 


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.