Is there any way to get UNC paths to work with version 3.4.1?
I am trying to read files from network shares. When I input the path like this:
\\\\server\\share\\file
Or like this:
file:////server//share//file
Within a spreadsheet data reader, it loads the sheet names properly, and I can even click the “Mapping” ellipsis, and it will show my data in the file. Once I run the graph, I get an error saying that the file could not be found. Clearly it can be found if it can load the proper sheet names and show me the data, but it can’t load it?
I found a thread that says version 3.5 supports UNC paths, but if the reader can see my data from the Mapping screen, why can’t it read it when I execute?
Hello,
The first thing we need to realize is that we do not support UNC paths in CloverETL 3.4 in any way. The official support of UNC paths came in CloverETL 3.5 and File URLs should always start with prefix smb://
It may appear that 3.4 can also work with UNC paths because some of the required functionality is partially available but the key parts are still missing there. As you probably know, CloverETL Designer is an Eclipse plug-in and it is possible that Eclipse IDE tries to deal with UNC paths by itself. However, CloverETL Engine which runs CloverETL graphs is not Eclipse-based and your graphs containing UNC paths therefore fail with various errors.
If you do not use CloverETL Server, the workaround should be simple. Just map your shared folder as a new network drive (for example Z) and use URL like Z:\folder\file when referring to the file. In case you use CloverETL Server, the workaround would be more complex and dependent on the way you use the Server. For more information, see the links below.
https://bug.javlin.eu/browse/CLO-860
https://bug.javlin.eu/browse/CLO-651
https://bug.javlin.eu/browse/CL-1229
How to access UNC (windows share) paths
Map a network drive to be used by a service
I hope this helps.