Problem, regarding filepath, when reading a file that is stored on the RM Server.

chris_skgchris_skg Member Posts: 20 Learner I
edited November 17 in Help
I have a RM Server running on a VM (Ubuntu) on top of my Win10 machine.
I have a process to read a .csv file and write its contents on a MySQL database on a MySQL Server which also runs on the same VM.

The problem is that the read file operator does not seem to be able to find the file.

Scenario1.
When I try as location-name in the read csv operator `../data/myFile.csv`
And run the process on Server I am getting `Failed to execute initialization process: Error executing process /apps/myApp/process/task_read_csv_to_db: The file 'java.io.FileNotFoundException: /root/../data/myFile.csv (No such file or directory)' does not exist.`

Scenario2.
When I try as location-name in the read csv operator `/apps/myApp/data/myFile.csv`
And run the process on Server I am getting `Failed to execute initialization process: Error executing process /apps/myApp/process/task_read_csv_to_db: The file 'java.io.FileNotFoundException: /apps/myApp/data/myFile.csv (No such file or directory)' does not exist.`

What is the right filepath that I should give to the Read CSV operator?

Tagged:

Best Answer

Answers

  • David_ADavid_A Administrator, Moderator, Employee, RMResearcher, Member Posts: 197  RM Research
    edited November 18
    I would say, the issue is that depending on the location of the JobAgent that is executing your process, the relative path might be varying.
    Is `/apps/myApp/data/myFile.csv` the correct path to the file? If not, I would suggest to use the absolute path to the file. Hope this helps.

    Best,
    David
    chris_skg
  • chris_skgchris_skg Member Posts: 20 Learner I
    I was trying to find the absolute path to the file but with no luck.

    I guess that it has to be somewhere in the /root/rapidminer-server/rapidminer-server-9.5.0/ or the /root/rapidminer-server/rapidminer-server-home/ but I wasn't able to find it.

    Could you or someone else please, tell me where exactly a new remote repository is created on a linux system?
  • sgenzersgenzer 12Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,636  Community Manager
  • chris_skgchris_skg Member Posts: 20 Learner I
    Thank you my friend that certainly helped! Although I wish I there was a way to have everything in one place.
  • mmichelmmichel Employee, Member Posts: 125   RM Engineering
    It depends on the file sizes but one other solution might also be to use web-services for it. You could POST your csv file to a RapidMiner web-service which is then writing the parsed content to the MySQL DB - then you don't need to mess around with file paths.

    Cheers,
    Marcel
Sign In or Register to comment.