IZ16095: ORACLE GATEWAY DISCARDS EVENTS FROM ORACLE ERROR ORA-01688

APAR status

• Closed as fixed if next.

Error description

• The Oracle gateway discards events after receiving Oracle Error
  ORA-01688 for the table being out of space. Below is the error
  logged in the gateway log file -
  
  Mon Feb  4 00:00:46 2008: E-UNK-000-000: Oracle Error:
  [ORA-01688: unable to extend table REPORTER.REPORTER_STATUS
  partition P] - sqlcode[-1688]
  Mon Feb  4 00:00:46 2008: E-UNK-000-000: Thread
  'StatusTableInsProcThread': Failed to send batch to Oracle
  database, due to an unknown error. Aborting the operation.
  
  The gateway should store the data and send it when the table
  space is extended.
  

Local fix

• Extend the Oracle database table space.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of Gateway for Oracle experiencing *
  *                 inability to extend a table partition in     *
  *                 Oracle.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Inability to extend a table partition   *
  *                      in Oracle errors can be corrected in    *
  *                      Oracle on the fly (as the gateway is    *
  *                      running). It is a type of 'db full'     *
  *                      error that in other circumstances is    *
  *                      handled by the gateway by storing the   *
  *                      event and retrying later, periodically. *
  *                      In the case of ORA-01688 messages,      *
  *                      however, the event is dropped by the    *
  *                      gateway as being an 'unknown' error     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  *                                                              *
  ****************************************************************
  nability to extend a table partition in Oracle errors can be
  corrected in Oracle on the fly (as the gateway is running). It
  is a type of 'db full' error that in other circumstances is
  handled by the gateway by storing the event and retrying later,
  periodically. In the case of ORA-01688 messages, however, the
  event is dropped by the gateway as being an 'unknown' error
  

Problem conclusion

Temporary fix

Comments

• Date of Release: 30/9/2008
  
  Date of Release: 09/30/08
  
  
  
  
  
  Date of Release: 09/30/08 Fix Pack Name: gateway-nco-g-oracle
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• NETCOOL
  

Fix information

Applicable component levels

• R100 PSY

     UP