Gel Script Execution error in local machine - Client

Unspecified folder path error

better to install XOG Client folder with out space, so that we can avoid "unspecified error"


Install XOG client C:XOG not in

C:\Program Files (x86)\CA\Clarity\CA Clarity PPM XOG\bin

Clarity Gel Script For Updating the Task attribute based on project attribute

<gel:script
xmlns:core="jelly:core"
xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"
xmlns:sql="jelly:sql" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&rt;
<gel:setDataSource dbId="Niku"/&rt;
<core:catch var="v_exception_WBSO"&rt;
<sql:query var="qry_get_WBSO"&rt;
select
case odf.wbso_subsidy
when 'ws_yes' then 'Yes'
else 'No'
end wbso_subsidy
from odf_ca_project odf,prtask prt
where odf.id=prt.prprojectid
and prt.prid=(${gel_objectInstanceId})
</sql:query&rt;
<gel:log&rt;Update WBSO on Task level.(${gel_objectInstanceId})</gel:log&rt;

</core:catch&rt;
<core:choose&rt;
<core:when test="${v_exception_WBSO eq null}"&rt;
<core:set value="${qry_get_WBSO.rows[0].wbso_subsidy}" var="var_wbso"/&rt;
<gel:log&rt;Update var_wbso on Task level.(${var_wbso})</gel:log&rt;
<core:catch var="v_exception_update"&rt;
<sql:update&rt;
update odf_ca_task set wbso100 = ? where id=(${gel_objectInstanceId})
<sql:param value="${var_wbso}"/&rt;
</sql:update&rt;
</core:catch&rt;
<core:choose&rt;
<core:when test="${v_exception_update != null}"&rt;
<gel:log category="Update" level="ERROR"&rt;
Failure: Update WBSO on Task level.
</gel:log&rt;
</core:when&rt;
<core:otherwise/&rt;
</core:choose&rt;
</core:when&rt;
<core:otherwise&rt;
<gel:log&rt;Error in getting the WBSO of the project. ${v_exception_WBSO}</gel:log&rt;
        </core:otherwise&rt;
    </core:choose&rt;
</gel:script&rt;