Wednesday, March 9, 2011

DQL to get all renditions associated with a document

Was trying to deleted unwanted renditions in Documentum when I came across this annoying message:
"You cannot delete the primary rendition"

So it happens that I have TWO pdf renditions for one document and I am unable to remove the older one as both renditions had the same name. I ended up having to delete it using DQL Editor.

1. Get the r_object_id of document
select * from dm_document where object_name = 'XXXXX.doc'

2. Get all renditions associated with that document
select * from dmr_content where any parent_id='09000578802351ee' and full_format='pdf'

3. Identify the non-primary rendition(s). The Physical path is probably pointing to some cache directory in the results from (2).

4. To remove any unwanted renditions:
DELETE dmr_content object WHERE r_object_id = '06000578802136ef'

Hide the Home tab in SAP portal

Here’s an example of how it can be done:
1. Copy role as delta link: e.g. RFx Respondent (from User Administration: Portal Content -> Content Provided by SAP -> specialist -> SRM7.0 -> Core -> Roles -> RFx Respondent)
2. Open the Role and set the properties for the "Home" folder (top-level navigation):
Entry Point - No; Initial State of Navigation Panel – Always Close; Invisible in Navigation Areas – Yes
3. Assign the new role to user instead of the original/default RFx Respondent

Thursday, March 3, 2011

DQL to get workflow of document

Given the document name XXX018.doc

SELECT r_object_id FROM dm_document WHERE object_name = 'XXX018.doc'
or
SELECT r_object_id FROM dm_document WHERE object_name LIKE 'XXX018%'

select * from dm_workflow
where r_object_id in (select r_workflow_id
from dmi_package
where any r_component_id in (select r_object_id
from dm_sysobject (all)
where i_chronicle_id in (select i_chronicle_id
from dm_sysobject where r_object_id='09000578802335ad'))) and r_runtime_state='1'

Wednesday, March 2, 2011

DQL to find details based on workflow item

Based on this information, get the workflow details and document.
Started workitem: "4a000578800d9915" in docbase "ecmdocbase"

1. Get workflow id from package id
select r_workflow_id from dmi_workitem where r_object_id = '4a000578800d9915'

2. Get workflow details
select * from dm_workflow where r_object_id = '4d0005788004d500'

3. Get the document id from workflow package
select r_component_id from dmi_package where r_workflow_id = '4d0005788004d500'

4. get the document name
select * from dm_document where r_object_id = '0900057880210948'

running command line programs in remote servers

Download pstools from sysinternals.
Inside the package there's a tool called psexec.

Launch psexec from command line.
e.g. \\servername -u -p
Related Posts Plugin for WordPress, Blogger...