Hello!
Running the graph via Workbench CoverETL runs successfully, however the graph errors out when running from the command line (using *.grf) during the aggregate:
ERROR [main] - [AGGREGATE0] - org.jetel.component.aggregate.AggregationException: Invalid mapping '$EID:=firstnonnull($EID)' :
The EID is mapped:
<Field delimiter="|" name="EID" nullable="true" shift="0" skipFirstLine="false" type="string"/>
<Node aggregateKey="[b]EID" enabled="enabled" guiHeight="0" guiName="Aggregate" guiWidth="0" guiX="491" guiY="265" id="AGGREGATE0" mapping="$EID:=firstnonnull($EID);$LASTNAME:=firstnonnull($LASTNAME);" sorted="false" type="AGGREGATE"/>[/b]
<Edge fromNode="AGGREGATE0:0" guiBendpoints="" id="Edge2" inPort="Port 0 (in)" metadata="Metadata0" outPort="Port 0 (out)" toNode="DB_OUTPUT_TABLE1:0"/>
Any ideas as to why it would error out? The graph runs file through the GUI. See attached for a visual of the graph.
Thanks in advance!!
Running the graph via Workbench CoverETL runs successfully, however the graph errors out when running from the command line (using *.grf) during the aggregate:
ERROR [main] - [AGGREGATE0] - org.jetel.component.aggregate.AggregationException: Invalid mapping '$EID:=firstnonnull($EID)' :
The EID is mapped:
<Field delimiter="|" name="EID" nullable="true" shift="0" skipFirstLine="false" type="string"/>
<Node aggregateKey="[b]EID" enabled="enabled" guiHeight="0" guiName="Aggregate" guiWidth="0" guiX="491" guiY="265" id="AGGREGATE0" mapping="$EID:=firstnonnull($EID);$LASTNAME:=firstnonnull($LASTNAME);" sorted="false" type="AGGREGATE"/>[/b]
<Edge fromNode="AGGREGATE0:0" guiBendpoints="" id="Edge2" inPort="Port 0 (in)" metadata="Metadata0" outPort="Port 0 (out)" toNode="DB_OUTPUT_TABLE1:0"/>
Any ideas as to why it would error out? The graph runs file through the GUI. See attached for a visual of the graph.
Thanks in advance!!
Comments (6)