Documentum
-
DQL:How to get count of all documents by folder
Here is how to get a count of all the documents in a cabinet by folder: select count(*), f.r_folder_path from dm_document d, dm_folder f where d.i_folder_id = f.r_object_id and folder(‘/CABINET_NAME’, descend) and f.r_folder_path is not nullstring group by f.r_folder_path enable(row_based) Continue reading
-
Documentum: How to find physical file location
In order to find the physical file location of any file: select i_contents_id from dm_document where folder(‘/<CABINET_NAME>’, descend) and object_name = ‘<File Name>’ execute GET_PATH for ‘<content_id returned from above>’ Continue reading
-
Documentum: How to recover database password
Copy the content of dbpasswd.txt file from the following folder: $DOCUMENTUM/dba/config/<REPOSITORY NAME> Content will be in this format: DM_ENCR_TEXT_V2=AAAAEFpxldCW8pnF4gbWPFV+1jP8TEK9HS8d28MW0HwWw+C3uV/+rshuoJ/3j Open IAPI, and do the following: $>iapi $>Please enter a docbase name (docubase): <REPOSITORY NAME> Please enter a user (dmadmin): Please enter password for dmadmin: $>initcrypto,c $>decrypttext,c,DM_ENCR_TEXT_V2=AAAAEFpxldCW8pnF4gbWPFV+1jP8TEK9HS8d28MW0HwWw+C3uV/+rshuoJ/3j Continue reading
-
Documentum: How to find out if you have a custom registered table
Documentum has the concept of a registered table. It is basically a regular database table accessible via DQL. This allows you to add information to a regular database table and access it via regular DQL. To find out if you have any custom registered tables, run the following query: select * from dm_registered where object_name… Continue reading
-
Documentum D2: About D2 returns dfc.properties
If you click on the About D2 link, it returns the complete dfc.properties file which may include your servername or ip address. This is a security vulnerability. To resolve this issue, open the D2.war and D2-Config.war files, find the following file: WEB-INF/lib/D2FS4DCTM-WEB-4.5.0.jar Open the file above and find the following file: xml/dialog/AboutDialog.xml Comment out the… Continue reading
-
Documentum Composer: dar created with newer version issue
Sometimes when you create a dar file from a higher version of composer, and try to install that dar file with an earlier version, the dar deployer shows an error: This is easily fixed. Open the dar in a program like PKZip, or unzip the dar. There is a version.ini file in the root folder.… Continue reading
-
Documentum D2: DM_STORAGE_E_BAD_TICKET Error
Users were getting the following error just after logging in to D2: The object id of the object appeared in the log file. Since that object was a dm_audit_trail object for a test object, I deleted the object using the following API command: destroy,c,<r_object_id> This resolved the error. Continue reading
-
Documentum D2: Impossible to Decrypt Method Server Response
The impossible to decrypt method server error is almost always related to your lockbox. ERROR: com/emc/clb/clbBridge/clbBridgeJNI ON EACH CONTENT SERVER Perform the following actions on both Content Servers as <install_owner> cd <lockbox_file_location> rm D2.lockbox* java -Dclb.library.path=<lockbox_file_location>/linux_gcc34_ia32 com.emc.common.java.crypto.SetLockboxProperty <lockbox_file_location> D2Method.passphrase <lockbox_passphrase> Expected Output JVM : 1.7.0_72 (64bits) ‘<lockbox_file_location>/D2.lockbox’ file updated ‘D2Method.passphrase’ property updated Copy the newly… Continue reading
-
Documentum D2: XML Cache
D2 has cache files in the following location on the app server: /tmp The file names that can be safely deleted to clear the cache are ls /tmp/*cache* xml-cache.index xml-cache.data taxonomy_level-cache.data dictionary_dql-cache.data folder-cache.data skin-cache.data Sometimes if doing Tools –> Refresh Cache does not work, try deleting the above caches. This is definitely needed when doing… Continue reading
-
Documentum: Getting multiple folders / files in DQL result
If you are getting multiple results in your DQL results for single objects, modify the server.ini file on the Content Server to add the following line return_top_results_row_based=false in the [SERVER_STARTUP] section and restart the Content Server. Here are the complete steps: Stop the following in order JMS, All running Docbases and Docbroker Locate the server.ini… Continue reading
About Me
Senior Software Engineer professional with over 16 years of success with multiple open source technologies and various Content Management platforms and solutions.
Proven technical abilities through numerous projects involving enterprise web application design and development, application installation, configuration and support, and workflow and collaboration system designs.
- Ability to learn new technologies and platforms quickly and apply them to the task at hand.
- Excellent analytical skills, and strong communication and collaboration abilities.
- Technical emphasis in including but not limited to Java, Ruby on Rails, Documentum and Alfresco
in both Linux and Windows based environments
