Planning Analytics

 View Only

  • 1.  Etldap command line

    Posted Wed September 18, 2019 03:14 PM
    Edited by System Fri January 20, 2023 04:38 PM
    Running this command line:
    java etldap -help

    Error:
    ... class not found...

    The cmd file is working and starts the GUI.

    Environment:
    Win2016 server
    PA 2.0.7
    error message

    Thanks for help!

    ------------------------------
    Ivo Pawlow
    ------------------------------
    #PlanningAnalyticswithWatson


  • 2.  RE: Etldap command line

    Posted Thu September 19, 2019 07:22 AM
    I found this documentation https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/t_runningetldapfromwindows_n80193.html.  

    I cannot remember ever seeing ETLDAP run from the command line in the past.  I did a quick test and can reproduce the same error.   I suspect the problem might be specific to our JRE being moved from the ./tm1_64/bin/jre/ directory to the ./tm1_64/jre/ directory .  I also suspect the example command line in the documentation may need to be updated to something like this:

    java -jar etldap.jar -help

    I'll dig into this and see what we need to do to make this work.

    ------------------------------
    Stuart King
    IBM Planning Analytics Offering Manager
    ------------------------------

    Original Message


  • 3.  RE: Etldap command line
    Best Answer

    Posted Thu September 19, 2019 10:01 AM
    Hi Stuart,

    thanks for yor infos.

    The documentation is definitely wrong.

    But i found a solution. So we can import our AD-User to the TM1-Server every night with a batch command.

    In the installation folder of etldap.cmd create copy of that file and append the options
    -f and -batch to the end of the last line.

    The cmd file shold look like this:

    setlocal
    set APPLIXPath=%~d0%~p0
    set PATH=%PATH%;%APPLIXPath%

    "%APPLIXPath%..\jre\bin\javaw.exe" -Djavax.net.ssl.trustStore="%APPLIXPath%ssl\tm1store" -Djavax.net.ssl.trustStorePassword=applix -cp "%APPLIXPath%classes\TM1JavaApi.jar";"%APPLIXPath%ldapsp.jar";"%APPLIXPath%ldapjdk.jar";"%APPLIXPath%etldap.jar" com.applix.tm1etldap.etldap -f D:\IPA\ad_etldap.txt -batch

    Regards 


    ------------------------------
    Ivo Pawlow
    ------------------------------

    Original Message