SUBWORK1 error

[Guy Werry]

You would get a different error if QTP cannot create the temporary folder: we've had this happen.
 
I THINK (stress the THINK portion) that this is probably due to a sort file exceeding the 2 gig limit. 
 
What is the QTP doing?  Can you post the source code for it?
 
What we've done to eliminate huge sorts is to build an indexed subfile, with keys that match the sort that you want to perform.  Then you access the subfile and say SORTED ON ... .  What this does is ELIMINATE the sorting althogether.  Although there is overhead when building the indices on the indexed subfile, the overhead is far less than doing a gigantic sort.   Of course, you have to purge the subfile and re-build the entire subfile every time.
 
Hope that helps.
 
Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited. 

-----Original Message-----
From: powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com [mailto:powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com]On Behalf Of Joe Boyle
Sent: Wednesday, November 22, 2006 5:25 PM
To: fernando.olmos at hpa.com.au; powerh-l at lists.sowder.com
Subject: RE: SUBWORK1 error



Could it be that you are hitting the 2 gig file size limit ( I seem to recall that you have to tinker with partition sizes on unix in order to exceed 2 gig), or exceeding the PH 2 gig records limit ?

 


  _____  


From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com [mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of fernando.olmos at hpa.com.au
Sent: 22 November 2006 23:06
To: powerh-l at lists.sowder.com
Subject: RE: SUBWORK1 error

 

More information... 

Would SUBWORK1 be the SUBFILE equivalent of SUBSORT, which is a temporary file space created to handle internal sorting of data?

I ask this because I've noticed that under Unix, QTP creates a temporary folder (like "ph18704.tmp"), as a temporary storage space. It "should" get deleted once the QTP has finished and exited back to the $ prompt. This does not always happen!

I guess my question then leads into this: How is it possible to tell PH to create the temporary folders with a certain permission? Would it be something controlled by the Unix administrator, or can it be controlled from PH?

I assume the SUBWORK error mentioned below is happening because QTP cannot create the temporary folder it requires to do the sort?

Thanks 

 

 -----Original Message----- 
From:   Fernando Olmos  
Sent:   Thursday, 23 November 2006 9:40 AM 
To:     'powerh-l at lists.sowder.com' 
Subject:        SUBWORK1 error 

Hi guys. 

We're running a C shell script in Sun Solaris which calls Powerhouse (8.43) QTP. 

When ever we try and run a particular QTP program we get the following error ... 

Run:     invoices 
Request: COMPLETED_ORDERS 

------------------------------------------------------------------------------- 
There was a file error on the work file SUBWORK1.                              
------------------------------------------------------------------------------- 
No such file or directory                                                      
                                                                               
Action Taken: Run terminated. 
------------------------------------------------------------------------------- 
Finished. 

What is SUBWORK1 used for? 

Thanks 

 

Fernando Olmos 
MIS 
Senior Analyst Programmer 

HPA
Direct:  03 9217 5411
Mobile: 0410 382 857
Fax:     03 9217 5716 

 <file:///H:\Appdata\Microsoft\Signatures\www.hpa.com.au> www.hpa.com.au 

 

**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and intended
solely for the use of the individual or entity to whom they are addressed.  If
you received this e-mail in error, please notify the HPA Postmaster, postmaster at hpa.com.au,
then delete  the e-mail.
This footnote also confirms that this e-mail message has been swept for the
presence of computer viruses by Ironport. Before opening or using any
attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For more
information about use, disclosure and access see our Privacy Policy at
www.hpa.com.au
**********************************************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20061123/370f0fab/attachment.htm