IT30865: THE JDE ASI SCHEMA IS MISSING FROM THE JDE ADAPTER

APAR status

• Closed as program error.

Error description

• JDE Adapter version 7.5.0.5_IF14 does not contain the JDE asi
  schema. This lead to a problem locating
  the metadata required
  to make calls to the JDE server and can cause the following
  NullPointerException
  when executing the JDE Request
  Node:
  
  javax.resource.ResourceException:
  java.lang.NullPointerException
   at com.ibm.j2ca.extension.comman
  dpattern.CommandForCursor.execute(CommandForCursor.java:84)
   at
  com.ibm.j2ca.jde.outbound.JDEInterpreter.execute(JDEInterpreter.
  java:39)
   at com.ibm.j2ca.jde.outbound.JDEInteraction.doExecute(
  JDEInteraction.java:230)
   at com.ibm.j2ca.jde.outbound.JDEIntera
  ction.doExecute(JDEInteraction.java:103)
   at com.ibm.j2ca.base.W
  BIInteraction.execute(WBIInteraction.java:522)
   at com.ibm.broke
  r.adapter.deploy.MbAdapterAccess.execute(MbAdapterAccess.java:18
  8)
   at com.ibm.broker.adapter.nodes.MbAdapterRequestNode.request
  Data(MbAdapterRequestNode.java:589)
   at com.ibm.broker.plugin.Mb
  RequestTemplateNode.requestData(MbRequestTemplateNode.java:60)
  
  at com.ibm.broker.plugin.MbOutputTerminal._propagate(Native
  Method)
   at com.ibm.broker.plugin.MbOutputTerminal.propagate(MbO
  utputTerminal.java:133)
   at com.ibm.broker.plugin.MbOutputTermin
  al.propagate(MbOutputTerminal.java:88)
   at com.ibm.broker.ct.map
  ping.MappingNode.buildAndPropagate(MappingNode.java:1152)
   at co
  m.ibm.broker.ct.mapping.MappingNode.evaluate(MappingNode.java:47
  3)
   at
  com.ibm.broker.plugin.MbNode.evaluate(MbNode.java:2039)
  Caused
  by: java.lang.NullPointerException
   at com.ibm.j2ca.jde.outbound
  .bsfn.JDEBSFNInvoker.createListOfBSFN(JDEBSFNInvoker.java:378)
  
  at com.ibm.j2ca.jde.outbound.bsfn.JDEBSFNInvoker.execute(JDEBSFN
  Invoker.java:245)
   at com.ibm.j2ca.jde.outbound.commandpattern.J
  DEExecuteCommand.execute(JDEExecuteCommand.java:80)
   at com.ibm.
  j2ca.extension.commandpattern.CommandForCursor.execute(CommandFo
  rCursor.java:76)
   ... 13 more
  

Local fix

