Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: HTTP Post Step Not Working in Carte

  1. #1
    Join Date
    Sep 2009
    Posts
    14

    Default HTTP Post Step Not Working in Carte

    I have a transformation that creates a soap request using javascript and the toXMLString() method. It then sends this to our Oracle CRM on Demand via their webservices. To do this I have been using the HTTP Post step. It works fine when I run this in Spoon, but when I try to run it remotely on Carte, I get the following error in the log:

    2011/01/31 17:29:03 - CreditStatusUpdate - Loading transformation from repository [CreditStatusUpdate] in directory [/CRMWebServicesJob]
    2011/01/31 17:29:04 - CreditStatusUpdate - Dispatching started for transformation [CreditStatusUpdate]
    2011/01/31 17:29:04 - CreditStatusUpdate - This transformation can be replayed with replay date: 2011/01/31 17:29:04
    2011/01/31 17:29:05 - CreateWorkflowParentJob - Starting entry [InitializeWorkflow]
    2011/01/31 17:29:05 - InitializeWorkflow - Loading transformation from repository [InitializeWorkflow] in directory [/Chris' Jobs and Transformations/WorkflowEngine]
    2011/01/31 17:29:06 - TWiSTWFLsToNYPrintersJob - Starting entry [TWiSTWFLsToNYPrinters_RunsOnWPJB2]
    2011/01/31 17:29:06 - TWiSTWFLsToNYPrinters_RunsOnWPJB2 - Loading transformation from repository [TWiSTWFLsToNYPrinters_RunsOnWPJB2] in directory [/Chris' Jobs and Transformations/TWiSTWFLsToNYPrinters]
    2011/01/31 17:29:10 - InitializeWorkflow - Dispatching started for transformation [InitializeWorkflow]
    2011/01/31 17:29:10 - InitializeWorkflow - This transformation can be replayed with replay date: 2011/01/31 17:29:10
    2011/01/31 17:29:10 - TWiSTWFLsToNYPrinters_RunsOnWPJB2 - Dispatching started for transformation [TWiSTWFLsToNYPrinters_RunsOnWPJB2]
    2011/01/31 17:29:10 - TWiSTWFLsToNYPrinters_RunsOnWPJB2 - This transformation can be replayed with replay date: 2011/01/31 17:29:10
    2011/01/31 17:29:10 - GetFolderNames.0 - Finished processing (I=0, O=0, R=0, W=18, U=0, E=0)
    2011/01/31 17:29:10 - Filter rows.0 - Finished processing (I=0, O=0, R=18, W=18, U=0, E=0)
    2011/01/31 17:29:10 - Add constants.0 - Finished processing (I=0, O=0, R=18, W=18, U=0, E=0)
    2011/01/31 17:29:11 - CreateWorkflowParentJob - Starting entry [CreateStoryFolderNames]
    2011/01/31 17:29:11 - CreateStoryFolderNames - Loading transformation from repository [CreateStoryFolderNames] in directory [/Chris' Jobs and Transformations/WorkflowEngine]
    2011/01/31 17:29:12 - CreateWorkflowParentJob - Starting entry [RenameStoryFolder]
    2011/01/31 17:29:13 - CreateWorkflowParentJob - Starting entry [CheckWorkflowFolders]
    2011/01/31 17:29:13 - CheckWorkflowFolders - Loading transformation from repository [CheckWorkflowFolders] in directory [/Chris' Jobs and Transformations/WorkflowEngine]
    2011/01/31 17:29:13 - CheckWorkflowFolders - Dispatching started for transformation [CheckWorkflowFolders]
    2011/01/31 17:29:13 - CheckWorkflowFolders - This transformation can be replayed with replay date: 2011/01/31 17:29:13
    2011/01/31 17:29:16 - Table input.0 - Finished reading query, closing connection.
    2011/01/31 17:29:16 - Add constants .0 - Finished processing (I=0, O=0, R=3, W=3, U=0, E=0)
    2011/01/31 17:29:16 - CreateTitlecode.0 - Finished processing (I=0, O=0, R=3, W=3, U=0, E=0)
    2011/01/31 17:29:16 - CreateRootPaths.0 - Finished processing (I=0, O=0, R=3, W=3, U=0, E=0)
    2011/01/31 17:29:16 - Table input.0 - Finished processing (I=3, O=0, R=0, W=3, U=0, E=0)
    2011/01/31 17:29:16 - Lookup Titles.0 - Finished processing (I=3, O=0, R=3, W=3, U=0, E=0)
    2011/01/31 17:29:17 - Table input.0 - Finished reading query, closing connection.
    2011/01/31 17:29:17 - Add constants.0 - Finished processing (I=0, O=0, R=58, W=58, U=0, E=0)
    2011/01/31 17:29:17 - Table input.0 - Finished processing (I=58, O=0, R=0, W=58, U=0, E=0)
    2011/01/31 17:29:17 - Get File Names.0 - Finished processing (I=0, O=0, R=18, W=590, U=0, E=0)
    2011/01/31 17:29:17 - Filter rows 2.0 - Finished processing (I=0, O=0, R=590, W=590, U=0, E=0)
    2011/01/31 17:29:17 - Dummy (do nothing) 2.0 - Finished processing (I=0, O=0, R=590, W=590, U=0, E=0)
    2011/01/31 17:29:17 - TWiSTWFLsToNYPrintersJob - Starting entry [TWiSTWFLsToNYPrinters_RunsOnNYCT4MMU1]
    2011/01/31 17:29:17 - TWiSTWFLsToNYPrinters_RunsOnNYCT4MMU1 - Loading transformation from repository [TWiSTWFLsToNYPrinters_RunsOnNYCT4MMU1] in directory [/Chris' Jobs and Transformations/TWiSTWFLsToNYPrinters]
    2011/01/31 17:29:18 - Database lookup.0 - Finished processing (I=49, O=0, R=58, W=58, U=0, E=0)
    2011/01/31 17:29:21 - SOAP Query.0 - Finished processing (I=0, O=0, R=58, W=58, U=0, E=0)
    2011/01/31 17:29:23 - Filter rows 3.0 - Finished processing (I=0, O=0, R=106, W=106, U=0, E=0)
    2011/01/31 17:29:23 - Dummy (do nothing) 3.0 - Finished processing (I=0, O=0, R=2, W=2, U=0, E=0)
    2011/01/31 17:29:23 - CreateSubRootFolders.0 - Finished processing (I=0, O=0, R=104, W=104, U=0, E=0)
    2011/01/31 17:29:23 - GetStoryFolderNames.0 - Finished processing (I=0, O=0, R=3, W=106, U=0, E=0)
    2011/01/31 17:29:23 - WorkflowStepsRootExists.0 - Finished processing (I=0, O=0, R=104, W=104, U=0, E=0)
    2011/01/31 17:29:23 - Filter rows.0 - Finished processing (I=0, O=0, R=104, W=104, U=0, E=0)
    2011/01/31 17:29:23 - Dummy (do nothing) 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2011/01/31 17:29:23 - LookupEdit.0 - Finished processing (I=104, O=0, R=104, W=104, U=0, E=0)
    2011/01/31 17:29:25 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Because of an error, this step can't continue:
    2011/01/31 17:29:25 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Can not result from [https://secure-ausomxcka.crmondemand...s/Integration]
    2011/01/31 17:29:25 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Unbuffered entity enclosing request can not be repeated.
    2011/01/31 17:29:25 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2011/01/31 17:29:25 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Can not result from [https://secure-ausomxcka.crmondemand...s/Integration]
    2011/01/31 17:29:25 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Unbuffered entity enclosing request can not be repeated.
    2011/01/31 17:29:25 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.steps.httppost.HTTPPOST.callHTTPPOST(HTTPPOST.java:250)
    2011/01/31 17:29:25 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.steps.httppost.HTTPPOST.processRow(HTTPPOST.java:382)
    2011/01/31 17:29:25 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2011/01/31 17:29:25 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : java.lang.Thread.run(Unknown Source)
    2011/01/31 17:29:25 - HTTP Post.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
    2011/01/31 17:29:25 - CreditStatusUpdate - CreditStatusUpdate
    2011/01/31 17:29:25 - CreditStatusUpdate - CreditStatusUpdate
    2011/01/31 17:29:25 - CreditStatusUpdate - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Errors detected!
    2011/01/31 17:29:25 - CreditStatusUpdate - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Errors detected!

  2. #2
    Join Date
    Sep 2009
    Posts
    14

    Default

    BTW I am using pdi 4.0.1 stable

  3. #3
    Join Date
    Sep 2009
    Posts
    14

    Default

    Update: I just tried running it in Kitchen and received the same errors


    2011/01/31 18:06:12 - CreditStatusUpdate - Loading transformation from repository [CreditStatusUpdate] in directory [/CRMWebServicesJob]
    2011/01/31 18:06:13 - CreditStatusUpdate - Dispatching started for transformation [CreditStatusUpdate]
    2011/01/31 18:06:13 - CreditStatusUpdate - This transformation can be replayed with replay date: 2011/01/31 18:06:13
    2011/01/31 18:06:13 - Table input.0 - Finished reading query, closing connection.
    2011/01/31 18:06:13 - Add constants.0 - Finished processing (I=0, O=0, R=58, W=58, U=0, E=0)
    2011/01/31 18:06:13 - Table input.0 - Finished processing (I=58, O=0, R=0, W=58, U=0, E=0)
    2011/01/31 18:06:14 - Database lookup.0 - Finished processing (I=49, O=0, R=58, W=58, U=0, E=0)
    2011/01/31 18:06:14 - SOAP Query.0 - Finished processing (I=0, O=0, R=58, W=58, U=0, E=0)
    2011/01/31 18:06:15 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Because of an error, this step can't continue:
    2011/01/31 18:06:15 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Can not result from [https://secure-ausomxcka.crmondemand...s/Integration]
    2011/01/31 18:06:15 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Unbuffered entity enclosing request can not be repeated.
    2011/01/31 18:06:15 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2011/01/31 18:06:15 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Can not result from [https://secure-ausomxcka.crmondemand...s/Integration]
    2011/01/31 18:06:15 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Unbuffered entity enclosing request can not be repeated.
    2011/01/31 18:06:15 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.steps.httppost.HTTPPOST.callHTTPPOST(HTTPPOST.java:250)
    2011/01/31 18:06:15 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.steps.httppost.HTTPPOST.processRow(HTTPPOST.java:382)
    2011/01/31 18:06:15 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2011/01/31 18:06:15 - HTTP Post.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : java.lang.Thread.run(Unknown Source)
    2011/01/31 18:06:15 - CreditStatusUpdate - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Errors detected!
    2011/01/31 18:06:15 - HTTP Post.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
    2011/01/31 18:06:15 - CreditStatusUpdate - CreditStatusUpdate
    2011/01/31 18:06:15 - CreditStatusUpdate - CreditStatusUpdate
    2011/01/31 18:06:15 - CreditStatusUpdate - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Errors detected!

  4. #4
    Join Date
    Sep 2009
    Posts
    14

    Default

    Anyone?

  5. #5
    Join Date
    Apr 2008
    Posts
    146

    Default

    Some things you might want to try or verify are:

    1) Check the .bat or .sh files that start spoon or kitchen as they both have a place to modify library and memory settings.
    2) Was the user and hence environment that you ran spoon under the same as the one that ran kitchen? - Sometimes when you run as different users, the environment variables are not setup exactly the same, ie JAVA_HOME may be different and a host of other small things like settings in the .pentaho folder located in the home directory of the user you ran spoon as.
    3) Is carte running as root or an admin user? - (My experience this weekend were scheduled job failures here and there because root didn't have a fully setup environment. I received strange errors like the ones above, but with a different step.)

    You may try getting 'subversion', 'ant' <-Apache, and a Java JDK and compiling the latest PDI. The one you are using is pretty dated and I remember it having some significant bugs.
    See http://community.pentaho.com/getthecode/

    or this command may be useful once you read up a bit more
    svn co http://source.pentaho.org/svnkettler...tags/4.1.2-GA/
    in the directory 4.1.2-GA, you'd type 'ant' and it will build PDI and put it in a directory called 'distrib' located at 4.1.2-GA/distrib

    You may have luck downloading one that's been built already, but it's a little more dangerous as it is a constant integration build (made from trunk)
    ci.pentaho.com

    http://ci.pentaho.com/view/Data%20In...on/job/Kettle/
    or
    http://ci.pentaho.com/view/Data%20In...ob/Kettle-4.1/

    Other than that, creating a set of example files and attaching them to this post where people can open them up and see what settings you are using would be helpful. The best case is a demonstration set of ktr etc that demonstrate the problem in a way that others can try themselves.

    I wish you luck. Even Pentaho Enterprise support would ask you for demonstration files or some detailed way to try to reproduce the problem.

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.