We are testing the 24x7 version 3.4.17 and got a
problem with FTPFileExists. The programm finds
every file not existing. The script is checking the
filedate after FTPFileExists and returns 01.01.1980.
As there is no file with this date could it be that
this is a default value for this function.
We have tried several filenames, several paths, the
file is always found.
Thx for your help.

Please make sure you enter correct file name including full path and you have permissions for the FTP source directory.
To check what files are there you can try FTPDir and then print the result to a file using FileSave, or use Print or simply MessageBox to display on screen.

: We are testing the 24x7 version 3.4.17 and got a
: problem with FTPFileExists. The programm finds
: every file not existing. The script is checking the
: filedate after FTPFileExists and returns 01.01.1980.
: As there is no file with this date could it be that
: this is a default value for this function.
: We have tried several filenames, several paths, the
: file is always found.
: Thx for your help.

: Please make sure you enter correct file name including full path and you have
: permissions for the FTP source directory.

The path and filename are correct.

: To check what files are there you can try FTPDir and then print the result to
: a file using FileSave, or use Print or simply MessageBox to display on
: screen.

The FTPDir brings the expected result with all the files in this directory.

The FTPFileExists run a few lines after the FTPDir finds again files, for which we entered wrong filenames.
Actually every filename gives us a TRUE.

Can you post the actual script here? For security reasons when posting the script please replace your server name and password with asterisks or some other meaningless text.

: The path and filename are correct.

: The FTPDir brings the expected result with all the files in this directory.

: The FTPFileExists run a few lines after the FTPDir finds again files, for
: which we entered wrong filenames.
: Actually every filename gives us a TRUE.

: Can you post the actual script here? For security reasons when posting the
: script please replace your server name and password with asterisks or some
: other meaningless text.

The new added FTPDir gives a "RueckstLo.txt not found", the FTPFileExists gives TRUE

Dim found_file, Boolean
Dim filedatum, Date
Dim filedatumcheck, Boolean
Dim actualdate, Date
Dim directory, String
Dim is_equal, Boolean

Today(actualdate)

FileDIR:

FTPDir( "***", "***", "***", "/u011/app/logs/outMAST11/ch_internet/fileout/RueckstLo.txt", directory )
IsEqual (directory, "RueckstMeLo.txt", is_equal )
If (is_equal, filecheck, end )

FILECHECK:

FTPFileExists( "***", "***", "***", "/u011/app/logs/outMAST11/ch_internet/fileout/RueckstLo.txt", found_file )
If (found_file, file_date, end )

FILE_DATE:

FTPFileDateTime( "***", "***", "***", "/u011/app/logs/outMAST11/ch_internet/fileout/RueckstLo.txt", filedatum )
IsEqual(filedatum, actualdate, filedatumcheck )
If (filedatumcheck, file_size, end )

FILE_SIZE:

END:

Which version of 24x7 are you running?
Also which FTP server software are you running on the server and which Windows version and Internet Explorer version are you running on the client?

: The new added FTPDir gives a "RueckstLo.txt not found", the
: FTPFileExists gives TRUE

: Dim found_file, Boolean
: Dim filedatum, Date
: Dim filedatumcheck, Boolean
: Dim actualdate, Date
: Dim directory, String
: Dim is_equal, Boolean

: Today(actualdate)

: FileDIR: FTPDir( "***", "***", "***",
: "/u011/app/logs/outMAST11/ch_internet/fileout/RueckstLo.txt",
: directory )
: IsEqual (directory, "RueckstMeLo.txt", is_equal )
: If (is_equal, filecheck, end )

: FILECHECK: FTPFileExists( "***", "***", "***",
: "/u011/app/logs/outMAST11/ch_internet/fileout/RueckstLo.txt",
: found_file )
: If (found_file, file_date, end )

: FILE_DATE: FTPFileDateTime( "***", "***",
: "***",
: "/u011/app/logs/outMAST11/ch_internet/fileout/RueckstLo.txt",
: filedatum )
: IsEqual(filedatum, actualdate, filedatumcheck )
: If (filedatumcheck, file_size, end )

: FILE_SIZE: END:

: Which version of 24x7 are you running?
: Also which FTP server software are you running on the server and which
: Windows version and Internet Explorer version are you running on the
: client?

3.4.17 not licenced evaluating version
don't know the FTP server software, i just know it's a unix system
client is Windows 2000, IE 6.0.2800.1106

