PK84618: Unable to use the Load/Import data wizard when data has Spanish characters

Rational Application Developer for WebSphere Software, Version 7.0.0.9

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 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