It looks like you have gone over a record pointer of 32767 which is the 16
bit integer limit. I assume you have over 1,376,214 records being selected.
The maximum retrieval limit was raised to 16,700,000 but we could not
realistically test that size for QUERY. You do not give the QUERY version
but it looks like the latest has the same 32767 limit on qsselect size.
It looks like you have hit an undetected internal restriction on the max
retrievals. It used to be 900,000 so the 32767 blocks of 42 records per
QSSELECT block was never experienced. You cannot force the size of QSSELECT
successfully as it is based on the maximum retrieval limit.
I will create an SR for this but it probably will not be fixed before March
2002 (if then)
as we are working on MPE/iX 7.5 stuff that must be done. OF course, we may
just hit the next unknown restriction. We worry most about SORT/MERGE file
size problems etc.
Drop me a message with your phone number and I can try to remember to let
you know when a beta test version of QUERYNM with the fix is available.
James Overman ([log in to unmask])
HP CS R&D QUERY Engineer
"Russ Smith" <[log in to unmask]> wrote in message
news:9u0se902q02@enews2.newsguy.com...
> Has anyone gotten this error from QueryNM before, or know what it means?
An attempt to file equate QSSELECT to force a larger record count produced
the same error.
>
> SCRATCH FILE READ ERROR 12
>
> +-F-I-L-E---I-N-F-O-R-M-A-T-I-O-N---D-I-S-P-L-A-Y+
> ! FILE NAME IS QSSELECT.DATA.CU1 !
> ! FOPTIONS: NEW,BINARY,FORMAL,F,NOCCTL,DEQ !
> ! NOLABEL !
> ! AOPTIONS: IN/OUT,MR,NOLOCK,EXC,NOBUF,NOMULTI !
> ! WAIT,NOCOPY !
> ! DEVICE TYPE: 3 DEVICE SUBTYPE: 8 !
> ! LDEV: 35 DRT: 8 UNIT: 0 !
> ! RECORD SIZE: 128 BLOCK SIZE: 128 (WORDS) !
> ! EXTENT SIZE: 49703 MAX EXTENTS: 8 !
> ! RECPTR: 32768 RECLIMIT: 397621 !
> ! LOGCOUNT: 218041 PHYSCOUNT: 218039 !
> ! EOF AT: 61757 LABEL ADDR: %00000000000 !
> ! FILE CODE: 1071 ULABELS: 0 !
> ! FILE OWNER: MGR.CU1 !
> ! PHYSICAL STATUS: 0000000000000000 !
> ! ERROR NUMBER: 12 RESIDUE: 0 !
> ! BLOCK NUMBER: 218039 NUMREC: 1 !
> +------------------------------------------------+
>
> FATAL ERROR: QUERY TERMINATED
>
> The doc says the error is the File System error so:
> FILE SYSTEM Record number out of range (FSERR 12)
>
>
> Program terminated in an error state. (CIERR 976)
>
>
>
> Thanks,
> Rs~
>
> Russ Smith
> Systems Analyst, CalState9 CU, Concord CA, rsmith @ calstate9.comm
> Programmer/Analyst, Problem Solved, Vacaville CA, rsmith @ cu-help.comm
> 3000L lurker and troublemaker, work @ rsmith.orgg
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
