The target for a numeric operation is too small to hold the result

From Support

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

Problem:

Upgraded from an older version of the Email Report Server/400 (V1.69 to V2.32) and started getting the following error when running ERSMON001:

Message ID: RNQ0103 - The target for a numeric operation is too small to hold the result. 
RPG procedure ERSMON001 in program RJSERS/ERSMON001  at statement XXX (785, 805) performed 
an arithmetic operation which resulted in a value that was too large to fit in the target.

Solution:

Run the following command to insure that all spool file attributes are being extracted from a report during processing.

An option was added to handle the user defined options field info in library update V2.01 and the QUSRSPLA data area should now be set to 1600. This isn't a problem for new installs, only for upgrades since existing settings values are preserved.

CHGDTAARA DTAARA(RJSERS/QUSRSPLA) VALUE(1600)

Note: If you're at version 2.32 or below of the Email Report Server/400, just upgrade. We fixed the problem so the QUSRSPLA gets updated correctly, and we changed ERSMON001 to not try and check the User Defined Options offset info if a spool file happens to get deleted while processing a list of spool files from a selected outq. The following hard halt error was occurring from ERSMON001 (outq monitor) if a spool file got deleted while being processed: "The target for a numeric operation is too small to hold the result."