Suhas Das

Storage Update

If your storage is full, and you add a new drive/Storage, and need to route all new content to the new one. Here are some useful steps, you really need. Create the dql select ‘alter type ‘ + ti.r_type_name + ‘ SET DEFAULT STORAGE ”filestorex_11”  ‘ from dm_store st, dmi_type_info ti where st.r_object_id=ti.default_storage and st.name…

Read More

[DFC_BOF_CLASS_CACHE_INIT_ERROR] Failed to initialize class cache.;

[DFC_BOF_CLASS_CACHE_INIT_ERROR] Failed to initialize class cache.; dfc.data.local_dir=/tmp/dmcl_cachedfc.cache.dir=/tmp/dmcl_cache DfException:: THREAD: main; MSG: [DFC_BOF_CLASS_CACHE_INIT_ERROR] Failed to initialize class cache.; ERRORCODE: ff; NEXT: nullat com.documentum.fc.client.impl.bof.cache.NullClassCacheManager.checkCacheConsistency(NullClassCacheManager.java:46)at com.documentum.fc.client.impl.bof.compoundclass.CompoundClassMgr.getImpClass(CompoundClassMgr.java:66)at com.documentum.fc.client.impl.objectmanager.AbstractPersistentObjectFactory.getCompoundClassEntry(AbstractPersistentObjectFactory.java:39)at com.documentum.fc.client.impl.objectmanager.PObjectFactoryWithAspects.makeObject(PObjectFactoryWithAspects.java:49)at com.documentum.fc.client.impl.objectmanager.PersistentObjectManager.newUncachedObject(PersistentObjectManager.java:100)at com.documentum.fc.client.impl.objectmanager.PersistentObjectManager.newObject(PersistentObjectManager.java:66)at com.documentum.fc.client.impl.objectmanager.PersistentObjectManager.newObject(PersistentObjectManager.java:52)at com.documentum.fc.client.impl.session.Session.newObject(Session.java:948)at com.documentum.fc.client.impl.session.SessionHandle.newObject(SessionHandle.java:901) The error can be caused if there is more then one application trying to use this directory or if you started your application server with…

Read More

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

Content Compression

Do you want to store the content in compress mode? Are you tired of adding new storage drive frequently? Is your content growing fast? Here is the solution. You need to enable Content Compression. Content compression requires a Content Storage Services (CSS) license.  The Content Storage Services (CSS) add-on allows you to create and use content storage…

Read More

Folder related queries

Unlink folders:update dm_folder object unlink ‘/Cabinet/Folder1/Folder2/…./Parent Folder’ where r_object_id = ‘0bxxxxxxxxxxxxxx’ List folder path and all documents in given path select distinct dm.r_object_id, dm.object_name, dm.a_category, dm.r_creation_date, dm.r_modify_date, dm.r_object_type, f.r_folder_path from dm_document dm, dm_folder f where FOLDER(ID(‘0b01bd6f805353a4’), DESCEND) AND dm.r_object_type in(‘w_doc’,’w_media’) AND f.r_folder_path like ‘%/My Location%’ AND dm.i_folder_id = f.r_object_id ORDER by f.r_folder_path ENABLE (ROW_BASED)  Content…

Read More

DQL hints

1. RETURN_TOP N This hint limits the number of rows that a query returns. If you are not interested in seeing all the rows but only the top five (for example), use this code: SELECT user_name FROM dm_user ENABLE (RETURN_TOP 5) 2. OPTIMIZE_TOP N This hint directs the database server to return the first n…

Read More

Deleted content

queries related to deleted content. Find Deleted Content Find all the deleted content in the repository.  This works well as long as the dm_Clean job has not run.  A technique for undeleting content will be the subject of a future post. select * from dmr_content where any parent_id is NULL and content_size > 0 order…

Read More

Workflow DQL

select distinct xxx_atrb1, due_date, xxxx, task_state, name from xxx_custom_folder, dmi_queue_item, dmi_package, dm_workflow, dm_process, dmi_workitem where due_date >= date(’03/01/2020′) and due_date <= date(’04/01/2020′) and dmi_queue_item.router_id=dmi_package.r_workflow_id and dm_workflow.r_object_id=dmi_queue_item.router_id and dm_workflow.r_object_id=dmi_workitem.r_workflow_id and dm_workflow.process_id=dm_process.r_object_id and task_name like ‘%Custom Task Name%’ and ANY dmi_package.r_component_id = cms_custom_folder.r_object_idorder by name; find by date & finished ones: select distinct cms_custom_id, cms_processing_type, cms_custom_date, cms_task_due_date, due_date, cms_pkg_custom_location, task_state, name from cms_custom_folder, dmi_queue_item, dmi_package, dm_workflow,…

Read More