Standalone DQL editor for Documentum 16.4

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.

Find more posts tagged with

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

All comments

hqiu

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

yevryid

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

@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

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

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

KarelG

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

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

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

gokul1989_1

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

Thanks a lot.

KwokLeong

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

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

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

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

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

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

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

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

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

You can also use RepoInt for running DQL.
Cheers
Alain

fawazgi

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_

@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

I followed the blog(https://blog.aldago.es/2020/05/15/dqman-configuration-with-documentum-16-4-or-newer/comment-page-1/?unapproved=1073&moderation-hash=9b682983b952b0787a8a5c683c3f2121#comment-1073)
and also did few things my own.

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

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

KB16234522

Florian_PH

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