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?