A fix is available
APAR status
Closed as program error.
Error description
Rational Software v7.0.0.7, when trying to load/Import data into a data table via a data file which contains a Spanish character such as '?' the wizard fails with the following error output in data output view: Load 'ITETABLAS'.'CONTENIDORELCPTOTABATRICPTOTAB' sun.io.MalformedInputException The load was not done successfully. Error log provides stack trace: org.eclipse.wst.rdb.data.core !MESSAGE !STACK 0 sun.io.MalformedInputException at sun.io.ByteToCharUTF8.convert(Unknown Source) at sun.nio.cs.StreamDecoder$ConverterSD.convertInto(Unknown Sou rce) at sun.nio.cs.StreamDecoder$ConverterSD.implRead(Unknown Source ) at sun.nio.cs.StreamDecoder.read(Unknown Source) at java.io.InputStreamReader.read(Unknown Source) at java.io.BufferedReader.fill(Unknown Source) at java.io.BufferedReader.readLine(Unknown Source) at java.io.BufferedReader.readLine(Unknown Source) at org.eclipse.wst.rdb.data.internal.core.load.DataFileTokenizer.op en(Unkno wn Source) at org.eclipse.wst.rdb.data.internal.core.load.LoadData.doLoad1 (Unknown Source) at org.eclipse.wst.rdb.data.internal.core.load.LoadData.doLoad( Unknown Source) at org.eclipse.wst.rdb.data.internal.ui.load.LoadDataWizard$1.run(U nknown Source) at org.eclipse.core.internal.jobs.Worker.run(Unknown Source) The issue is reproducible with various DataBases like Oracle v8. 1.7, DB2 v8.2, and Derby.
Local fix
Problem summary
If a notepad file which has first character as " double qutotes as character string delimiter for it is saved in UTF-8 format, BOM's(Byte Order Mark) are introduced and the first character shows the sign of '?' when each character of the first string is tried to print on console. Because the first character become '?' loading of file gives exception
Problem conclusion
Before loading the file, a check is made if BOM are introduced in the UTF-8 encoded file. If the first three bytes are 0xEF, 0xBB, 0xBF the first character is skipped as it is BOM. Fix delivered in Rational Application Developer V7.0.0.9
Temporary fix
Comments
APAR Information
APAR number
PK84618
Reported component name
SW ARCHITECT WI
Reported component ID
5724I7001
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-04-14
Closed date
2009-07-17
Last modified date
2009-07-17
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
RATL APP DEV WI
Fixed component ID
5724J1901
Applicable component levels
R700 PSN
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSRTLW","label":"Rational Application Developer for WebSphere Software"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
17 July 2009