<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:st1 =
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: SUBWORK1 error</TITLE>
<META content="MSHTML 6.00.2800.1400" name=GENERATOR><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]--><o:SmartTagType name="City"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="place"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
PRE {
FONT-SIZE: 10pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Courier New"
}
SPAN.EmailStyle19 {
FONT-WEIGHT: normal; COLOR: blue; FONT-STYLE: normal; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-GB vLink=blue link=blue>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=648560914-23112006>You
would get a different error if QTP cannot create the temporary folder: we've had
this happen.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=648560914-23112006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=648560914-23112006>I
THINK (stress the THINK portion) that this is probably due to a sort file
exceeding the 2 gig limit. </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=648560914-23112006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=648560914-23112006>What
is the QTP doing? Can you post the source code for it?</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=648560914-23112006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=648560914-23112006>What
we've done to eliminate huge sorts is to build an <U>indexed subfile</U>, 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.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=648560914-23112006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=648560914-23112006>Hope
that helps.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=648560914-23112006><FONT
size=2></FONT></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=648560914-23112006><FONT
size=2>Guy L. Werry<BR>Senior Systems Analyst<BR>Hudson Bay Mining &
Smelting Co., Limited. </FONT></DIV></SPAN></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com
[mailto:powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com]<B>On Behalf Of
</B>Joe Boyle<BR><B>Sent:</B> Wednesday, November 22, 2006 5:25
PM<BR><B>To:</B> fernando.olmos@hpa.com.au;
powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: SUBWORK1
error<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial">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 ?<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN lang=EN-US
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">
powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com] <B><SPAN
style="FONT-WEIGHT: bold">On Behalf Of
</SPAN></B>fernando.olmos@hpa.com.au<BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> 22 November 2006 23:06<BR><B><SPAN
style="FONT-WEIGHT: bold">To:</SPAN></B> powerh-l@lists.sowder.com<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: SUBWORK1
error</SPAN></FONT><SPAN lang=EN-US><o:p></o:p></SPAN></P></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">More
information...</SPAN></FONT> <o:p></o:p></P>
<P><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Would SUBWORK1 be the
SUBFILE equivalent of SUBSORT, which is a temporary file space created to
handle internal sorting of data?</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">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!</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">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?</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">I assume the SUBWORK
error mentioned below is happening because QTP cannot create the temporary
folder it requires to do the sort?</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Thanks</SPAN></FONT>
<o:p></o:p></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> </SPAN></FONT><FONT face=Tahoma size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Tahoma">-----Original
Message-----</SPAN></FONT> <BR><B><FONT face=Tahoma size=1><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 7.5pt; FONT-FAMILY: Tahoma">From:
</SPAN></FONT></B> <FONT face=Tahoma size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Tahoma">Fernando Olmos
</SPAN></FONT><BR><B><FONT face=Tahoma size=1><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 7.5pt; FONT-FAMILY: Tahoma">Sent: </SPAN></FONT></B>
<FONT face=Tahoma size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Tahoma">Thursday, 23 November 2006 9:40
AM</SPAN></FONT> <BR><B><FONT face=Tahoma size=1><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 7.5pt; FONT-FAMILY: Tahoma">To: </SPAN></FONT></B>
<FONT face=Tahoma size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Tahoma">'powerh-l@lists.sowder.com'</SPAN></FONT>
<BR><B><FONT face=Tahoma size=1><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 7.5pt; FONT-FAMILY: Tahoma">Subject: </SPAN></FONT></B>
<FONT face=Tahoma size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Tahoma">SUBWORK1 error</SPAN></FONT>
<o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi guys.</SPAN></FONT>
<o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">We're running a C shell script in
Sun Solaris which calls Powerhouse (8.43) QTP.</SPAN></FONT> <o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">When ever we try and run a
particular QTP program we get the following error ...</SPAN></FONT>
<o:p></o:p></P>
<P><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Run:
invoices</SPAN></FONT> <BR><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Request:
COMPLETED_ORDERS</SPAN></FONT> <o:p></o:p></P>
<P><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">-------------------------------------------------------------------------------</SPAN></FONT>
<BR><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">There was a file error on
the work file
SUBWORK1.
</SPAN></FONT><BR><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">-------------------------------------------------------------------------------</SPAN></FONT>
<BR><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">No such file or
directory
</SPAN></FONT><BR><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">
</SPAN></FONT><BR><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Action Taken: Run
terminated.</SPAN></FONT> <BR><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">-------------------------------------------------------------------------------</SPAN></FONT>
<BR><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Finished.</SPAN></FONT>
<o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">What is SUBWORK1 used
for?</SPAN></FONT> <o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks</SPAN></FONT>
<o:p></o:p></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P><I><FONT face=Arial color=blue size=4><SPAN
style="FONT-SIZE: 13.5pt; COLOR: blue; FONT-STYLE: italic; FONT-FAMILY: Arial">Fernando
Olmos</SPAN></FONT></I> <BR><B><FONT face=Arial size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">MIS</SPAN></FONT></B>
<BR><B><FONT face=Arial size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">Senior Analyst
Programmer</SPAN></FONT></B> <o:p></o:p></P>
<P><B><FONT face=Arial color=blue size=2><SPAN lang=EN-AU
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">HPA</SPAN></FONT></B><FONT
face=Arial><SPAN lang=EN-US style="FONT-FAMILY: Arial"><BR></SPAN></FONT><FONT
face=Arial color=black size=2><SPAN lang=EN-AU
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">Direct: 03
9217 5411</SPAN></FONT><SPAN lang=EN-US><BR></SPAN><st1:City
w:st="on"><st1:place w:st="on"><FONT face=Arial color=black size=2><SPAN
lang=EN-AU
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">Mobile</SPAN></FONT></st1:place></st1:City><FONT
face=Arial color=black size=2><SPAN lang=EN-AU
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">:
0410 382 857</SPAN></FONT><FONT face=Arial><SPAN lang=EN-US
style="FONT-FAMILY: Arial"><BR></SPAN></FONT><FONT face=Arial color=black
size=2><SPAN lang=EN-AU
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">Fax:
03 9217 5716</SPAN></FONT><SPAN lang=EN-AU> </SPAN><o:p></o:p></P>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"><A
href="file:///H:\Appdata\Microsoft\Signatures\www.hpa.com.au"><B><FONT
face=Arial size=2><SPAN lang=EN-AU
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">www.hpa.com.au</SPAN></FONT></B></A>
<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P><PRE><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt">**********************************************************************<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt">IMPORTANT<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt">The contents of this e-mail and its attachments are confidential and intended<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt">solely for the use of the individual or entity to whom they are addressed. If<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt">you received this e-mail in error, please notify the HPA Postmaster, postmaster@hpa.com.au,<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt">then delete the e-mail.<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt">This footnote also confirms that this e-mail message has been swept for the<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt">presence of computer viruses by Ironport. Before opening or using any<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt">attachments, check them for viruses and defects.<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt">Our liability is limited to resupplying any affected attachments.<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt">HPA collects personal information to provide and market our services. For more<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt">information about use, disclosure and access see our Privacy Policy at<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt">www.hpa.com.au<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt">**********************************************************************<o:p></o:p></SPAN></FONT></PRE></DIV></BLOCKQUOTE></BODY></HTML>