Focal Point
[CLOSED] ReportCaster FTP to network drive?

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2027097916

May 04, 2012, 12:54 PM
Doug
[CLOSED] ReportCaster FTP to network drive?
FTPing to network drive from ReportCaster should be simple.

Maybe this is a brain freeze or something. But, while I can email a report to an email address (showing that the RC job and report functionality is fine.), I cannot FTP it to a network drive. BTW: My id/pw are correct.

The FTP results is "Schedule ID: [job id], Job Description: [job name] Completed with errors/warnings unable to distribute to FTPtest.pdf \\this.net\folder1\folder2\folder3".

This message has been edited. Last edited by: <Kathryn Henning>,




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Currently with Fidelity Investments
May 06, 2012, 10:28 PM
Rao D
Is the WebFOCUS server having access to the network drive location?
The user id/pwd you mentioned are those the details used for schedule execution
or
Are those the details to access the destination?

Does the user id/pwd has write access to that location?


WebFOCUS - ver8201
[ReportingServers: Windows 64bit;
Client: tomcat and IIS on windows 2012
AppStudio

May 07, 2012, 01:37 AM
StuBouyer
This may seem like an obvious question, but do you have an FTP server running on any of your machines?

If you turn on all traces you will see that ReportCaster tries to connect to an FTP server using FTP client commands. If there is no server then it fails.

If you do have an FTP server running, then look at the ReportCaster full log to see if it gives more information on why it fails. Otherwise run it again with traces enabled.


WebFOCUS 8.2.03 (8.2.06 in testing)
May 07, 2012, 09:55 AM
Doug
I'll check the logs to get the answers to your questions.

My desired destination is the shared network drive where my, and all other users have their, network drives. Perhaps I need the pw/id for the base network drive and not just my own (full path) id/pw?

Like I said, I'll check the logs...
April 18, 2013, 01:58 PM
cs_source
hello, did you happen to find out what the issue was? i have a similar error where i'm trying to run a report and output is excel to a network share.

in the log is shows all is well except the distribution failed and i believe i might not have the right settings...


WebFocus 8.02, SQL Server 2008r2
April 19, 2013, 04:57 AM
Martin vK
We had similar issues.
In the end in our case it had to do with the user which was used for the WF reporter server (service). We had to change this from the system user to another user which could be provided the correct rights on the network share. By the way, the service seems only to run if the system user is used or exactly the same use which was used during WF installation.


WebFocus 8203M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
April 22, 2013, 11:22 AM
cs_source
Hi Martin vK,

interesting, i have the user who WF was installed under as the user executing the schedule. When i edit my schedule i see that the distribution has the following fields:

Type:
- Distribution List
- Distribution File
- Single File <- selected
- Dynamic Distribution List

Name:
- Name of file

Directory
- E:\xxx (this directory exists on the WF server itself as well as the user has accessibility to the share itself)

In the error log everything checks out except this line:

BTP1010 The distribution failed: Connection refused: connect


WebFocus 8.02, SQL Server 2008r2
April 23, 2013, 05:28 AM
Martin vK
You write "i have the user who WF was installed under as the user executing the schedule", but is this also the user account which the SERVICE of WebFOCUS Server and WebFOCUS ReportCaster use to Log on? Please check your Services.
If this is okay, I suggest to put some traces on to get more information.


WebFocus 8203M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
April 23, 2013, 07:41 AM
Madasabear
Dull questions but are you fully qualifying the address rather than E:\ or something.
Second thing to try is to use a DOS NET USE command to map a drive from your webfocus side of things.


Developer Studio Release : 7.6.11
April 23, 2013, 10:16 AM
cs_source
hi Martin/Madasabear,

Yes the account i am using is the the master account we used for WF install and is able to logon to the server and reportcaster.

I am also using the full address but i will look into DOS NET USE.

I'll keep working away at it thanks for the help so far!


WebFocus 8.02, SQL Server 2008r2