 
| Subject: | |
| From: | |
| Reply To: | Johnson, Tracy |
| Date: | Wed, 3 Dec 2014 14:41:40 +0000 |
| Content-Type: | text/plain |
| Parts/Attachments: |
|
|
The only thing I don't see are your ACCESS statements (and your SELECT and CHOOSE statements if any). I see the link items but not how you are linking them. If you're pulling multiple files together with one to many relationships you may have a serious increase in output.
Or you can simply set the limit to 100 million or a billion since disc space is cheap. The large result may also help you figure out the best way to SELECt or CHOOSE to keep it low.
Tracy Johnson
00 1 757 766 4318 tel
00 1 757 755-6470 mobile
[log in to unmask]
> -----Original Message-----
> From: HP-3000 Systems Discussion [mailto:[log in to unmask]]
> On Behalf Of Dinesh
> Sent: Wednesday, December 03, 2014 9:12 AM
> To: [log in to unmask]
> Subject: [HP3000-L] Mpe: QTP, Error: File is full. Run Terminated
>
> Hi , I get an error with a QTP job. The job return the error msg as file is
> full. Below are the error msg, source code and details on file. Can
> anyone help please.
>
> Error Msg:
> ------------------------------------------------------------------------------
> This file is full.
> File: JOBS-SUMM-NEW
> Linkitem: JOB-KEY WHS @ UT@ INR
> ------------------------------------------------------------------------------
>
> Source code:
> ------------------------------------------------------------------------------
> SET LOCK FILE REQUEST
> SET PROCESS LIMIT 100000
>
> OUTPUT JOBS-SUMMARY ALIAS JOBS-SUMM-NEW ADD AT WORK-
> REASON
> ITEM SPONSOR OF JOBS-SUMM-NEW INITIAL "@"
> ITEM NUMBER-OF-JOBS OF JOBS-SUMM-NEW SUBTOTAL &
> NUMBER-OF-JOBS OF JOBS-SUMMARY
> ITEM EST-HOURS OF JOBS-SUMM-NEW SUBTOTAL &
> EST-HOURS OF JOBS-SUMMARY
>
> ------------------------------------------------------------------------------
>
> Details on Original file:
> ------------------------------------------------------------------------------
> File: JOBS-SUMMARY
> Organization: INDEXED
> Type: KSAM (ASCII)
> Open: MMKJOBS.MMDATA
> Capacity: 40000 Records
> Create Status: Create
> ------------------------------------------------------------------------------
>
> Count of the record sets proceesed is : 110714 Count of Transactions
> Processed is : 173591.
>
> I did change the Process limit to 200000 but not sucessfull.
>
> * 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 *
|
|
|
