SUBWORK1 error
fernando.olmos at hpa.com.au
fernando.olmos at hpa.com.au
Thu Nov 23 16:05:38 CST 2006
I doubt it's the 2gig limit. I say this because it's not a SUBSORT
error. It's a SUBWORK error, which makes me think this is the lack of
permissions to create the temporary DAT file. Bob... can you confirm
what PH is trying to do with these temporary files, please?
Well let me ask you this: If PH has the ability to create the temporary
folder, but it cannot create the DAT file (which is what I think is
really happening here), then that would not make sense because if PH had
the permission to create the folder, why wouldn't it have the permission
to create the DAT file, within the temporary folder? Unless Unix can do
that!? I am not a Unix guru here, so please help me out.
Thanks anyway
-----Original Message-----
From: powerh-l-request at lists.sowder.com
[mailto:powerh-l-request at lists.sowder.com]
Sent: Friday, 24 November 2006 5:01 AM
To: powerh-l at lists.sowder.com
Subject: powerh-l Digest, Vol 18, Issue 16
Send powerh-l mailing list submissions to
powerh-l at lists.sowder.com
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.sowder.com/mailman/listinfo/powerh-l
or, via email, send a message with subject or body 'help' to
powerh-l-request at lists.sowder.com
You can reach the person managing the list at
powerh-l-owner at lists.sowder.com
When replying, please edit your Subject line so it is more specific than
"Re: Contents of powerh-l digest..."
Today's Topics:
1. RE:SUBWORK1 error (Guy Werry)
----------------------------------------------------------------------
Message: 1
Date: Thu, 23 Nov 2006 08:17:46 -0600
From: "Guy Werry" <guy.werry at hbms.ca>
Subject: RE: SUBWORK1 error
To: <powerh-l at lists.sowder.com>
Message-ID:
<0ECD404B6909D0458968F14A7FF73BCBBDFB5E at hbffc003.hbms.hudbay.corp>
Content-Type: text/plain; charset="iso-8859-1"
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.html
------------------------------
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.
End of powerh-l Digest, Vol 18, Issue 16
****************************************
**********************************************************************
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
**********************************************************************
More information about the powerh-l
mailing list