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
Expand all | Collapse all

wm.tn.doc:recognize

webMethods Community Member

webMethods Community MemberTue June 30, 2009 08:17 PM

  • 1.  wm.tn.doc:recognize

    Posted Tue April 07, 2009 04:34 PM

    Has anybody experienced performance issues with wm.tn.doc:recognize which is the first step in wm.tn:receive? I have noticed this for certain EDI transactions and was wondering if anybody else has noticed the same.

    I have opened an SR with webMethods but no leads as yet.


    #B2B-Integration
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: wm.tn.doc:recognize

    Posted Wed April 08, 2009 01:37 PM

    We are using this service in our framework with a huge number of documents flowing in and out on daily basis. As of now we didn’t encounter any performance issues. Can you share some of your observations please?

    Cheers
    Guna


    #webMethods
    #B2B-Integration
    #Integration-Server-and-ESB


  • 3.  RE: wm.tn.doc:recognize

    Posted Mon April 20, 2009 05:30 PM

    Hi Mathew,

    Have you got the SR update from webMethods? If so can you pls share it with us?


    #webMethods
    #B2B-Integration
    #Integration-Server-and-ESB


  • 4.  RE: wm.tn.doc:recognize

    Posted Mon April 20, 2009 05:44 PM

    I have not received any feedback yet. Are you facing the same problem?


    #webMethods
    #B2B-Integration
    #Integration-Server-and-ESB


  • 5.  RE: wm.tn.doc:recognize

    Posted Mon April 20, 2009 08:23 PM

    I think de-enveloping occurs during recognize. If you have a lot of transaction sets (or large sets) in an envelope that might explain the apparent delay?


    #B2B-Integration
    #webMethods
    #Integration-Server-and-ESB


  • 6.  RE: wm.tn.doc:recognize

    Posted Tue June 02, 2009 04:45 PM

    I took a stack trace while running the service and found that the thread was hung at at wm/b2b/editn/db/FADBops.queryDocIds(Bytecode PC:50(Compiled Code))
    Reporting to wM was told this is due to bad join in SQL which is fixed in EDIforTN_6-5-2_Fix7. I am getting ready to get this fix in and see where it goes. Hope this helps the others facing similar issues.


    #webMethods
    #B2B-Integration
    #Integration-Server-and-ESB


  • 7.  RE: wm.tn.doc:recognize

    Posted Tue June 09, 2009 03:50 PM

    We are having same issue even after applying EDIforTN_6-5-2_Fix14 and pre-requistes. Did this issue ever got resolved after applying EDIforTN_6-5-2_Fix7?

    Cheers,
    Akshith


    #webMethods
    #Integration-Server-and-ESB
    #B2B-Integration


  • 8.  RE: wm.tn.doc:recognize

    Posted Tue June 09, 2009 03:55 PM

    I am yet to put the fix in prod where the performance issue seems to manifest (Due to data volume). Here is what i recommend:

    1. While the service is running take a stack trace.
    2. Analyze the stack trace for the running thread. If the delay is still at the Oracle query, run a trace on the database side and capture the SQL being executed. Get an execution plan on the query and get with webMethods on it.

    I intend on doing this after I get the fix in Thursday!! HTH.


    #Integration-Server-and-ESB
    #webMethods
    #B2B-Integration


  • 9.  RE: wm.tn.doc:recognize

    Posted Tue June 09, 2009 04:36 PM

    Thanks for the reply, We already opened a log with SAG support but just was curious if this fix resolved the issue for you. Did this issue resolve at least in your QA env? if it does then we will also plan to roll back to the old fix EDIforTN_6-5-2_Fix7 and its prereqs.

    Cheers,
    Akshith


    #B2B-Integration
    #Integration-Server-and-ESB
    #webMethods


  • 10.  RE: wm.tn.doc:recognize

    Posted Tue June 30, 2009 07:34 PM

    Here is what I found. I installed Fix9. The jar file that fixes the issue was packaged incorrectly and placed in /packages/WmTN/code/jar directory. The correct place is /packages/WmTN/code/jars. I installed Fix15 which has it right and is cumulative. This resolved the issue.

    The original bad query was:

    SELECT editracking.docid, editracking.fastatus
    FROM editracking, bizdoc
    WHERE editracking.senderid = ‘m1gcfk0v068uhu6b000000ip’
    AND editracking.receiverid = ‘m1hkke00vda1u0m500000043’
    AND editracking.groupid = ‘1’
    AND editracking.grouptype = ‘SH’
    AND editracking.groupversion = ‘4010’
    AND (bizdoc.docid = editracking.docid OR editracking.docid LIKE ‘EDI_%’)


    It has been changed as below:
    [FONT=Arial][COLOR=#0000ff]

    SELECT editracking.docid, editracking.fastatus
    FROM editracking, bizdoc
    WHERE editracking.senderid = ‘m1gcfk0v068uhu6b000000ip’
    AND editracking.receiverid = ‘m1hkke00vda1u0m500000043’
    AND editracking.groupid = ‘1’
    AND editracking.grouptype = ‘SH’
    AND editracking.groupversion = ‘4010’
    AND (editracking.docid LIKE ‘EDI_%’ or Exists (select 1 from bizdoc where bizdoc.docid = editracking.docid))

    [/COLOR][/FONT]


    #B2B-Integration
    #webMethods
    #Integration-Server-and-ESB


  • 11.  RE: wm.tn.doc:recognize

    Posted Tue June 30, 2009 08:12 PM

    nMathew,

    What’s the IS/TN version you have running on?

    HTH,
    RMg


    #B2B-Integration
    #Integration-Server-and-ESB
    #webMethods


  • 12.  RE: wm.tn.doc:recognize

    Posted Tue June 30, 2009 08:17 PM