PH43207: TX ORACLE AQ ADAPTER OCI-22303 ERRORS WHEN QUEUE TABLE IS DEFINED AS JMS PAYLOAD TYPE SYS.AQ$_JMS_TEXT_MESSAGE

APAR status

• Closed as program error.

Error description

• The Transformation Extender Oracle AQ Adapter intermittently
  fails with the following error when dequeuing or enqueuing
  messages to an Oracle AQ queue with the Queue table defined as
  the JMS payload type "SYS.AQ$_JMS_TEXT_MESSAGE".
  
  Error (-1) returned by OCITypeByName, errcode=22303 OCI-22303:
  type ""."SYS" not found
  *ERR: in CAdp::_OraGetNextCollItem (-2)
  *ERR: in CAdp::_DevelopOraObjects (-2)
  *ERR: in CAdp::_DevelopOraObjects (-2)
  *ERR: in CAdp::_DevelopOraObjects (-2)
  *ERR: in AdpProcessObject (-2)
  *ERR: in CMaqAdapter::_ProcessObject (-2)
  

Local fix

• ITXCQ - ITX00060947
  GM / CF
  Circumvention: None
  

Problem summary

• Users Affected:
  IBM Transformation Extender users using oracle AQ adapter.
  
  Problem Description:
  Getting error using ITX Oracle AQ adapter: Error (-1) returned
  by OCITypeByName, errcode=22303
  OCI-22303: type ""."SYS" not found
  
  Platforms Affected:
  All
  

Problem conclusion

• Added check of not NULL for schema value before calling oracle
  function.
  
  Applies to:
  9.0.0.4, 10.0.0.0, 10.0.3.0, 10.1.0.1, 10.1.1.0
  
  Fixed in the next service packs and releases.
  
  To obtain the fix for this APAR:
  
  To see if the next service pack or product release is available,
  check the IBM Transformation Extender Release Notes page:
  https://www.ibm.com/support/docview.wss?uid=swg27008337
  
  If the service pack or product release is available, download it
  from Fix Central:
  http://www.ibm.com/support/fixcentral/
  
  If the service pack or product release is not available and you
  require the APAR fix immediately, request a Limited Availability
  Interim Fix (LAIF) by opening a case:
  https://www.ibm.com/mysupport/
  
  Prior to version 9.0.0, IBM Transformation Extender was called
  IBM WebSphere Transformation Extender.
  

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

  TX HIPPA EDI

• Fixed component ID

  5724M6100

Applicable component levels