Problem with FTP & Telnet

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
MESSIER1
Participant
Posts: 23
Joined: Wed Aug 20, 2003 5:38 am

Problem with FTP & Telnet

Post by MESSIER1 »

Hello all,

We are in the process of moving our ERP system to a new server and are currently testing and validating the DataStage jobs against the new server. One particular job FTPs data off the server to pass to a target server then is supposed to execute a 'Telnet After Command'. However, it is not executing the comand due to the following messages:

Project:PRD_IT_QISWPAITF (tor-etl-02)
Job name:RcvJdatAvanteExtract
Event #:97
Timestamp:7/30/2009 5:31:29 PM
Event type:Info
User:TOR-DOWTY\mo008408
Message:
RcvJdatAvanteExtract..SRC_RECEIPTS: 'RECV' call failed, error number = [10035]


Project:PRD_IT_QISWPAITF (tor-etl-02)
Job name:RcvJdatAvanteExtract
Event #:98
Timestamp:7/30/2009 5:31:29 PM
Event type:Info
User:TOR-DOWTY\mo008408
Message:
RcvJdatAvanteExtract..SRC_RECEIPTS: unable to get response from the FTP server after sending the command QUIT


I turned on tracing for the FTP stage and discovered that the acknowledgement message on the new server is different to the one on the old server. Is there something that can be done in the job design (triggers?) or modifying the server's FTP properties to mitigate this issue? Here are examples of the FTP messages coming from the 2 servers. Please note that the DataStage job has not been modified in any way.

Old Server
Project:PRD_IT_QISWPAITF (tor-etl-02)
Job name:RcvJdatAvanteExtract
Event #:146
Timestamp:8/18/2009 2:05:49 PM
Event type:Info
User:TOR-DOWTY\mo008408
Message:
RcvJdatAvanteExtract..SRC_RECEIPTS: 221 Goodbye.


New Server
Project:PRD_IT_QISWPAITF (tor-etl-02)
Job name:RcvJdatAvanteExtract
Event #:96
Timestamp:7/30/2009 5:31:29 PM
Event type:Info
User:TOR-DOWTY\mo008408
Message:
RcvJdatAvanteExtract..SRC_RECEIPTS: 221-You have transferred 1656 bytes in 1 files.


Thanks in advance for any advice you can offer.

Regards,

Wayne Morris
jhmckeever
Premium Member
Premium Member
Posts: 301
Joined: Thu Jul 14, 2005 10:27 am
Location: Melbourne, Australia
Contact:

Post by jhmckeever »

Hi Wayne,

On the Stage -> Properties tab, what do you currently have defined for the Telnet Prompts?

John.
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
MESSIER1
Participant
Posts: 23
Joined: Wed Aug 20, 2003 5:38 am

Post by MESSIER1 »

Hi John,

The prompts are login: and Password:. The 2 servers send identical prompts.

Regards,

Wayne
Post Reply