JR31488: PORT ECASE 128645 TO IS 801 FP1A AIX

APAR status

• Closed as program error.

Error description

• Error below occurs ONLY when using Oracle EE stage operating
  insert and update in the same time with large amount of data and
  large table: "Tgt_ODS_AR_RECEIVABLE_APPLICATIONS,0: Fatal Error:
  Throwing exception: APT_BadAlloc: Heap allocation failed."
  Details:  Error below occurs ONLY when using Oracle EE
  stage operating insert and update in the same
  time with large amount of data and large table:
  
  "Tgt_ODS_AR_RECEIVABLE_APPLICATIONS,0: Fatal
  Error: Throwing exception: APT_BadAlloc: Heap
  allocation failed."
  
  In event of problem occurred, maximum process
  memory has been applied as below:
  

Local fix

• This fix is included in 8.0.1 fix pack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users of release 801 on all O/S platforms.
  ****************************************************************
  PROBLEM DESCRIPTION:
  Request to port  ECASE 128645 TO IS 801.
  
  This ecase resolved Heap allocation failure issue in oracle ee
  stage upsert method on with large amount of data on a big table.
  ****************************************************************
  RECOMMENDATION:
  apply patch.
  ****************************************************************
  

Problem conclusion

• ported as requested.
  

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