OMG!! I lost my Administrator password.. Here is the solution to set it to default

Generally all the users info(userName and Password) are saved in the .xml. The name of the file is users.cnf(located at /Config/users.cnf)

1. Change this file name to users_org.cnf(or some other name which must be different from the "users.cnf")
2. Restart the IS
3. IS will recreate the users.cnf file with the default users and the default password(Administrator/manage)
4. Now open the users.cnf file and copy the password(which is encoded)
5. Now replacing this value in the Administrator pwd. of file user_org.cnf, will make the Administrator password to default i.e "manage".
6. You have to delete the users.cnf and rename the users_org.cnf to users.cnf back again(so as to keep the entries of the other users intact)


Snippet:
#############################################

***Other code here***
{sha1}vI5TC3V31VdoYdyukqpb7AYXHXQ=
***Other code here***

#############################################

Here in this snippet, the value you must copy is "{sha1}vI5TC3V31VdoYdyukqpb7AYXHXQ="

NOTE: Ofcourse!, you must have access to the file system of the IS.

Want to delete a particular Process Instance ??

We can't delete a particular instance from MWS(My WebMethods Server), so if we want to delete that process Instance we can still do it. Below are lines of scripts which are to be run for deleting an instance --

delete FROM wmprocess a where a.processkey like '%instanceid_to_delete%'
delete from wmprocessassoc a where a.instanceid = '%instanceid_to_delete%'
delete from wmprocessrecent a where a.instanceid = '%instanceid_to_delete%'
delete from wmprocessstep a where a.instanceid = '%instanceid_to_delete%'


wmprocess - contains all the process instance information. for each step, there will be start and complete entries available.

wmprocessrecent - holds recent process instance that are run. instanceid & processkey are available to delete

wmstepdefinition - contains details about each step in a process model

wmprocessassoc - Not very sure of this table what it has ? To my guess - it contains details of the associated processes. It comes into picture when there is an implementation of sub-process.
comments are most welcome to fill out this table information..

Want the Process Model which is running in Prod ???

You want to edit the process Model which is live in Prod. (want to add a step) but sadly you are not having the backup of the process model which is in prod. So, how can we survive for the scenario?

In the database(which is the wmPRT is pointing) we have a table - WMPROCESSDEFINITION. This table has a column named 'ProcessFile' and its stores the Process model in blob format. This blob object can be saved (using some SQL Developer or TOAD tools) and renamed to .process. This can be imported in Designer.

In my case I used SQL Developer, right clicked on the cell( row is: ProcessModelId and the column is : ProcessFile ) and saved as file into file system. In the file system i renamed it with the extension .process. And imported this file into the designer. The process which is in Production till now is available in my local also. :)

Creation of Topic/Queue in MWS using LDAP

For the creation of Topic:

1. Create a destination with the lookup name and destination name being same as the topic name to be created.
   
2. Select Topic from the drop down list
3. Create the destination
4. Go to the document types(For Topic) and click on the button "create Topic"
   
5. Click on the tab "from the Naming Directory"
6. Now, select the provider, here it is LDAP
7. Select the destination which is created in #1
8. Click on the create button
9. The Topic is created
10. Now, we have to add this Topic to the publishable, subscribable in the IS-JMS client group.
    

For the creation of Queue:

1. Create a destination with the lookup name and destination name being same as the Queue name to be created.
   
2. Select Queue the drop down list
3. Create the destination
4. Go to the Clients(For Queue) and click on the button "create Queue"
   
5. Click on the tab "from the Naming Directory"
6. Now, select the provider, here it is LDAP
7. Select the destination which is created in #1
8. Click on the create button
9. The Queue is created