We run GUIDEs every night around 1:00 AM. On Sunday, one of our files, SODEL, suddenly had thousands of errors on an indexed field (SCHED.DT). I doubt there were any changes to the file since Friday and we had no errors before. I pulled up several of the noted records in the editor, went into up-arrow mode, but did not see any errors, control characters, etc. in the data.
In a copy of our LIVE account, called MIDNIGHT (a copy of LIVE created ad midnight), and type
cat GUIDE_XERROR.LIS | more
we see this:
This goes on and on, possibly for all 500K records. The GUIDE_XERROR.LIS file is huge, over 22 megs.
From within UniData, if I type “SSELECT SODEL BY F4”, I get:
I get this for a bunch of records (maybe every record). If I edit the SODELs, none have any escape characters, so what is this error trying to tell me?
This is followed by:
The keys to the SODEL all look correct.
I build a new file called SODEL.JRI and from the command line, copied all the records to this new file. It has the same errors.
What is the error that suddenly happened, and how do I fix it?
JRI
