Process With [XOG]Exception while Parsing

[Sai95]

Hello all,

I am getting this error when a process is executed and i am in no clue about what is happening. The process worked fine till previous month and it throws an error now.

 

Please help as this is a high priority issue currently to me and is very urgent.

 

[XOG]Exception while Parsing the XML:org.apache.commons.jelly.JellyTagException: null:198:44: <gel:parse> Premature end of file. in ca ppm.

 

Thanks and Regards,

Sai Charan Pasumarthi.

[David Morton]

You have not told us much about your process!

 

It looks like your process is calling XOG? So is it a GEL script - and is it possible that the data that the GEL script is using has caused a syntax error with the XML that it is building up to be passed to XOG?

 

(GUESSing obviously)

[Sai95]

Hi David,

Thanks for getting back on this very soon.

That is the error i get when i run the process and below is the code for the process.

 

 

 

<gel:script xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:bpm="jelly:com.niku.bpm.gel.BPMTagLibrary" xmlns:core="jelly:core" xmlns:file="jelly:com.niku.union.gel.FileTagLibrary"
xmlns:fn="http://java.sun.com/jsp/jstl/functions" xmlns:ftp="jelly:com.niku.union.gel.FTPTagLibrary"
xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary" xmlns:obj="http://www.niku.com/xog/Object" xmlns:soap="jelly:com.niku.union.gel.SOAPTagLibrary"
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:sql="jelly:sql" xmlns:util="jelly:util"
xmlns:x="jelly:org.apache.commons.jelly.tags.xml.XMLTagLibrary" xmlns:xog="http://www.niku.com/xog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<!--**************************************************************************************************************************
**Modification History Start**
**======================================================================================================================
** Name :-
Created Date :- 21-Oct-2016
Description :- Release Management Fields Update
Created By :-
Description :-
Modified Date :-
Modified By :-
Modified Version -
**======================================================================================================================**
**Modification History End**
************************************************************************************************************************** -->
<!--###Read credentials from Property file, which is in SFTP Location END### -->
<!--Set Database ID START -->
<gel:setDataSource dbId="niku" var="nikuDS"/>
<gel:parameter var="userName"/>
<gel:parameter var="debugFlag"/>
<core:set value="0" var="test_len"/>
<!--Set Database ID END -->
<!--###Check DB Connection and raise exception if connection is not established START###-->
<core:catch var="ChkDBConnection">
<sql:query dataSource="${nikuDS}" var="chkdb">Select 1 from dual</sql:query>
</core:catch>
<!--#### Check DB Connection and raise exception if connection is not established END ###-->
<core:choose>
<core:when test="${ChkDBConnection != NULL}">
<gel:log level="ERROR">******** ERROR IN DB CONNECTION ********</gel:log>
</core:when>
<core:otherwise>
<core:catch var="v_exception">
<sql:query dataSource="${nikuDS}" escapeText="0" var="q_rej_queryresult"><![CDATA[
SELECT
I.NAME
,i.code
,p.prname prname
,p.PREXTERNALID TaskID
,p.PRWBSLEVEL
,odf.rls_target
,trls.RLS_DEVELOPMENT_ORG z_rel_dev_org
,trls.RLS_PKG_NAME_FILTER z_rel_pack_levl_name
,trls.TARGET_QTR rls_qtr
,NVL(TRG_RLS_ID_AUD.TARGET_RLS_OLD_VALUE,0) TARGET_RLS_OLD_VALUE
,NVL(TRG_RLS_ID_AUD.TARGET_RLS_NEW_VALUE,0) TARGET_RLS_NEW_VALUE
,odf.tsk_commitment_statu
,NVL(ACT_RLS_AUD.ACTUAL_RLS_OLD_VAL,0) ACTUAL_RLS_OLD_VAL
,NVL(ACT_RLS_AUD.ACTUAL_RLS_NEW_VAL,0) ACTUAL_RLS_NEW_VAL
,NVL(CMNT_STS_AUD.COMMITMENT_STATUS_OLD_VAL,0) COMMITMENT_STATUS_OLD_VAL
,NVL(CMNT_STS_AUD.COMMITMENT_STATUS_NEW_VAL,0) COMMITMENT_STATUS_NEW_VAL
,(case when trls.rls_curr_date is not null then to_char(trls.rls_curr_date,'YYYY-MM-DD')||'T'||to_char(trls.rls_curr_date,'HH24:MI:SS')
else to_char(trls.rls_curr_date,'YYYY-MM-DD') end ) z_target_rel_date

,odf.z_orig_rls_id
,(case when odf.z_origi_rel_date is not NULL THEN TO_CHAR(odf.z_origi_rel_date,'YYYY-MM-DD')||'T'||TO_CHAR(odf.z_origi_rel_date,'HH24:MI:SS')
ELSE ' ' END )z_origi_rel_date
,odf.z_baseline_rls_id
,(case when odf.z_baseline_rel_date is not NULL THEN TO_CHAR(odf.z_baseline_rel_date,'YYYY-MM-DD')||'T'||TO_CHAR(odf.z_baseline_rel_date,'HH24:MI:SS')
ELSE ' ' END )z_baseline_rel_date
,odf.z_actual_rls_id

,(case when arls.rls_curr_date is not null then to_char(arls.rls_curr_date,'YYYY-MM-DD')||'T'||to_char(arls.rls_curr_date,'HH24:MI:SS')
else to_char(arls.rls_curr_date,'YYYY-MM-DD') end ) z_act_rel_date
,PROCESS_DETAILS.process_version_id
,PROCESS_DETAILS.PRC_OBJ_NAME
,PROCESS_DETAILS2.process_version_id2
,PROCESS_DETAILS2.PRC_OBJ_NAME2
,PROCESS_DETAILS3.process_version_id3
,PROCESS_DETAILS3.PRC_OBJ_NAME3
,PROCESS_DETAILS4.process_version_id4
,PROCESS_DETAILS4.PRC_OBJ_NAME4
,odf.z_select_release
,odf.z_actal_rel_id_ronly

FROM INV_INVESTMENTS i
join prtask p on p.PRPROJECTID=i.id
JOIN ODF_CA_TASK ODF ON ODF.ID=p.PRID
LEFT OUTER JOIN odf_ca_rls_mgnt trls ON trls.name = odf.RLS_TARGET
LEFT OUTER JOIN odf_ca_rls_mgnt arls ON arls.name = odf.Z_ACTUAL_RLS_ID
LEFT OUTER JOIN odf_ca_rls_mgnt orls ON orls.name = odf.Z_ORIG_RLS_ID
LEFT OUTER JOIN odf_ca_rls_mgnt brls ON brls.name = odf.Z_BASELINE_RLS_ID
JOIN (SELECT
CM_AUD.RAW_VALUE_BEFORE TARGET_RLS_OLD_VALUE
,CM_AUD.RAW_VALUE_AFTER TARGET_RLS_NEW_VALUE
,CM_AUD.OBJECT_ID
FROM CMN_AUDITS CM_AUD
JOIN
(SELECT MAX(CREATED_DATE) CRTD_DTE,OBJECT_ID FROM CMN_AUDITS
WHERE ATTRIBUTE_CODE='rls_target' AND OBJECT_CODE='task'
GROUP BY OBJECT_ID)CMN ON CMN.CRTD_DTE=CM_AUD.CREATED_DATE AND CMN.OBJECT_ID=CM_AUD.OBJECT_ID
WHERE CM_AUD.ATTRIBUTE_CODE='rls_target' AND CM_AUD.OBJECT_CODE='task') TRG_RLS_ID_AUD ON TRG_RLS_ID_AUD.OBJECT_ID=ODF.ID
LEFT JOIN(SELECT
CM_AUD.RAW_VALUE_BEFORE ACTUAL_RLS_OLD_VAL
,CM_AUD.RAW_VALUE_AFTER ACTUAL_RLS_NEW_VAL
,CM_AUD.OBJECT_ID
FROM CMN_AUDITS CM_AUD
JOIN
(SELECT MAX(CREATED_DATE) CRTD_DTE,OBJECT_ID FROM CMN_AUDITS
WHERE ATTRIBUTE_CODE='z_actual_rls_id' AND OBJECT_CODE='task'
GROUP BY OBJECT_ID)CMN ON CMN.CRTD_DTE=CM_AUD.CREATED_DATE AND CMN.OBJECT_ID=CM_AUD.OBJECT_ID
WHERE CM_AUD.ATTRIBUTE_CODE='z_actual_rls_id' AND CM_AUD.OBJECT_CODE='task')ACT_RLS_AUD ON ACT_RLS_AUD.OBJECT_ID=ODF.ID
LEFT JOIN(SELECT
CM_AUD.RAW_VALUE_BEFORE COMMITMENT_STATUS_OLD_VAL
,CM_AUD.RAW_VALUE_AFTER COMMITMENT_STATUS_NEW_VAL
,CM_AUD.OBJECT_ID
FROM CMN_AUDITS CM_AUD
JOIN
(SELECT MAX(CREATED_DATE) CRTD_DTE,OBJECT_ID FROM CMN_AUDITS
WHERE ATTRIBUTE_CODE='tsk_commitment_statu' AND OBJECT_CODE='task'
GROUP BY OBJECT_ID)CMN ON CMN.CRTD_DTE=CM_AUD.CREATED_DATE AND CMN.OBJECT_ID=CM_AUD.OBJECT_ID
WHERE CM_AUD.ATTRIBUTE_CODE='tsk_commitment_statu' AND CM_AUD.OBJECT_CODE='task')CMNT_STS_AUD ON CMNT_STS_AUD.OBJECT_ID=ODF.ID
LEFT JOIN (SELECT
CM_AUD.RAW_VALUE_BEFORE RLS_TYP_AUD_OLD_VALUE
,CM_AUD.RAW_VALUE_AFTER RLS_TYP_AUD_NEW_VALUE
,CM_AUD.OBJECT_ID
FROM CMN_AUDITS CM_AUD
JOIN
(SELECT MAX(CREATED_DATE) CRTD_DTE,OBJECT_ID FROM CMN_AUDITS
WHERE ATTRIBUTE_CODE='z_rlease_type' AND OBJECT_CODE='task'
GROUP BY OBJECT_ID)CMN ON CMN.CRTD_DTE=CM_AUD.CREATED_DATE AND CMN.OBJECT_ID=CM_AUD.OBJECT_ID
WHERE CM_AUD.ATTRIBUTE_CODE='z_rlease_type' AND CM_AUD.OBJECT_CODE='task') RLS_TYP_AUD ON
RLS_TYP_AUD.OBJECT_ID=ODF.ID
LEFT JOIN(SELECT
CM_AUD.RAW_VALUE_BEFORE SELECT_RLS_OLD_VAL
,CM_AUD.RAW_VALUE_AFTER SELECT_RLS_NEW_VAL
,CM_AUD.OBJECT_ID
FROM CMN_AUDITS CM_AUD
JOIN
(SELECT MAX(CREATED_DATE) CRTD_DTE,OBJECT_ID FROM CMN_AUDITS
WHERE ATTRIBUTE_CODE='z_select_release' AND OBJECT_CODE='task'
GROUP BY OBJECT_ID)CMN ON CMN.CRTD_DTE=CM_AUD.CREATED_DATE AND CMN.OBJECT_ID=CM_AUD.OBJECT_ID
WHERE CM_AUD.ATTRIBUTE_CODE='z_select_release' AND CM_AUD.OBJECT_CODE='task')SEL_RLS_AUD ON
SEL_RLS_AUD.OBJECT_ID=ODF.ID
join (SELECT
bdpv.id process_version_id,
bdo.object_name PRC_OBJ_NAME
FROM
bpm_def_processes bdp,
bpm_def_process_versions bdpv,
bpm_def_objects bdo
WHERE bdpv.process_id = bdp.id
and bdo.pk_id = bdpv.id
and bdp.process_code = 'z_locking_rls_mngmnt_fields'
and (bdo.is_system = 0 or bdo.is_system is null))PROCESS_DETAILS ON 1=1
join (SELECT
bdpv.id process_version_id2,
bdo.object_name PRC_OBJ_NAME2
FROM
bpm_def_processes bdp,
bpm_def_process_versions bdpv,
bpm_def_objects bdo
WHERE bdpv.process_id = bdp.id
and bdo.pk_id = bdpv.id
and bdp.process_code = 'z_lock_planned_quarter'
and (bdo.is_system = 0 or bdo.is_system is null))PROCESS_DETAILS2 ON 1=1
join (SELECT
bdpv.id process_version_id3,
bdo.object_name PRC_OBJ_NAME3
FROM
bpm_def_processes bdp,
bpm_def_process_versions bdpv,
bpm_def_objects bdo
WHERE bdpv.process_id = bdp.id
and bdo.pk_id = bdpv.id
and bdp.process_code = 'z_lck_actual_rel_id'
and (bdo.is_system = 0 or bdo.is_system is null))PROCESS_DETAILS3 ON 1=1
join (SELECT
bdpv.id process_version_id4,
bdo.object_name PRC_OBJ_NAME4
FROM
bpm_def_processes bdp,
bpm_def_process_versions bdpv,
bpm_def_objects bdo
WHERE bdpv.process_id = bdp.id
and bdo.pk_id = bdpv.id
and bdp.process_code = 'z_unlocking_planned_qtr'
and (bdo.is_system = 0 or bdo.is_system is null))PROCESS_DETAILS4 ON 1=1
WHERE i.id=(SELECT PRPROJECTID FROM PRTASK WHERE PRID=${gel_objectInstanceId})
AND P.PRID=${gel_objectInstanceId}
]]></sql:query>
</core:catch>
<core:choose>
<core:when test="${v_exception != NULL}">
<gel:log level="ERROR">Caught Exception was: ${v_exception}</gel:log>
</core:when>
<core:when test="${q_rej_queryresult.rowCount == 0}">
<gel:log level="INFO">No records found</gel:log>
</core:when>
<core:otherwise>
<!--Preparing XML -->
<core:catch var="v_parsed_exception">
<gel:parse var="v_sub_ins_xog">
<!-- Only Current Release ID Selected-->
<core:if test="${ q_rej_queryresult.rows[0].rls_target != null and (q_rej_queryresult.rows[0].TARGET_RLS_NEW_VALUE != q_rej_queryresult.rows[0].TARGET_RLS_OLD_VALUE ) and (q_rej_queryresult.rows[0].tsk_commitment_statu == null or q_rej_queryresult.rows[0].tsk_commitment_statu != 'committed')}">
<gel:log>In first if</gel:log>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd">
<Header action="write" externalSource="NIKU" objectType="project" version="13.3.0.286"/>
<Projects>
<Project name="${q_rej_queryresult.rows[0].name}" projectID="${q_rej_queryresult.rows[0].code}">
<Tasks>
<Task name="${q_rej_queryresult.rows[0].prname}" outlineLevel="${q_rej_queryresult.rows[0].PRWBSLEVEL}" taskID="${q_rej_queryresult.rows[0].TaskID}">
<CustomInformation>
<ColumnValue name="rls_target">${q_rej_queryresult.rows[0].rls_target}</ColumnValue>
<ColumnValue name="rls_qtr">${q_rej_queryresult.rows[0].rls_qtr}</ColumnValue>
<ColumnValue name="z_rel_dev_org">${q_rej_queryresult.rows[0].z_rel_dev_org}</ColumnValue>
<ColumnValue name="z_rel_pack_levl_name">${q_rej_queryresult.rows[0].z_rel_pack_levl_name}</ColumnValue>
<ColumnValue name="z_target_rel_date">${q_rej_queryresult.rows[0].z_target_rel_date}</ColumnValue>
</CustomInformation>
<core:set value="1" var="targetUserId"/>
<core:set value="${gel_objectInstanceId}" var="targetObjectId"/>
<core:set value="${q_rej_queryresult.rows[0].process_version_id2}" var="targetProcessId"/>
<core:set value="${q_rej_queryresult.rows[0].PRC_OBJ_NAME2}" var="targetObjectKey"/>
<bpm:startProcess initObjectId="${targetObjectId}" initObjectKey="${targetObjectKey}" initUserId="${targetUserId}" processVersionId="${targetProcessId}"/>
</Task>
</Tasks>
</Project>
</Projects>
</NikuDataBus>
</core:if>
<!-- When Current Release ID is Deleted -->
<core:if test="${(q_rej_queryresult.rows[0].rls_target == null and (q_rej_queryresult.rows[0].TARGET_RLS_NEW_VALUE != q_rej_queryresult.rows[0].TARGET_RLS_OLD_VALUE))}">
<gel:log>In second if</gel:log>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd">
<Header action="write" externalSource="NIKU" objectType="project" version="13.3.0.286"/>
<Projects>
<Project name="${q_rej_queryresult.rows[0].name}" projectID="${q_rej_queryresult.rows[0].code}">
<Tasks>
<Task name="${q_rej_queryresult.rows[0].prname}" outlineLevel="${q_rej_queryresult.rows[0].PRWBSLEVEL}" taskID="${q_rej_queryresult.rows[0].TaskID}">
<CustomInformation>
<ColumnValue name="rls_target">${q_rej_queryresult.rows[0].rls_target}</ColumnValue>
<ColumnValue name="rls_qtr"/>
<ColumnValue name="tsk_commitment_statu">${q_rej_queryresult.rows[0].tsk_commitment_statu}</ColumnValue>
<ColumnValue name="z_rel_dev_org">NA</ColumnValue>
<ColumnValue name="z_rel_pack_levl_name">NA</ColumnValue>
<ColumnValue name="z_target_rel_date">2099-12-31T00:00:00</ColumnValue>
</CustomInformation>
<core:set value="1" var="targetUserId"/>
<core:set value="${gel_objectInstanceId}" var="targetObjectId"/>
<core:set value="${q_rej_queryresult.rows[0].process_version_id4}" var="targetProcessId"/>
<core:set value="${q_rej_queryresult.rows[0].PRC_OBJ_NAME4}" var="targetObjectKey"/>
<bpm:startProcess initObjectId="${targetObjectId}" initObjectKey="${targetObjectKey}" initUserId="${targetUserId}" processVersionId="${targetProcessId}"/>
</Task>
</Tasks>
</Project>
</Projects>
</NikuDataBus>
</core:if>
<!-- Current Release ID is not null and Committment Status is Committed -->
<core:if test="${((q_rej_queryresult.rows[0].rls_target != null ) and (q_rej_queryresult.rows[0].tsk_commitment_statu == 'committed') and (q_rej_queryresult.rows[0].COMMITMENT_STATUS_OLD_VAL != q_rej_queryresult.rows[0].COMMITMENT_STATUS_NEW_VAL) and q_rej_queryresult.rows[0].z_actual_rls_id ==null)}">
<gel:log>In third if</gel:log>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd">
<Header action="write" externalSource="NIKU" objectType="project" version="13.3.0.286"/>
<Projects>
<Project name="${q_rej_queryresult.rows[0].name}" projectID="${q_rej_queryresult.rows[0].code}">
<Tasks>
<Task name="${q_rej_queryresult.rows[0].prname}" outlineLevel="${q_rej_queryresult.rows[0].PRWBSLEVEL}" taskID="${q_rej_queryresult.rows[0].TaskID}">
<CustomInformation>
<ColumnValue name="rls_target">${q_rej_queryresult.rows[0].rls_target}</ColumnValue>
<ColumnValue name="rls_qtr">${q_rej_queryresult.rows[0].rls_qtr}</ColumnValue>
<ColumnValue name="tsk_commitment_statu">${q_rej_queryresult.rows[0].tsk_commitment_statu}</ColumnValue>
<ColumnValue name="z_rel_dev_org">${q_rej_queryresult.rows[0].z_rel_dev_org}</ColumnValue>
<ColumnValue name="z_rel_pack_levl_name">${q_rej_queryresult.rows[0].z_rel_pack_levl_name}</ColumnValue>
<ColumnValue name="z_target_rel_date">${q_rej_queryresult.rows[0].z_target_rel_date}</ColumnValue>
<core:if test="${(q_rej_queryresult.rows[0].z_orig_rls_id == 'Not Yet Set' ) }">
<ColumnValue name="z_origi_rel_date">${q_rej_queryresult.rows[0].z_target_rel_date}</ColumnValue>
<ColumnValue name="z_orig_rls_id">${q_rej_queryresult.rows[0].rls_target}</ColumnValue>
</core:if>
<core:if test="${(q_rej_queryresult.rows[0].z_baseline_rls_id == 'Not Yet Set' ) }">
<ColumnValue name="z_baseline_rel_date">${q_rej_queryresult.rows[0].z_target_rel_date}</ColumnValue>
<ColumnValue name="z_baseline_rls_id">${q_rej_queryresult.rows[0].rls_target}</ColumnValue>
</core:if>
</CustomInformation>
<core:set value="1" var="targetUserId"/>
<core:set value="${gel_objectInstanceId}" var="targetObjectId"/>
<core:set value="${q_rej_queryresult.rows[0].process_version_id}" var="targetProcessId"/>
<core:set value="${q_rej_queryresult.rows[0].PRC_OBJ_NAME}" var="targetObjectKey"/>
<bpm:startProcess initObjectId="${targetObjectId}" initObjectKey="${targetObjectKey}" initUserId="${targetUserId}" processVersionId="${targetProcessId}"/>
</Task>
</Tasks>
</Project>
</Projects>
</NikuDataBus>
</core:if>
<!-- Update Actual Release ID Read only field and Date -->
<core:if test="${((q_rej_queryresult.rows[0].rls_target != null ) and (q_rej_queryresult.rows[0].tsk_commitment_statu == 'committed') and (q_rej_queryresult.rows[0].COMMITMENT_STATUS_OLD_VAL != q_rej_queryresult.rows[0].COMMITMENT_STATUS_NEW_VAL) and q_rej_queryresult.rows[0].z_actual_rls_id !=null)}">
<gel:log>In Fourth if</gel:log>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd">
<Header action="write" externalSource="NIKU" objectType="project" version="13.3.0.286"/>
<Projects>
<Project name="${q_rej_queryresult.rows[0].name}" projectID="${q_rej_queryresult.rows[0].code}">
<Tasks>
<Task name="${q_rej_queryresult.rows[0].prname}" outlineLevel="${q_rej_queryresult.rows[0].PRWBSLEVEL}" taskID="${q_rej_queryresult.rows[0].TaskID}">
<CustomInformation>
<core:if test="${(q_rej_queryresult.rows[0].RLS_TYP_AUD_OLD_VALUE =='Target' and q_rej_queryresult.rows[0].rls_target != q_rej_queryresult.rows[0].SELECT_RLS_OLD_VAL) }">
<ColumnValue name="rls_target">${q_rej_queryresult.rows[0].rls_target}</ColumnValue>
<ColumnValue name="rls_qtr">${q_rej_queryresult.rows[0].rls_qtr}</ColumnValue>
<ColumnValue name="z_rel_dev_org">${q_rej_queryresult.rows[0].z_rel_dev_org}</ColumnValue>
<ColumnValue name="z_rel_pack_levl_name">${q_rej_queryresult.rows[0].z_rel_pack_levl_name}</ColumnValue>
<ColumnValue name="z_target_rel_date">${q_rej_queryresult.rows[0].z_target_rel_date}</ColumnValue>
</core:if>
<core:if test="${(q_rej_queryresult.rows[0].z_orig_rls_id == 'Not Yet Set' ) }">
<ColumnValue name="z_origi_rel_date">${q_rej_queryresult.rows[0].z_target_rel_date}</ColumnValue>
<ColumnValue name="z_orig_rls_id">${q_rej_queryresult.rows[0].rls_target}</ColumnValue>
</core:if>
<core:if test="${(q_rej_queryresult.rows[0].z_baseline_rls_id == 'Not Yet Set' ) }">
<ColumnValue name="z_baseline_rel_date">${q_rej_queryresult.rows[0].z_target_rel_date}</ColumnValue>
<ColumnValue name="z_baseline_rls_id">${q_rej_queryresult.rows[0].rls_target}</ColumnValue>
</core:if>
<core:if test="${(q_rej_queryresult.rows[0].z_actal_rel_id_ronly == 'Not Yet Set' ) }">
<ColumnValue name="z_act_rel_date">${q_rej_queryresult.rows[0].z_act_rel_date}</ColumnValue>
<ColumnValue name="z_actal_rel_id_ronly">${q_rej_queryresult.rows[0].z_actual_rls_id}</ColumnValue>
</core:if>
</CustomInformation>
<core:set value="1" var="targetUserId"/>
<core:set value="${gel_objectInstanceId}" var="targetObjectId"/>
<core:set value="${q_rej_queryresult.rows[0].process_version_id3}" var="targetProcessId"/>
<core:set value="${q_rej_queryresult.rows[0].PRC_OBJ_NAME3}" var="targetObjectKey"/>
<bpm:startProcess initObjectId="${targetObjectId}" initObjectKey="${targetObjectKey}" initUserId="${targetUserId}" processVersionId="${targetProcessId}"/>
<bpm:startProcess initObjectId="${targetObjectId}" initObjectKey="${q_rej_queryresult.rows[0].PRC_OBJ_NAME}"
initUserId="${targetUserId}" processVersionId="${q_rej_queryresult.rows[0].process_version_id}"/>
</Task>
</Tasks>
</Project>
</Projects>
</NikuDataBus>
</core:if>
<!--<core:if test="${q_rej_queryresult.rows[0].z_actual_rls_id !=null and q_rej_queryresult.rows[0].z_actal_rel_id_ronly=='Not Yet Set' }"><gel:log>In Fourth if</gel:log><CustomInformation><ColumnValue name="z_act_rel_date">${q_rej_queryresult.rows[0].z_act_rel_date}</ColumnValue><ColumnValue name="z_actal_rel_id_ronly">${q_rej_queryresult.rows[0].z_actual_rls_id}</ColumnValue></CustomInformation><core:set value="1" var="targetUserId"/><core:set value="${gel_objectInstanceId}" var="targetObjectId"/><core:set value="${q_rej_queryresult.rows[0].process_version_id3}" var="targetProcessId"/><core:set value="${q_rej_queryresult.rows[0].PRC_OBJ_NAME3}" var="targetObjectKey"/><bpm:startProcess initObjectId="${targetObjectId}" initObjectKey="${targetObjectKey}" initUserId="${targetUserId}" processVersionId="${targetProcessId}"/><bpm:startProcess initObjectId="${targetObjectId}" initObjectKey="${q_rej_queryresult.rows[0].PRC_OBJ_NAME}"
initUserId="${targetUserId}" processVersionId="${q_rej_queryresult.rows[0].process_version_id}"/></core:if> -->
</gel:parse>
</core:catch>
<!--End of Preparing the XML -->
<core:choose>
<core:when test="${v_parsed_exception != null}">
<gel:log category="XOG" level="ERROR">Exception while Parsing the XML:${v_parsed_exception}</gel:log>
</core:when>
<core:otherwise>
<!--Printing XML File if there is no exception-->
<core:if test="${debugFlag != 0}">
<gel:set asString="true" select="$v_sub_ins_xog" var="v_xogString"/>
<gel:log category="XOG" level="INFO">${v_xogString}</gel:log>
</core:if>
<!--Creating session -->
<core:catch var="v_session_exception">
<core:set value="${v_config.getProperties()}" var="v_prop"/>
<core:set value="${v_prop.getWebServer().getSchedulerUrl()}" var="v_clarityURL"/>
<core:new className="com.niku.union.security.DefaultSecurityIdentifier" var="v_secId"/>
<core:invokeStatic className="com.niku.union.security.UserSessionControllerFactory" method="getInstance" var="v_userSessionCtrl"/>
<core:set value="${v_userSessionCtrl.init(userName, v_secId)}" var="v_secId"/>
<core:set value="${v_secId.getSessionId()}" var="v_thisSessionId"/>
</core:catch>
<core:choose>
<core:when test="${v_session_exception != null}">
<gel:log category="XOG" level="ERROR">Caught exception while retrieving logging into Clarity. Exception was: ${v_session_exception}</gel:log>
</core:when>
<core:otherwise>
<core:if test="${debugFlag == 1}">
<gel:log category="XOG" level="INFO">Session generated successfully..!!</gel:log>
<gel:log category="XOG" level="INFO">XOG User: ${userName}; SessionID: ${v_thisSessionId}</gel:log>
</core:if>
<core:catch var="v_xog_exception">
<soap:invoke endpoint="internal" var="v_xogResult">
<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>${v_thisSessionId}</xog:SessionID>
</xog:Auth>
</soapenv:Header>
<soapenv:Body>
<gel:include select="$v_sub_ins_xog"/>
</soapenv:Body>
</soapenv:Envelope>
</soap:message>
</soap:invoke>
<core:if test="${debugFlag != 0}">
<gel:set asString="true" select="$v_xogResult" var="v_xogString_RLS"/>
<gel:log category="XOG" level="INFO">v_xogString_RLS :: ${v_xogString_RLS}</gel:log>
</core:if>
<gel:set asString="true" select="$v_xogResult//XOGOutput/Status/@state" var="v_xogState"/>
<gel:set asString="true" select="$v_xogResult//XOGOutput/Statistics/@failureRecords" var="v_xogFailureRecords"/>
<gel:set asString="true" select="$v_xogResult//XOGOutput/Statistics/@insertedRecords" var="v_xogInsertedRecords"/>
<gel:set asString="true" select="$v_xogResult//XOGOutput/Statistics/@totalNumberOfRecords" var="v_xogTotalRecords"/>
<gel:set asString="true" select="$v_xogResult//XOGOutput/Statistics/@updatedRecords" var="v_xogUpdatedRecords"/>
</core:catch>
<core:choose>
<core:when test="${v_xog_exception != null}">
<gel:log category="XOG" level="ERROR">Caught exception while XOG. Exception was: ${v_xog_exception}</gel:log>
</core:when>
<core:when test="${v_xogState == 'FAILURE' or v_xogFailureRecords gt 0}">
<gel:set asString="true" select="$v_xogResult//ErrorInformation/Description/text()" var="v_errorDescription"/>
<gel:log category="XOG" level="ERROR">Operation failed. ${v_errorDescription}. Number of failure records ${v_xogFailureRecords}</gel:log>
</core:when>
<core:otherwise>
<gel:log category="XOG" level="INFO">Operation completed (Total number of records ${v_xogTotalRecords}, Inserted records ${v_xogInsertedRecords}, Updated records ${v_xogUpdatedRecords})</gel:log>
</core:otherwise>
</core:choose>
<!--Killing the session -->
<soap:invoke endpoint="internal" var="v_xogLogout">
<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>${v_thisSessionId}</xog:SessionID>
</xog:Auth>
</soapenv:Header>
<soapenv:Body>
<xog:Logout/>
</soapenv:Body>
</soapenv:Envelope>
</soap:message>
</soap:invoke>
<!--Killing the session End-->
</core:otherwise>
</core:choose>
</core:otherwise>
</core:choose>
</core:otherwise>
</core:choose>
</core:otherwise>
</core:choose>
</gel:script>

 

