CPYSPLF To database fails with message CPF3468

15 pts.
Tags:
AS/400
AS/400 errors
CPF errors
CPYSPLF
Hello there: I'm having problems at work for the last couple days. I submitted a job that wakes up when the Dataque retrieves an incoming spool file (invoice). Right after Cpysplf is executed by QCMDEXC, I received message Id CPF3468. I would love to hear any suggestions. Thank you very much

Software/Hardware used:
AS/400

Answer Wiki

Thanks. We'll let you know when a new response is added.

Check out this link.  It should you out:

http://archive.midrange.com/midrange-l/200605/msg00349.html

Discuss This Question: 9  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • philpl1jb
    I think we'll probably need the message text. phil
    49,980 pointsBadges:
    report
  • TomLiotta
    Most likely, there are DBCS characters in the spooled file. Since CPF3468 happens when a DBCS string isn't formatted properly (perhaps because the resulting database file record caused a truncation), it's at least fairly certain that shift-in/shift-out character pairs are found in the spooled files. Without seeing the spooled files themselves, there probably isn't much we can add. Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    And that would mean that you should get the same error anytime you try to copy that spool file.
    49,980 pointsBadges:
    report
  • glad
    I just checked my job log to find the correct message id : CPF3482.. "Copy request failed. Spool file COFORAPF is open." If the same job runs from the command line, then I don't have this problem. Your help is highly appreciated.. I need to bring a resolution to our problem with the RA's not printing details(some times) but headings.. I think that by copying the spooled files to a database, I might be able to see if there is any special character not printing that makes the details skipped to print totals.. Thanks again...
    15 pointsBadges:
    report
  • TomLiotta
    ...the correct message id : CPF3482.. “Copy request failed. Spool file COFORAPF is open.” If the same job runs from the command line, then I don’t have this problem. You can't copy it until it's closed. By the time you run the job again, the spooled file is closed. Don't try to copy it while it doesn't have a closed status. The Retrieve Spooled File Attributes (QUSRSPLA) API will return the 'Status' in format SPLA0100. If the Status isn't '*READY', '*SAVED' or '*HELD', you can't copy it yet. You might retrieve the status in a delay loop until the spooled file is ready. Or you could use a similar delay loop through a MONMSG for CPF3482 -- if that error occurs, DLYJOB for 15 or 30 seconds, loop back and try CPYSPLF again. You might want to count how many times you loop so you can break out of it after too many tries. Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    assuming that you are writing the spool file from an RPG program, make the file USROPN. Open it before you start writing to it. Close it before you send to the DataQue. Trasnsfers by DataQueue can be very fast, your queue processing program is probably in wait state for the message and may start processing almost immediately when it receives the message..before your RPG program can close the files. Phil
    49,980 pointsBadges:
    report
  • TomLiotta
    It hasn't been made clear for us what the source of the spooled file is nor the source of any *dtaq entry. Spooled files might be generated by a PC through a printer share -- no RPG (nor any local program) involved in generation. They might arrive via LPR/LPD. Or local programming could create them. Entries on the *dtaq might be sent by local program, by remote program through the *dtaq server or by an *outq exit program that receives notification of *RDY status. But no matter how any of the pieces are generated, the CPYSPLF still must capture and handle any CPF3482 conditions. If the status isn't appropriate, the CPYSPLF will fail. And if CPYSPLF fails when the status is appropriate, it should be IBM's problem. We won't be able to help. No? Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    Glad If I understand the problem you sometimes don't get details when your spool file prints. But you don't detect an error. As I understand it, this problem isn't related to the CPF3468 “Copy request failed. Spool file COFORAPF is open.” which occurs when you try to "log" or capture the spool files. Infact, it sound like you've added this cpysplf in an attempt to capture the original printing error. Can you tell us what creates the spoolfile and what sends an entry to the Data Queue? And why you think that the spool file will be closed at the time you send the entry? Phil
    49,980 pointsBadges:
    report
  • Splat
    You might want to check the printer file attributes. An output queue data queue entry won't be posted until the spooled file entry is at a ready status - if the print file is defined or overridden with SCHEDULE(*IMMED) it will show at a ready state even though it's incomplete.
    7,245 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following