HP3000 QUIZ SORT ISSUE (Linkages with sort to Large)

[Stanfield, Randy (Carrollton, TX)]

I know I've seen the issue before. Not sure if it was on the HP3000 list or the Powerhouse list.

We've had a Quiz report files abort and cause a System failure abort 500. Which causes the HP3000 to shutdown.


SYSTEM ABORT 500 FROM SUBSYSTEM 185
SECONDARY STATUS:  INFO = -58, SUBSYS = 107
SYSTEM HALT 7, $01F4

************* SYSTEM ALERT **************

The quiz causing the process is only really reporting about 292,000 records because it subfiles at an item break. But with all the records processing is about 1,200,000 records.

We have a "set report limit 10,000,000" by lowering the Report limit to 5,000,000 no problem occurs.

The record linkages with a straight report sum all build a record of 3374. Which the actual subfile created is only 888.

ACCOUNT=  TESTSW      GROUP=  WHSE

FILENAME  CODE  ------------LOGICAL RECORD-----------  ----SPACE----
                  SIZE  TYP        EOF      LIMIT R/B  SECTORS #X MX

REPALL            3374B  FA        1000       1000   2    13184 34 32

ACCOUNT=  TESTSW      GROUP=  WHSE

FILENAME  CODE  ------------LOGICAL RECORD-----------  ----SPACE----
                  SIZE  TYP        EOF      LIMIT R/B  SECTORS #X MX

IV170103  644     888B  FA      277978   10000000   2   964288  * 32


I know we can pre-sort the file, remove some of the linkages in the request or lower the report limit.

Is there anything else that can be checked or done to elevate the system abort?

Running Cognos version 8.29c on MPE USER VERSION: C.75.03



Randy Stanfield






-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20170209/d76b1afe/attachment.htm>