FTP Enterprise stage Error: read file from windows XP server

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

nsm
Premium Member
Premium Member
Posts: 139
Joined: Mon Feb 09, 2004 8:58 am

FTP Enterprise stage Error: read file from windows XP server

Post by nsm »

I wanted to read file from Windows2000 server and write it into DB2.
My job design is like FTP Enterprise stage----->Transformer--->DB2/API stage.
Below are the errors I got .
I gave userid, Password and gave full path for URI.
>##E IIS-DSEE-TFOP-00020 15:13:43(006) <FTP_Enterprise_11> Error occurred during initializeFromArgs().
>##E IIS-DSEE-PFTP-00034 15:13:43(007) <FTP_Enterprise_11> uri : ftp://filepath/./../filename is not valid remote file.
##I IIS-DSEE-PFTP-00032 15:13:43(008) <FTP_Enterprise_11> uri : ftp://filepath/./../filename is having following ftp errors.
##I IIS-DSEE-PFTP-00033 15:13:43(009) <FTP_Enterprise_11> Not connected.
>##E IIS-DSEE-TCOS-00029 15:13:43(010) <main_program> Creation of a step finished with status = FAILED.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Not connected.

Hmm.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
nsm
Premium Member
Premium Member
Posts: 139
Joined: Mon Feb 09, 2004 8:58 am

Post by nsm »

Ray,

I gave full file path for URI.

Under connection I mentioned:
ftp command :ftp
username: user id for windows server
pasword: password.

can you help me anything with details above..I am confused on why its not connectig?

nsm.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Post your "full path".
-craig

"You can never have too many knives" -- Logan Nine Fingers
nsm
Premium Member
Premium Member
Posts: 139
Joined: Mon Feb 09, 2004 8:58 am

Post by nsm »

ftp://servername/folder1/Data transfer/Data load/New files/Files to Load/Filename.csv
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Was wondering... just a pathname here, so remove the "ftp" and "server name" parts as the stage takes care of that for you. And you may have problems with the space in the pathname, perhaps try the "short name" for that portion.
-craig

"You can never have too many knives" -- Logan Nine Fingers
nsm
Premium Member
Premium Member
Posts: 139
Joined: Mon Feb 09, 2004 8:58 am

Post by nsm »

Chulett,

ftp://servername has to be part of URI path in version8.

I tried reading the file from path which has no spaces , didn't work.
Not sure what's happening.

Thanks
nsm.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Me neither, don't have v8 to work with here.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kandyshandy
Participant
Posts: 597
Joined: Fri Apr 29, 2005 6:19 am
Location: Singapore

Post by kandyshandy »

NSM, did you try FTP to that server from command prompt?
Kandy
_________________
Try and Try again…You will succeed atlast!!
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Did you try it outside ds?
nsm
Premium Member
Premium Member
Posts: 139
Joined: Mon Feb 09, 2004 8:58 am

Post by nsm »

yes..Using PSFTP I can put the file on to Datastage server.
kandyshandy
Participant
Posts: 597
Joined: Fri Apr 29, 2005 6:19 am
Location: Singapore

Post by kandyshandy »

PUT or GET? From your DataStage server, did you try FTP to server from where you need to GET the files?
Kandy
_________________
Try and Try again…You will succeed atlast!!
nsm
Premium Member
Premium Member
Posts: 139
Joined: Mon Feb 09, 2004 8:58 am

Post by nsm »

Kandyshandy,

Please read my question properly.

nsm.
kandyshandy
Participant
Posts: 597
Joined: Fri Apr 29, 2005 6:19 am
Location: Singapore

Post by kandyshandy »

I understood like this. You want to get files from windows server to DS server and load the data to DB2. Am i right?

My question is
From your local machine, did you try doing FTP to windows server and GET the files? Was it successful?
Kandy
_________________
Try and Try again…You will succeed atlast!!
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

PSFTP is a form of secure FTP which is not what the stage uses, and which is why the suggestion is to let us know if plain old ftp works for you.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply