This is weird... Online vs. In a Job INDEX
Nancy Tietz
ntietz@MCARE.MED.UMICH.EDU
Thu, 17 Oct 2002 09:02:12 -0400
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_01C275DD.686D2200
Content-Type: text/plain;
charset="iso-8859-1"
Thank you to everyone who offered their kind advice.
Forgive me but I didn't want to publish my full code to the list.
My co-worker Brian Jones figured out the issue.
Answers to your questions:
1. the job user has AM capability
2. all subfiles were purged prior to running the job
3. I tried it again with more different names in the subfiles in that
erroring section and still the online worked and the job didn't.
4. no temp files are created in the job, and we have no similar named temp
files in our UDC's.
5. The job logged onto the WRK group, and the online Quiz designated .wrk
on the input file.
Why the job didn't work:
1. the Quiz running in the job had SET REP LIM 3999999 in the beginning of
it, which is our company standard
2. In the online version I just typed in 999999 as a REP LIM because I knew
the file size.
3. one of the fields - REST - in the subfile is 1961 bytes long. (this may
or may not have been a contributing factor)
4. our Test computer where the job ran (and where I ran my online version
as well) is known for frequent disc space problems etc. (we sometimes get
QTPSORT and QUIZSORT type errors on this computer and have to modify our
limits for those)
5. The job finally ran successfully with the INDEX option when the SET REP
LIM was changed to 999999 instead of 3999999.
6. I will be trying out a run of this same job with the Index option and
3999999 rep lim on another HP3000 that has more memory and disc space to see
if it works there. I'm thinking it will.
That's it.
Thanks everybody!! I sure do appreciate this listserver. Have a great
weekend. The fall colors are beautiful and the apple cider is delicious out
here in Michigan!
Nancy
-----Original Message-----
From: DAVID MORANKO [mailto:DMORANKO@wellplan.com]
Sent: Wednesday, October 16, 2002 4:12 PM
To: powerh-l@lists.swau.edu; ntietz@mcare.med.umich.edu
Subject: Re: This is weird... Online vs. In a Job INDEX
Nancy,
Are you sure your two examples are looking at the same file? In your snippet
from the Job version your input file is not qualified for the group name. Or
perhaps in your 'on-line' example, you could be accessing a temp file as
opposed to a disc file? Just a thought...
>>> Nancy Tietz <ntietz@mcare.med.umich.edu> 10/16/02 10:48AM >>>
I am able to create an indexed subfile online in Quiz, but not in a job.
HP3000 series 939 MPE
Q U I Z (PowerHouse 8.19.C2)
Here is what happened in the job: (I traced it back to the INDEX. If I take
out the INDEX it works.)
300
301 >
302 > ACC *TGRDVF03
303 >
304 > SORTED ON EE-SSN
305 >
306 > SET SUB NAME UM21004F KEEP AT EE-SSN INDEX EE-SSN
307 > REP SUM &
308 > NEW-BEG &
309 > F4 &
310 > NEW-DIV &
311 > F7 &
312 > EE-SSN &
313 > REST
314 >
315 > GO ;*********
316 *E* File error on dictionary portion of subfile.
317 *E* The file does not exist in specified domain; the file was not
found.
318 (FILE
319 OPEN ERROR -247)
320 > EXIT
And here is the successful run OnLine:
:quiz
Q U I Z (PowerHouse 8.19.C2)
Copyright 1998 COGNOS INCORPORATED
M-Care
> ACC *TGRDVF03.WRK
*W* PowerHouse name for TGRDVF03.WRK is TGRDVF03.
> SORTED ON EE-SSN
> SET SUB NAME UM21004T KEEP AT EE-SSN INDEX EE-SSN
> REP SUM &
> NEW-BEG F4 NEW-DIV F7 EE-SSN REST
> SET REP LIM 999999
> GO
Records selected: 2311
Records written: 1841
>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
<http://lists.swau.edu/mailman/listinfo/powerh-l>
This list is closed, thus to post to the list you must be a subscriber.
------_=_NextPart_001_01C275DD.686D2200
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 6.00.2713.1100" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 8pt MS Sans Serif; MARGIN-LEFT: 2px">
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=546534712-17102002>Thank
you to everyone who offered their kind advice.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=546534712-17102002>Forgive me but I didn't want to publish my full code to
the list.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=546534712-17102002>My
co-worker Brian Jones figured out the issue.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=546534712-17102002></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=546534712-17102002>Answers to your questions:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=546534712-17102002>1. the job user has AM capability
</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=546534712-17102002>2. all subfiles were purged prior to running the
job</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=546534712-17102002>3. I tried it again with more different names in
the subfiles in that erroring section and still the online worked and the job
didn't.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=546534712-17102002>4. no temp files are created in the job, and we
have no similar named temp files in our UDC's.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=546534712-17102002>5. The job logged onto the WRK group, and the
online Quiz designated .wrk on the input file.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=546534712-17102002></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=546534712-17102002>Why
the job didn't work:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=546534712-17102002>1. the Quiz running in the job had SET REP LIM
3999999 in the beginning of it, which is our company
standard</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=546534712-17102002>2. In the online version I just typed in 999999
as a REP LIM because I knew the file size.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=546534712-17102002>3. one of the fields - REST - in the subfile
is 1961 bytes long. (this may or may not have been a contributing
factor)</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=546534712-17102002>4. our Test computer where the job ran (and where
I ran my online version as well) is known for frequent disc space problems etc.
(we sometimes get QTPSORT and QUIZSORT type errors on this
computer and have to modify our limits for those)</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=546534712-17102002>5. The job finally ran successfully with the
INDEX option when the SET REP LIM was changed to 999999 instead of
3999999. </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=546534712-17102002>6. I will be trying out a run of this same job
with the Index option and 3999999 rep lim on another HP3000 that has more memory
and disc space to see if it works there. I'm thinking it
will.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=546534712-17102002></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=546534712-17102002>That's
it.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=546534712-17102002>Thanks
everybody!! I sure do appreciate this listserver. Have a great
weekend. The fall colors are beautiful and the apple cider is delicious
out here in Michigan!</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=546534712-17102002>Nancy</SPAN></FONT></DIV>
<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> DAVID MORANKO
[mailto:DMORANKO@wellplan.com]<BR><B>Sent:</B> Wednesday, October 16, 2002
4:12 PM<BR><B>To:</B> powerh-l@lists.swau.edu;
ntietz@mcare.med.umich.edu<BR><B>Subject:</B> Re: This is weird... Online vs.
In a Job INDEX<BR><BR></FONT></DIV>
<DIV><FONT size=1>Nancy,</FONT></DIV>
<DIV><FONT size=1></FONT> </DIV>
<DIV><FONT size=1>Are you sure your two examples are looking at the same file?
In your snippet from the Job version your input file is not qualified for the
group name. Or perhaps in your 'on-line' example, you could be accessing a
temp file as opposed to a disc file? Just a thought...</FONT></DIV>
<DIV><FONT size=1></FONT> </DIV>
<DIV><FONT size=1></FONT> </DIV>
<DIV><BR><BR>>>> Nancy Tietz <ntietz@mcare.med.umich.edu>
10/16/02 10:48AM >>><BR><BR>I am able to create an indexed subfile
online in Quiz, but not in a job.<BR><BR>HP3000 series 939
MPE<BR>Q U I Z (PowerHouse 8.19.C2)<BR><BR>Here is what
happened in the job: (I traced it back to the INDEX. If I take<BR>out the
INDEX it works.)<BR> 300 <BR>
301 > <BR>
302 > ACC *TGRDVF03<BR>
303 > <BR>
304 > SORTED ON EE-SSN<BR>
305 > <BR>
306 > SET SUB NAME UM21004F KEEP AT EE-SSN
INDEX EE-SSN<BR> 307 > REP SUM
&<BR> 308 > NEW-BEG
&<BR> 309 > F4
&<BR> 310 > NEW-DIV
&<BR> 311 > F7
&<BR> 312 > EE-SSN
&<BR> 313 > REST<BR>
314 > <BR>
315 > GO ;*********<BR>
316 *E* File error on dictionary portion of
subfile.<BR> 317 *E* The file does not
exist in specified domain; the file was not<BR>found. <BR>
318 (FILE <BR>
319 OPEN ERROR -247)<BR>
320 > EXIT<BR><BR>And here is the
successful run OnLine:<BR>:quiz<BR><BR>Q U I Z (PowerHouse
8.19.C2)<BR>Copyright 1998 COGNOS INCORPORATED<BR>M-Care<BR><BR>> ACC
*TGRDVF03.WRK<BR>*W* PowerHouse name for TGRDVF03.WRK is TGRDVF03.<BR>>
SORTED ON EE-SSN<BR>> SET SUB NAME UM21004T KEEP AT EE-SSN INDEX
EE-SSN<BR>> REP SUM &<BR>> NEW-BEG F4 NEW-DIV F7 EE-SSN
REST<BR>> SET REP LIM 999999<BR>> GO<BR><BR>Records selected:
2311<BR>Records written: 1841<BR><BR>> <BR><BR>= = = = = = = =
= = = = = = = = = = = = = = = = = = = =<BR>Mailing list:
powerh-l@lists.swau.edu<BR>Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu<BR>Unsubscribe: "unsubscribe" in message body
to powerh-l-request@lists.swau.edu<BR><A
href="http://lists.swau.edu/mailman/listinfo/powerh-l">http://lists.swau.edu/mailman/listinfo/powerh-l</A><BR>This
list is closed, thus to post to the list you must be a
subscriber.<BR></DIV></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C275DD.686D2200--