WW sending result to output file?

[Carpentero]

Does anyone have a problem in World Writer using the option to write the output to an output file? In my case, the World Writer version failes when you try to run it, because it cannot create the output file. It seems that World Writer has a problem with creating output files.

 

[Ingramw]

Verify your field output.
Look for duplicate field output
Reduce the number of output fields

The above are some options you may want to try. If you still do not get
desired results, you may want to run the WW in debug. You must step
through the code until the create PF (Output File) process is run. DDS
will be created in QTEMP. Where you can view the errors if any.

W.I.
.



Carpentero
<raf.carpentero@eur To: [email protected]
.bosal.com> cc:
Sent by: Subject: WW sending result to output file?
owner-jdeworld@jdel
ist.com


10/17/2002 03:48 AM
Please respond to
jdeworld






Does anyone have a problem in World Writer using the option to write the
output to an output file? In my case, the World Writer version failes when
you try to run it, because it cannot create the output file. It seems that
World Writer has a problem with creating output files.
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=43554
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList World? mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+

 

[Hal_McGee]

Raf,
The number one reason I have seen WW fail to create an output file is
that the WW contains the same field listed twice. Even if you use an alias,
WW will blow up. Other than that, it works fine for us.
Good Luck
Hal

Hal McGee
Engineering Data Manager
Group Engineering - Process and Compliance
Seating Products Group
B/E Aerospace
Winston-Salem, NC

 

[elway]

Several possible reasons for this failure come to mind:

- the WW may be attempting to overwrite a file listed in the Software Versions Repository (this is the case with all standard issue JDE files such as F0911 etc);

- the user profile under which the WW runs does not have the appropriate authority to either the destination library (QGPL by default, but this can be changed) or destination file;

- the WW parameters have not been correctly configured.

Can you give details of the exact error message from the log ?

 

[alzakkr]

Does the file your trying to output to already exist? I don't believe WW
can't create a new file like Query does.

Kristin

 

[LDiMarco]

Carpentero:
The only time I've seen this fail is if there are duplicate fields you are
requesting to output ,too many records you're trying to update or no match
to the criteria of the report. Try running in print form first. Either
way, the job log should tell you either problem-duplicate or # of records

 

[scott_parker]

Look at all the fields in the output specs. If you are using the same files multiple times and also the same field in those files then WW will not build a file.

Solution is to put the "Offending" field into a made up calculated field.



Scott Parker
Grote Industries, LLC
mailto:[email protected]





Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V5R1

 

[TGreene]

We create output files from WW all the time. Be sure the file you're
trying to create fits 400 standards. No blanks imbedded, cannot begin
with a number or an asterisk or an ampersand, etc. Otherwise, maybe it
could be an authority problem? I'm not sure about that.

Hope this helps,
Teri


Does anyone have a problem in World Writer using the option to write
the output to an output file? In my case, the World Writer version
failes when you try to run it, because it cannot create the output file.
It seems that World Writer has a problem with creating output files.
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=43554
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList WorldO mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards.

+ - - - - - - - - - - - - - - - - - - - - - - - -+

 

[jill_a_fralick]

Or are you trying to write to the file using totals rather than detail?
WW does not like totals when writing to output file.




Jill Fralick
ABB Flexible Automation
Auburn Hills, MI 48313
A7.3 cum 10
(248) 391-8618

 

[Rowen_Sevilla-E]

WorldWriter will not create output files for Total or summary records.
Check that the Query Detail (or Totals Only)field in the Additional
Parameters screen is set to D.

Goodluck,

Rowen Sevilla-Enriquez
Granite Construction Incorporated
email: [email protected]





Rowen Sevilla-Enriquez
IT-Business Analyst
Granite Construction Incorporated
A7.3 cume 12

 

[jean_driscoll]

I tried it, it created a file, but then it dumped and ended abnormally because the file created had a initial#records = 10000 with only 3 1000 increments to add and my WW was querying more than 13000 records. Is there anyway to set the initial # records for a WW output file. I tried changing the file and running again, but the WW deleted the previous file and added another.

What's the specific error in the joblog that you are getting?

 

[slandess]

Jean:

When a file fills up (reaches maximum # of records), the CPF5305 message is
sent to the QSYSOPR message queue that indicates
' Record not added. Member FXXXXX is full. (C I 9999)
Reply . . : __________________

If the system operator replies with 'C' to this message, the program will
cancel and the WW will end abnormally. If answered with 'I', the file will
be extended one increment, or if you answer with 1 - 9999, the file will be
extended by 1 to 9999 increments, depending on the number that you enter...
There are two ways to handle this situation:

1) The default file size on the AS/400 is 10000 records, with three
increments of 1000, totalling 13,000 records. You can see this by prompting
the CRTPF command and viewing the values in the SIZE parameter. This can be
changed by changing the default value using CHGCMDDFT on the CRTPF command
to specify a different values for the SIZE parameter, but this applies
globally to all files created by using CRTPF (Dangerous!)

2) If you add a reply list entry (see ADDRPYLE, WRKRPYLE) to automatically
reply to this message, then your WW won't bomb. If you specify 'I' as the
default answer for CPF5305, it will continue expanding the file, one
increment at at time, until the WW is finished. You can also tailor the
responses for this msgid
based on the file name that it occurred on. Your operations department may
assert their responsibility about making these changes. If you allow a
runaway WW to create a file that fills up the disk, then you could take the
system down. You most definitely need to manage this properly.

Search all books at http://as400bks.rochester.ibm.com for 'system reply
list'. I used the V4R5 books for my search.

Here is a link from the V4R5 OS/400 CL Programming Guide (if the link
doesn't post properly, use EVERYTHING between the "<" and the ":
<
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/qb3auo03/8.6?ACTION=MATC
HES&REQUEST=system+reply+list&TYPE=FUZZY&SHELF=QB3AYC08&DT=19991014091328&se
archTopic=&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FI
RSTHIT
HTH

----- Original Message -----
From: "Jean_Driscoll" <[email protected]>
To: <[email protected]>
Sent: Thursday, October 17, 2002 11:22 AM
Subject: Re: WW sending result to output file?


I tried it, it created a file, but then it dumped and ended abnormally
because the file created had a initial#records = 10000 with only 3 1000
increments to add and my WW was querying more than 13000 records. Is there
anyway to set the initial # records for a WW output file. I tried changing
the file and running again, but the WW deleted the previous file and added
another.What's the specific error in the joblog that you are getting?
Jean Driscoll
AS/400 Co-existent Xe 17.1, Update 4/A73Cum12
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=43584
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList WorldT mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+



Steve Landess
V4R4 A7.3 cume9
EDI
(512) 423-0935

 

[JohnSchiff]

CHGCMDDFT for the CRTPF to size(*NOMAX)



Director Solutions Delivery
WolrdSoftware Division
J.D.Edwards

 

[youngdublin]

Re: RE: WW sending result to output file?

Thanks Scott
I encountered the same problem and found it to be caused by duplicate fields selected