Hi Robert ,
Thanks for your assistance. After using the larger file size I was able to alter the file. Issue is fixed and Thanks to everyone for their generous help.
Many Thanks,
Dinesh Babu, S
-----Original Message-----
From: Robert Thwaites [mailto:[log in to unmask]]
Sent: 03 December 2014 17:07
To: S, DineshBabu; [log in to unmask]
Subject: RE: [HP3000-L] Mpe: QTP, Error: File is full. Run Terminated
Your initial comment showed that the required size is around 124,000 records.
When you tried to make the file smaller than the current 40,000 records, MPEX told you that it got an end of file when it tried to copy the 20,001 record to the new file.
You should also know about the non MPEX solutions...the MPEX altfile in principal creates a new file, copies the contents from the old to the new, deletes the old and renames the new one.
Doing the same work yourself:
If you need the current contents of your ksam file, rename the current ksam file first and then fcopy the old file into the new file once you have built it.
Additional issues:
* Normally in the dictionary, you define how big the files need to be. A powerhouse utility QUTIL is available to build the various files that are defined.
(Documented in the powerhouse PDL manual.)
* The KSAMUTIL build command can also be used to create the file. QUTIL programmatically directs KSAMUTIL to do that.
I found the KSAMUTIL reference manual here:
http://www.hpmmsupport.com/MPE%20Manual/5000/B3265090386.10088/11.htm
You want to set the numrec to something more than the expected number of records. (40,000 isn't enough Build command:
BUILD filereference 1 F ,BINARY
[;REC=[recsize] [,[blockfactor] [, V ] ] ]
,ASCII
[;TEMP]
[;DEV=device]
[;CODE=filecode]
[;DISC=[numrec] [,[numextents] [,initialloc] ] ]
;KEYENTITY =filereference 2
,DUPLICATE
,DUP
;KEY=keytype, keylocation, keysize[,[keyblocking] ,RDUPLICATE
,RDUP
,DUPLICATE
;KEY=keytype, keylocation, keysize[,[keyblocking] ,DUP
,RDUPLICATE
,RDUP
[;KEYENTRIES=numentries]
[;LABELS=numlabels]
[;KEYDEV=device]
[;FIRSTREC=recnum]
[;LANG=parameter]
[;NODUPLOCKS]
Robert Thwaites
Seward Consulting
(780) 426-4876
Mobile (780) 231-0067
[log in to unmask]
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf Of S, DineshBabu
Sent: Wednesday, December 03, 2014 8:39 AM
To: [log in to unmask]
Subject: Re: [HP3000-L] Mpe: QTP, Error: File is full. Run Terminated
Yes Tracy , I'm not able to list the subfile size , as it goes off after the Job runs. Also im not sure on how to increase the KSAM file (JOB-SUMMARY) size as I'm new to this.
Many Thanks,
Dinesh Babu, S
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf Of Johnson, Tracy
Sent: 03 December 2014 15:32
To: [log in to unmask]
Subject: Re: [HP3000-L] Mpe: QTP, Error: File is full. Run Terminated
Yes John is right. I just remembered the ALIAS is going back to the JOBS-SUMMARY file which I presume is in your Dictionary.
Also, if this was run online and not in batch you can LISTF and see how big your temporary subfiles were before they disappear.
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 Pickering, John (NORBORD)
> Sent: Wednesday, December 03, 2014 10:23 AM
> To: [log in to unmask]
> Subject: Re: [HP3000-L] Mpe: QTP, Error: File is full. Run Terminated
>
> File MMKJOBS.MMDATA (Opened in the Powerhouse dictionary as
> JOBS-SUMMARY and known in this QTP run as JOBS-SUMM-NEW has a capacity
> of 40,000 records and it is full. You will need to delete some records
> from it or expand its capacity.
>
> Regards,
> JWP
>
> -----Original Message-----
> From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
> Behalf Of S, DineshBabu
> Sent: Wednesday, December 03, 2014 10:16 AM
> To: [log in to unmask]
> Subject: Re: [HP3000-L] Mpe: QTP, Error: File is full. Run Terminated
>
> Hi Tracy,
>
> Attached the complete program .
>
> Many Thanks,
> Dinesh Babu, S
> K-C ITAS Chennai,India | EMEA Manufacturing
> Tel: +44- (0)207 531 9300 Extn: 449324 | Cell: +91 9962605209 Group
> Mailbox: [log in to unmask]
>
>
>
> -----Original Message-----
> From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
> Behalf Of Johnson, Tracy
> Sent: 03 December 2014 14:42
> To: [log in to unmask]
> Subject: Re: [HP3000-L] Mpe: QTP, Error: File is full. Run Terminated
>
> 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 *
> ________________________________
>
>
> This e-mail is intended for the use of the addressee(s) only and may
> contain privileged, confidential, or proprietary information that is
> exempt from disclosure under law. If you have received this message in
> error, please inform us promptly by reply e-mail, then delete the e-
> mail and destroy any printed copy. Thank you.
>
>
> ________________________________
>
> * 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 *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html * ________________________________
This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you.
________________________________
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
________________________________
This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you.
________________________________
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
