Index error
Jeff Harrison
jeffaharrison at yahoo.com
Thu Feb 7 05:43:42 PST 2013
> From: GCC Consulting <rkreiss at gccconsulting.net>
>To: filepro-list at lists.celestial.com
>Sent: Wednesday, February 6, 2013 5:09 PM
>Subject: Index error
>
>I am testing a -v select process which uses a - lookup on index Q.
>
>After on the 500th record being read, I get the following filepro error msg.
>
>
>*** A System Error Has Occurred ***
>
>On File: W:\ccp/filepro/l_doctor/index.B
>
>Input Processing
>Line Number: 15
>
>lookup test r=free -n
>
>
>No error
>
>Last Windows error was 0.
>
>
>Press H -Hardcopy Enter -Continue
>
>
>I have deleted and rebuilt l_doctor/indexB a number of times. To catch the
>record or at lead the record before the crash, I am posting out to the file
>test the control number and date of each record read.
>
>As far as I can tell, there are no problems with the last record posted or
>the next one as I can access the record sequence using index @ and checking
>the record prior to, same as, just after the last record in the file test.
>There does not appear to be any problems with these records.
>
>Anyone have a suggestion as to what else I might look at.
>
>
>Richard Kreiss
>GCC Consulting
>
>Office: 410-653-2813
>
You are using index Q? How many idexes do you have? Could you have too many files open at one time? You should be able to increase your parameters for this in windows. Does the error occur in your selection processing when you are running no other processing? Try adding -y none -z none to your command line and see if the error persists. Also, try deleting l_doctor/index.B if it is not needed and run the process without it - does it still error?
Also, you did not mention what the current file is - is it l_doctor?
Also, post your code!
Jeff Harrison
jeffaharrison at yahoo.com
Author of JHExport and JHImport
More information about the Filepro-list
mailing list