Skip to main content
Planview Customer Success Center

Decimal and/or datetime conversion errors in API

Symptoms:
Various decimal and/or datetime conversion errors received from the custom resource interface which uses Changepoint API.

Error/warning messages:

Input string was not in a correct format. Couldn't store 37.5 in HOURS PER WEEK Column. Expected type is Double.

HireDate. Error Converting '25 Jun 2012' to type: 'DateTime'. There are more chars than in the format string: 'dd MMM yyyy'

Reason:
Resource interface runs as a service under Local System account which uses French locale.


Resolution:
Check the regional and language settings of the Windows account under which the resource interface runs as a service, and make sure that the account runs under English US i.e. uses US format by default.

Alternatively, create a new user account, set its locale to English US and set this new user as the logon account for the service.