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

how to avoid duplicate entries in WMPROCESSDEFINITION table

  • 1.  how to avoid duplicate entries in WMPROCESSDEFINITION table

    Posted Tue April 13, 2010 04:55 PM

    HI,

    The WMPROCESSDEFINITION table has a column DEPLOYMENTVERSION which I think gets incremented each time a process is built resulting in adding a new row to this table.

    When we use the pub.monitor.process.instance:getInstanceList built-in service as give the unique process instance ID as an input instead of returning 1 instance as an output, it returns the instances as a document list equivalent to the number of deployment versions present in the WMPROCESSDEFINITION table.

    If the WMPROCESSDEFINITION table has 20 rows for a particular process with the deploymentversion ranging from 1 - 20 then the output of this service is 20 instances all with the same values.

    Request you to please let me know how to change this behaviour of the WMPROCESSDEFINITION table or how to make the service return one output for one instanceID.

    Thanks,
    Kiran.


    #webMethods
    #BPM
    #webMethods-BPMS


  • 2.  RE: how to avoid duplicate entries in WMPROCESSDEFINITION table

    Posted Tue April 13, 2010 07:59 PM

    ProcessDefinition table works the way you understand, it keeps track if how many redeployment you done… so alteast u have the audit for the same.
    I am kinda confused with the other question you raised… according to you
    wm.monitor.instance:getInstanceList services is returning you duplicate records, what do you mean by that… this service will always return all the running/existing (instances detail not archived) for the given ModelID/ModelIDs…

    -nD


    #webMethods-BPMS
    #BPM
    #webMethods


  • 3.  RE: how to avoid duplicate entries in WMPROCESSDEFINITION table

    Posted Thu April 15, 2010 03:51 PM

    Hi,

    Thanks for your reply.

    I have found a solution to my problem.Thought of sharing so that it might be helpful to everyone.

    The WMPROCESSDEFINITION table stores a separate deployment version each time the process is built.This cannot be changed.My concern was the getInstanceList service returing multiple instances.
    There is a Monitor fix to this issue.Please look at the below URL in advantage for more details.
    [URL]http://advantage.webmethods.com/article/?id=1614330152[/URL]
    HTH,
    Kiran.


    #BPM
    #webMethods-BPMS
    #webMethods


  • 4.  RE: how to avoid duplicate entries in WMPROCESSDEFINITION table

    Posted Tue May 18, 2010 10:43 AM

    Thanks for sharing this to all users


    #BPM
    #webMethods-BPMS
    #webMethods