[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: FTPAPI quit working
Can you use FTP from the i command line? Try that, and if you can't
connect, try setting (or unsetting) passive mode.
On Tue, Nov 8, 2016 at 1:51 PM, Jeff Crosby
<[1]jlcrosby@xxxxxxxxxxxxxxxx> wrote:
� �Forgot to add one thing.
� �There is a 3rd place we use FTPAPI.� We FTP files to a couple
of
� �workstations on the LAN (i.e., inside the firewall) and that
works.
� �On Tue, Nov 8, 2016 at 1:12 PM, Jeff Crosby
� �<[1][2]jlcrosby@xxxxxxxxxxxxxxxx> wrote:
� �All,
� �IBM i 7.1, up to date on PTFs.
� �We've been using FTPAPI for 8+ years for 2 purposes:
� �1) FTP purchase orders to a single vendor several times per
week
� �2) FTP a sales report once a week to a totally unrelated vendor
� �Starting last Wednesday, the FTPing of those purchase orders
stopped
� �working.� What happens is the connection is made, sign on
occurs, and
� �when the "STOR" command is issued, it just stops. �It
literally sat
� �there from 8:12am to almost 5pm.� The reason I saw it is that
it
� �started interfering with end-of-day activities.
� �Here is the IBM i joblog of a retry attempt of mine:
� �Job . . : � JLCROSBYC1 � �User . . : � JEFF � � �
� �Number .
� �. . : � 170213
� �� � � � � � � � � � � � � � � �
� � � � � � � � � �� � � � � � � � � � � � � �� � �3>> PO09 VNDNR(02378) WEEK(44) DIGIT(1) POSTYLE(*DOT) � �
� � � � � �� � � � �� � �� � � �143 - CALL PGM(PO09) � � � � �/* The
CALL command
� �contains parameters
� �� � � */ � � � � � � � � � � � �
� � � � � � � � � �� � � � � � � � � � � � � � � �� � Object PO02378441 in QTEMP type *FILE created. � �
� � � � � �� � � � � � � � �� � 1 objects duplicated. � � � � � � � �
� � � � � � � �� � � � � � � � � � �� � �� � Ownership of object QCPEXTEMPS in QTEMP type *USRSPC
changed. � � �� � � �� � �� � Ownership of object QACP170213 in QTEMP type *USRSPC
changed. � � �� � � �� � �� � Ownership of object QACEXFLD12 in QTEMP type *USRSPC
changed. � � �� � � �� � �� � Ownership of object Q4T9TT02 in QTEMP type *FILE
changed. � � � �� � � � �� � �� � All records copied from file PO02378441 in QTEMP. �
� � � � � �� � � � � �� � �� � Object changed. � � � � � � � � � �
� � � � � � � �� � � � � � � � � � � �� � �� � Object changed. � � � � � � � � � �
� � � � � � � �� � � � � � � � � � � �� � �� � Object PO02378441 in QTEMP type *FILE deleted. � �
� � � � � �� � � � � � � � �� � 0: FTPAPI version 2.2 released on 2005-09-20 � �
� � � � � � �� � � � � � � � �� � �0: 220 **********, Inc. FTP Server � � � � � � �� � �0: > USER dilgard � � � � � � � � �
� � � � � �� � �0: 331 Password required for dilgard. � � � � �� � �0: > PASS ********** � � � � � � � �
� � �� � �� � �0: 230 User logged in. � � � � � � �
� � �� � �� � �0: > CWD In � � � � � � � � � �
� � � � � � � �� � �0: 250 CWD command successful. � � � � � � � � �� � �0: > TYPE I � � � � � � � � � �
� � � � � � � �� � �0: 200 Type set to I. � � � � � � � �
� � � � �� � �0: > PORT 192,168,0,1,74,7 � � � � � �
� �� � �� � �0: 200 PORT command successful. � � � � � � � �� � �0: > STOR PO02378441.csv � � � � � � �
� �� � �� � �0: 150 Opening BINARY mode data connection.
� �and that's it.� That was last Wednesday.� The WRKACTJOB
display of
� �that job is this:
� �� � � � � � � � � � �Current � � �
� � � � � � � � �� � � � � � � � � � � ��Opt �Subsystem/Job �User � � � �Type �CPU % � Function � � � �� �Status
� �� � � � JLCROSBYC1 � JEFF � � � �INT � � � .0 �CMD-PO09 � � �� � � TIMW� � �The help text for status TIMW says:
� �TIMW � � � � � � � � � � � � � �
� � � � � � � � � ��� � �� � The initial thread of the job is waiting for a� � �� � time interval to end.
� �What the IBM i job does is 1) build a file in library QTEMP, 2)
copy
� �that file to the IFS as a .csv file, and 3) FTP that .csv file
to the
� �vendor.
� �We successfully sent one Tuesday morning (the day before) from
the IBM
� �i.
� �Tuesday night the firmware was updated in the Meraki MX60
router.� So
� �that was the first place we thought of.� But�I copied the
.csv file
� �to my desktop and was able to send it via FileZilla through
that same
� �router.
� �The once a week sales report gets FTP'ed on Fridays.� It also
failed,
� �but at least the joblog had this: �"425 Unable to build data
� �connection: Connection refused".� I copied that file to my PC
and was
� �able to send it via FileZilla as well.
� �We upgraded to FTPAPI 2.3 and it still fails.� The IBM i was
rebooted
� �Saturday as part of a SAVE 21 and it still fails. �(Not that I
think
� �reboots help the IBM i like it does Windows.)
� �We send/receive files from/to the IBM i via FTP every day and
every
� �night.� The ONLY ones failing are those being sent via
FTPAPI.
� �Any suggestions?
� �Thanks.
� �--
� �[uc?export=download&id=0B0OlGhlpA1wISUpiZ2FfSGYxb28&
amp;revid=0B0Ol
� �GhlpA1wIVDd6WXFUYWorNVFaTTM5TUpDRWY2SnF4MjJrPQ]
� �Jeff Crosby
� �VP Information Systems
� �UniPro FoodService/Dilgard
� �P.O. Box 13369
� �Ft. Wayne, IN 46868-3369
� �[2]260-422-7531
� �[3][3]www.dilgardfoods.com
� �The opinions expressed are my own and not necessarily the
opinion of my
� �company.� Unless I say so.
� �--
� �[uc?export=download&id=0B0OlGhlpA1wISUpiZ2FfSGYxb28&
amp;revid=0B0Ol
� �GhlpA1wIVDd6WXFUYWorNVFaTTM5TUpDRWY2SnF4MjJrPQ]
� �Jeff Crosby
� �VP Information Systems
� �UniPro FoodService/Dilgard
� �P.O. Box 13369
� �Ft. Wayne, IN 46868-3369
� �260-422-7531
� �[4][4]www.dilgardfoods.com
� �The opinions expressed are my own and not necessarily the
opinion of my
� �company.� Unless I say so.
References
� �1. mailto:[5]jlcrosby@xxxxxxxxxxxxxxxx
� �2. tel:[6]260-422-7531
� �3. [7]http://www.dilgardfoods.com/
� �4. [8]http://www.dilgardfoods.com/
------------------------------------------------------------
-----------
This is the FTPAPI mailing list.� To unsubscribe, please go to:
[9]http://www.scottklement.com/mailman/listinfo/ftpapi
------------------------------------------------------------
-----------
References
1. mailto:jlcrosby@xxxxxxxxxxxxxxxx
2. mailto:jlcrosby@xxxxxxxxxxxxxxxx
3. http://www.dilgardfoods.com/
4. http://www.dilgardfoods.com/
5. mailto:jlcrosby@xxxxxxxxxxxxxxxx
6. tel:260-422-7531
7. http://www.dilgardfoods.com/
8. http://www.dilgardfoods.com/
9. http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------
This is the FTPAPI mailing list. To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------