HowTo reset a Repository owner system user

1. Stop the Documentum Content Server (Repository) and DocBrocker
2. Go to $DM_HOME/dba/config/<repository name>/ 
3. Backup dbpasswd.txt 
4. Run SQL command in DBMS (change the password of Repository Owner)
 ALTER USER <Repository Owner Username> IDENTIFIED BY <New Password>; 
5. Replace the new password as plain text (<New Password>) in dbpasswd.txt  and save it
6. Go to $DM_HOME/product/6.7/bin/ and run the following: 
dm_encrypt_password -docbase <docbase name> -rdbms -encrypt <database password> 
7. Run Repository and DocBrocker start scripts. 

Troubleshooting. Checklist.

Troubleshooting

1)     Analize all DCTM log files (DocBrocker / Docbase / WebApp)

2)     Check RAM memory (command: topas) and storage free space, free inode on server (commands df, du)

3)     Restart App (Save all log and stop app / clear cache / start app )

4)     Check system jobs log and ensure that jobs are active and there are no critical warnings in logs (especially DMDbWarning – assess a free space and extents of DB / consider index creating)

1. DMClean job -  removes deleted and orphaned objects from the Docbase.

2. DMFileScan job removes deleted and orphaned content files from the file system.

3. Log Purge job removes server and session logs from the Docbase and file system.

4. Consistency Checker job runs 77 referential integrity checks on the Docbase.

5 Update Stats job updates database table statistics and repairs fragmented tables

6. QueueMgt job deletes dequeued Inbox items from the Docbase.

7. State of the Docbase job produces a report of the repository environment and statistics about object types.

5)     Check quantity of dm_audittrails (DCTM user activity log records), dmi_queue_item (BP tasks records) – delete unneeded records if too many quantity

*********************************************************************************

ACTIONS AFTER UPDATES and RECONFIGURATION

If you updated something objects in repository, please perform cleaning cache and reinitilisation of Repository

publish_dd,c (flush entire cache)

publish_dd,c,,dm_document (flush cache for dm_document type, there is extra comma after c for the locale)

reinit,c

If services DCTM hasn’t been started – check conf env

/etc/services  - docbrocker and repository ports shout be defined

/ect/hosts – host and IP address resolution shout be defined