Has anyone encountered the "The distribution failed: No such file" issue in WebFOCUS 8 (WF8)? If so, please let me know you thoughts and findings regarding this issue.

Background:
The ReportCaster job executes an MRE Standard Report which includes an extract for the report data and creates the Dynamic Distribution list (DDL) source file.
The ReportCaster distribution is set to FTP to a server using a DDL fex.
The DDL fex used to create the DDL is in the associated app folder (full code below) and uses the DDL source file which is created in the main extract MRE procedure.

WF7: Everything works fine.
WF8: I get the " The distribution failed: No such file " error. (any surprise here?)

Creation of the DDL source file used to create the DDL:

APP DELETEF AppFolderName SouceFileName MASTER
APP DELETEF AppFolderName SouceFileName FOCUS
APP HOLDDATA AppFolderName
APP HOLDMETA AppFolderName
-RUN
TABLE FILE SouceFileName
BY REPORT_NAME
ON TABLE HOLD AS WSS_DDL_SOURCE FORMAT FOCUS INDEX REPORT_NAME
END
-RUN

Creation of the DDL file used for FTP distribution:

TABLE FILE WSS_DDL_SOURCE
PRINT REPORT_NAME/A35 AS 'VALUE'
      REPORT_NAME/A35 AS 'DEST'
BY    REPORT_NAME NOPRINT
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SET ASNAMES ON
ON TABLE PCHOLD FORMAT XML
END
-RUN

This message has been edited. Last edited by: Doug,

Which of the following is true for the above , in WF8 (#1 works in WF7)?

1) ON TABLE PCHOLD
2) ON TABLE PCHOLD FORMAT XML
3) ON TABLE HOLD
4) ON TABLE HOLD FORMAT XML  

This turned out to be an issue with SFTP in ReportCaster... Issue Solved!

Hi. We're having the same problem with "The distribution failed: No such file." We're also using SFTP. If you don't mind saying, what was your issue, and how did you solve it?

We use FTP instead.

Hi,
we have the same issue with Report Caster FTP.
When we use \ in the path for the output file we get the error: Distribution failed: no such file
When we use / in the same path it works perfectly.
I have tested with sFTP and FTP
In both cases the same !

We are testing the 8.1.05 in our Test environment.
We have production running with 8.006