CPF4167 Error - Job cannot create any more spool files

From Support

If you have a question or seek clarification, please call Technical Support.

Problem:

The CPF4167 error can occur if 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.

Potential joblog details when the error occurs:

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:

There was an issue in AS/400 Report Splitter V4.13 and older where the debug spool file RS0005P was being opened even when not debugging SQL statements, thus causing a job to potentially reach the maximum number of spool file entries regularly.

If customer has older than AS/400 Report Splitter V4.13, have them upgrade to the latest version.