IBM Support

"The value must be numeric" errors when importing from flat file, if regional setting's decimal symbol is a comma

Technote (troubleshooting)


Problem(Abstract)

User imports data (into Controller) via a flat-file (for example CSV). Afterwards, the "Statistics - Import of External Data" window shows a very large number of 'DiscardedRows'.

User double-clicks on the entry (to open the report). Inside the report, there are a large number of errors. These errors will only occur where the values (to be imported) are not whole numbers (integers) - instead, they contain a decimal point.

Symptom

1016 The value must be numeric


Cause

Limitation of Controller 10.2, triggered if the regional settings decimal symbol is a comma.


More Information:
When using Controller 10.2, the Controller application server's regional settings must be configured to be a compatible setting (for example 'English (UK)').


Environment

As an example, the problem has been seen when the Controller application server's regional settings are set to Czech.

It has also been seen when both of the following are true:

  • Controller application server based on Windows 2012
  • Regional settings set to South African.

NOTE: The South African regional settings are actually compatible for Windows 2008 (and earlier) because there was a change (by Microsoft) for the South African regional settings from Windows 2012 onwards. See Windows article (at the end of this Technote) for more details.

Resolving the problem

Modify the Controller application server's regional settings to be a compatible setting (for example 'English (UK)').


Steps:
1. Obtain a short period of downtime (no users on the system)
2. Logon to the Controller application server as an administrator
3. Launch Control Panel
4. Open 'Region'
5. Change "Format" to "English (United Kingdom)":


6. Click tab 'Location'
7. For the sake of consistency, change this to 'United Kingdom' too
8. Click tab "Administrative"
9. Click "Change system locale..." and change this to "English (United Kingdom)":


10. Click "Copy Settings"
11. Tick the box "Welcome screen and system accounts"
12. Tick "New user accounts":

13. Click OK
14. Reboot the Controller application server
15. Test.

Related information

1370695 - Which languages can be used / applied in Cont
MICROSOFT - Apply regional and language settings to res
Microsoft - South African regional settings changed for

Document information

More support for: Cognos Controller
Controller

Software version: 10.2.0

Operating system(s): Windows

Reference #: 1691867

Modified date: 18 December 2014


Translate this page: