deepakallscripts

All records are not processed in GEL SCRIPT

Discussion created by deepakallscripts on Dec 16, 2013
Latest reply on Dec 18, 2013 by Dave

I have created custom Field in INV_INVESTMENTS with name as "TRACK_ASSIGN_ONLY". I am writing gel script which will set value of this field to "True" if that project is active.

My script works fine for 2-3 projects i.e i execute gel script with " code in ('9022','387030') ". But when i execute for all active records, It doesn't update any of records but process shows as completed successfully.

Any reason behind such behavior ? Is there any limit of records that can be processed in Gel script.

 

Here is my gel script content :

 

el:set asString="true"
  select="$auth/SOAP-ENV:Envelope/SOAP-ENV:Body/xog:SessionID/text()" var="sessionID"/>
  <!--Fetch rows from the excel sheet-->
  
 
      <soap:invoke
      endpoint="http://localhost/niku/xog" var="runresult">
        <soap:message>
          <soapenv:Envelope
          xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xog="http://www.niku.com/xog">
            <soapenv:Header>
              <xog:Auth>
                <xog:SessionID>${sessionID}</xog:SessionID>
              </xog:Auth>
            </soapenv:Header>
            <soapenv:Body>
 
 
              <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd">
                <Header action="write" externalSource="NIKU" objectType="project" version="12.1.3.1361"/>
                <Projects>
 
<sql:query var="results" escapeText="false" dataSource="${ClarityDS}">
select code, name from inv_investments where code in ('9022','387030') and is_active = 1
</sql:query>
<core:choose>
<core:forEach items="${results.rowsByIndex}" var="row">
<core:set var="PROJECTCODE">${row[0]}</core:set>
<core:set var="PROJECTNAME">${row[1]}</core:set>
<Project active="true" name="${PROJECTNAME}" projectID = "${PROJECTCODE}" allowAssignedTasksOnly="1">   
</Project>
</core:forEach>
</core:choose>
</Projects>
              </NikuDataBus>
            </soapenv:Body>
          </soapenv:Envelope>
        </soap:message>
      </soap:invoke>    

Outcomes