michael.f.brunak

XOGing Transactions in using GEL and SQL script - Tag error

Discussion created by michael.f.brunak on Oct 12, 2010
Latest reply on Oct 12, 2010 by fpena
I am able to get the GEL script to execute and connect with XOG. However, I cannot find the correct syntax for one line from another example that I copied.

BPM-0704: An error occurred while executing custom script: org.apache.commons.jelly.JellyTagException: null:110:94: <gel:set> Missing or invalid XML at com.niku.union.gel.tags.SetTag.doTag(SetTag.java:137) at
. . .
ava.lang.Thread.run(Thread.java:595) Caused by: org.apache.commons.jelly.JellyTagException: null:-1:-1: <null> <gel:set> attribute 'select' $:v_xml_rootchild::NikuDataBus/child::transactions does not refer to an existing node. at com.niku.union.gel.tags.SetTag.doTag(SetTag.java:72) ... 14 more Root cause org.apache.commons.jelly.JellyTagException: null:-1:-1: <null> <gel:set> attribute 'select' $:v_xml_rootchild::NikuDataBus/child::transactions does not refer to an existing node. at com.niku.union.gel.tags.SetTag.doTag(SetTag.java:72) at

In the example below the last gel:set select statement is looking for the correct node for importing transactions.
Any thoughts? Is there a reference document or xsd file? Thanks




<core:forEach items="${qPCR.rowsByIndex}" var="row">


<core:set var="vs_res_unique_name">${row[0]}</core:set>


<core:set var="vs_res_first_name">${row[1]}</core:set>


<core:set var="vs_res_last_name">${row[2]}</core:set>


<core:set var="vs_res_email">${row[3]}</core:set>


<!--########################################## -->


<!-- 6 Format looped data relevant into XOG format --> <!-- EXAMPLE ONLY -->


<!--########################################## -->


<gel:parse var="user_data">




<Transaction projectID="16491" resourceID="mford" transactionDate="2010-04-28" units="1" actualCostRate="80" billRate="80" taskID="6917289" chargeable="1" chargeCode="operating" importStatus="N" transactionType="L" inputTypeCode="REG" transactionClass="355" externalID=""/>


</gel:parse>


<!--########################################## -->


<!-- 7 Merge looped data into XOG shell --> <!-- EXAMPLE ONLY -->


<!--########################################## -->


<gel:set value="${user_data}" select="$v_xml_root/NikuDataBus/transactions" insert="true"/>

</core:forEach>

Outcomes