IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

passing null values to adapter connection

  • 1.  passing null values to adapter connection

    Posted Thu December 21, 2006 06:40 PM

    HI everyone,

    I cannot pass null value(i have hardcoded this fields to $null in pipeline) to adapter service, iam getting the following error while tracing:

    com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service TPCM_LDWInterface.adapters.ExPRSStaging:saveExPRSSettlementStaging_DBAdapter.
    [ADA.1.314] Cannot set data for the input field “XXXXXXX”
    For input string: "$null.

    i really appreciate your help.

    thanks,
    vj


    #Flow-and-Java-services
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: passing null values to adapter connection

    Posted Thu December 21, 2006 07:53 PM

    Vijay

    The field in the table might have been configured not to allow nulls. Please check that and ask your DBA to remove that constraint or do not pass nulls.

    use regular expressions to filter out the nulls or empty strings by using /[^ ]/ on the branch sequence and set evaluate labels to ‘false’

    Krishna


    #webMethods
    #Flow-and-Java-services
    #Integration-Server-and-ESB


Related Content