Trending

Latest posts

xCP Application Uninstaller

It is the latest bundle for subsequent release of xCP Application Uninstaller v1.0 available here. The idea remains same, it is to ease deployment hurdles or free up the resources in DEVELOPMENT environment. This time it is relatively easy to use as it is integrated with xMs-Agent. And offers the complete uninstallation including undeploying the…

Read More

Counting DQL

queries to count Number of documents created:select datetostring(r_creation_date,’mm-dd-yyyy’) as creation_date, count(*) as document_count, r_object_type from dm_document where r_creation_date >=DATE(TODAY)-7 group by datetostring(r_creation_date,’mm-dd-yyyy’), r_object_type Number of folders created:select datetostring(r_creation_date,’mm-dd-yyyy’) as creation_date, count(*) as folder_count from dm_folder where r_creation_date >=DATE(TODAY)-7 group by datetostring(r_creation_date,’mm-dd-yyyy’) Number of workflows created:select datetostring(r_start_date,’mm-dd-yyyy’) as wf_start_date, count(*) as workflow_count from dm_workflow where r_start_date >=DATE(TODAY)-7 group…

Read More

Apache Commons Text vulnerability (commons-text-1.9.jar)

Applies to • Documentum xCP 22.2 • Documentum xCP Designer 22.2 Summary Are Documentum xCP components affected by CVE-2022-42889 the commons-text library vulnerability? Resolution Documentum XCP 22.2 is the first version of the platform that is shipped with the Apache commons-text java library.   This library is focused on algorithms for working with strings that developers may want…

Read More

Avoiding Single Quotes in Usernames: Lessons for DQL Queries

Here is the error: Caused by: com.documentum.fc.common.DfException: [DM_QUERY_E_SYNTAX]error: “A Parser Error (syntax error) has occurred in the vicinity of: select distinct(object_name) from dms_type_permissions where delete_permission = true and role_name in ( select distinct(group_name) from dm_group where any i_all_users_names =’John D’Aguiar” When creating usernames, especially in systems that rely on query languages like Documentum Query Language…

Read More

Deploying xCP Application on tcServer

Users who may attempt to configure this may run into issues when using more than one application server. This additional information is for the TC Server. Resolution In order to setup the clustering on TC Server, the notes in the Whitepaper should be carried out with the additional information as follows:             <Cluster className=”org.apache.catalina.ha.tcp.SimpleTcpCluster”              channelSendOptions=”8″>         …

Read More

Renew OTDS certificate

Manually renew certificate: open the url: https://otds_app_host-app02/otdsws/rest/systemconfig/certificate_content and make a single line, and paste to the file: otdsauth.properties located at D:\Documentum\tomcat9.0.85\webapps\OTDSAuthentication\WEB-INF\classes in Content Server. Below is the screenshot: Restart JMS. Verify – your application must work. In general, how long is a new OTDS certificate valid for? If you save the certificate to a file…

Read More

Unsupported major.minor version 52.0 in dfc code

We are getting below error message while uploading documents in repo using the dfc 7.2 code. Exception in thread “main” java.lang.UnsupportedClassVersionError: com/documentum/mailapp/operations/inbound/DfSeparateAttachments : Unsupported major.minor version 52.0 Solution: Summary The easiest solution is to upgrade your runtime to Java 8 or higher, which should resolve the UnsupportedClassVersionError.

Read More

Do you need license for using iText?

Yes, if you’re using com.itextpdf.text.pdf.PdfReader from the iText library in a Java application, you will need a license depending on the intended use of your application. Here’s a breakdown: For more information on licensing and compliance, you can visit iText’s official licensing page: iText Licensing. Using iText without a proper license in commercial or closed-source…

Read More

RPS: Repository Connection Diagnostics and more

http://localhost:8080/records/component/diagnostics installed services: Record Dashboard: Find all RQM queue: select r_object_id, message, sign_off_user, sign_off_date from dmi_queue_item where name=’rqm_queue’ Useful DQL: To get details on the queue, use the following query.DQL> select r_object_id, message, sign_off_user, sign_off_date from dmi_queue_item where name=’rqm_queue’The format of the message is:profile_id=”0800a9b580007577″ -render=”true” -arg_object_id=”0800a9b5800082cd”the arg_object_id will be the ID of the work order…

Read More