Drill thougth sample

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Drill thougth sample

    Hi all

    i tried to reproduce the drill through sample, I loaded data via palo ETL (version 3.2) it's ok, but when I load spreadsheet sample_drill_through.xls and select drill through fuction I'had next error:

    NO DATA RETURNED FOR THIS AREA

    what I losed as step to produce this sample?
    Bi integrator and ETL Talend.com
  • RE: Drill thougth sample

    Hi,

    Have you installed SVS (Palo Supervision Server)?

    According to my knowledge, Drill through needs SVS which is only part of premium edition (to be confirmed). I think I remember having this issue because SVS was not started.

    Regards
    Pierre
  • I followed step by step install of SVS server on a primium version and I run the ETL jobs.

    I verified PHP files that use the good etl url (OK)

    I verifed that the svs server was started (OK)

    But when I opend the spreadsheet file of drill_through sample I've data in cells but when I right-clic on cell of the sample to run Drill through a notification message indicate "NO DATA RETURNED FOR THIS AREA "
    Bi integrator and ETL Talend.com

    The post was edited 2 times, last by khen ().

  • Drill through sample should work "out of the box" if:

    -Database (Biker_ETL) is created via ETL job(shipped in setup)
    -SVS is properly configured (scripts shipped in setup)

    I guess you are missing proper DB, i.e. ETL Server doesn't "know" your DB.
    Mit freundlichen Gruessen/ With kind Regards / Meilleures salutations

    Vladislav Malicevic
    VP Development & Support
    Jedox AG
  • I attached to this post the steps that I done to reproduce the drill-through sample with success:

    1 run Biker ETL and Drill through etl
    2 test drill through Cube
    3 test in excel the drill through

    the database to store drill through data was not created when I run Biker ETL only Palo db was created.

    Is there any solution to reproduce this sample?
    Bi integrator and ETL Talend.com
  • Hi,

    did you configure SVS properly?
    And did you check your SEP.log?

    Source Code

    1. SVS (1708) | GMT 18.02.2011 15:01:13: PHP Warning: Palo returned error: Could n
    2. ot resolve '80↨☺rs2' in 'Biker_ETL' in C:\Program Files (x86)\Jedox\Palo Suite\s
    3. vs\Samples\sep.inc.drill_through.php on line 41
    4. SVS (1708) | GMT 18.02.2011 15:01:13: PHP Warning: Exception caught! Exception:
    5. No database specified in connection string. in C:\Program Files (x86)\Jedox\Pal
    6. o Suite\svs\Samples\sep.inc.drill_through.php on line 50
    7. SVS (1708) | GMT 18.02.2011 15:02:13: PHP user log: SOAP Fault: (faultcode: WSDL
    8. , faultstring: SOAP-ERROR: Parsing WSDL: Couldn't load from 'http://localhost:77
    9. 75/etlserver/services/ETL-Server?wsdl' : failed to load external entity "http://
    10. localhost:7775/etlserver/services/ETL-Server?wsdl"
    11. )
    Display All


    And "No data returned" as well.

    Regards.

    The post was edited 4 times, last by tish1 ().

  • in SEP.log

    SVS (5392) | GMT 18.02.2011 16:46:02: PHP user log: << Get triggering area >>
    SVS (5392) | GMT 18.02.2011 16:46:02: PHP user log: << Termination handler >>
    SVS (5392) | GMT 18.02.2011 16:46:02: SupervisionServer: terminating.
    SVS (5412) | GMT 18.02.2011 16:46:03: PHP user log: << Get triggering area >>
    SVS (5412) | GMT 18.02.2011 16:46:03: PHP user log: << Termination handler >>
    SVS (5412) | GMT 18.02.2011 16:46:03: SupervisionServer: terminating.
    SVS (5424) | GMT 18.02.2011 16:46:03: PHP user log: << Get triggering area >>
    SVS (5424) | GMT 18.02.2011 16:46:03: PHP user log: << Termination handler >>
    SVS (5424) | GMT 18.02.2011 16:46:03: SupervisionServer: terminating.
    SVS (5436) | GMT 18.02.2011 16:46:04: PHP user log: << Get triggering area >>
    SVS (5436) | GMT 18.02.2011 16:46:04: PHP user log: << Termination handler >>
    SVS (5436) | GMT 18.02.2011 16:46:04: SupervisionServer: terminating.
    SVS (5464) | GMT 18.02.2011 16:46:04: PHP user log: << Get triggering area >>
    SVS (5464) | GMT 18.02.2011 16:46:04: PHP user log: << Termination handler >>
    SVS (5464) | GMT 18.02.2011 16:46:04: SupervisionServer: terminating.
    SVS (5484) | GMT 18.02.2011 16:46:05: PHP user log: << Get triggering area >>
    SVS (5484) | GMT 18.02.2011 16:46:05: PHP user log: << Termination handler >>
    SVS (5484) | GMT 18.02.2011 16:46:05: SupervisionServer: terminating.
    SVS (5520) | GMT 18.02.2011 16:46:05: PHP user log: << Get triggering area >>
    SVS (5520) | GMT 18.02.2011 16:46:05: PHP user log: << Termination handler >>
    SVS (5520) | GMT 18.02.2011 16:46:05: SupervisionServer: terminating.
    SVS (5536) | GMT 18.02.2011 16:46:06: PHP user log: << Get triggering area >>
    SVS (5536) | GMT 18.02.2011 16:46:06: PHP user log: << Termination handler >>
    SVS (5536) | GMT 18.02.2011 16:46:06: SupervisionServer: terminating.
    SVS (2232) | GMT 18.02.2011 16:46:18: PHP user log: << User logged in: _internal_suite >>
    SVS (2232) | GMT 18.02.2011 16:47:01: PHP user log: << User logged in: _internal_suite >>
    SVS (2232) | GMT 18.02.2011 16:47:05: PHP user log: << User logged in: admin >>
    SVS (2232) | GMT 18.02.2011 16:47:05: PHP user log: << User logged in: admin >>




    Respose from etl server is valide: when I introduce next wsdl address

    localhost:7775/etlserver/services/ETL-Server?wsdl


    and it return next xml code in attached file
    Bi integrator and ETL Talend.com
  • Hi,

    does the client or only the supervision server establish a connection to ETL Server? So is it OK to leave localhost:7775 if ETL Server and Palo Molap are on the same machine, but the client calling the drill-through isn't?

    @khen: to me your xml file looks more like the wsdl descriptor than the actual response to your drill request.

    Regards.

    The post was edited 1 time, last by tish1 ().

  • hi

    here is palo.ini contents:

    user-login
    http "127.0.0.1" 7777
    log "C:\PaloSuite32\log\olap_server.log"
    verbose info
    splash-limit 1000 500 100
    goalseek-limit 1000
    goalseek-timeout 10000
    cache-barrier 100000
    clear-cache-cells 10000
    template-directory "C:\PaloSuite32\olap\Api"
    #worker "C:\PaloSuite32\svs\SupervisionServer.exe"
    #workerlogin information

    # Worker
    worker "C:\PaloSuite32\svs\SupervisionServer.exe"
    workerlogin information
    use-cube-worker
    enable-drillthrough


    and for a test I install all servers on the same machine (ETL, OLAP ...)

    tish1 what do you mean by your question "but the client calling the drill-through isn't?"
    Bi integrator and ETL Talend.com
  • Hi,

    my ETL Server is running on the same machine as the Palo Molap Server, but the client, that calls the drill-through operation is on a different machine.
    So my question is, "is it ok to leave localhost:7775 in the SVS configuration or do I have to enter the server name?"
    If there is no direct communication between the Palo Excel Add-In and the ETL Server web-service, localhost should be just fine. If not, then not.

    Regards.
  • If You have the message: "No Data Returned" and in the Stdout..log will be shown an error:
    "SOAP-ERROR: Parsing WSDL: Couldn't load from 'http://localhost:7775/etlserver/services/ETL-Server?wsdl' : failed to load external entity "http://localhost:7775/etlserver/services/ETL-Server?wsdl""
    There are two options, why this error occurs. The first Problem can be a false configuration of the "sep.inc.drill_through.php". Here should be checked if the host(standard "localhost") or the Port(standard "7775") is correct.
    You can check this by simply trying to call the Site: "http://localhost:7775/etlserver/services/ETL-Server?wsdl".
    If the Browser is responding by showing the XML file, that lies beneath this adress, the connection is ok.
    The Second Problem can be specified by a look into the tomcat.log. The Errormessage: "ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/web-etl] - server-service: ERROR: The module path requested, /tc/web-etl/app/, is not in the same web application as this servlet, /web-etl. Your module may not be properly configured or your client and server code maybe out of date." is referencing on a parsing problem of "localhost".
    This is a systemspecific Problem. This is depending on the OS. It helps to change "localhost" to "127.0.0.1".

    The post was edited 2 times, last by e_zeiter ().