Interwoven - Replacing the Entity DB

Entity Database Background

TeamSite uses an internal structure called the Entity Database to store information about various TeamSite entities such as users, groups, and roles.  Normally, the Entity Database is invisible to the user, and any entities that TeamSite needs are created automatically, either when TeamSite is first installed, or when a new user first logs on.

However, there are some circumstances in which the TeamSite Entity Database may become corrupted.   Usually, this can be corrected by using the 'iwuser' command line tool to remove any corrupt entities from the database.  However, in extreme cases, there may be no alternative but to re-build the Entity Database from scratch.

By default, the Entity Database is found in `iwgethome`/local, and most TeamSite installations use this location. If there are no files in this directory, check the active iw.cfg file to see if another location for the Entity Database has been specified

Removing an Existing Entity Database

Note that any user preferences stored in the Entity Database will be lost when this procedure is followed. In current versions of TeamSite, (TS 5.0.2 and earlier, TS5.5.2 and earlier), this is the only significant side effect of replacing the Entity Database. In the future, it's possible that there will be other side effects or lost data.

Windows

1. Stop TeamSite:

2.       net stop iwserver

3.   

1. Rename the <iw-home>\local\entities directory for example, to entities.bak

Initializing a New (Replacement) Entity Database

There are a few 'standard' entities that are required to be in the Entity Database before some Interwoven applications will function normally. These may be added using a perl script called 'add_edb.pl'. This is the same script that the TeamSite installer program runs to create the Entity Database when TeamSite is first installed. The entities it adds are a group called 'IWGLOBAL', and eight roles. The roles are the four standard TeamSite roles, plus four others that may be needed by other optional Interwoven programs. Before running add_edb.pl, make sure that the TeamSite server is running. The add_edb script uses the 'iwuser' command line tool to do its work, and this tool needs to communicate with iwserver.

Run this script with one argument - the location of the iwhome directory, which can be found by issuing the `iwgethome` command. You will see nine data files in entities/data when this script is finished. The index and the other data files will be re-generated automatically, one at a time, as each user logs on. If you do not see the expected nine data files, look at the log file called add_edb.log found in `iwgethome`/install to see why it failed.

Windows

1. Reboot the server. TeamSite will create a new entities directory.



2. Run the following command to recreate the entity database:

<iw-home>\iw-perl\bin\iwperl <iw-home>\install\add_edb.pl <iw-home>