need to run the graph in linux which as DBinput,ExtHashjoin

rammohan

• October 21, 2008 00:00

• Answered

Follow

when i run the graph in windows it is working fine but when i run it linux it is unable to find the joining keys that are mentioned in the ExtHashJoin component.
i am geetting the following Exception
ERROR [jetel.exception.ConfigurationStatus] - Field name specified as a key doesn't exist: $hu_user_id
2008-10-21 22:56:24,757 [http-0.0.0.0-8080-1] ERROR [jetel.exception.ConfigurationStatus] - Field name specified as a key doesn't exist: $ha_ha_user_id
2008-10-21 22:56:24,757 [http-0.0.0.0-8080-1] ERROR [jetel.exception.ConfigurationStatus] - Field name specified as a key doesn't exist: $hu_user_id
2008-10-21 22:56:24,757 [http-0.0.0.0-8080-1] ERROR [jetel.exception.ConfigurationStatus] - Field name specified as a key doesn't exist: $hu_user_id
2008-10-21 22:56:24,757 [http-0.0.0.0-8080-1] ERROR [jetel.exception.ConfigurationStatus] - Field name specified as a key doesn't exist: $hu_user_id
2008-10-21 22:56:24,757 [http-0.0.0.0-8080-1] ERROR [jetel.exception.ConfigurationStatus] - Field name specified as a key doesn't exist: $hu_user_id
2008-10-21 22:56:24,757 [http-0.0.0.0-8080-1] ERROR [jetel.exception.ConfigurationStatus] - Field name specified as a key doesn't exist: $hd_dealer_id
2008-10-21 22:56:24,757 [http-0.0.0.0-8080-1] ERROR [jetel.exception.ConfigurationStatus] - Field name specified as a key doesn't exist: $hd_dealer_id
2008-10-21 22:56:24,757 [http-0.0.0.0-8080-1] ERROR [jetel.exception.ConfigurationStatus] - Field name specified as a key doesn't exist: $hwr_do_num
2008-10-21 22:56:24,757 [http-0.0.0.0-8080-1] ERROR [jetel.exception.ConfigurationStatus] - Field name specified as a key doesn't exist: $hwr_do_num



all the keys which ithe error is thrown are mentioned in the ExtHashJoin component

• 

  avackova

  • October 21, 2008 10:37

  0

  Comment actions Permalink

  it's strange: all graph should works in windows as well as in linux. Could you show your graph?
• 

  rammohan

  • October 22, 2008 05:31

  0

  Comment actions Permalink

  On further research .. I found out that .. it is noyhing to do with the windows or linux ... but if i run the graph from clover GUI ( run as clover ETL graph ) it works fine ... but while running from stand alone "runGraph" utility class it says ....
  
  2008-10-01 10:46:30,345 [main] ERROR [jetel.exception.ConfigurationStatus] - Field name specified as a key doesn't exist: $hu_user_id
  2008-10-01 10:46:30,345 [main] ERROR [jetel.exception.ConfigurationStatus] - Field name specified as a key doesn't exist: $ha_ha_user_id
  2008-10-01 10:46:30,345 [main] INFO [jetel.graph.TransformationGraph] - Initializing connection:
  
  
  in EXT HASH JOIN
  
  Node looks like this
  
  
  <Node>
  <attr><CDATA></attr>
  </Node>
• 

  rammohan

  • October 22, 2008 05:32

  0

  Comment actions Permalink

  <Node enabled="enabled" guiHeight="0" guiName="ExtHashJoin" guiWidth="0" guiX="412" guiY="76" id="EXT_HASH_JOIN1" joinKey="$hu_user_id=$hu_user_id;#" slaveDuplicates="true" type="EXT_HASH_JOIN">
  <attr name="transform"><![CDATA[//#TL
  
  // Transforms input record into output record.
  function transform() {
  $0.hu_customer_guid := $0.hu_customer_guid;
  $0.hu_identification_type := $0.hu_identification_type;
  $0.hu_identification_num := $0.hu_identification_num;
  $0.hu_user_id := $0.hu_user_id;
  $0.ha_salutation := $0.ha_salutation;
  $0.ha_first_name := $0.ha_first_name;
  $0.ha_last_name := $0.ha_last_name;
  $0.ha_address_line_1 := $0.ha_address_line_1;
  $0.ha_address_line_2 := $0.ha_address_line_2;
  $0.ha_address_line_3 := $0.ha_address_line_3;
  $0.ha_address_line_4 := $0.ha_address_line_4;
  $0.ha_town_area_suburb := $0.ha_town_area_suburb;
  $0.ha_city := $0.ha_city;
  $0.ha_state := $0.ha_state;
  $0.ha_postal_code := $0.ha_postal_code;
  $0.hcr_country_code := $0.hcr_country_code;
  $0.ha_home_phone := $0.ha_home_phone;
  $0.ha_mobile_phone := $0.ha_mobile_phone;
  $0.ha_office_phone := $0.ha_office_phone;
  $0.ha_email_id := $0.ha_email_id;
  $0.hupi_date_of_birth := $1.hupi_date_of_birth;
  $0.hupi_gender := $1.hupi_gender;
  $0.hupi_ethnic_religion := $1.hupi_ethnic_religion;
  $0.hupi_company_name := $1.hupi_company_name;
  $0.ha_adress_id := $0.ha_address_id;
  }
  
  // Called during component initialization.
  // function init() {}
  
  // Called after the component finishes.
  // function finished() {}
  ]]></attr>
  </Node>
• 

  avackova

  • October 22, 2008 06:45

  0

  Comment actions Permalink

  I think that you try to run graph that was created by 2.0/2.5 version with older version. In new version key like $fieldName is recognized as clover field with name "fieldName", but older versions requires notation without preceding $.

Please sign in to leave a comment.