System error occurs when somebody tries to change the hours when an hour value with 6 digits was intially entered.

Document ID : KB000051565
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

If a resource enters a high value of hours such as 216,667 into the cell for hours entry in a timesheet, and then tries to correct the entry, the timesheet page will show "System error. Contact system administrator" when saving the timesheet and the app-niku.log will show an error similar to the following:

ERROR 2010-04-27 14:40:40,980 [http-80-Processor10] niku.xql2
(admin:6635200__78726251:timeadmin.saveTimesheet) Number -216,667.0- format
string #0.###### default locale en_US
ERROR 2010-04-27 14:40:40,980 [http-80-Processor10] niku.xql2
(admin:6635200__78726251:timeadmin.saveTimesheet) Parse Index 3 string length 9
ERROR 2010-04-27 14:40:40,980 [http-80-Processor10] niku.xql2
(admin:6635200__78726251:timeadmin.saveTimesheet) Internal Processing exception
java.lang.NumberFormatException: Number not completely processed 216,667.0
at com.niku.xql2.util.TypeUtil.parseNumber(TypeUtil.java:139)
at com.niku.xql2.util.TypeUtil.parseDouble(TypeUtil.java:62)
.processAction(WebActionController.java:

Solution:

To correct the problem and allow the timesheet hour entry to be corrected and saved:

  1. Exit out of the timesheet.
  2. Go back into the timesheet.
  3. Click the Select All button in left column( blue arrow pointing down with checkmark next to it).
  4. Delete all the tasks.
  5. Re-enter the tasks and do not use a comma when the value is entered.