Recently a user has reported an intermittant problem that appears to be related to the indexing of a local view. The code in question has been running for years w/o issue. The errorlog is reporting the error as "FILE IS NOT OPEN" and it appears to occur on the INDEX line below:
SELECT v_myview
DELETE TAG ALL
=requery("v_myview")
SELECT v_myview
=cursorsetprop("BUFFERING",3)
INDEX ON UPPER(lastname) TAG lastname
Although the logged error reads "FILE IS NOT OPEN", the view in question is open.... according to the collected list of open tables/views also stored in the errorlog details.
Assuming that the reported error is in fact THE error, I had suspected that a CDX write issue was involved. There's housekeeping code in place that deletes 2 day old *.TMP files from the temp folder (on the user's C drive). However, i realized that the housekeeping code was deleting just TMP files and that a good number of CDX files (now deleted) were still in that folder.
Any ideas?