JR34502: ORACLE EE STAGE UPSERT GETS SIGSEGV AND DUMPS CORE AT END OF JOB WHEN USING DOUBLE FIELDS.

APAR status

• Closed as program error.

Error description

• Oracle EE stage Upsert gets SIGSEGV and dumps core at end of job
  when loading datatype DOUBLE to Oracle NUMBER.
  

Local fix

• This fix is included in 8.0.1 fixpack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  users doing upsert with floating point inputs.
  ****************************************************************
  PROBLEM DESCRIPTION:
  If upsert has input fileds of type double (aka double), core
  dump could result even as upsert finishes OK.
  ****************************************************************
  RECOMMENDATION:
  Apply patch provided.
  This change is included in 8.1 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

• View adapter is converting double value to string with
  precision18.  Maximum precision that works is 17. Error
  corrected.
  

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

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R801 PSN

     UP