Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: HTTP jobentry fails for local URLs

  1. #1
    Join Date
    Jul 2007
    Posts
    247

    Default HTTP jobentry fails for local URLs

    Hi everybody,

    I designed a job that uses the http jobentry to check whether a webserver is running or not. I used http://localhost:8080 as URL and ${KETTLE_HOME}\zeb\dummy.txt as target file. After the http jobentry there are two conditional hops, one if the entry fails and one for success.

    Here's what I encountered during testing:

    If the server is not running the "false" hop will be executed correctly. But if the server is up and running the http request is executed and the result saved to the dummy file, but after that there's an exception like the following:

    Code:
    2007/09/06 11:56:34 - Chef - Starting job...
    2007/09/06 11:56:34 - LocalVariables - ---> Create new KettleVariables for thread [Check for JBoss (Check for JBoss (Thread-2))] for parent thread [main], same namespace? [false]
    2007/09/06 11:56:34 - zebbasel2 - New database connection defined
    2007/09/06 11:56:34 - zebbasel2 - Connected to database.
    2007/09/06 11:56:34 - zebbasel2 - launch DDL statement: 
    2007/09/06 11:56:34 - zebbasel2 - ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,'
    2007/09/06 11:56:34 - zebbasel2 - 1 statement executed
    2007/09/06 11:56:34 - zebbasel2 - Executed connect time SQL statements:
    2007/09/06 11:56:34 - zebbasel2 - ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,' ;
    2007/09/06 11:56:34 - zebbasel2 - Connection to database closed!
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - exec(0, 0, Start.0)
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - Sleeping: 0 minutes
    2007/09/06 11:56:34 - Check for JBoss - Starting entry [Check if JBoss server is running]
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - exec(1, 0, Check if JBoss server is running.0)
    2007/09/06 11:56:34 - Check if JBoss server is running - Start of HTTP job entry.
    2007/09/06 11:56:34 - Check if JBoss server is running - Connecting to URL: http://localhost:8080
    2007/09/06 11:56:34 - Check if JBoss server is running - Start reading reply from webserver.
    2007/09/06 11:56:34 - Check if JBoss server is running - Resource type: "text/html", last modified on: "Mon May 02 20:26:14 CEST 2005".
    2007/09/06 11:56:34 - Check if JBoss server is running - Finished writing 1437 bytes to result file [C:\Programme\zeb\kettle\zeb\dummy.txt]
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) : java.lang.NullPointerException
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) :     at be.ibridge.kettle.job.Job.execute(Job.java:324)
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) :     at be.ibridge.kettle.job.Job.execute(Job.java:360)
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) :     at be.ibridge.kettle.job.Job.execute(Job.java:231)
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) :     at be.ibridge.kettle.job.Job.run(Job.java:202)
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) : A serious error occurred during job execution!
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) : 
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) : Unexpected error occurred while launching entry [Check if JBoss server is running.0]
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) :     at be.ibridge.kettle.job.Job.run (Job.java:202)
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) :     at be.ibridge.kettle.job.Job.execute (Job.java:231)
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) :     at be.ibridge.kettle.job.Job.execute (Job.java:360)
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) :     at be.ibridge.kettle.job.Job.execute (Job.java:324)
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) : be.ibridge.kettle.core.exception.KettleException: 
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) : Unexpected error occurred while launching entry [Check if JBoss server is running.0]
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) :     at be.ibridge.kettle.job.Job.run (Job.java:202)
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) :     at be.ibridge.kettle.job.Job.execute (Job.java:231)
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) :     at be.ibridge.kettle.job.Job.execute (Job.java:360)
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) :     at be.ibridge.kettle.job.Job.execute (Job.java:324)
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) : 
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) :     at be.ibridge.kettle.job.Job.execute(Job.java:365)
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) :     at be.ibridge.kettle.job.Job.execute(Job.java:231)
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) :     at be.ibridge.kettle.job.Job.run(Job.java:202)
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) : Caused by: java.lang.NullPointerException
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) :     at be.ibridge.kettle.job.Job.execute(Job.java:324)
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) :     at be.ibridge.kettle.job.Job.execute(Job.java:360)
    2007/09/06 11:56:34 - Thread[Check for JBoss (Check for JBoss (Thread-2)),5,main] - ERROR (version 2.5.1, build 1 from 2007/09/06 11:56:15) :     ... 2 more
    2007/09/06 11:56:34 - Chef - Job has ended.
    As a result of the exception the job terminates without executing neither the "false" hop nor the "true" hop. Result for the job is "success", though the job terminated somewhere in the middle...

    If I replace the URL with something like http://www.google.com there's no exeception and the "true" hop is executed correctly as expected.

    Does anybody has an idea where this exception may come from and why it's not caught correctly? If there's an exception (whether that one makes sense or not) then at least the "false" hop should be executed.

    I'm using 2.5.1 GA

    Thx in advance,
    Ben

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    It's a code thing, you can create a tracker at http://jira.pentaho.org/browse/PDI

    In v3.0 it would follow false probably.

    Regards,
    Sven

  3. #3
    Join Date
    Jul 2007
    Posts
    247

    Default

    Created as PDI-138.

  4. #4
    Join Date
    Nov 1999
    Posts
    459

    Default

    Ben,
    it works for me in 2.5.1 and 3.0. Can you please attach your job to the case http://jira.pentaho.org/browse/PDI-138 to see if there is something special I missed.
    Thanks,
    Jens

  5. #5
    Join Date
    Jul 2007
    Posts
    247

    Default

    Hi Jens,

    thank you for taking a look at my issue.

    Sorry, for the late reply, but it looks like my job is somewhat corrupt...

    Exporting the job from the repository/spoon fails: if I try to use File --> Export to an XML file --> Enter filename and click Save --> Spoon quits without any notice. Trying to export all jobs using the repository explorer will also fail:
    "An unexpected error occurred in the repository explorer in part [set screen size and position] ... java.lang.NullPointerException"

    Is there any other way to export the job?

    What I also did is to design the job as a completely new job from scratch again: no more HTTP exceptions and the "true" hop is executed without any problems! Looks like the corrupt job was also responsible for the http errors.

    Though I wounder why the job is corrupt or even how this job could be stored in repository, I think you can close PDI-138 as this seems not to be a general issue.

    Thx anyway for your help, it is always very appreciated.

    Regards
    Ben

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.