IBM Support

Not a valid floating point value, running Resource Supply and Demand pivot in RPM

Troubleshooting


Problem

This technote provides a workaround for the Unhandled exception: EDatabase Error: Not a valid floating point value, error that occurs when running a Resource Supply and Demand pivot in IBM® Rational® Portfolio Manager (RPM).

Cause

The full error message:

Unhandled exception: EDatabase Error, '168,00' is not a valid floating point value for field 'fldRESOURCE_CALENDAR'

This issue occurs because the Regional Language Standard and Formats is set to Spanish or other languages whose decimal symbol and digit grouping symbol are not the same as US standard.

This issue has been identified as a product defect and has been logged under APAR PK27911.

Resolving The Problem

To workaround this issue, perform the following:

  1. Click on Start > Control Panel and open Regional and Language Options
  2. Select the Regional Options tab
  3. Under the Standard and Formats update the drop down to display English (United States)

[{"Product":{"code":"SSRR2G","label":"Rational Portfolio Manager"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Pivots & Reports","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.0.0.0;7.0.1.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
16 June 2018

UID

swg21246048

Page Feedback