Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED] The distribution failed: No such file (WebFOCUS 8)

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CASE-OPENED] The distribution failed: No such file (WebFOCUS 8)
 Login/Join
 
Doug
Expert
posted
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,




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Doug
Expert
posted Hide Post
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
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Doug
Expert
posted Hide Post
Smiler This turned out to be an issue with SFTP in ReportCaster... Issue Solved!
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
hiredgun
Member
posted Hide Post
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?


Test: Win 7 SP1, Dev Studio 8.0.07, SQL Server 2K8, PDF, EXL2K
Prod: Win 2K3/8, WF 7.7.02m, SQL Server 2K5/2K8, PDF, EXL2K
 
Posts: 4 | Location: Cincinnati | Registered: February 04, 2005Report This Post
Doug
Expert
posted Hide Post
We use FTP instead.
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Bernard Hakir
Member
posted Hide Post
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 !


WebFOCUS 8.0.06 on Win2008/Tomcat7/LDAP Mode
 
Posts: 2 | Registered: February 14, 2014Report This Post
Bernard Hakir
Member
posted Hide Post
We are testing the 8.1.05 in our Test environment.
We have production running with 8.006


WebFOCUS 8.0.06 on Win2008/Tomcat7/LDAP Mode
 
Posts: 2 | Registered: February 14, 2014Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED] The distribution failed: No such file (WebFOCUS 8)

Copyright © 1996-2020 Information Builders