Retrieving the location of a piece of content in a repository using DQL and DFS

Hi all,

I am trying to retrieve the filesystem location of a wmv file in order to programmatically build a mms URL to send to Windows Media Player. I can use DQL to locate the object I wish to stream, and from its i_contents_id I can get the r_object_id of the dmr_content object that represents the file. I can also get the base URL for streaming services by getting the storage_id of the dmr_content object and using that as the r_object_id of the associated dm_store object.

However, how do I get the path to the object on the content server file system, so I can return an URL like:

mms://windowsstreamingserver/streaming/06/0b/0c/a.wmv?

I can get this information using the getfile API or DFC, but both are deprecated in future versions of Documentum.

Thanks for your patience,

Derrick

Find more posts tagged with

Documentum

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

mszurap

If the wmv format is rich media enabled and you have set up the base url for the storage area, then selecting mfile_url should work:

select r_object_id,mfile_url('wmv',-1,'') from dm_document where r_object_id='your_object_id'

The mfile_url should contain the whole url.

All comments

Derrick

I've used the info from another post (Streaming pdf via UCF) to put together some DFS code that should pull back the content URL, but when I run it I get an exception with error message "Fail on exception payload policy could not process action com.emc.documentum.fs.services.core.impl.execution.GetContentUrlAction@10b937e"

What does this message mean?

The error is thrown on this line of code:

objContents = m_objectService.getObjectContentUrls(objectIdSet);Where objContents is of type ObjectService.ObjectContentSet[].

mszurap

If the wmv format is rich media enabled and you have set up the base url for the storage area, then selecting mfile_url should work:

select r_object_id,mfile_url('wmv',-1,'') from dm_document where r_object_id='your_object_id'

The mfile_url should contain the whole url.

Derrick

I tried putting that URL into Windows Media Player and the content doesn't stream.

Are there any other conditions for the mfile_url function to work properly?

Derrick

Now I'm trying to determine the value by using the IObjectService.GetObjectContentUrls() method, but every call to this method returns an exception:

System.ServiceModel.FaultException: Remote server for UrlContent is not available.

Which is the server I need to use the method GetObjectContentUrls()?

mszurap

I suppose your ACS server (inside the Java Method Server) is not running or it's not projected itself to the docbroker (if you restarted your docbroker since JMS start then you need to bounce the JMS too).

You can check this by:

getting the url: http://yourhost:9080/ACS/servlet/ACS
Running "$DM_HOME/bin/dmqdocbroker -c getservermap yourrepositoryname -a

Derrick

The URL worked for me. I got the ACS is up and running message.

However, the command line returned this:

\Documentum\product\6.5\bin>dmqdocbroker -c getservermap DMS -a

dmqdocbroker: A DocBroker Query Tool

dmqdocbroker: Documentum Client Library Version: 6.5.0.225SP2

Targeting current host

'uname' is not recognized as an internal or external command,

operable program or batch file.

Targeting port 1489

dmqdocbroker: Error returned from docbroker request:

[DM_DOCBROKER_E_NO_SERVERS_FOR_DOCBASE]error: "The DocBroker running on host (D

TORDAM01:1489) does not know of a server for the specified docbase (DMS)"

Should I restart the repository and docbroker?

mszurap

Yes, you should. And at the end, don't forget to restart the Java Method Server too...

derricklau

Using the query provided:

select r_object_id,mfile_url('wmv',-1,'') from dm_document where r_object_id='your_object_id'

I got an URL of the form:

mms://dTORDAM06/streaming/path=000008ae\\80\\00\\00\\24.wmv&store=streaming_store02

I then stripped of the "path=" and "&store=streaming_store02".

Then I was able to stream fine.