• The file jdeasi.xsd can be found in the adapter connector
  project int he toolkit. Placing this jar
  inside the
  $MQSI_FILEPATH/server/adapter/prereqs/jars/CWYED_JDE.jar file
  at the root level will resolve the
  problem.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of IBM Integration Bus v10.0.0.16 to 10.0.0.18 or App
  Connect Enterprise v11.0.0.4 to 11.0.0.6 using the JDERequest
  Node.
  
  
  Platforms affected:
  MultiPlatform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  <span style="background-color:rgb(255, 255, 255)">JDE Adapter
  version 7.5.0.5_IF14 does not contain the JDE ASI </span><span
  style="background-color:rgb(255, 255, 255)">schema. This can
  lead to a problem locating </span><span
  style="background-color:rgb(255, 255, 255)">the metadata
  required </span><span style="background-color:rgb(255, 255,
  255)">to make calls to the JDE server and can cause the
  following </span><span style="background-color:rgb(255, 255,
  255)">NullPointerException </span><span
  style="background-color:rgb(255, 255, 255)">when executing the
  JDERequest </span><span style="background-color:rgb(255, 255,
  255)">Node:
       </span>
  <span style="background-color:rgb(255, 255, 255)">
  
  </span>
  <span style="background-color:rgb(255, 255,
  255)">javax.resource.ResourceException:
       </span>
  <span style="background-color:rgb(255, 255,
  255)">java.lang.NullPointerException
       </span>
  <span style="background-color:rgb(255, 255, 255)">at
  com.ibm.j2ca.extension.comman</span><span
  style="background-color:rgb(255, 255,
  255)">dpattern.CommandForCursor.execute(CommandForCursor.java:84
  )    </span>
  <span style="background-color:rgb(255, 255, 255)">at
  </span><span style="background-color:rgb(255, 255,
  255)">com.ibm.j2ca.jde.outbound.JDEInterpreter.execute(JDEInterp
  reter.</span><span style="background-color:rgb(255, 255,
  255)">java:39)
       </span>
  <span style="background-color:rgb(255, 255, 255)">at
  com.ibm.j2ca.jde.outbound.JDEInteraction.doExecute(</span><span
  style="background-color:rgb(255, 255,
  255)">JDEInteraction.java:230)
       </span>
  <span style="background-color:rgb(255, 255, 255)">at
  com.ibm.j2ca.jde.outbound.JDEIntera</span><span
  style="background-color:rgb(255, 255,
  255)">ction.doExecute(JDEInteraction.java:103)
       </span>
  <span style="background-color:rgb(255, 255, 255)">at
  com.ibm.j2ca.base.W</span><span style="background-color:rgb(255,
  255, 255)">BIInteraction.execute(WBIInteraction.java:522)
                  </span>
  <span style="background-color:rgb(255, 255, 255)">at
  com.ibm.broke</span><span style="background-color:rgb(255, 255,
  255)">r.adapter.deploy.MbAdapterAccess.execute(MbAdapterAccess.j
  ava:18</span><span style="background-color:rgb(255, 255,
  255)">8)
       </span>
  <span style="background-color:rgb(255, 255, 255)">at
  com.ibm.broker.adapter.nodes.MbAdapterRequestNode.request</span>
  <span style="background-color:rgb(255, 255,
  255)">Data(MbAdapterRequestNode.java:589)
       </span>
  <span style="background-color:rgb(255, 255, 255)">...    </span>
  <span style="background-color:rgb(255, 255, 255)">Caused
  </span><span style="background-color:rgb(255, 255, 255)">by:
  java.lang.NullPointerException
  </span>
  <span style="background-color:rgb(255, 255, 255)">at
  com.ibm.j2ca.jde.outbound</span><span
  style="background-color:rgb(255, 255,
  255)">.bsfn.JDEBSFNInvoker.createListOfBSFN(JDEBSFNInvoker.java:
  378) </span><span style="background-color:rgb(255, 255, 255)">
  
  </span>
  <span style="background-color:rgb(255, 255, 255)">at
  com.ibm.j2ca.jde.outbound.bsfn.JDEBSFNInvoker.execute(JDEBSFN</s
  pan><span style="background-color:rgb(255, 255,
  255)">Invoker.java:245)
       </span>
  <span style="background-color:rgb(255, 255, 255)">at
  com.ibm.j2ca.jde.outbound.commandpattern.J</span><span
  style="background-color:rgb(255, 255,
  255)">DEExecuteCommand.execute(JDEExecuteCommand.java:80)
       </span>
  <span style="background-color:rgb(255, 255, 255)">at
  com.ibm.</span><span style="background-color:rgb(255, 255,
  255)">j2ca.extension.commandpattern.CommandForCursor.execute(Com
  mandFo</span><span style="background-color:rgb(255, 255,
  255)">rCursor.java:76)
       </span>
  <span style="background-color:rgb(255, 255, 255)">... 13 more
                              </span>
  
  The affected version of the JDE Adapter was shipped in IBM
  Integration Bus Fixpack 10.0.0.16 to 10.0.0.18 inclusive and App
  Connect Enterprise fixpacks 11.0.0.4 to 11.0.0.6 inclusive
  

Problem conclusion

• The JDE Adapter has been modified so that it includes the JDE
  ASI schema and the problem no longer occurs.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v10.0      10.0.0.19
  v11.0      11.0.0.7
  
  The latest available maintenance can be obtained from:
  http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
  
  If the maintenance level is not yet available,information on
  its planned availability can be found on:
  http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
  ---------------------------------------------------------------
  

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

  INTEGRATION BUS

• Fixed component ID

  5724J0540

Applicable component levels