Problem:

Return code 9/029 on DELETE of index file over Fileshare

Before the delete a close was coded

Resolution:

This normally is correct in that your program was not the only one that opened the file and the file is open via another program that never

If Fileshare is started via service, you will need to use FSVIEW from Net Express command prompt. The trace will write to fsscreen.lst in the fileshare work directory.

FSVIEW

server set your-server-name

trace toggle      to start trace

trace toggle      to stop trace

exit                   to exit

After the error is recreated make a copy of the fsscreen.lst file. Using an editor do a search for the file name you are having problems with in the sample it was D:\\M.LEATHEM\\CNTLLIB\\MHCT_MHCBQ.DAT so I searched for MHCT_MHCBQ.DAT.

Just before the file you will find the input opcode requested of Fileshare and the output is the Fileshare status code to the operation request.

09295286 FS163-I Input- 00003 FAF8 D:\\\\M.LEATHEM\\\\CNTLLIB\\\\MHCT_MHCBQ.DAT\\par    ======== Delete Successful

09295288 FS173-I Output- 00003 0/0\\par

09305317 FS163-I Input- 00003 FA02 D:\\\\M.LEATHEM\\\\CNTLLIB\\\\MHCT_MHCBQ.DAT\\par  ======= Open I/O created the file

09305319 FS173-I Output- 00003 0/5\\par

09305422 FS163-I Input- 00003 FA02 D:\\\\M.LEATHEM\\\\CNTLLIB\\\\MHCT_MHCBQ.DAT\\par   ======== Open I/O successful

09305424 FS173-I Output- 00003 0/0\\par

09305427 FS163-I Input- 00003 FA80 D:\\\\M.LEATHEM\\\\CNTLLIB\\\\MHCT_MHCBQ.DAT\\par   ======== Close File successful

09305430 FS173-I Output- 00003 0/0\\par

09305435 FS163-I Input- 00003 FAF3 D:\\\\M.LEATHEM\\\\CNTLLIB\\\\MHCT_MHCBQ.DAT\\par   ======== WRITE successful

09305436 FS173-I Output- 00003 0/0\\par

09305708 FS163-I Input- 00003 FAEB D:\\\\M.LEATHEM\\\\CNTLLIB\\\\MHCT_MHCBQ.DAT\\par   ====== START not less than >= successful

09305710 FS173-I Output- 00003 0/0\\par

09305713 FS163-I Input- 00003 FAF5 D:\\\\M.LEATHEM\\\\CNTLLIB\\\\MHCT_MHCBQ.DAT\\par   ====== READ sequential successful

09305714 FS173-I Output- 00003 0/0\\par

09312513 FS163-I Input- 00003 FAF8 D:\\\\M.LEATHEM\\\\CNTLLIB\\\\MHCT_MHCBQ.DAT\\par   ====== Delete unsuccessful as file is open

09312514 FS173-I Output- 00003 9/029\\par

The open codes can be found in the documentation under

Contants tab

        Reference

               File Handler

                      Operation codes

OR

Serach TAB for operation codes and then search the result set for FA

Run FSVIEW again and this time check the file status.

You can also key in the command help to see all of the FSVIEW commands available.

FSVIEW

server set your-fs-server

file get-users  D:\\M.LEATHEM\\CNTLLIB\\MHCT_MHCBQ.DAT

file close D:\\M.LEATHEM\\CNTLLIB\\MHCT_MHCBQ.DAT

exit

Attachments:

fileshare_20060131.txt.txt