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:54 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.


    #BPM
    #webMethods-BPMS
    #webMethods


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

    Posted Thu April 15, 2010 03:44 PM

    Hi All,

    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.

    http://advantage.webmethods.com/article/?id=1614330152

    HTH,
    Kiran.


    #webMethods
    #webMethods-BPMS
    #BPM