SYMPTOM

When working with a File metadata (executing a read or write mapping, replicate File to rdbms...) the following error occurs :

Error: FileDriverStatement::executeQuery, error opening the file \\servername\d$\Data\IN\CUSTOMER-20180808-134523.txt

The file is located on a shared drive.

SOLUTION

This is generally due to permission issues.

  • Verify that the user which runs the Runtime has permission on the shared drive
  • Alternatively, share the folder instead of the drive : \\servername\IN\...