Re: HELP. Letter Generation has failed (SQL Status = -1201,Number is too small for a DECIMAL data type)

[Don DeSmith <DESMITD@DOMINOS.COM>]

Looks like a tough one.

For some strange reason you are getting an error in an SQL statement in the code that updates the Process Scheduler with your status (initiated, queued, processing, successful, unsuccessful, error) and any error messages.  All of the values that it should be passing are integers and character strings.   If you are using Informix the -1201 message means 
-----------------
Number is too small for a DECIMAL data type. 

The DECIMAL data type accommodates numbers from 10 to the -130th power through 10 to the 124th power in absolute value. The precision (number of significant digits) varies from 1 to 32; however, the source of this error is not the length of the number but its magnitude.
-------------------
I have no idea why you would be trying to pass in data that would cause this message to occur.  Check with your Informix database administrator to see if the table PSPRCSRQST is messed up.  Are other Process Scheduler jobs working ok?  What DBMS?  Is this part of a multi-step Job?  

This is the SQL update statement that is bombing.
  
        UPDATE PSPRCSRQST
         SET RUNSTATUS = #prcs_run_status,
           MSGSET = #prcs_message_set_nbr,
           MSGNUM = #prcs_message_nbr,
           PRCSRTNCD = #prcs_rc,
           MSGPARM1 = $prcs_message_parm1,
           MSGPARM2 = $prcs_message_parm2,
           MSGPARM3 = $prcs_message_parm3,
           MSGPARM4 = $prcs_message_parm4,
           MSGPARM5 = $prcs_message_parm5,
           CONTINUEJOB = #prcs_continuejob,
           ENDDTTM = {DateTimeIn-Prefix}&SysDateTime{DateTimeIn-Suffix}
         WHERE PRCSINSTANCE = #prcs_process_instance
  
Good luck
Don


>>> Beth Smith-Naprstek <BANAPRST@HEWITT.COM> 07/17 3:59 PM >>>
Our letter generation support folks are not here today, so per Murphy's
Law, it has failed in Production but we cannot replicate it in our QA Test
region.

Any help or suggestions would be greatly appreciated.

Thanks in advance,
Beth Smith-Naprstek
Hewitt Associates

ERROR MESSAGE::


APP007
Build Recruitment Letter Merge File
BOJ - Start Program at: 14:06:52  1998-07-17
\\l98nfp2\nat_vol2\ha\psft\hr\prod\sqr\app007.sqr: APP007 - SQL Statement =

PRCSAPI.SQC,Update-Process-Status,Update,PSPrcsRqst
SQL Status = -1201, SQL Error  = Number is too small for a DECIMAL data
type


Error on line 129:
   (SQR 3301) Program stopped by user request.

SQRW: Program Aborting.