IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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 number

    IT30865

  • Reported component name

    INTEGRATION BUS

  • Reported component ID

    5724J0540

  • Reported release

    A00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-11-06

  • Closed date

    2019-12-23

  • Last modified date

    2019-12-23

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSNQK6","label":"IBM Integration Bus"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.0","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
23 December 2019