Problem:

With Report Splitter, you get the error:

CPF4167 Error - Job cannot create any more spool files

The job log includes something like this:

JOB LOG DETAILS
CPF1015    Escape  40    06/18/02   12:27:44   QCLRTVDA       QSYS
0208     RPT010C      RJSSPLIT     01C5
               Message . . . . :   Data area RPTPAGES in QTEMP not
found.
CPF4167    Escape  40    06/18/02   12:27:44   QSPIERRS       QSYS
0028     RS005R       RJSSPLIT     *STMT
               To module . . . . . . . . . :   RS005R
               To procedure  . . . . . . . :   RS005R
               Statement . . . . . . . . . :   1000001
               Message . . . . :   Job cannot create any more spooled
files.
RNX1216    Escape  99    06/18/02   12:27:45   QRNXIE         QSYS
*STMT    RS005R       RJSSPLIT     *STMT
               From module . . . . . . . . :   QRNXMSG
               From procedure  . . . . . . :   SignalException
               Statement . . . . . . . . . :   20
               To module . . . . . . . . . :   RS005R
               To procedure  . . . . . . . :   RS005R
               Statement . . . . . . . . . :   1000001
               Message . . . . :   Error message CPF4167 appeared
during OPEN for file RS005P.
RNQ1216    Sender  99    06/18/02   12:27:45   QRNXIE         QSYS
*STMT    QRNXIE       QSYS         *STMT
               From module . . . . . . . . :   QRNXMSG
               From procedure  . . . . . . :   InqMsg
               Statement . . . . . . . . . :   2
               To module . . . . . . . . . :   QRNXMSG
               To procedure  . . . . . . . :   InqMsg
               Statement . . . . . . . . . :   2
               Message . . . . :   Error message CPF4167 appeared
during OPEN for file RS005P (C S D F).
*NONE      Reply         06/18/02   12:40:05   QMHSCLVL       QSYS
0590     QRNXIE       QSYS         *STMT
               To module . . . . . . . . . :   QRNXMSG
               To procedure  . . . . . . . :   InqMsg
               Statement . . . . . . . . . :   4
MSGID      TYPE                    SEV   DATE       TIME       FROM PGM
LIBRARY     INST     TO PGM  LIBRARY INST
                               Message . . . . :   C
CEE9901    Escape  30    06/18/02   12:40:05   QLEAWI         QSYS
*STMT    RS007R       RJSSPLIT   *STMT
               From module . . . . . . . . :   QLEDEH
               From procedure  . . . . . . :   Q LE leDefaultEh
               Statement . . . . . . . . . :   232
               To module . . . . . . . . . :   RS007R
               To procedure  . . . . . . . :   RS007R
               Statement . . . . . . . . . :   440
               Message . . . . :   Application error.  RNX1216
unmonitored RS005R at
                                 statement 0001000001, instruction
X'0000'.
CPF1015    Escape  40    06/18/02   12:40:05   QCLRTVDA       QSYS
0208     RPT010C      RJSSPLIT     01C5

Solution:

The CPF4167 error occurs when the Report Splitter output queue monitor creates more than 9999 (prior to V5R1) or more than 999,999 (V5R1 and above) spool files within a job. In Report Splitter version 4.13 and earlier, there was an issue where the debug spool file RS0005P opened even when not debugging SQL statements. This caused jobs to reach the maximum number of spool file entries regularly.

To resolve this issue, upgrade to Report Splitter version 4.14 or above.

 


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016