Periodic Process or Calculation returns “Array overflow condition encountered” error message (16005,27009).
Root Cause
This message is returned whenever one of many different possible COBOL Arrays has been exceeded.
The message does not show which Array was exceeded, but the program name, program section, and array message are included in the application trace output. This is a display statement, so the output is included even when the application trace is inactivated.
Errors reported from the Service program (PAPCSRVC) are the exception, and no additional application trace output is included. When the Array is exceeded, the SQL executing at the time is saved in the message log parameters but not displayed within the message.
Solutions
Identify the Array exceeded (see conditions below).
If possible, estimate the required array size (follow the link to the relevant Array Knowledge Base article).
Increase the appropriate array size, change the configuration if applicable, or remove employee data to resolve.
Hints
Not all Array problems use this message. This message applies primarily to Arrays populated in PAPCRSQL or PAPPRSQL.
Message Log Enhancement includes the additional message fields for identifying the exceeded Array.
More to come…
Details
Message Set/Number: 16005,27009
Warning Message: Array overflow condition encountered
Programs: PAPCRSQL, PAPCSRVC, PAPPRSQL
Message Pointer: S-MSG-ARRAY-OVERFLOW
Conditions
Exceeding Function Results Per Plan Array
Results in the following application trace output:
| Program Variable | Application Trace Output |
| S-MSG-PGM-NM | PAPCRSQL |
| S-MSG-PGM-PARA | GET-CALC-PROC |
| S-MSG-LUCID-MSG: MSG-ERR-PROC-MAX | Calc Prc Lst Exceeds Tbl Max. |
Related Message Pointer: S-MSG-RSQL-ERR-PROC-MAX
Related SQL Statement: PAPCRSQL_S_PROC
Exceeding Benefit Plans for Calculation (3) Array
Results in the following application trace output:
| Program Variable | Application Trace Output |
| S-MSG-PGM-NM | PAPCRSQL |
| S-MSG-PGM-PARA | GET-CALC-PLAN-DATA |
| S-MSG-LUCID-MSG: MSG-ERR-CALCPLN-MAX | Calc Plan Inpts Exceed Tbl Max |
Related Message Pointer: S-MSG-RSQL-ERR-CALCPLN-MAX
Related SQL Statement: PAPCRSQL_S_PLAN1
Exceeding Definitions in a Function Result (5) Array
Results in the following application trace output:
| Program Variable | Application Trace Output |
| S-MSG-PGM-NM | PAPCRSQL |
| S-MSG-PGM-PARA | GET-FNCRSLT |
| S-MSG-LUCID-MSG: MSG-ERR-RSLT-MAX | Calc Function Results Exceeds Tbl Max. |
Related Message Pointer: S-MSG-RSQL-ERR-RSLT-MAX
Related SQL Statement: PAPCRSQL_S_RSLT
Exceeding USDB Pension Plan History (6) Array
Results in the following application trace output:
| Program Variable | Application Trace Output |
| S-MSG-PGM-NM | PAPCRSQL |
| S-MSG-PGM-PARA | GET-PLAN-HIST |
| S-MSG-LUCID-MSG: MSG-ERR-PLAN-HIST-MAX | Plan History Exceeds Tbl Max |
Related Message Pointer: S-MSG-RSQL-ERR-HIST-MAX
Exceeding Function Fields Per Result (8) Array
Results in the following application trace output:
| Program Variable | Application Trace Output |
| S-MSG-PGM-NM | PAPCRSQL |
| S-MSG-PGM-PARA | GET-PROCFLD |
| S-MSG-LUCID-MSG: MSG-ERR-PROCFLD-MAX | Calc prc Fld Exceeds Tbl Max. |
Related Message Pointer: S-MSG-RSQL-ERR-PROCFLD-MAX
Related SQL Statement: PAPCRSQL_S_PROCFLD
Exceeding Job Data (200) Array
Results in the following application trace output:
| Program Variable | Application Trace Output |
| S-MSG-PGM-NM | PAPCRSQL |
| S-MSG-PGM-PARA | SELECT-JOB |
| S-MSG-LUCID-MSG: MSG-ERR-JOB-MAX | Employee Job Records Exceeds Tbl Max. |
Related Message Pointer: S-MSG-RSQL-ERR-JOB-MAX
Related SQL Statement: PAPCRSQL_S_JOB
| Program Variable | Application Trace Output |
| S-MSG-PGM-NM | PAPCRSQL / PAPPRSQL |
| S-MSG-PGM-PARA | SELECT-ELIGACT |
| S-MSG-LUCID-MSG: MSG-ERR-JOB-MAX | Employee Job Records Exceeds Tbl Max. |
Related Message Pointer: S-MSG-RSQL-ERR-JOB-MAX
Related SQL Statements: PAPCRSQL_S_ELIGACT, PAPPRSQL_S_ELIGACT
Exceeding Primary Job Overrides (202) Array
Results in the following application trace output:
| Program Variable | Application Trace Output |
| S-MSG-PGM-NM | PAPCRSQL / PAPPRSQL |
| S-MSG-PGM-PARA | BLD-OVERRIDE-TIMELINE |
| S-MSG-LUCID-MSG: MSG-ERR-OVRD-JOB-MAX | Employee Override Job Records Exceeds Tbl Max. |
Related Message Pointer: S-MSG-OVRD-JOB-MAX
Related SQL Statements: PAPCRSQL_S_OVRD, PAPPRSQL_S_OVRD
| Program Variable | Application Trace Output |
| S-MSG-PGM-NM | PAPCRSQL / PAPPRSQL |
| S-MSG-PGM-PARA | BLD-REST-TIMELINE |
| S-MSG-LUCID-MSG: MSG-ERR-PRIM-JOB-MAX | Employee Primary Job Records Exceeds Tbl Max. |
Related Message Pointer: S-MSG-PRIM-JOB-MAX
Exceeding Active Jobs (203) Array
Results in the following application trace output:
| Program Variable | Application Trace Output |
| S-MSG-PGM-NM | PAPCRSQL / PAPPRSQL |
| S-MSG-PGM-PARA | GET-ACTIVE-REC |
| S-MSG-LUCID-MSG: MSG-ERR-ACT-JOB-MAX | Employee Eligible Job Records Exceeds Tbl Max. |
Related Message Pointer: S-MSG-ACT-JOB-MAX
Related SQL Statements: PAPCRSQL_S_ELIGJOB, PAPPRSQL_S_ELIGJOB
Exceeding Multi-Job Eligibility Rows (204) Array
Results in the following application trace output:
| Program Variable | Application Trace Output |
| S-MSG-PGM-NM | PAPCRSQL / PAPPRSQL |
| S-MSG-PGM-PARA | GET-ELIGIBLE-REC |
| S-MSG-LUCID-MSG: MSG-ERR-ELIG-JOB-MAX | Employee Eligible Job Records Exceeds Tbl Max. |
Related Message Pointer: S-MSG-ELIG-JOB-MAX
Related SQL Statements: PAPCRSQL_S_ELIGJOB, PAPPRSQL_S_ELIGJOB
Exceeding Active Job Periods (205) Array
Results in the following application trace output:
| Program Variable | Application Trace Output |
| S-MSG-PGM-NM | PAPCRSQL / PAPPRSQL |
| S-MSG-PGM-PARA | GET-ELI-REC |
| S-MSG-LUCID-MSG: MSG-ERR-ELIG-ACT-JOB-MAX | Employee Elig Act Job Records Exceeds Tbl Max. |
Related Message Pointer: S-MSG-ELIG-ACT-JOB-MAX
Exceeding Service Adjustments (302) Array
Additional application trace output is not returned for errors in PAPCSRVC, but additional parameters may be saved to the message log parameters table:
| Program Variable | Application Trace Output |
| S-MSG-PGM-NM | PAPCSRVC |
| S-MSG-PGM-PARA | SI120-GET-EXTERNAL-ADJUST |
| MESSAGE-PARM(1) | RTNCD |
| MESSAGE-PARM(2) | SQL-STMT OF S-PADJUST |
Related SQL Statement: PAPCSRVC_S_PADJUST
Exceeding Service Purchase Adjustments (303) Array
Additional application trace output is not returned for errors in PAPCSRVC, but additional parameters may be saved to the message log parameters table:
| Program Variable | Application Trace Output |
| S-MSG-PGM-NM | PAPCSRVC |
| S-MSG-PGM-PARA | SI620-GET-SVC-PRCH-ADJUST |
| MESSAGE-PARM(1) | RTNCD |
| MESSAGE-PARM(2) | SQL-STMT OF S-ESTADJ |
Related SQL Statement: PAPCSRVC_S_ESTADJ
Leave a Reply
You must be logged in to post a comment.