PK84199: Update timesheet returns error 'Database error. Please contact y our System Administrator'

APAR status

• Closed as program error.

Error description

• Update timesheet returns error 'Database error. Please contact y
  our  System Administrator'
  
  Steps to reproduce:
  
  
  1) Create a new resource A with start date in January 1, 2006.
  
  2) Create a project , nest a task and assign resource A for 4000
   hours
  of work from start date August 1, 2006
  
  3) Copy proposed to plan and publish project
  
  4) From staffing view of task enter 3600 hours of actual work
  
  5) logon as resource A , navigate to timesheet view and open wee
  k
  4/12/2008 or next one
  
  6) Check-out the view and enter actual time for any day. Check i
  n the
  view. The error appears 'Database error. Please contact your  Sy
  stem
  Administrator'.
  
  
  RPM is executing the stored procedure SP_U_SRV_TS where in Syste
  mOut.log
  it shows the error 'Error has occurred: -9999' and in Alltrace.l
  og
            EXCEPTION: SP_U_SRV_TS(588) : timesheets.sql(6637) : 2
  008-07-
  30 09:47:51.890000
  
  SQLCODE: -1426 SQLERR: ORA-01426: numeric overflow
  
  
  Alltraces.log file shows error:
  
  
  - 2008-07-30 09:47:51.859000
  
  :r := SP_U_SRV_TS('C8FA2EEF964E4B1DA4F4A555E3D65C7E', '2008-04-1
  9',
  '2006-08-01 08:00:00.000000', NULL, '', '', 480, 0, 480, 0, 0, 0
  , 0, 0,
  0, 0, 0, 0, 0, 0, 960, 0, 2400, 23520, 0, '', '', '',
  
  'C8FA2EEF964E4B1DA4F4A555E3D65C7E', 'P',
  
  'F3ABE81BC7644AAE82232F01A44A807F');
  
                ENTER: SP_U_SRV_TS(139) : timesheets.sql(6127) : 2
  008-07-
  30 09:47:51.859000
  
                ENTER: FC_ISSUE_ALERT(105) : alerts.sql(5393) : 20
  08-07-30
  09:47:51.859000
  
                  EXIT: FC_ISSUE_ALERT(1847) : alerts.sql(7135) :
  2008-07-
  30 09:47:51.875000 STATE: 0
  
                ENTER: FC_ISSUE_ALERT(105) : alerts.sql(5393) : 20
  08-07-30
  09:47:51.875000
  
                  EXIT: FC_ISSUE_ALERT(1847) : alerts.sql(7135) :
  2008-07-
  30 09:47:51.875000 STATE: 0
  
                ENTER: FC_U_SUMMARY_TIMESHEETS(348) : timesheets.s
  ql(2150)
  : 2008-07-30 09:47:51.875000
  
            EXCEPTION: SP_U_SRV_TS(588) : timesheets.sql(6637) : 2
  008-07-
  30 09:47:51.890000
  
  SQLCODE: -1426 SQLERR: ORA-01426: numeric overflow
  
  
  
  We have observed that this error message appears only if the act
  ual start date of task is more than 52 weeks from todays date.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Once the actual effort for an assignment is higher than 3600
  hours, the formula used to calculate the milestone percent
  of the assignment will cause an overflow when multiplying
  the actual effort (in minutes) by 10000. The problem only
  occurs in Oracle version of RPM.
  

Problem conclusion

• Change the order of the multiplication and division to avoid
  the overflow.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  RATL PORT MGR U

• Fixed component ID

  5724J4002

Applicable component levels

• R711 PSN

     UP