Standalone DQL editor for Documentum 16.4

yevryid
yevryid Member
in Documentum #1

Hi ,

Is there any standalone DQL editor available for documentum 16.4 ? Other than the ones provided by DA. I am looking for tool which will make DQL API execution a bit simpler.

Regards
YG.

Answers

  • hqiu
    hqiu E
    #2

    HI, yevryid:

    no , there is no Standard DQL editor from OpenText.

    having said that, you can use DQMan latest version to connect to Documentum 16.4.

    TOny

    Tony Qiu
    Opentext ECD - SME

  • yevryid
    yevryid Member
    #3

    Hi

    Thanks for the reply. I tried DqMan but it does not connect from remote.Even though the server is accessible from DA. It just throws the error "Login Failed.Please try again."

    There is no trace or log file available to look into .Any ideas on how to go about this?

    Regards
    Yashashri.

  • TulioCarvalho
    TulioCarvalho
    #4

    @yevryid said:
    Hi

    Thanks for the reply. I tried DqMan but it does not connect from remote.Even though the server is accessible from DA. It just throws the error "Login Failed.Please try again."

    There is no trace or log file available to look into .Any ideas on how to go about this?

    Regards
    Yashashri.

    Hi Yashashri,

    If you can't connect using DQMan, you should check if docbase ports are open.

    In Content Server, go to "/etc/services", and check the last lines of the file to get Docbase ports.

    To check if the ports are already opened, you can just try to telnet the Content Service using docbase ports from DQMan workstation.
    If couldn't connect to CS via Telnet, than we figured it out why you're not able to successfully connect via DQMan.

    This issue happens because DQMan connect directly with the docbase service, once it get answered by Docbroker.

    If you need any further help, just let us know.

    Best Regards,
    Tulio

  • gokul1989_1
    gokul1989_1
    #5

    It seems that DqMan doesnt work with fresh install of CS 16.4, Same Dqman connects with 7.3 CS without any issues which resides in same network.

    Anyone had luck connecting CS16.4 Linux/windows version with DQman. Im sure the Firewall is open

    @hqiu ? @yevryid ?

  • rkavanagh
    rkavanagh E
    #6

    Yes, we did face issues with dqman. A colleague created a support note to help with the setup. I am unsure if it is the same problem you face but it does work with 16.4.

    See KB10030004

    Russell Kavanagh
    Documentum SME | Opentext

  • KarelG
    KarelG Member
    #7

    I read something about installing correct DFC (16.4) on client side
    I read something about copying DMCL.INI to the dqman installation folder
    And somebody said this solved his problem: dqman.exe -r -u -p

    Just some tips, not sure if any is usefull….

  • gokul1989_1
    gokul1989_1
    edited January 8, 2019 #8

    Yes I got the solution from the KB10030004 article thanks everyone

    https://forums.opentext.com/forums/discussion/224993/querying-utility-for-documentum-16-4#latest

  • KS1798
    KS1798
    #9

    Hi, could you place the content of the article here since it doesn't seem to be accessible. Thanks.

  • gokul1989_1
    gokul1989_1
    #10

    Resolution

    The following configuration can be used to allow the tool to interact with latter versions of Documentum Server.
    1. Install dqMan 5 binaries if not already installed. Ensure your license file is in the dqMan folder.
    2. On client machine (do NOT install on Documentum Server), install DFC for the Documentum Server.
    3. Using the dfc.properties created during DFC installation copy it to the dqman/config folder.
    4. Copy the deprecated dmcl.dll file from an older Documentum Server (6.7 or older) and copy it to the dqMan folder.
    5. Start up dqMan and ensure you can create a new session to the Documentum Server and the repositories.

  • KS1798
    KS1798
    #11

    Thanks a lot.

  • KwokLeong
    KwokLeong Member
    #12

    Hi,

    I was wondering if anyone got it to work.
    I am trying to get dqMan to work but is unsuccessful.

    I have a Documentum CS 16.4 P10, and a fresh Windows 10 1709 client.
    Installed dqMan 5 and put in the license file. Installed DFC 16.4 (without patches) in D drive.
    Copied dfc.properties to dqman\config, copied the dmcl.dll in the KB to the dqman folder too.
    Able to telnet the docbroker and docbase ports too.

    Not sure what else can be done.

  • fmejwagner
    fmejwagner Member
    #13

    I applied these configurations to my (zipped + copied + unzipped) dqman 6 to connect to 16.4 repository:

    • Some DFC 16.4 installation.

    • Check/Set environment variables:
      ClassPath: (dfc-user-dir)\config + (dfc-install-dir)\dctm.jar
      Path: (dfc-install-dir)\java(version)\jre\bin + (dfc-install-dir)\Shared + (dfc-user-dir)\config
      JAVA_HOME: (dfc-install-dir)\java(version)

    • Hide DMCL files in dqman folder (by renaming to x-...) to enforce DFC usage: dmcl40.dll + dmcl.ini

    Hints:

    • Newer Content Server version 16.4 does not allow DMCL connection... you must use DFC to connect from dqman to Docbase.
    • Use 32-bit Java from DFC installation! Trying to use my other available Java-x64-portable seems to cause 32-64-bit trouble.
    • Better install DFC. Zip+Copy+Unzip of DFC may cause trouble detecting the DFC (you may have to use .bat startup or java.ini files on dqman launch... but that may be helpful to have several DFC versions available on 1 develop machine).

    Have a look at my .bat file used to launch my dqman6 with (unzipped+copied) 32-bit DFC and Java 32-bit Portable:

    set ClassPath=%ClassPath%;C:\Software\dctm\dfc\config;C:\Software\dctm\dfc\dctm.jar
    set Path=%Path%;C:\Software\Develop\Java\jdk8u181x32-portable\jre\bin;C:\Software\dctm\dfc\shared;C:\Software\dctm\dfc\config
    set JAVA_HOME=C:\Software\Develop\Java\jdk8u181x32-portable
    start /B C:\Software\dctm\dqMan6\dqman.exe

    Hint:
    The "start /B" command option hides the CMD window from .bat file execution. Only dqman window opens ;)

  • Hans Henrik
    Hans Henrik Member
    #14

    Why oh why, have they stopped DMCL connections?
    We are very dependable on old tools like DocLoader to use DMCL connections.
    This really a show stopper for us!!!

  • Arijitgupte
    Arijitgupte Member
    #15

    Hi All,
    i too tried copying dfc.properties to config folder yet unable to get login screen in dqMan,
    Even copied the latest dfc.jar file to dqMan and config folder.
    Any help.

  • Arijitgupte
    Arijitgupte Member
    #16

    Hi All,
    i too tried copying dfc.properties to config folder yet unable to get login screen in dqMan,
    Even copied the latest dfc.jar file to dqMan and config folder.

  • Arijitgupte
    Arijitgupte Member
    #17

    Hi All,
    i too tried copying dfc.properties to config folder yet unable to get login screen in dqMan,
    Even copied the latest dfc.jar file to dqMan and config folder.

  • Arijitgupte
    Arijitgupte Member
    #18

    Hi All,
    i too tried copying dfc.properties to config folder yet unable to get login screen in dqMan,
    Even copied the latest dfc.jar file to dqMan and config folder.

  • cymm
    cymm Member
    #19

    Hi fmejwagner

    "Better install DFC. Zip+Copy+Unzip of DFC may cause trouble detecting the DFC (you may have to use .bat startup or java.ini files on dqman launch... but that may be helpful to have several DFC versions available on 1 develop machine)."

    What is the content of the java.ini file?
    thanks
    Cyrill

  • fmejwagner
    fmejwagner Member
    #20

    Well... I use a .bat file to launch dqman... so I have no java.ini example for you.

    But my colleague has posted his java.ini settings in our internal knowledge tool:

    java_library_path="C:\Apps\Java\jre1.8.0_101_32\bin\client\jvm.dll"
    JAVA_OPTIONS=" -Xcheck:jni -XX:+RestoreMXCSROnJNICalls -Xmx256m"
    java_classpath = "dfc\lib164\dfc.jar;dfc\config"

  • Alain_Molimard2
    Alain_Molimard2 Member
    #21

    You can also use RepoInt for running DQL.
    Cheers
    Alain

  • fawazgi
    fawazgi Member
    #22

    Hi
    Dqman worked fine with me when connecting in a non-secure mode. Once I have changed the connection mode to secure, it stopped working. I followed the instructions in the mentioned KB

  • Mohamed_Yousuff_
    Mohamed_Yousuff_ E
    #23

    @fawazgi said:
    Hi
    Dqman worked fine with me when connecting in a non-secure mode. Once I have changed the connection mode to secure, it stopped working. I followed the instructions in the mentioned KB

    Point to 32 bit version of java8 using the below environment variables and then retry again.

    java_library_path - Point to ….JAVA_HOME\bin\client\jvm.dll
    PATH - Point to JAVA_HOME\bin folder.

    I had similar kind of problem with composer, I was able to connect using non-secure mode but not with secure mode. It got resolved by using java8 version. May be the later versions of java have secure algorithms required to establish secure connection.

  • rvasanth63
    rvasanth63
    #24
    I was able to get my DQMan 6 version work against Documentum CS 16.4.as a standalone package.


    Download the DQman 6 and Install the license.
    Then ...

    1. I just coped the dmcl.dll to the Dqman Home folder "C:\dqMan" from C:\dqMan\config
    2. I have installed DFC 16.4 .
    3. Then  copied the "Java 1.8 32 bit "  that come bundled with DFC16.4 from C:\Documentum to C:\dqMan
    I also copied the DFC.properties file into C:\dqMan\config

    4. I created a java.ini file inside C:\dqMan

    This is what it is inside my java.ini. ( all jars are taken from 1.6 DFC installation "shared" folder)

    java_library_path="C:\dqMan\java\1.8.0_152\jre\bin\client\jvm.dll"
    JAVA_OPTIONS=” -Xcheck:jni -XX:+RestoreMXCSROnJNICalls -Xmx256m”
    java_classpath="C:\dqMan\config\aspectjrt.jar;C:\dqMan\config\commons-codec-1.10.jar;C:\dqMan\config\commons-lang-2.6.jar;C:\dqMan\config\dctm.jar;C:\dqMan\config\dfc.jar;C:\dqMan\config\log4j.jar;C:\dqMan\config"

    Nothing else is needed DQman will now work seamlessly without any issues.
  • Mohamed.Sayed
    Mohamed.Sayed Member
    #25

    Please see my article with open text about "how can you connect the DQLTester tool to newer Documentum Server releases?"


    KB16234522


  • Florian_PH
    Florian_PH Member
    #26
    logo_dqman_horizontal.png

    Back in December 2021, fme AG announces development of a new dqMan commercial version for administration of OpenText Documentum. With the new dqMan, users can expect the release of a revised version providing compatibility to current OpenText Documentum applications and feature enhancements like a new user interface offering an improved user experience. In addition, also full native support for x64 and Citrix support is planned. The release is planned for July 2022 and you can find the first information and a early bird discount for the upcoming dqMan here: http://www.dqman.com

Categories