PH63004: JAVA EXCEPTION 'DECIMAL SCALE -127 ERROR' DURING TYPE TREE IMPORT FROM ORACLE DB IF COLUMN NUMBER DEFINED WITH NO PRECISION

APAR status

• Closed as program error.

Error description

• When using IBM Sterling Transformation Extender (ITX) using the
  Java command line to import a type tree from an Oracle database
  via the JDBC adapter:
  
  java -cp C:\IBM\TransformationExtender_10.1.2\*;C:\IBM\Transfor
  mationExtender_10.1.2\tools\*;C:\IBM\TransformationExtender_10.
  1.2\jars\com.hcl.hip.adapters.m4jdbc\*;C:\IBM\TransformationExt
  ender_10.1.2\extjar\*-Duser.language=en -Duser.country=US
  -Djava.library.path=C:\IBM\TransformationExtender_10.1.2
  com.hcl.hip.tools.adapterdriver.TreeImporter
  com.hcl.hip.adapters.m4jdbc C:\Users\Paul\Desktop\Typetree.mtt
  -url jdbc:oracle:thin:@localhost:1521:orac -driver
  oracle.jdbc.driver.OracleDriver -user user -password password
  -schema dbo -query 'select * from Test4'
  
  An error will display, if the underlying table has a decimal
  number, with no precision specified.
  
  Example:
  create table Test4 (myId number);
  
  If the table create is altered from number to number(6) for
  example, then the type tree create works.
  

Local fix

• ITXCQ ITX00062621
  PB / GK
  Circumvention: None
  

Problem summary

• Users Affected:
  IBM Transformation Extender users using jdbc adapter
  
  Problem Description:
  java.lang.IllegalArgumentException: DECIMAL,scale,-127 error
  during type tree import from Oracle database if there is a
  column defined as number with no scale or precision.
  
  Platforms Affected:
  All
  

Problem conclusion

• Schema creation fails for negative scale value.  If table is
  created with decimal field and without specific size i.e.
  "create table Test4 (myId number)" , schema generation fails
  with error DECIMAL,scale,-127 Code updated and it is working
  now.
  
  Applies to:
  10.1.2.1
  
  Fixed in the next service packs and releases.
  
  To obtain the fix for this APAR:
  
  To see if the next fix pack or product release is available,
  check the IBM Transformation Extender product Release Notes
  page:
  https://www.ibm.com/support/pages/node/318755
  
  If a fix pack release is available, download it from Fix
  Central:
  http://www.ibm.com/support/fixcentral/
  
  If a new product release is available, download it from Passport
  Advantage:
  https://www.ibm.com/software/passportadvantage/pao_customer.html
  
  
  If the fix pack or product release is not available and you
  require the APAR fix immediately, request a Limited Availability
  Interim Fix (LAIF) by opening a support Case:
  https://www.ibm.com/mysupport
  

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

  ITX

• Fixed component ID

  5724Q2300

Applicable component levels