APAR status
Closed as program error.
Error description
Getting error "Exception occured in ResestData processXML(): input string was not in correct format when opening the 'esimate resource' window.
Local fix
Set regional setting to US/English on the client machine
Problem summary
**************************************************************** USERS AFFECTED: IS DataStage 8.1 AIX 6.1 DB2 9.5FP2 **************************************************************** PROBLEM DESCRIPTION: Error message "Exception occured in ResestData processXML(): input string was not in correct format" when opening the 'Estimate Resource' window. **************************************************************** RECOMMENDATION: Install the patch for JR31709. This fix is included in 81 FP1 ****************************************************************
Problem conclusion
The problem with XML parsing has to do with the local setting and the data values. The local is set to fr_FR however the numeric data values stored in the XML file for decimals and doubles are in the English locale (the decimal point is used as the fractional delimiter i.e. 123.45). This can be worked around by setting the UI thread locale to French and the non-UI locale to English, however, this will result in decimal values being shown using the decimal point as the fractional separator and not the comma as might be expected. This is currently a limitation of the tool. I will build a new library containing the fix discussed above which will allow the tools to operate and not experience the XMLparsing exception.
Temporary fix
Comments
APAR Information
APAR number
JR31921
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-02-05
Closed date
2010-01-21
Last modified date
2010-01-21
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
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R810 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
21 January 2010