Tech Kraft

Documentum, AWS, Java, Ruby on Rails, Linux, Windows, App Servers

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:

  1. Stop the following in order
    1. JMS,
    2. All running Docbases and
    3. Docbroker
  2. Locate the server.ini on Content Server at $DM_HOME/dba/config/<DocbaseName>
  3. Create a backup of the file
  4. Open the server.ini file and locate the [SERVER_STARTUP] section
  5. Add the following line in the [SERVER_STARTUP] section:

return_top_results_row_based=false

  1. Save server.ini
  2. Restart Docbroker, Docbases stopped in step 1, and JMS
,
chanakya2's avatar

Posted by:

chanakya2

Leave a comment

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

Recent Posts

Newsletter