Hello,
I have a requirement where I need to call multiple graphs by passing a parameter, e.g. the location of the input file to the DATA_READER component. I am trying to run the graph through RunGraph component and passing the parameter (location of the input file name) to that graph. However, in the graph's DATA_READER component, I need to specify the URL of input file name, which should just be a placeholder, telling it that this parameter needs to be passed through RunGraph component. However, when I run the RunGraph component, I get the below error:
Component pre-execute initialization failed. File is unreachable: /u02/clover/cdes/${dataFileIn} caused by: java.io.FileNotFoundException: /u02/clover/cdes/${dataFileIn} (No such file or directory)
This is because I am specifying the file URL in the graph's DATA_READER as ${dataFileIn}, which is not taken as a placeholder and is being evaluated for a location, which does not resolve to anything. I also tried to externalize the dataFileIn parameter in the RunGraph, but to no avail. Any help will be greatly appreciated.
Here is the code for RunGraph and the graph that I am trying to call from RunGraph:
Please let me know if I have missed some important detail or the code and I will post it.
Thanks!
<?xml version="1.0" encoding="UTF-8"?>
<Graph author="jdimond" created="Fri Aug 05 18:10:23 CDT 2011" guiVersion="3.1.0" id="1312588363284" licenseCode="CLP1DALLAN71605509BY" licenseType="Commercial Pro" modified="Tue Aug 09 10:51:26 CDT 2011" modifiedBy="mkansal" name="load_master" revision="1.92" showComponentDetails="true">
<Global>
<Metadata fileURL="${META_DIR}/rungraph_output.fmt" id="Metadata1"/>
<Metadata id="Metadata2" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="graph" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="graphParameter" type="string"/>
</Record>
</Metadata>
<Metadata id="Metadata0" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="rungraph_input" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="graph_path" type="string"/>
<Field name="command_line_argument" type="string"/>
</Record>
</Metadata>
<Property fileURL="data-in/test2/InputFileNameParameters.prm" id="GraphParameter0"/>
<Property fileURL="workspace.prm" id="GraphParameter1"/>
<Dictionary/>
</Global>
<Phase number="0">
<Node alternativeJavaCmdLine="java -Xmx512 -cp" enabled="enabled" graphName="${GRAPH_DIR}/test2/eig_import_match_candidate_parameter_test.grf" guiHeight="93" guiName="RunGraph" guiWidth="128" guiX="351" guiY="118" id="RUN_GRAPH0" paramsToPass="dataFileIn=${DATAIN_DIR}/test1.in" sameInstance="true" type="RUN_GRAPH"/>
<Node enabled="enabled" guiHeight="72" guiName="Trash" guiWidth="128" guiX="962" guiY="118" id="TRASH0" type="TRASH"/>
<Edge debugMode="true" fromNode="RUN_GRAPH0:0" guiBendpoints="" guiRouter="Manhattan" id="Edge1" inPort="Port 0 (in)" metadata="Metadata1" outPort="Port 0 (regular mode: status messages, pipeline mode: an information record in case of successful termination, otherwise nothing)" toNode="TRASH0:0"/>
<Edge debugMode="true" fromNode="RUN_GRAPH0:1" guiBendpoints="" guiRouter="Manhattan" id="Edge2" inPort="Port 1 (in)" metadata="Metadata1" outPort="Port 1 (in pipeline mode an information record in case of an error, otherwise nothing)" toNode="TRASH0:1"/>
</Phase>
</Graph>
<?xml version="1.0" encoding="UTF-8"?>
<Graph author="jdimond" created="Thu Jul 28 18:33:27 CDT 2011" guiVersion="3.1.0" id="1311896218018" licenseCode="CLP1DALLAN71605509BY" licenseType="Commercial Pro" modified="Tue Aug 09 11:14:32 CDT 2011" modifiedBy="mkansal" name="eig_import_test1" revision="1.367" showComponentDetails="true">
<Global>
<Metadata fileURL="${META_DIR}/eig.fmt" id="Metadata4"/>
<Metadata fileURL="${META_DIR}/EIGDefinition.fmt" id="Metadata8"/>
<Metadata fileURL="${META_DIR}/eig-with-candidate-and-attribute-id.fmt" id="Metadata18"/>
<Metadata fileURL="${META_DIR}/eig-with-data-source-id.fmt" id="Metadata9"/>
<Metadata fileURL="${META_DIR}/eig-with-ids.fmt" id="Metadata5"/>
<Metadata fileURL="${META_DIR}/eig-with-ids-and-attributes-metadata.fmt" id="Metadata28"/>
<Metadata fileURL="${META_DIR}/eig-with-ids-and-delimiter.fmt" id="Metadata23"/>
<Metadata id="Metadata22">
<Record fieldDelimiter="|" name="append_attribute_id" recordDelimiter="\r\n" type="delimited">
<Field name="append_attribute_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata1" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="append_data_source" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="id" type="long"/>
<Field name="name" type="string"/>
<Field name="description" type="string"/>
<Field format="yyyy-MM-dd HH:mm:ss" name="load_date" type="date"/>
<Field name="active_flag" type="string"/>
</Record>
</Metadata>
<Metadata id="Metadata11" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="appendAttribues" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="name" type="string"/>
<Field name="type" type="string"/>
<Field name="append_data_source_id" type="long"/>
<Field name="append_attribute_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata17" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="appendAttribute" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="append_attribute_id" type="long"/>
<Field name="append_data_source_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata13" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="appendAttribute" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="name" type="string"/>
<Field name="type" type="string"/>
</Record>
</Metadata>
<Metadata id="Metadata26">
<Record fieldDelimiter="|" name="appendAttributeNameId" recordDelimiter="\r\n" type="delimited">
<Field name="name" type="string"/>
<Field name="append_attribute_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata27" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="appendAttributeNameIds" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="attribute_name_ids" type="string"/>
<Field name="append_data_source_id" type="string"/>
</Record>
</Metadata>
<Metadata id="Metadata7">
<Record fieldDelimiter="|" name="appendAttributes" recordDelimiter="\r\n" type="delimited">
<Field name="name" type="string"/>
<Field name="type" type="string"/>
</Record>
</Metadata>
<Metadata id="Metadata6" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="appendAttributes" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="name" type="string"/>
<Field name="type" type="string"/>
</Record>
</Metadata>
<Metadata id="Metadata19" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="appendAttributes" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="id" type="long"/>
<Field name="append_data_source_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata24" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="appendAttributes" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="appendAttributes" type="string"/>
<Field name="attribute_name_ids" type="string"/>
<Field name="match_candidate_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata10">
<Record fieldDelimiter="|" name="appendAttributesOut" recordDelimiter="\r\n" type="delimited">
<Field name="id" type="number"/>
<Field name="append_data_source_id" type="number"/>
<Field name="name" type="string"/>
<Field name="data_type" type="string"/>
<Field name="sunset_flag" type="string"/>
</Record>
</Metadata>
<Metadata id="Metadata12" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="appendAttributeValue" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="value" type="string"/>
<Field name="append_attribute_id" type="string"/>
<Field name="match_candidate_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata3" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="id" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata0" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="id" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata21" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="id" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata2" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="load_process_id" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="load_process_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata14" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="load_process_id" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="load_process_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata15" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="match_candidate" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="match_candidate_id" type="long"/>
<Field name="append_data_source_id" type="long"/>
<Field name="first_name" type="string"/>
<Field name="last_name" type="string"/>
<Field name="house_number" type="string"/>
<Field name="street_name" type="string"/>
<Field name="unit" type="string"/>
<Field name="city" type="string"/>
<Field name="state" type="string"/>
<Field name="zip5" type="string"/>
<Field name="load_process_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata16" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="recordName1" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="append_data_source_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata20">
<Record fieldDelimiter="|" name="rowCount" recordDelimiter="\r\n" type="delimited">
<Field name="count" type="long"/>
</Record>
</Metadata>
<Connection database="ORACLE" id="JDBC2" jdbcSpecific="ORACLE" jndiName="jdbc/CDES" type="JDBC"/>
<Connection database="ORACLE" dbURL="jdbc:oracle:oci:@svc2tst" id="JDBC1" jdbcSpecific="ORACLE" name="cdes_oci" password="M0reG00derDatatst" type="JDBC" user="cdes"/>
<Connection database="ORACLE" dbURL="jdbc:oracle:thin:@spdb2:1521:svc2tst" id="JDBC4" jdbcSpecific="ORACLE" name="cdes_oci2" password="M0reG00derDatatst" type="JDBC" user="cdes"/>
<Connection dbDriver="oracle.jdbc.OracleDriver" dbURL="jdbc:oracle:oci:@spdb2" driverLibrary="file:C:/oracle/11.2/jdbc/lib/ojdbc6.jar" id="JDBC3" jdbcSpecific="ORACLE" name="cdes_oci3" password="M0reG00derDatatst" type="JDBC" user="cdes"/>
<Connection database="ORACLE" dbURL="jdbc:oracle:thin:@spdb2:1521:svc2tst" id="JDBC0" jdbcSpecific="ORACLE" name="cdes_thin" password="M0reG00derDatatst" type="JDBC" user="cdes"/>
<Property fileURL="workspace.prm" id="GraphParameter1"/>
<Sequence cached="8" fileURL="${SEQ_DIR}/append_attribute_sequence.cfg" id="Sequence0" name="append_attribute_seq" start="1" step="1" type="SIMPLE_SEQUENCE"/>
<LookupTable id="LookupTable0" initialSize="512" key="name" metadata="Metadata11" name="appendAttributeIdLookup" type="simpleLookup"/>
<Dictionary/>
</Global>
<Phase number="1">
<Node enabled="enabled" fileURL="${dataFileIn}" guiHeight="80" guiName="Read EIG input files" guiWidth="138" guiX="11" guiY="125" id="DATA_READER0" type="DATA_READER"/>
<Node enabled="enabled" guiHeight="67" guiName="SimpleCopy" guiWidth="128" guiX="445" guiY="204" id="SIMPLE_COPY2" type="SIMPLE_COPY"/>
<Edge fromNode="DATA_READER0:0" guiBendpoints="" guiRouter="Manhattan" id="Edge2" inPort="Port 0 (in)" metadata="Metadata4" outPort="Port 0 (output)" toNode="SIMPLE_COPY2:0"/>
<Edge fromNode="SIMPLE_COPY2:0" guiBendpoints="" guiRouter="Manhattan" id="Edge16" inPort="Port 0 (in)" metadata="Metadata4" outPort="Port 0 (out)" toNode="DATA_WRITER2:0"/>
</Phase>
<Phase number="3">
<Node enabled="enabled" fileURL="${DATAOUT_DIR}/test2/eig_append_only.txt" guiHeight="93" guiName="UniversalDataWriter" guiWidth="145" guiX="730" guiY="178" id="DATA_WRITER2" type="DATA_WRITER"/>
</Phase>
</Graph>
I have a requirement where I need to call multiple graphs by passing a parameter, e.g. the location of the input file to the DATA_READER component. I am trying to run the graph through RunGraph component and passing the parameter (location of the input file name) to that graph. However, in the graph's DATA_READER component, I need to specify the URL of input file name, which should just be a placeholder, telling it that this parameter needs to be passed through RunGraph component. However, when I run the RunGraph component, I get the below error:
Component pre-execute initialization failed. File is unreachable: /u02/clover/cdes/${dataFileIn} caused by: java.io.FileNotFoundException: /u02/clover/cdes/${dataFileIn} (No such file or directory)
This is because I am specifying the file URL in the graph's DATA_READER as ${dataFileIn}, which is not taken as a placeholder and is being evaluated for a location, which does not resolve to anything. I also tried to externalize the dataFileIn parameter in the RunGraph, but to no avail. Any help will be greatly appreciated.
Here is the code for RunGraph and the graph that I am trying to call from RunGraph:
Please let me know if I have missed some important detail or the code and I will post it.
Thanks!
<?xml version="1.0" encoding="UTF-8"?>
<Graph author="jdimond" created="Fri Aug 05 18:10:23 CDT 2011" guiVersion="3.1.0" id="1312588363284" licenseCode="CLP1DALLAN71605509BY" licenseType="Commercial Pro" modified="Tue Aug 09 10:51:26 CDT 2011" modifiedBy="mkansal" name="load_master" revision="1.92" showComponentDetails="true">
<Global>
<Metadata fileURL="${META_DIR}/rungraph_output.fmt" id="Metadata1"/>
<Metadata id="Metadata2" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="graph" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="graphParameter" type="string"/>
</Record>
</Metadata>
<Metadata id="Metadata0" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="rungraph_input" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="graph_path" type="string"/>
<Field name="command_line_argument" type="string"/>
</Record>
</Metadata>
<Property fileURL="data-in/test2/InputFileNameParameters.prm" id="GraphParameter0"/>
<Property fileURL="workspace.prm" id="GraphParameter1"/>
<Dictionary/>
</Global>
<Phase number="0">
<Node alternativeJavaCmdLine="java -Xmx512 -cp" enabled="enabled" graphName="${GRAPH_DIR}/test2/eig_import_match_candidate_parameter_test.grf" guiHeight="93" guiName="RunGraph" guiWidth="128" guiX="351" guiY="118" id="RUN_GRAPH0" paramsToPass="dataFileIn=${DATAIN_DIR}/test1.in" sameInstance="true" type="RUN_GRAPH"/>
<Node enabled="enabled" guiHeight="72" guiName="Trash" guiWidth="128" guiX="962" guiY="118" id="TRASH0" type="TRASH"/>
<Edge debugMode="true" fromNode="RUN_GRAPH0:0" guiBendpoints="" guiRouter="Manhattan" id="Edge1" inPort="Port 0 (in)" metadata="Metadata1" outPort="Port 0 (regular mode: status messages, pipeline mode: an information record in case of successful termination, otherwise nothing)" toNode="TRASH0:0"/>
<Edge debugMode="true" fromNode="RUN_GRAPH0:1" guiBendpoints="" guiRouter="Manhattan" id="Edge2" inPort="Port 1 (in)" metadata="Metadata1" outPort="Port 1 (in pipeline mode an information record in case of an error, otherwise nothing)" toNode="TRASH0:1"/>
</Phase>
</Graph>
<?xml version="1.0" encoding="UTF-8"?>
<Graph author="jdimond" created="Thu Jul 28 18:33:27 CDT 2011" guiVersion="3.1.0" id="1311896218018" licenseCode="CLP1DALLAN71605509BY" licenseType="Commercial Pro" modified="Tue Aug 09 11:14:32 CDT 2011" modifiedBy="mkansal" name="eig_import_test1" revision="1.367" showComponentDetails="true">
<Global>
<Metadata fileURL="${META_DIR}/eig.fmt" id="Metadata4"/>
<Metadata fileURL="${META_DIR}/EIGDefinition.fmt" id="Metadata8"/>
<Metadata fileURL="${META_DIR}/eig-with-candidate-and-attribute-id.fmt" id="Metadata18"/>
<Metadata fileURL="${META_DIR}/eig-with-data-source-id.fmt" id="Metadata9"/>
<Metadata fileURL="${META_DIR}/eig-with-ids.fmt" id="Metadata5"/>
<Metadata fileURL="${META_DIR}/eig-with-ids-and-attributes-metadata.fmt" id="Metadata28"/>
<Metadata fileURL="${META_DIR}/eig-with-ids-and-delimiter.fmt" id="Metadata23"/>
<Metadata id="Metadata22">
<Record fieldDelimiter="|" name="append_attribute_id" recordDelimiter="\r\n" type="delimited">
<Field name="append_attribute_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata1" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="append_data_source" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="id" type="long"/>
<Field name="name" type="string"/>
<Field name="description" type="string"/>
<Field format="yyyy-MM-dd HH:mm:ss" name="load_date" type="date"/>
<Field name="active_flag" type="string"/>
</Record>
</Metadata>
<Metadata id="Metadata11" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="appendAttribues" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="name" type="string"/>
<Field name="type" type="string"/>
<Field name="append_data_source_id" type="long"/>
<Field name="append_attribute_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata17" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="appendAttribute" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="append_attribute_id" type="long"/>
<Field name="append_data_source_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata13" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="appendAttribute" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="name" type="string"/>
<Field name="type" type="string"/>
</Record>
</Metadata>
<Metadata id="Metadata26">
<Record fieldDelimiter="|" name="appendAttributeNameId" recordDelimiter="\r\n" type="delimited">
<Field name="name" type="string"/>
<Field name="append_attribute_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata27" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="appendAttributeNameIds" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="attribute_name_ids" type="string"/>
<Field name="append_data_source_id" type="string"/>
</Record>
</Metadata>
<Metadata id="Metadata7">
<Record fieldDelimiter="|" name="appendAttributes" recordDelimiter="\r\n" type="delimited">
<Field name="name" type="string"/>
<Field name="type" type="string"/>
</Record>
</Metadata>
<Metadata id="Metadata6" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="appendAttributes" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="name" type="string"/>
<Field name="type" type="string"/>
</Record>
</Metadata>
<Metadata id="Metadata19" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="appendAttributes" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="id" type="long"/>
<Field name="append_data_source_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata24" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="appendAttributes" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="appendAttributes" type="string"/>
<Field name="attribute_name_ids" type="string"/>
<Field name="match_candidate_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata10">
<Record fieldDelimiter="|" name="appendAttributesOut" recordDelimiter="\r\n" type="delimited">
<Field name="id" type="number"/>
<Field name="append_data_source_id" type="number"/>
<Field name="name" type="string"/>
<Field name="data_type" type="string"/>
<Field name="sunset_flag" type="string"/>
</Record>
</Metadata>
<Metadata id="Metadata12" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="appendAttributeValue" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="value" type="string"/>
<Field name="append_attribute_id" type="string"/>
<Field name="match_candidate_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata3" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="id" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata0" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="id" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata21" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="id" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata2" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="load_process_id" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="load_process_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata14" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="load_process_id" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="load_process_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata15" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="match_candidate" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="match_candidate_id" type="long"/>
<Field name="append_data_source_id" type="long"/>
<Field name="first_name" type="string"/>
<Field name="last_name" type="string"/>
<Field name="house_number" type="string"/>
<Field name="street_name" type="string"/>
<Field name="unit" type="string"/>
<Field name="city" type="string"/>
<Field name="state" type="string"/>
<Field name="zip5" type="string"/>
<Field name="load_process_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata16" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter="|" name="recordName1" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" type="delimited">
<Field name="append_data_source_id" type="long"/>
</Record>
</Metadata>
<Metadata id="Metadata20">
<Record fieldDelimiter="|" name="rowCount" recordDelimiter="\r\n" type="delimited">
<Field name="count" type="long"/>
</Record>
</Metadata>
<Connection database="ORACLE" id="JDBC2" jdbcSpecific="ORACLE" jndiName="jdbc/CDES" type="JDBC"/>
<Connection database="ORACLE" dbURL="jdbc:oracle:oci:@svc2tst" id="JDBC1" jdbcSpecific="ORACLE" name="cdes_oci" password="M0reG00derDatatst" type="JDBC" user="cdes"/>
<Connection database="ORACLE" dbURL="jdbc:oracle:thin:@spdb2:1521:svc2tst" id="JDBC4" jdbcSpecific="ORACLE" name="cdes_oci2" password="M0reG00derDatatst" type="JDBC" user="cdes"/>
<Connection dbDriver="oracle.jdbc.OracleDriver" dbURL="jdbc:oracle:oci:@spdb2" driverLibrary="file:C:/oracle/11.2/jdbc/lib/ojdbc6.jar" id="JDBC3" jdbcSpecific="ORACLE" name="cdes_oci3" password="M0reG00derDatatst" type="JDBC" user="cdes"/>
<Connection database="ORACLE" dbURL="jdbc:oracle:thin:@spdb2:1521:svc2tst" id="JDBC0" jdbcSpecific="ORACLE" name="cdes_thin" password="M0reG00derDatatst" type="JDBC" user="cdes"/>
<Property fileURL="workspace.prm" id="GraphParameter1"/>
<Sequence cached="8" fileURL="${SEQ_DIR}/append_attribute_sequence.cfg" id="Sequence0" name="append_attribute_seq" start="1" step="1" type="SIMPLE_SEQUENCE"/>
<LookupTable id="LookupTable0" initialSize="512" key="name" metadata="Metadata11" name="appendAttributeIdLookup" type="simpleLookup"/>
<Dictionary/>
</Global>
<Phase number="1">
<Node enabled="enabled" fileURL="${dataFileIn}" guiHeight="80" guiName="Read EIG input files" guiWidth="138" guiX="11" guiY="125" id="DATA_READER0" type="DATA_READER"/>
<Node enabled="enabled" guiHeight="67" guiName="SimpleCopy" guiWidth="128" guiX="445" guiY="204" id="SIMPLE_COPY2" type="SIMPLE_COPY"/>
<Edge fromNode="DATA_READER0:0" guiBendpoints="" guiRouter="Manhattan" id="Edge2" inPort="Port 0 (in)" metadata="Metadata4" outPort="Port 0 (output)" toNode="SIMPLE_COPY2:0"/>
<Edge fromNode="SIMPLE_COPY2:0" guiBendpoints="" guiRouter="Manhattan" id="Edge16" inPort="Port 0 (in)" metadata="Metadata4" outPort="Port 0 (out)" toNode="DATA_WRITER2:0"/>
</Phase>
<Phase number="3">
<Node enabled="enabled" fileURL="${DATAOUT_DIR}/test2/eig_append_only.txt" guiHeight="93" guiName="UniversalDataWriter" guiWidth="145" guiX="730" guiY="178" id="DATA_WRITER2" type="DATA_WRITER"/>
</Phase>
</Graph>
-
Hello, there are to ways to pass parameters to another graph. Both require the second graph to have an internal parameter called dataFileIn defined.
Your first option is to run the second graph in the same JVM. In this case, you are able to pass parameters with the same name. In your case, you create an internal parameter dataFileIn also in your first graph and set it to desired value (${DATAIN_DIR}/test1.in). In the RunGraph component you need to set the "Graph parameters to pass" attribute to dataFileIn. When you run the graph now, the value of the dataFileIn parameter will be passed to the second graph an the second graph will be run will its dataFileIn parameter set to this value (${DATAIN_DIR}/test1.in).
The second option is to run the second graph in another JVM ("The same JVM" attribute of the RunGraph component set to false"). In this case you need to set the "Command line arguments" attribute to -P:dataFileIn=${DATAIN_DIR}/customers.dat or generaly -P:parameterName=parameterValue.
Please sign in to leave a comment.
Comments 1