Topic
3 replies Latest Post - ‏2008-02-15T11:39:50Z by SystemAdmin
SystemAdmin
SystemAdmin
2340 Posts
ACCEPTED ANSWER

Pinned topic Global Container members order change

‏2008-02-12T21:34:43Z |
Hi

I deployed the ProcessTemplate with Global data container using fmcibie command, and later changed the order of Global data container members and tried to deploy the FDL but the deployment failed with error.
this is understandable as we can only add new members to Global container and can not change the order of its members.
But strange is that even If a delete the ProcessTemplate which has the Glonbal container associated and redeploy the ProcessTemplate again still the fmcibie is giving the errors that Global container table can not be update.

Any help to solve this..
Updated on 2008-02-15T11:39:50Z at 2008-02-15T11:39:50Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    2340 Posts
    ACCEPTED ANSWER

    Re: Global Container members order change

    ‏2008-02-13T11:30:37Z  in response to SystemAdmin
    The deletion of Process Templates is only a logical deletion of a process
    template, to avoid the creation of process instances of the template.
    Running instances of this template still need the template information.
    The easiest way to remove a process template and its global container is
    to use the Process Template Deletion Tool, which is contained in the
    Database Maintanance Tools support pac, This utility checks for all
    depencendies before the physical removal of a process template. The global
    container may be kept even if the template is removed, if global container
    sharing is used. In this case your process template needs to define and
    use a new global container.

    here is a short description and link to the support pac:
    Database Maintenance Tools (WC01 ? New)
    Collection of utilities for Workflow Administrators to interact directly
    with the Runtime database. It enables functions like Runtime database or
    process template housekeeping.
    Global Container Maintenance Tool to merge or split (shared) global
    containers in the Runtime database
    Process Template Deletion Tool to physically remove process templates from
    the Runtime database

    http://www.ibm.com/software/integration/support/supportpacs/product.html

    Volker Hoss
    IBM WebSphere Process Server Development
    • SystemAdmin
      SystemAdmin
      2340 Posts
      ACCEPTED ANSWER

      Re: Global Container members order change

      ‏2008-02-14T13:23:58Z  in response to SystemAdmin
      Hi Volker

      Is there any direct query in db2 , to delete/clear process template and its associated Global Data Container table?

      Thanks in advance
      Mulumudi
      • SystemAdmin
        SystemAdmin
        2340 Posts
        ACCEPTED ANSWER

        Re: Global Container members order change

        ‏2008-02-15T11:39:50Z  in response to SystemAdmin
        Hello Mulumudi,

        it is not a good idea to manually interact with the MQWF DB.
        You might loose DB integrity and you loose support.
        In this case there is no reason to do so either.
        Either it is a test system, then you can drop the DB and start from
        scratch or it is a
        production system the you should take the effort an use the Process
        Template Deletion tool.

        Volker Hoss
        IBM WebSphere Process Server Development