As per line
DEFAULT DIRECTORY dat_dir
I expect ODI to write the files in DIRECTORY dat_dir.
Execute "select * from all_directories" and check to what folder is directory dat_dir mapped.
Update: I figured that the path is defined with the java.lang.System.getProperty method. The string parameter was "user.home", which points to my user directory (this was the default value). I changed it to "user.dir", which points to the work directory:
But I got a different error, this time on the work path.
"KUP-04001: error opening file C:\Oracle\Middleware\Oracle_Home\odi\studio\bin/XC_1DATASET.log"
So I guess I don't have read/write permissions on these paths. I will keep on digging but I wonder if anyone else has had this problem before. Cheers.