Do you have "ignore job errors" option checked by any chance?

Try running the job in trace mode (you can enable trace mode in Tools/Options menu, Log page, Trace Enabled option) and in the console window and ftp.log files check for additional messages sent by your FTP server. If possible post contents of the script.log and ftp.log files here (replace passwords, servers, etc... before posting)

: 3.4.17 not licenced evaluating version
: don't know the FTP server software, i just know it's a unix system
: client is Windows 2000, IE 6.0.2800.1106

: Do you have "ignore job errors" option checked by any chance?

nope

: Try running the job in trace mode (you can enable trace mode in Tools/Options
: menu, Log page, Trace Enabled option) and in the console window and
: ftp.log files check for additional messages sent by your FTP server. If
: possible post contents of the script.log and ftp.log files here (replace
: passwords, servers, etc... before posting)

JAL 19: FTPFILEEXISTS
JAL 19: Executing FTPFILEEXISTS("***", "***", "***", "/u011/app/logs/outMAST11/ch_internet/fileout/RueckstLo.txt", "false")
JAL Return "true"
JAL 20: IF
JAL 20: Executing IF("true", "FILE_DATE", "END")
JAL 25: FTPFILEDATETIME
JAL 25: Executing FTPFILEDATETIME("***", "***", "***", "/u011/app/logs/outMAST11/ch_internet/fileout/RueckstLo.txt", "01.01.1900 00:00:00")
JAL Return "01.01.1980 12:00:00"
JAL 26: ISEQUAL
JAL 26: Executing ISEQUAL("01.01.1980", "01.04.2004", "false")
JAL Return "false"

It looks like the file really exists. The reason you get some wacky file date/time is that your UNIX server ls command reports it in some unparseable format. Try running ls on the host using Telnet client to see how the date/time is displayed.

: nope

: JAL 19: FTPFILEEXISTS
: JAL 19: Executing FTPFILEEXISTS("***", "***",
: "***",
: "/u011/app/logs/outMAST11/ch_internet/fileout/RueckstLo.txt",
: "false")
: JAL Return "true"
: JAL 20: IF
: JAL 20: Executing IF("true", "FILE_DATE",
: "END")
: JAL 25: FTPFILEDATETIME
: JAL 25: Executing FTPFILEDATETIME("***", "***",
: "***",
: "/u011/app/logs/outMAST11/ch_internet/fileout/RueckstLo.txt",
: "01.01.1900 00:00:00")
: JAL Return "01.01.1980 12:00:00"
: JAL 26: ISEQUAL
: JAL 26: Executing ISEQUAL("01.01.1980", "01.04.2004",
: "false")
: JAL Return "false"

: It looks like the file really exists. The reason you get some wacky file
: date/time is that your UNIX server ls command reports it in some
: unparseable format. Try running ls on the host using Telnet client to see
: how the date/time is displayed.

No, have a look at the response of the server, it says

"/u011/app/logs/outMAST11/ch_internet/fileout/RueckstLo.txt",
: "false")
: JAL Return "true"

this is the problem that there is a false changed into a true.

This is not a response. It is the current value passed to the FTPFileExists. The response is True.

: No, have a look at the response of the server, it says

: "/u011/app/logs/outMAST11/ch_internet/fileout/RueckstLo.txt",

: this is the problem that there is a false changed into a true.

: This is not a response. It is the current value passed to the FTPFileExists.
: The response is True.

ok, but the file is definitely not there. I told you that the FTPDir command gives a "not
found" and the FTPFileExists gives the return TRUE.
This is also the cause of the wacky file date/time, unix can't give a correct date for a
non existing file.

Open Control Panel; double-click Internet Options; click Settings button in Temporary Internet Files box then click "Every Visit to The Page" option. Apply updates and try running the job again.

: ok, but the file is definitely not there. I told you that the FTPDir command
: gives a "not
: found" and the FTPFileExists gives the return TRUE.
: This is also the cause of the wacky file date/time, unix can't give a correct
: date for a
: non existing file.

: Open Control Panel; double-click Internet Options; click Settings button in
: Temporary Internet Files box then click "Every Visit to The
: Page" option. Apply updates and try running the job again.

I tried this but it didn't work and I cannot waste more time for this issue. We will just don't use this command. The Dir-command has the same function which works...

Thanks for your help.