×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

SM Reindex Application Files, and/or Closing period is sometimes deleting a file (!)

SM Reindex Application Files, and/or Closing period is sometimes deleting a file (!)

SM Reindex Application Files, and/or Closing period is sometimes deleting a file (!)

(OP)
On May 9 as we closed the previous period SBT hung up. Can't remember exactly but it gave a message that closing AR had failed. Turned out it was because it could not locate armast01. Armast01, both dbf and cdx were gone from the data folder. We restored from a cloud backup taken earlier that day and could close then. We scratched our heads vigorously.

Today we used SM Reindex Application Files to reindex just armast01 and artran01. No problems, we thought. THEN we did Reindex Application Files again and chose all the AR files. The process informed us it could not locate arychs01! Both arycsh01.dbf and arycsh01.cdx were not in the folder. (Immediately prior to the first reindex we had copied all AR data files to a subfolder. Both arycsh01 files were in that subfolder and we copied them back to the live folder.)

Our SBT system is on a Windows 2008 R2 Standard server. The workstation in both cases was the same Win7 Pro machine. The Win7Pro machine has both VFP 5.0 and VFP 9 SP2 installed on it. Great care is taken to never open SBT files in VFP9, btw.

/OT
The second reindex process took FOREVER because of whatever SBT does when it copies files to temp files then renames or something because the arytrn01.fpt file copy took so long. It was only 8.8mb, too.
/OT off

In the 20+ years of using SBT continuously we have never experienced something deleting data files. Has anyone had this experience?

Trey Harris
hdb
Houston

RE: SM Reindex Application Files, and/or Closing period is sometimes deleting a file (!)

(OP)
I discovered a file, sydilog.dbf, that may help me research this issue. Does any one know what field NDXSTAT means? The technical reference only says "Indexing Status". I find I, N and F values when browsing the table.

Trey Harris
hdb
Houston

RE: SM Reindex Application Files, and/or Closing period is sometimes deleting a file (!)

(OP)
Sorry for the unnecessary churning. Looking at the code of smtrnx.prg I see the following:

CODE -->

*-- Setup status code for log file update
      DO CASE
        CASE ln_result = 0
          *-- No index defined for this file
          lc_ndxstat = "N"

        CASE ln_result = -2
          *-- Failed due to conflict with another user
          lc_ndxstat = "C"

        CASE ln_result = -1 OR ln_result = -3
          *-- Failed due to missing data file or invalid index expression
          lc_ndxstat = "F"

        OTHERWISE
          *-- All indexes built
          lc_ndxstat = "I"

      ENDCASE 

Trey Harris
hdb
Houston

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close