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

CloverDX Platform
1

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

2

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

3

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

4
<!\[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() {}
]]>

5

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 $.