Please check and help in this.

Thanks in advance.

[David Morton]

I would think that at the point that you raise the error in the GEL, i.e. when you do this;

      <gel:log category="XOG" level="ERROR">Exception while Parsing the XML:${v_parsed_exception}</gel:log>

then you would also want to see the contents of v_parsed_exception and v_sub_ins_xog - that should help you find the issue.

[Sai95]

No David,

I tried printing that in v_xogString.and the sentence did not go till execution.

 

Thanks and Regards,

Sai

[David Morton]

^ thats because your problem appears to be that "v_sub_ins_xog" is not properly formed XML, the "debug" that you are using to report the contents of the XML is treating it as XML and therefore is failing because of the same underlying reason - you really need to find out what "v_sub_ins_xog" contains.

[suhail-sayed]

Hello Sai,

 

It would help if you could click on the 'Show details' button when you try to read the messages about the failed process. You can share it here as a screenshot.

 

Suhail.

[Sai95]

Hello Suhail,

Greetings!!!

 

Few Days back the processes stopped erroring out for sure as it was a <core:otherwise> tag that was missing inside the <core:choose> tag.

But it has come again to a situation where a couple of them are still failing.

It would be great if you would point out at the correct issue.

 

Thanks and Regards,

Sai.

[suhail-sayed]

Hello Sai,

 

Shouldn't the commands <core:otherwise> and <core:choose> be properly ended with a </core:otherwise> and </core:choose> respectively? I cannot see this in your code above. Please correct me if I am wrong. Also, please click on the 'Show Details' button on your error message. I cannot find the error message details in your image above.

 

Suhail.