QTP scratchfile 2 GB limit?
Fry, Mark
Mark.Fry@COGNOS.com
Mon, 14 Jan 2002 11:32:22 -0000
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C19CEF.21DEF060
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Jon,
=20
Have you tried moving some of the work from QTP to the database by =
using
SQL? If your QTP is fairly simple, you can often replace your several =
lines
of QTP code with a single SQL statement. Otherwise, if you're doing
something more advanced such as control-break processing, you could =
move the
sort to the database by replacing the input phase of each request by an =
SQL
cursor using an ORDER BY clause. This should reduce or even remove the =
need
for a scratch file in QTP, and so may get you past your problem.
=20
Best regards,
Mark Fry=20
Cognos Limited=20
email: Mark.Fry@Cognos.com=20
Cognos Limited=20
Registered in England, number 1635598. Registered office: Westerly =
Point,
Market Street, Bracknell, Berkshire, RG12 1QB
-----Original Message-----
From: Boyle, Joe [mailto:Joe.Boyle@cognos.com]
Sent: 14 January 2002 09:22
To: 'Jon.Kvisli@lindorffapplications.com'; powerh-l@lists.swau.edu
Subject: RE: QTP scratchfile 2 GB limit?
Hi Jon,
=20
there is no way around this limitation using the Unix platform. It is =
hoped
that the 8.4 release will be able to handle larger file sizes, but this =
is
not due out for some time, and may not contain the new feature.
=20
The only solution I am aware of in similar situations, is where PH has =
been
available on other platforms such as Mpe/ix or Openvms, and those =
servers
have been used to process a portable subfile and the resulting subfile =
(
which is now less than 2 Gig and pre-sorted ) ported back to the Unix
platform for processing.
-----Original Message-----
From: Jon.Kvisli@lindorffapplications.com
[mailto:Jon.Kvisli@lindorffapplications.com]
Sent: 14 January 2002 08:10
To: powerh-l@lists.swau.edu
Subject: QTP scratchfile 2 GB limit?
We have a problem with qtp terminating with the following =
error-message:=20
Error on scratch file.
=20
Action Taken: Run terminated.=20
We have 16 GB free disk space for scratch files, but the problem seems =
to
occur when the file reaches 2 GB size..=20
Is this a known limitation in qtp?=20
If so, are there any configurable parameters in PH where this can be
changed?=20
We are running PH 8.23.D4 on HP-UX and Oracle8i.=20
Jon Kvisli
----------------------------------------------
Senior systemkonsulent
Lindorff Applications as
Hellandtunet forsknings- og n=E6ringssenter
Postboks 4, 3833 B=F8 i Telemark
tlf: 35 06 15 71
fax: 35 06 15 01
e-post: jon.kvisli@lindorffapplications.com
www.lindorffapplications.com
----------------------------------------------=20
This message may contain privileged and/or confidential information. If =
you
have received this e-mail in error or are not the intended recipient, =
you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the =
sender
promptly by e-mail that you have done so. Thank you.
This message may contain privileged and/or confidential information. =
If you
have received this e-mail in error or are not the intended recipient, =
you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the =
sender
promptly by e-mail that you have done so. Thank you.
------_=_NextPart_001_01C19CEF.21DEF060
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=124592511-14012002><FONT face=Arial color=#0000ff size=2>Hi
Jon,</FONT></SPAN></DIV>
<DIV><SPAN class=124592511-14012002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=124592511-14012002><FONT face=Arial color=#0000ff size=2>Have
you tried moving some of the work from QTP to the database by using SQL?
If your QTP is fairly simple, you can often replace your several lines of QTP
code with a single SQL statement. Otherwise, if you're doing something
more advanced such as control-break processing, you could move the sort to the
database by replacing the input phase of each request by an SQL cursor using an
ORDER BY clause. This should reduce or even remove the need for a scratch
file in QTP, and so may get you past your problem.</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=124592511-14012002><FONT face=Arial color=#0000ff size=2>Best
regards,</FONT></SPAN></DIV><BR>
<P><I><FONT face="Comic Sans MS" color=#000080>Mark Fry</FONT></I> <BR><FONT
face=Arial color=#808080 size=2>Cognos Limited</FONT> <BR><FONT face=Arial
size=2>email:<U> </U></FONT><U><FONT face=Arial color=#0000ff
size=2>Mark.Fry@Cognos.com</FONT></U> </P>
<P><FONT face=Arial size=2>Cognos Limited</FONT> <BR><FONT face=Arial
size=2>Registered in England, number 1635598. Registered office:
Westerly Point, Market Street, Bracknell, Berkshire, RG12 1QB</FONT></P>
<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> Boyle, Joe
[mailto:Joe.Boyle@cognos.com]<BR><B>Sent:</B> 14 January 2002
09:22<BR><B>To:</B> 'Jon.Kvisli@lindorffapplications.com';
powerh-l@lists.swau.edu<BR><B>Subject:</B> RE: QTP scratchfile 2 GB
limit?<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=924251009-14012002>Hi
Jon,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=924251009-14012002></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=924251009-14012002>there is no way around this limitation using the Unix
platform. It is hoped that the 8.4 release will be able to handle larger
file sizes, but this is not due out for some time, and may not contain the new
feature.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=924251009-14012002></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=924251009-14012002>The
only solution I am aware of in similar situations, is where PH has been
available on other platforms such as Mpe/ix or Openvms, and those servers have
been used to process a portable subfile and the resulting subfile ( which
is now less than 2 Gig and pre-sorted ) ported back to the Unix platform
for processing.</SPAN></FONT></FONT></DIV></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
Jon.Kvisli@lindorffapplications.com
[mailto:Jon.Kvisli@lindorffapplications.com]<BR><B>Sent:</B> 14 January 2002
08:10<BR><B>To:</B> powerh-l@lists.swau.edu<BR><B>Subject:</B> QTP
scratchfile 2 GB limit?<BR><BR></DIV></FONT><BR><FONT face=sans-serif
size=2>We have a problem with qtp terminating with the following
error-message:</FONT> <BR><BR><FONT size=2><TT>Error on scratch file.
</TT></FONT><BR><FONT size=2><TT>
</TT></FONT> <BR><FONT
size=2><TT>Action Taken: Run terminated.</TT></FONT> <BR><BR><FONT
face=sans-serif size=2>We have 16 GB free disk space for scratch files, but
the problem seems to occur when the file reaches 2 GB size..
</FONT><BR><FONT face=sans-serif size=2>Is this a known limitation in qtp?
</FONT><BR><FONT face=sans-serif size=2>If so, are there any configurable
parameters in PH where this can be changed?</FONT> <BR><BR><FONT
face=sans-serif size=2>We are running PH 8.23.D4 on HP-UX and
Oracle8i.</FONT> <BR><BR><FONT face=sans-serif size=2>Jon
Kvisli<BR>----------------------------------------------<BR>Senior
systemkonsulent<BR>Lindorff Applications as<BR>Hellandtunet forsknings- og
næringssenter<BR>Postboks 4, 3833 Bø i Telemark<BR>tlf: 35 06 15 71<BR>fax:
35 06 15 01<BR>e-post:
jon.kvisli@lindorffapplications.com<BR>www.lindorffapplications.com<BR>----------------------------------------------</FONT>
<BR></BLOCKQUOTE><BR>
<P><FONT face=Arial size=2>This message may contain privileged and/or
confidential information. If you have received this e-mail in error or are not
the intended recipient, you may not use, copy, disseminate or distribute it;
do not open any attachments, delete it immediately from your system and notify
the sender promptly by e-mail that you have done so. Thank
you.</FONT></P></BLOCKQUOTE></BODY></HTML>
<BR>
<P><FONT SIZE=2 FACE="Arial">This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.</FONT></P>
------_=_NextPart_001_01C19CEF.21DEF060--