2026-06-01 09:55:32,219 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,221 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$REF_SER]
2026-06-01 09:55:32,221 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,221 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue[AR_AP_SIGN]
2026-06-01 09:55:32,221 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ actualParamValueBffr : [ AR_AP_SIGN ]
2026-06-01 09:55:32,221 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ paramMap : [ {$PRFMR_ROLE_CODE=AR_AP_SIGN, $PRFMR_CODE=null, $OBJ_NAME=attd_regularize, $ENTITY_CODE=null, APPLN_TYPE=JB, EXEC_MODE=ASYNC, $SIGN_FOR=Approval, $XML_DATA_ALL=Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22], $REF_ID=VB0000049, $EDIT_FLAG=, COMP_NAME=ibase.wrkflw.utility.SignTrans, $PRFMR_ROLE_EXPR_TYPE=String:, $USER_INFO=, $PRC_ID=attd_regularize:1454:AR_AP_SIGN:2, METHOD_NAME=insertSignCtx, $PRFMR_ROLE_EXPR=Detail1.emp_code_c:, $REF_SER=AR} ]
2026-06-01 09:55:32,221 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue[attd_regularize]
2026-06-01 09:55:32,221 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ actualParamValueBffr : [ attd_regularize ]
2026-06-01 09:55:32,221 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ paramMap : [ {$PRFMR_ROLE_CODE=AR_AP_SIGN, $PRFMR_CODE=null, $OBJ_NAME=attd_regularize, $ENTITY_CODE=null, APPLN_TYPE=JB, EXEC_MODE=ASYNC, $SIGN_FOR=Approval, $XML_DATA_ALL=Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22], $REF_ID=VB0000049, $EDIT_FLAG=, COMP_NAME=ibase.wrkflw.utility.SignTrans, $PRFMR_ROLE_EXPR_TYPE=String:, $USER_INFO=, $PRC_ID=attd_regularize:1454:AR_AP_SIGN:2, METHOD_NAME=insertSignCtx, $PRFMR_ROLE_EXPR=Detail1.emp_code_c:, $REF_SER=AR} ]
2026-06-01 09:55:32,221 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue[]
2026-06-01 09:55:32,221 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ actualParamValueBffr : [ ]
2026-06-01 09:55:32,221 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ paramMap : [ {$PRFMR_ROLE_CODE=AR_AP_SIGN, $PRFMR_CODE=null, $OBJ_NAME=attd_regularize, $ENTITY_CODE=null, APPLN_TYPE=JB, EXEC_MODE=ASYNC, $SIGN_FOR=Approval, $XML_DATA_ALL=Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22], $REF_ID=VB0000049, $EDIT_FLAG=, COMP_NAME=ibase.wrkflw.utility.SignTrans, $PRFMR_ROLE_EXPR_TYPE=String:, $USER_INFO=, $PRC_ID=attd_regularize:1454:AR_AP_SIGN:2, METHOD_NAME=insertSignCtx, $PRFMR_ROLE_EXPR=Detail1.emp_code_c:, $REF_SER=AR} ]
2026-06-01 09:55:32,222 INFO [WorkflowLogger] (pool-16-thread-2)
actualParamValue B4 []
2026-06-01 09:55:32,223 INFO [WorkflowLogger] (pool-16-thread-2)
fieldRequired [signfor_approver] fieldValue [Attendance regularization approval of PRITI for 26-May-2026]
2026-06-01 09:55:32,223 INFO [WorkflowLogger] (pool-16-thread-2)
msgBuff [Attendance regularization approval of PRITI for 26-May-2026]
2026-06-01 09:55:32,223 INFO [WorkflowLogger] (pool-16-thread-2)
actualParamValue After [Attendance regularization approval of PRITI for 26-May-2026]
2026-06-01 09:55:32,223 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue[Attendance Regularization]
2026-06-01 09:55:32,223 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ actualParamValueBffr : [ Attendance Regularization ]
2026-06-01 09:55:32,223 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ paramMap : [ {$PRFMR_ROLE_CODE=AR_AP_SIGN, $PRFMR_CODE=null, $OBJ_NAME=attd_regularize, $ENTITY_CODE=null, APPLN_TYPE=JB, EXEC_MODE=ASYNC, $SIGN_FOR=Approval, $XML_DATA_ALL=Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22], $REF_ID=VB0000049, $EDIT_FLAG=, COMP_NAME=ibase.wrkflw.utility.SignTrans, $PRFMR_ROLE_EXPR_TYPE=String:, $USER_INFO=, $PRC_ID=attd_regularize:1454:AR_AP_SIGN:2, METHOD_NAME=insertSignCtx, $PRFMR_ROLE_EXPR=Detail1.emp_code_c:, $REF_SER=AR} ]
2026-06-01 09:55:32,223 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue[]
2026-06-01 09:55:32,223 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ actualParamValueBffr : [ ]
2026-06-01 09:55:32,223 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ paramMap : [ {$PRFMR_ROLE_CODE=AR_AP_SIGN, $PRFMR_CODE=null, $OBJ_NAME=attd_regularize, $ENTITY_CODE=null, APPLN_TYPE=JB, EXEC_MODE=ASYNC, $SIGN_FOR=Approval, $XML_DATA_ALL=Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22], $REF_ID=VB0000049, $EDIT_FLAG=, COMP_NAME=ibase.wrkflw.utility.SignTrans, $PRFMR_ROLE_EXPR_TYPE=String:, $USER_INFO=, $PRC_ID=attd_regularize:1454:AR_AP_SIGN:2, METHOD_NAME=insertSignCtx, $PRFMR_ROLE_EXPR=Detail1.emp_code_c:, $REF_SER=AR} ]
2026-06-01 09:55:32,223 INFO [WorkflowLogger] (pool-16-thread-2)
actualParamValue B4 []
2026-06-01 09:55:32,224 INFO [WorkflowLogger] (pool-16-thread-2)
fieldRequired [chg_date] fieldValue [01/06/26]
2026-06-01 09:55:32,224 INFO [WorkflowLogger] (pool-16-thread-2)
msgBuff [01/06/26]
2026-06-01 09:55:32,224 INFO [WorkflowLogger] (pool-16-thread-2)
actualParamValue After [01/06/26]
2026-06-01 09:55:32,224 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue[]
2026-06-01 09:55:32,224 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ actualParamValueBffr : [ ]
2026-06-01 09:55:32,224 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ paramMap : [ {$PRFMR_ROLE_CODE=AR_AP_SIGN, $PRFMR_CODE=null, $OBJ_NAME=attd_regularize, $ENTITY_CODE=null, APPLN_TYPE=JB, EXEC_MODE=ASYNC, $SIGN_FOR=Approval, $XML_DATA_ALL=Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22], $REF_ID=VB0000049, $EDIT_FLAG=, COMP_NAME=ibase.wrkflw.utility.SignTrans, $PRFMR_ROLE_EXPR_TYPE=String:, $USER_INFO=, $PRC_ID=attd_regularize:1454:AR_AP_SIGN:2, METHOD_NAME=insertSignCtx, $PRFMR_ROLE_EXPR=Detail1.emp_code_c:, $REF_SER=AR} ]
2026-06-01 09:55:32,224 INFO [WorkflowLogger] (pool-16-thread-2)
actualParamValue B4 []
2026-06-01 09:55:32,225 INFO [WorkflowLogger] (pool-16-thread-2)
fieldRequired [tran_id] fieldValue [VB0000049]
2026-06-01 09:55:32,225 INFO [WorkflowLogger] (pool-16-thread-2)
msgBuff [VB0000049]
2026-06-01 09:55:32,225 INFO [WorkflowLogger] (pool-16-thread-2)
actualParamValue After [VB0000049]
2026-06-01 09:55:32,225 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue[SR]
2026-06-01 09:55:32,225 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ actualParamValueBffr : [ SR ]
2026-06-01 09:55:32,225 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ paramMap : [ {$PRFMR_ROLE_CODE=AR_AP_SIGN, $PRFMR_CODE=null, $OBJ_NAME=attd_regularize, $ENTITY_CODE=null, APPLN_TYPE=JB, EXEC_MODE=ASYNC, $SIGN_FOR=Approval, $XML_DATA_ALL=Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22], $REF_ID=VB0000049, $EDIT_FLAG=, COMP_NAME=ibase.wrkflw.utility.SignTrans, $PRFMR_ROLE_EXPR_TYPE=String:, $USER_INFO=, $PRC_ID=attd_regularize:1454:AR_AP_SIGN:2, METHOD_NAME=insertSignCtx, $PRFMR_ROLE_EXPR=Detail1.emp_code_c:, $REF_SER=AR} ]
2026-06-01 09:55:32,225 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~ApplicationInvoker.java~invokeApplication~Application Invoked..
2026-06-01 09:55:32,225 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~ApplicationInvoker.java~invokeJB~ApplicationInvoker.invokeJB()
2026-06-01 09:55:32,225 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~ApplicationInvoker.java~invokeJB~noOfParams :11
2026-06-01 09:55:32,225 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~ApplicationInvoker.java~invokeJB~paramList length :[11]
2026-06-01 09:55:32,226 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~ApplicationInvoker.java~invokeJB~methodName [insertSignCtx]
2026-06-01 09:55:32,226 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~ApplicationInvoker.java~invokeJB~compName [ibase.wrkflw.utility.SignTrans]
2026-06-01 09:55:32,226 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~ApplicationInvoker.java~invokeJB~comp [ibase.wrkflw.utility.SignTrans@1d70a3a6]
2026-06-01 09:55:32,226 INFO [WorkflowLogger] (pool-16-thread-2)
[SignTransEJB]Inserting sign for processInstanceId with connection 222[attd_regularize:1454:AR_AP_SIGN:2] roleCodeSign :[AR_AP_SIGN] entityCode :[] with context1 [Attendance Regularization] context2 [01/06/26] context1 [VB0000049] signRightsChar [SR]
2026-06-01 09:55:32,226 INFO [WorkflowLogger] (pool-16-thread-2)
Executing Process Id Select Query :[SELECT PRC_INST__WF FROM OBJ_SIGN_TRANS WHERE PRC_INST__WF = ? ] processInstanceId [attd_regularize:1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,226 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PRC_INST__WF FROM OBJ_SIGN_TRANS WHERE PRC_INST__WF = 'attd_regularize:1454:AR_AP_SIGN:2']
2026-06-01 09:55:32,226 INFO [WorkflowLogger] (pool-16-thread-2)
Executing Query .....
2026-06-01 09:55:32,227 INFO [WorkflowLogger] (pool-16-thread-2)
Returning processInstanceIdExists [false]
2026-06-01 09:55:32,227 INFO [WorkflowLogger] (pool-16-thread-2)
processInstanceId [attd_regularize:1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,227 INFO [WorkflowLogger] (pool-16-thread-2)
afterProcessId [1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,227 INFO [WorkflowLogger] (pool-16-thread-2)
afterInstanceId [AR_AP_SIGN:2]
2026-06-01 09:55:32,227 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessDataMangerEJB with connection.getProcessInputData.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,227 INFO [WorkflowLogger] (pool-16-thread-2)
Selecting Process Data :[SELECT WF.ARGUMENT_ID AS ARGUMENT_ID, WF.ARGUMENT_VALUE_XML.getClobval() FROM WF_PRC_DATA WF WHERE PROCESS_ID=? AND INSTANCE_ID=?]
2026-06-01 09:55:32,227 INFO [WorkflowLogger] (pool-16-thread-2)
processId :[attd_regularize] instanceId :[1454]
2026-06-01 09:55:32,227 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT WF.ARGUMENT_ID AS ARGUMENT_ID, WF.ARGUMENT_VALUE_XML.getClobval() FROM WF_PRC_DATA WF WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454]
2026-06-01 09:55:32,228 INFO [WorkflowLogger] (pool-16-thread-2)
CommonConstants.DB_NAME [oracle]
2026-06-01 09:55:32,228 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getProcessInputData~argumentValue ::
2026-06-01 09:55:32,228 INFO [WorkflowLogger] (pool-16-thread-2)
argumentId [:$EDIT_FLAG] Value Length :[0]
2026-06-01 09:55:32,228 INFO [WorkflowLogger] (pool-16-thread-2)
CommonConstants.DB_NAME [oracle]
2026-06-01 09:55:32,228 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getProcessInputData~argumentValue ::Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22]
2026-06-01 09:55:32,228 INFO [WorkflowLogger] (pool-16-thread-2)
argumentId [:$XML_DATA_ALL] Value Length :[5759]
2026-06-01 09:55:32,228 INFO [WorkflowLogger] (pool-16-thread-2)
Selecting Process Status Info
2026-06-01 09:55:32,229 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT OBJ_NAME,REF_SER,REF_ID,ROLE_CODE__PERF,ENTITY_CODE__PERF FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID=2]
2026-06-01 09:55:32,230 INFO [WorkflowLogger] (pool-16-thread-2)
To append lastSignRemark in XML_DATA_ALL
2026-06-01 09:55:32,230 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getPrevSignRemarks~getPrevSignRemarks B4
2026-06-01 09:55:32,230 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT LINE_NO, SIGN_REMARKS, SIGN_STATUS FROM OBJ_SIGN_TRANS WHERE REF_SER = 'AR' AND REF_ID = 'VB0000049' ORDER BY LINE_NO]
2026-06-01 09:55:32,230 INFO [WorkflowLogger] (pool-16-thread-2)
[WorkflowProcessDataMangerEJB] getPrevSignRemarks previous remarks []
2026-06-01 09:55:32,230 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getPrevSignRemarks~WorkflowProcessDataMangerEJB getPrevSignRemarks After
2026-06-01 09:55:32,231 INFO [WorkflowLogger] (pool-16-thread-2)
Process Status Info Obj Name:[attd_regularize] Ref Ser :[AR] Ref Id :[VB0000049] Prfrmr Role Code :[null] Entity Code :[null]
2026-06-01 09:55:32,231 INFO [WorkflowLogger] (pool-16-thread-2)
paramMap {$REF_ID=VB0000049, $EDIT_FLAG=, $PRFMR_ROLE_CODE=null, $OBJ_NAME=attd_regularize, $ENTITY_CODE=null, $XML_DATA_ALL=Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22], $REF_SER=AR}
2026-06-01 09:55:32,232 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~DBAccessEJB.java~getRoleInfoList~[DBAccessEJB] Getting role code info for roleCode :[AR_AP_SIGN]
2026-06-01 09:55:32,232 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BaseStatement.java~executeQuery~BaseStatement sql 71:[SELECT ROLE_TYPE, ROLE_ENTITY, ROLE_ENTITY_SQL, USER_ID, ROLE_SQL_INPUT FROM WF_ROLE WHERE ROLE_CODE = 'AR_AP_SIGN']
2026-06-01 09:55:32,233 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~DBAccessEJB.java~getRoleInfoList~[DBAccessEJB] Returning role code info list : [[]]
2026-06-01 09:55:32,233 INFO [WorkflowLogger] (pool-16-thread-2)
Getting MaxLineNo from OBJ_SIGN_TRANS ...
2026-06-01 09:55:32,233 INFO [WorkflowLogger] (pool-16-thread-2)
sql SELECT MAX(LINE_NO) AS LINE_NO FROM OBJ_SIGN_TRANS WHERE REF_SER='AR' AND REF_ID='VB0000049'
2026-06-01 09:55:32,233 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BaseStatement.java~executeQuery~BaseStatement sql 71:[SELECT MAX(LINE_NO) AS LINE_NO FROM OBJ_SIGN_TRANS WHERE REF_SER='AR' AND REF_ID='VB0000049' ]
2026-06-01 09:55:32,235 INFO [WorkflowLogger] (pool-16-thread-2)
From Obj_sign_trans lineNo [0]
2026-06-01 09:55:32,235 INFO [WorkflowLogger] (pool-16-thread-2)
[SignTransEJB] insertSignCtx entityCode : []
2026-06-01 09:55:32,236 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT USER_TYPE FROM USERS WHERE EMP_CODE = '']
2026-06-01 09:55:32,236 INFO [WorkflowLogger] (pool-16-thread-2)
Sign Trans ..Inserting into OBJ_SIGN_TRANS with context [INSERT INTO OBJ_SIGN_TRANS(REF_SER, REF_ID, LINE_NO, ROLE_CODE__SIGN, CREATE_DATE, SIGN_STATUS, TITLE, ROLE_TYPE, ROLE_ENTITY, ENTITY_CODE, PRC_INST__WF, TRANS_INFO, MSG_FRM_FNAME, SIGN_FOR, CONTEXT_1, CONTEXT_2, CONTEXT_3, RIGHTS_CHAR_SIGN, USER_INPUT,OBJ_NAME ) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, EMPTY_BLOB(),?,?,?,?,?,?,?,?)]
2026-06-01 09:55:32,236 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~sendErrorMail~In WorkflowEngineEJB 2897 conn calling sendErrorMail........!!!!
2026-06-01 09:55:32,237 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~DBAccessEJB.java~getMailDetailList~[DBAccessEJB] :getMailDetails() 3919 for Format Code :WRKFLWERR
2026-06-01 09:55:32,237 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BaseStatement.java~executeQuery~BaseStatement sql 71:[SELECT SEND_TO, COPY_TO, BLIND_COPY, SUBJECT, BODY_TEXT, ATTACH_TYPE FROM MAIL_FORMAT WHERE FORMAT_CODE = 'WRKFLWERR']
2026-06-01 09:55:32,238 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~sendErrorMail~[ITMMailInfo] mailDetailList :[poonam.bhosale@baseinformation.com, null, null, Error Reported in Workflow, null, null]:
2026-06-01 09:55:32,238 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~getWrkflwErrorDir~Returning Directory Name [WERR:attd_regularize:1454:AR_AP_SIGN:2:2026-06-01 09:55:32.238]
2026-06-01 09:55:32,238 INFO [WorkflowLogger] (pool-16-thread-2)
Sending mail ...
2026-06-01 09:55:32,238 INFO [WorkflowLogger] (pool-16-thread-2)
Exception occured : insertSignCtx : [Index 0 out of bounds for length 0]
2026-06-01 09:55:32,238 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~SignTrans.java~insertSignCtx~[insertSign]isLocalConn =false and rollback the changes
2026-06-01 09:55:32,240 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BaseDBConnection.java~rollback~BaseDBConnection.rollback() method called from class [SignTrans.java] method [insertSignCtx] line number [1872]
2026-06-01 09:55:32,240 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~ApplicationInvoker.java~invokeJB~Applicationinvoker : invokeApplication : returnValue []
2026-06-01 09:55:32,240 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.invokeApplication.returnArr []
2026-06-01 09:55:32,240 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.invokeApplication.returnArr [[Ljava.lang.String;@11027971]
2026-06-01 09:55:32,240 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.Getting value of :[STATUS] from dataString LENGTH :[176]
2026-06-01 09:55:32,240 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value for field name :[STATUS] value :[0]
2026-06-01 09:55:32,240 INFO [WorkflowLogger] (pool-16-thread-2)
111111111111111111Calling workflowProcessInstanceMonitor.updateActivityStatus with 2 from performActivity ::::: [attd_regularize:1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,240 INFO [WorkflowLogger] (pool-16-thread-2)
processInstanceId [attd_regularize:1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,240 INFO [WorkflowLogger] (pool-16-thread-2)
afterProcessId [1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,240 INFO [WorkflowLogger] (pool-16-thread-2)
afterInstanceId [AR_AP_SIGN:2]
2026-06-01 09:55:32,240 INFO [WorkflowLogger] (pool-16-thread-2)
checkActivityStatus:prcStatusSelQry[SELECT PROCESS_STATUS FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID=2 ]
2026-06-01 09:55:32,240 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BaseStatement.java~executeQuery~BaseStatement sql 71:[SELECT PROCESS_STATUS FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID=2 ]
2026-06-01 09:55:32,243 INFO [WorkflowLogger] (pool-16-thread-2)
Returning Process Exists Status :[false]
2026-06-01 09:55:32,244 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~performActivity~performer++++:::null
2026-06-01 09:55:32,244 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.updateActivityStatus with connection.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,244 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.updateActivityStatus with connection.resultXmlStr length :[176]
2026-06-01 09:55:32,244 INFO [WorkflowLogger] (pool-16-thread-2)
processInstanceId [attd_regularize:1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,244 INFO [WorkflowLogger] (pool-16-thread-2)
afterProcessId [1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,244 INFO [WorkflowLogger] (pool-16-thread-2)
afterInstanceId [AR_AP_SIGN:2]
2026-06-01 09:55:32,244 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.Getting value of :[RESULT] from dataString LENGTH :[176]
2026-06-01 09:55:32,244 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value :[Error Occured check in folder WERR:attd_regularize:1454:AR_AP_SIGN:2:2026-06-01 09:55:32.238 for detail]
2026-06-01 09:55:32,244 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.Getting value of :[STATUS] from dataString LENGTH :[176]
2026-06-01 09:55:32,245 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value :[0]
2026-06-01 09:55:32,245 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT (CASE WHEN RETRY_COUNTER IS NULL THEN 0 ELSE RETRY_COUNTER END) AS RETRY_COUNT FROM WF_PRC_STATUS WHERE PROCESS_ID = 'attd_regularize' AND INSTANCE_ID = '1454' AND ACTIVITY_ID = 'AR_AP_SIGN' AND SEQ_ID = 2]
2026-06-01 09:55:32,245 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~checkForRetryCount~retryCount[checkForRetryCount] =[0]
2026-06-01 09:55:32,245 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~sendErrorMail~In WorkflowEngineEJB 2897 conn calling sendErrorMail........!!!!
2026-06-01 09:55:32,246 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~DBAccessEJB.java~getMailDetailList~[DBAccessEJB] :getMailDetails() 3919 for Format Code :WRKFLWERR
2026-06-01 09:55:32,246 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BaseStatement.java~executeQuery~BaseStatement sql 71:[SELECT SEND_TO, COPY_TO, BLIND_COPY, SUBJECT, BODY_TEXT, ATTACH_TYPE FROM MAIL_FORMAT WHERE FORMAT_CODE = 'WRKFLWERR']
2026-06-01 09:55:32,246 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~sendErrorMail~[ITMMailInfo] mailDetailList :[poonam.bhosale@baseinformation.com, null, null, Error Reported in Workflow, null, null]:
2026-06-01 09:55:32,247 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~getWrkflwErrorDir~Returning Directory Name [WERR:attd_regularize:1454:AR_AP_SIGN:2:2026-06-01 09:55:32.247]
2026-06-01 09:55:32,247 INFO [WorkflowLogger] (pool-16-thread-2)
Sending mail ...
2026-06-01 09:55:32,247 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB with connection ::Updating Activity Satus to :[2], Query :[UPDATE WF_PRC_STATUS SET STATUS_DATE= sysdate , ERR_STATUS='0', RETRY_COUNTER = 1, ROLE_CODE__PERF='null' , ENTITY_CODE__PERF='' , STATUS_REMARKS='Error Occured check in folder WERR:attd_regularize:1454:AR_AP_SIGN:2:2026-06-01 09:55:32.238 for detail' WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID=2 AND PROCESS_STATUS != 3]
2026-06-01 09:55:32,247 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeUpdate~BasePreparedStatement Sql update [UPDATE WF_PRC_STATUS SET STATUS_DATE= sysdate , ERR_STATUS='0', RETRY_COUNTER = 1, ROLE_CODE__PERF='null' , ENTITY_CODE__PERF='' , STATUS_REMARKS='Error Occured check in folder WERR:attd_regularize:1454:AR_AP_SIGN:2:2026-06-01 09:55:32.238 for detail' WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID=2 AND PROCESS_STATUS != 3]
2026-06-01 09:55:32,250 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB with connection ::updateActivityStatus.processStatus [2]
2026-06-01 09:55:32,250 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.completeActivity.with connection.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,250 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.completeActivity.resultXmlStr length :[176]
2026-06-01 09:55:32,251 INFO [WorkflowLogger] (pool-16-thread-2)
processInstanceId [attd_regularize:1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,251 INFO [WorkflowLogger] (pool-16-thread-2)
afterProcessId [1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,251 INFO [WorkflowLogger] (pool-16-thread-2)
afterInstanceId [AR_AP_SIGN:2]
2026-06-01 09:55:32,251 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PROCESS_STATUS FROM WF_PRC_STATUS WHERE PROCESS_ID = 'attd_regularize' AND INSTANCE_ID = '1454' AND ACTIVITY_ID = 'AR_AP_SIGN' AND SEQ_ID = '2']
2026-06-01 09:55:32,251 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PROCESS_ID, INSTANCE_ID, ACTIVITY_ID, SEQ_ID, PROCESS_STATUS FROM WF_PRC_STATUS WHERE PROCESS_ID = 'attd_regularize' AND INSTANCE_ID = '1454' AND ACTIVITY_ID = 'AR_AP_SIGN' AND SEQ_ID = '2' AND PROCESS_STATUS = 0 FOR UPDATE NOWAIT]
2026-06-01 09:55:32,252 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.getActivitySpan.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,252 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT STATUS_DATE FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID='1454' AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID = 2]
2026-06-01 09:55:32,252 INFO [WorkflowLogger] (pool-16-thread-2)
hrs Delay [7.0E-5]
2026-06-01 09:55:32,252 INFO [WorkflowLogger] (pool-16-thread-2)
days Delay [2.9166667E-6]
2026-06-01 09:55:32,252 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.Getting value of :[STATUS] from dataString LENGTH :[176]
2026-06-01 09:55:32,253 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value for field name :[STATUS] value :[0]
2026-06-01 09:55:32,253 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.Getting value of :[RESULT] from dataString LENGTH :[176]
2026-06-01 09:55:32,253 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value for field name :[RESULT] value :[Error Occured check in folder WERR:attd_regularize:1454:AR_AP_SIGN:2:2026-06-01 09:55:32.238 for detail ]
2026-06-01 09:55:32,253 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.Getting value of :[DATA] from dataString LENGTH :[176]
2026-06-01 09:55:32,254 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value for field name :[DATA] value :[null]
2026-06-01 09:55:32,254 INFO [stdout] (pool-16-thread-2) appDataValue is empty.........
2026-06-01 09:55:32,254 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessDataMangerEJB with connection.getProcessInputData.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,254 INFO [WorkflowLogger] (pool-16-thread-2)
Selecting Process Data :[SELECT WF.ARGUMENT_ID AS ARGUMENT_ID, WF.ARGUMENT_VALUE_XML.getClobval() FROM WF_PRC_DATA WF WHERE PROCESS_ID=? AND INSTANCE_ID=?]
2026-06-01 09:55:32,254 INFO [WorkflowLogger] (pool-16-thread-2)
processId :[attd_regularize] instanceId :[1454]
2026-06-01 09:55:32,254 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT WF.ARGUMENT_ID AS ARGUMENT_ID, WF.ARGUMENT_VALUE_XML.getClobval() FROM WF_PRC_DATA WF WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454]
2026-06-01 09:55:32,255 INFO [WorkflowLogger] (pool-16-thread-2)
CommonConstants.DB_NAME [oracle]
2026-06-01 09:55:32,255 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getProcessInputData~argumentValue ::
2026-06-01 09:55:32,255 INFO [WorkflowLogger] (pool-16-thread-2)
argumentId [:$EDIT_FLAG] Value Length :[0]
2026-06-01 09:55:32,255 INFO [WorkflowLogger] (pool-16-thread-2)
CommonConstants.DB_NAME [oracle]
2026-06-01 09:55:32,256 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getProcessInputData~argumentValue ::Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22]
2026-06-01 09:55:32,256 INFO [WorkflowLogger] (pool-16-thread-2)
argumentId [:$XML_DATA_ALL] Value Length :[5759]
2026-06-01 09:55:32,256 INFO [WorkflowLogger] (pool-16-thread-2)
Selecting Process Status Info
2026-06-01 09:55:32,256 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT OBJ_NAME,REF_SER,REF_ID,ROLE_CODE__PERF,ENTITY_CODE__PERF FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID=2]
2026-06-01 09:55:32,257 INFO [WorkflowLogger] (pool-16-thread-2)
To append lastSignRemark in XML_DATA_ALL
2026-06-01 09:55:32,257 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getPrevSignRemarks~getPrevSignRemarks B4
2026-06-01 09:55:32,257 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT LINE_NO, SIGN_REMARKS, SIGN_STATUS FROM OBJ_SIGN_TRANS WHERE REF_SER = 'AR' AND REF_ID = 'VB0000049' ORDER BY LINE_NO]
2026-06-01 09:55:32,258 INFO [WorkflowLogger] (pool-16-thread-2)
[WorkflowProcessDataMangerEJB] getPrevSignRemarks previous remarks []
2026-06-01 09:55:32,258 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getPrevSignRemarks~WorkflowProcessDataMangerEJB getPrevSignRemarks After
2026-06-01 09:55:32,259 INFO [WorkflowLogger] (pool-16-thread-2)
Process Status Info Obj Name:[attd_regularize] Ref Ser :[AR] Ref Id :[VB0000049] Prfrmr Role Code :[null] Entity Code :[null]
2026-06-01 09:55:32,260 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.getActivityStatus.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,260 INFO [WorkflowLogger] (pool-16-thread-2)
Getting Activity Status for Process Id :[attd_regularize] Instance Id :[1454] Activity Id :[attd_regularize]
2026-06-01 09:55:32,260 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PROCESS_STATUS, SEQ_ID FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='attd_regularize' AND SEQ_ID = ( SELECT MAX(SEQ_ID) FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='attd_regularize' )]
2026-06-01 09:55:32,268 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.getActivityStatus.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,268 INFO [WorkflowLogger] (pool-16-thread-2)
Getting Activity Status for Process Id :[attd_regularize] Instance Id :[1454] Activity Id :[AR_APPRV_EMAIL_E]
2026-06-01 09:55:32,268 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PROCESS_STATUS, SEQ_ID FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_APPRV_EMAIL_E' AND SEQ_ID = ( SELECT MAX(SEQ_ID) FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_APPRV_EMAIL_E' )]
2026-06-01 09:55:32,274 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.getActivityStatus.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,274 INFO [WorkflowLogger] (pool-16-thread-2)
Getting Activity Status for Process Id :[attd_regularize] Instance Id :[1454] Activity Id :[AR_REJECT_EMAIL_E]
2026-06-01 09:55:32,274 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PROCESS_STATUS, SEQ_ID FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_REJECT_EMAIL_E' AND SEQ_ID = ( SELECT MAX(SEQ_ID) FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_REJECT_EMAIL_E' )]
2026-06-01 09:55:32,281 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.getActivityStatus.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,281 INFO [WorkflowLogger] (pool-16-thread-2)
Getting Activity Status for Process Id :[attd_regularize] Instance Id :[1454] Activity Id :[AR_REJECT_STATUS_A]
2026-06-01 09:55:32,281 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PROCESS_STATUS, SEQ_ID FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_REJECT_STATUS_A' AND SEQ_ID = ( SELECT MAX(SEQ_ID) FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_REJECT_STATUS_A' )]
2026-06-01 09:55:32,287 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.getActivityStatus.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,287 INFO [WorkflowLogger] (pool-16-thread-2)
Getting Activity Status for Process Id :[attd_regularize] Instance Id :[1454] Activity Id :[AR_APPRV_STATUS_A]
2026-06-01 09:55:32,288 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PROCESS_STATUS, SEQ_ID FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_APPRV_STATUS_A' AND SEQ_ID = ( SELECT MAX(SEQ_ID) FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_APPRV_STATUS_A' )]
2026-06-01 09:55:32,294 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.getActivityStatus.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,294 INFO [WorkflowLogger] (pool-16-thread-2)
Getting Activity Status for Process Id :[attd_regularize] Instance Id :[1454] Activity Id :[AR_AP_SIGN]
2026-06-01 09:55:32,294 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PROCESS_STATUS, SEQ_ID FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID = ( SELECT MAX(SEQ_ID) FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' )]
2026-06-01 09:55:32,299 INFO [WorkflowLogger] (pool-16-thread-2)
activitiesStatusMap [{$AR_APPRV_EMAIL_E_STATUS=-1, $AR_REJECT_STATUS_A_STATUS=-1, $attd_regularize_STATUS=3, $AR_APPRV_STATUS_A_STATUS=-1, $AR_AP_SIGN_STATUS=0, $AR_REJECT_EMAIL_E_STATUS=-1}]
2026-06-01 09:55:32,299 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PREVIOUS_ACTIVITY FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID=2]
2026-06-01 09:55:32,302 INFO [WorkflowLogger] (pool-16-thread-2)
previousActivity [attd_regularize]
2026-06-01 09:55:32,302 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.Getting value of :[RESULT] from dataString LENGTH :[176]
2026-06-01 09:55:32,303 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value for field name :[RESULT] value :[Error Occured check in folder WERR:attd_regularize:1454:AR_AP_SIGN:2:2026-06-01 09:55:32.238 for detail ]
2026-06-01 09:55:32,303 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~completeActivity~transitionList :[[ibase.wrkflw.metadata.impl.TransitionImpl@26ca3351, ibase.wrkflw.metadata.impl.TransitionImpl@770d191e]]
2026-06-01 09:55:32,303 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.evaluateTransitionCondition.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,303 INFO [WorkflowLogger] (pool-16-thread-2)
Expr To Eval :[$APP_RESULT=="S"]
2026-06-01 09:55:32,303 INFO [WorkflowLogger] (pool-16-thread-2)
currField [$APP_RESULT]
2026-06-01 09:55:32,303 INFO [WorkflowLogger] (pool-16-thread-2)
Value of $APP_RESULT [Error Occured check in folder WERR:attd_regularize:1454:AR_AP_SIGN:2:2026-06-01 09:55:32.238 for detail ]
2026-06-01 09:55:32,303 INFO [WorkflowLogger] (pool-16-thread-2)
Result of evaluation of expression :[false]
2026-06-01 09:55:32,303 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.evaluateTransitionCondition.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,303 INFO [WorkflowLogger] (pool-16-thread-2)
Expr To Eval :[$APP_RESULT == "R"]
2026-06-01 09:55:32,303 INFO [WorkflowLogger] (pool-16-thread-2)
currField [$APP_RESULT]
2026-06-01 09:55:32,303 INFO [WorkflowLogger] (pool-16-thread-2)
Value of $APP_RESULT [Error Occured check in folder WERR:attd_regularize:1454:AR_AP_SIGN:2:2026-06-01 09:55:32.238 for detail ]
2026-06-01 09:55:32,304 INFO [WorkflowLogger] (pool-16-thread-2)
Result of evaluation of expression :[false]
2026-06-01 09:55:32,304 INFO [WorkflowLogger] (pool-16-thread-2)
activityIdList in connection:[]
2026-06-01 09:55:32,304 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB:updateEvaluationDetails:exprToEval[$APP_RESULT == "R"]
2026-06-01 09:55:32,304 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeUpdate~BasePreparedStatement Sql update [UPDATE WF_PRC_STATUS SET EVAL_DETAIL='Expression To Evaluate = $APP_RESULT == "R" Evaluation Result = falseNext Activity = []' WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID=2]
2026-06-01 09:55:32,304 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.Getting value of :[STATUS] from dataString LENGTH :[176]
2026-06-01 09:55:32,305 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value for field name :[STATUS] value :[0]
2026-06-01 09:55:32,305 INFO [WorkflowLogger] (pool-16-thread-2)
resultXmlStr[]
2026-06-01 09:55:32,305 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.updateActivityStatus with connection.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,305 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.updateActivityStatus with connection.resultXmlStr length :[127]
2026-06-01 09:55:32,305 INFO [WorkflowLogger] (pool-16-thread-2)
processInstanceId [attd_regularize:1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,305 INFO [WorkflowLogger] (pool-16-thread-2)
afterProcessId [1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,305 INFO [WorkflowLogger] (pool-16-thread-2)
afterInstanceId [AR_AP_SIGN:2]
2026-06-01 09:55:32,305 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.Getting value of :[RESULT] from dataString LENGTH :[127]
2026-06-01 09:55:32,305 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value :[Completing :attd_regularize:1454:AR_AP_SIGN:2 Invoked :]
2026-06-01 09:55:32,305 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.Getting value of :[STATUS] from dataString LENGTH :[127]
2026-06-01 09:55:32,306 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value :[0]
2026-06-01 09:55:32,306 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT (CASE WHEN RETRY_COUNTER IS NULL THEN 0 ELSE RETRY_COUNTER END) AS RETRY_COUNT FROM WF_PRC_STATUS WHERE PROCESS_ID = 'attd_regularize' AND INSTANCE_ID = '1454' AND ACTIVITY_ID = 'AR_AP_SIGN' AND SEQ_ID = 2]
2026-06-01 09:55:32,306 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~checkForRetryCount~retryCount[checkForRetryCount] =[1]
2026-06-01 09:55:32,307 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~sendErrorMail~In WorkflowEngineEJB 2897 conn calling sendErrorMail........!!!!
2026-06-01 09:55:32,307 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~DBAccessEJB.java~getMailDetailList~[DBAccessEJB] :getMailDetails() 3919 for Format Code :WRKFLWERR
2026-06-01 09:55:32,307 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BaseStatement.java~executeQuery~BaseStatement sql 71:[SELECT SEND_TO, COPY_TO, BLIND_COPY, SUBJECT, BODY_TEXT, ATTACH_TYPE FROM MAIL_FORMAT WHERE FORMAT_CODE = 'WRKFLWERR']
2026-06-01 09:55:32,308 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~sendErrorMail~[ITMMailInfo] mailDetailList :[poonam.bhosale@baseinformation.com, null, null, Error Reported in Workflow, null, null]:
2026-06-01 09:55:32,308 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~getWrkflwErrorDir~Returning Directory Name [WERR:attd_regularize:1454:AR_AP_SIGN:2:2026-06-01 09:55:32.308]
2026-06-01 09:55:32,308 INFO [WorkflowLogger] (pool-16-thread-2)
Sending mail ...
2026-06-01 09:55:32,308 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB with connection ::Updating Activity Satus to :[3], Query :[UPDATE WF_PRC_STATUS SET STATUS_DATE= sysdate , ERR_STATUS='0', RETRY_COUNTER = 2, STATUS_REMARKS='Completing :attd_regularize:1454:AR_AP_SIGN:2 Invoked :' WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID=2 AND PROCESS_STATUS != 3]
2026-06-01 09:55:32,308 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeUpdate~BasePreparedStatement Sql update [UPDATE WF_PRC_STATUS SET STATUS_DATE= sysdate , ERR_STATUS='0', RETRY_COUNTER = 2, STATUS_REMARKS='Completing :attd_regularize:1454:AR_AP_SIGN:2 Invoked :' WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID=2 AND PROCESS_STATUS != 3]
2026-06-01 09:55:32,312 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB with connection ::updateActivityStatus.processStatus [3]
2026-06-01 09:55:32,312 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~updateTransWfStatus~CommonConstants.WRKFLW_DB:[Driver]
2026-06-01 09:55:32,312 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT OBJ_NAME , REF_ID FROM WF_PRC_STATUS WHERE PROCESS_ID = 'attd_regularize' AND INSTANCE_ID =1454]
2026-06-01 09:55:32,312 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT TABLE_NAME , WF_STATUS , TRAN_ID_COL FROM TRANSETUP WHERE TRAN_WINDOW = 'w_attd_regularize']
2026-06-01 09:55:32,313 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~updateTransWfStatus~wfStatus:[]
2026-06-01 09:55:32,313 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~updateTransWfStatus~tableName:[attd_regularize]
2026-06-01 09:55:32,313 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~updateTransWfStatus~tranIdCol:[tran_id]
2026-06-01 09:55:32,313 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~updateTransWfStatus~statusMsgStr:[Completed Activity:[ AR_AP_SIGN ]]
2026-06-01 09:55:32,313 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~updateTransWfStatus~Update failed obj_name : [ attd_regularize ] and transaction id : [ VB0000049 ] with workflow status :[ Completed Activity:[ AR_AP_SIGN ] ]
2026-06-01 09:55:32,313 INFO [WorkflowLogger] (pool-16-thread-2)
isActivityDefn :[true]
2026-06-01 09:55:32,313 DEBUG [JMSLogger] (pool-16-thread-2) 0000012303~NA~JMSWorklFlowInvoker.java~invokeWorkFlow~JMSWorklFlowInvoker.invokeWorkFlow() activity completed
2026-06-01 09:55:32,315 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BaseDBConnection.java~commit~BaseDBConnection.commit() method called from class [JMSWorklFlowInvoker.java] method [invokeWorkFlow] line number [78]
2026-06-01 09:55:32,315 DEBUG [JMSLogger] (pool-16-thread-2) NA~NA~JMSWorklFlowInvoker.java~getProcessInstanceID~JMSWorklFlowInvoker.getProcessInstanceID() Start
2026-06-01 09:55:32,315 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PROCESS_ID, INSTANCE_ID, ACTIVITY_ID, SEQ_ID FROM WF_PRC_STATUS WHERE PROCESS_STATUS = 0 AND OBJ_NAME = 'attd_regularize' AND REF_SER = 'AR' AND REF_ID = 'VB0000049' AND '1' != (CASE WHEN ERR_STATUS IS NULL THEN '0' ELSE ERR_STATUS END) AND WF_ABORT IS NULL]
2026-06-01 09:55:32,316 DEBUG [JMSLogger] (pool-16-thread-2) NA~NA~JMSWorklFlowInvoker.java~getProcessInstanceID~JMSWorklFlowInvoker.getProcessInstanceID() processInstanceID : [attd_regularize:1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,316 DEBUG [JMSLogger] (pool-16-thread-2) NA~NA~JMSWorklFlowInvoker.java~getProcessInstanceID~JMSWorklFlowInvoker.getProcessInstanceID() End
2026-06-01 09:55:32,316 DEBUG [JMSLogger] (pool-16-thread-2) 0000012303~NA~JMSWorklFlowInvoker.java~invokeWorkFlow~JMSWorklFlowInvoker.invokeWorkFlow() isRecAvail : [true] iteration : [2]
2026-06-01 09:55:32,316 DEBUG [JMSLogger] (pool-16-thread-2) 0000012303~NA~JMSWorklFlowInvoker.java~invokeWorkFlow~JMSWorklFlowInvoker.invokeWorkFlow() activity start
2026-06-01 09:55:32,316 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.performActivity.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,316 INFO [WorkflowLogger] (pool-16-thread-2)
processInstanceId [attd_regularize:1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,316 INFO [WorkflowLogger] (pool-16-thread-2)
afterProcessId [1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,316 INFO [WorkflowLogger] (pool-16-thread-2)
afterInstanceId [AR_AP_SIGN:2]
2026-06-01 09:55:32,316 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PROCESS_STATUS FROM WF_PRC_STATUS WHERE PROCESS_ID = 'attd_regularize' AND INSTANCE_ID = '1454' AND ACTIVITY_ID = 'AR_AP_SIGN' AND SEQ_ID = '2']
2026-06-01 09:55:32,317 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PROCESS_ID, INSTANCE_ID, ACTIVITY_ID, SEQ_ID, PROCESS_STATUS, OBJ_NAME FROM WF_PRC_STATUS WHERE PROCESS_ID = 'attd_regularize' AND INSTANCE_ID = '1454' AND ACTIVITY_ID = 'AR_AP_SIGN' AND SEQ_ID = '2' AND PROCESS_STATUS = 0 FOR UPDATE NOWAIT]
2026-06-01 09:55:32,317 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~performActivity~performActivity >> objName =[attd_regularize]
2026-06-01 09:55:32,317 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~updateTransOnNullExp~updateTransOnNullExp is called...........
2026-06-01 09:55:32,318 INFO [WorkflowLogger] (pool-16-thread-2)
SELECT COUNT IN WF_PRC_DATA for Current Process_id [attd_regularize] instance Id [1454]
2026-06-01 09:55:32,318 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT COUNT(1) AS CNT FROM WF_PRC_DATA WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID='1454']
2026-06-01 09:55:32,318 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessDataMangerEJB with connection.getProcessInputData.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,318 INFO [WorkflowLogger] (pool-16-thread-2)
Selecting Process Data :[SELECT WF.ARGUMENT_ID AS ARGUMENT_ID, WF.ARGUMENT_VALUE_XML.getClobval() FROM WF_PRC_DATA WF WHERE PROCESS_ID=? AND INSTANCE_ID=?]
2026-06-01 09:55:32,318 INFO [WorkflowLogger] (pool-16-thread-2)
processId :[attd_regularize] instanceId :[1454]
2026-06-01 09:55:32,318 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT WF.ARGUMENT_ID AS ARGUMENT_ID, WF.ARGUMENT_VALUE_XML.getClobval() FROM WF_PRC_DATA WF WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454]
2026-06-01 09:55:32,320 INFO [WorkflowLogger] (pool-16-thread-2)
CommonConstants.DB_NAME [oracle]
2026-06-01 09:55:32,320 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getProcessInputData~argumentValue ::
2026-06-01 09:55:32,320 INFO [WorkflowLogger] (pool-16-thread-2)
argumentId [:$EDIT_FLAG] Value Length :[0]
2026-06-01 09:55:32,320 INFO [WorkflowLogger] (pool-16-thread-2)
CommonConstants.DB_NAME [oracle]
2026-06-01 09:55:32,320 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getProcessInputData~argumentValue ::Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22]
2026-06-01 09:55:32,320 INFO [WorkflowLogger] (pool-16-thread-2)
argumentId [:$XML_DATA_ALL] Value Length :[5759]
2026-06-01 09:55:32,320 INFO [WorkflowLogger] (pool-16-thread-2)
Selecting Process Status Info
2026-06-01 09:55:32,320 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT OBJ_NAME,REF_SER,REF_ID,ROLE_CODE__PERF,ENTITY_CODE__PERF FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID=2]
2026-06-01 09:55:32,321 INFO [WorkflowLogger] (pool-16-thread-2)
To append lastSignRemark in XML_DATA_ALL
2026-06-01 09:55:32,321 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getPrevSignRemarks~getPrevSignRemarks B4
2026-06-01 09:55:32,321 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT LINE_NO, SIGN_REMARKS, SIGN_STATUS FROM OBJ_SIGN_TRANS WHERE REF_SER = 'AR' AND REF_ID = 'VB0000049' ORDER BY LINE_NO]
2026-06-01 09:55:32,322 INFO [WorkflowLogger] (pool-16-thread-2)
[WorkflowProcessDataMangerEJB] getPrevSignRemarks previous remarks []
2026-06-01 09:55:32,322 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getPrevSignRemarks~WorkflowProcessDataMangerEJB getPrevSignRemarks After
2026-06-01 09:55:32,323 INFO [WorkflowLogger] (pool-16-thread-2)
Process Status Info Obj Name:[attd_regularize] Ref Ser :[AR] Ref Id :[VB0000049] Prfrmr Role Code :[null] Entity Code :[null]
2026-06-01 09:55:32,325 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.getPerformer.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,325 INFO [WorkflowLogger] (pool-16-thread-2)
Performer Id :[AR_AP_SIGN]
2026-06-01 09:55:32,325 INFO [WorkflowLogger] (pool-16-thread-2)
Performer Role Code :[AR_AP_SIGN]
2026-06-01 09:55:32,325 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~DBAccessEJB.java~getRoleInfoList~[DBAccessEJB] Getting role code info for roleCode :[AR_AP_SIGN]
2026-06-01 09:55:32,325 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BaseStatement.java~executeQuery~BaseStatement sql 71:[SELECT ROLE_TYPE, ROLE_ENTITY, ROLE_ENTITY_SQL, USER_ID, ROLE_SQL_INPUT FROM WF_ROLE WHERE ROLE_CODE = 'AR_AP_SIGN']
2026-06-01 09:55:32,325 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~DBAccessEJB.java~getRoleInfoList~[DBAccessEJB] Returning role code info list : [[]]
2026-06-01 09:55:32,325 INFO [WorkflowLogger] (pool-16-thread-2)
Performer Type :[ROLE]
2026-06-01 09:55:32,325 INFO [WorkflowLogger] (pool-16-thread-2)
Evaluated Performer Code :[null]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.invokeApplication.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
Invoking Application Id :[SignTrans] Appl Type :[APPLICATION]
2026-06-01 09:55:32,326 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~ApplicationParams.java~setApplnName~Inside ApplicationParams::setApplnName()::SignTrans
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
EXEC_MODE [ASYNC]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.setAppParamsByRef.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue[$PRC_ID]
2026-06-01 09:55:32,326 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ actualParamValueBffr : [ $PRC_ID ]
2026-06-01 09:55:32,326 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ paramMap : [ {$PRFMR_ROLE_CODE=AR_AP_SIGN, $PRFMR_CODE=null, $OBJ_NAME=attd_regularize, $ENTITY_CODE=null, APPLN_TYPE=JB, EXEC_MODE=ASYNC, $SIGN_FOR=Approval, $XML_DATA_ALL=Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22], $REF_ID=VB0000049, $EDIT_FLAG=, COMP_NAME=ibase.wrkflw.utility.SignTrans, $PRFMR_ROLE_EXPR_TYPE=String:, $USER_INFO=, $PRC_ID=attd_regularize:1454:AR_AP_SIGN:2, METHOD_NAME=insertSignCtx, $PRFMR_ROLE_EXPR=Detail1.emp_code_c:, $REF_SER=AR} ]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$PRFMR_ROLE_CODE]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$PRFMR_CODE]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$OBJ_NAME]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$ENTITY_CODE]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[APPLN_TYPE]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[EXEC_MODE]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$SIGN_FOR]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$XML_DATA_ALL]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$REF_ID]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$EDIT_FLAG]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[COMP_NAME]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$PRFMR_ROLE_EXPR_TYPE]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$USER_INFO]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$PRC_ID]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[0]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:After if exist indexOfKey[attd_regularize:1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[METHOD_NAME]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$PRFMR_ROLE_EXPR]
2026-06-01 09:55:32,326 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$REF_SER]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue[$PRFMR_ROLE_CODE]
2026-06-01 09:55:32,327 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ actualParamValueBffr : [ $PRFMR_ROLE_CODE ]
2026-06-01 09:55:32,327 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ paramMap : [ {$PRFMR_ROLE_CODE=AR_AP_SIGN, $PRFMR_CODE=null, $OBJ_NAME=attd_regularize, $ENTITY_CODE=null, APPLN_TYPE=JB, EXEC_MODE=ASYNC, $SIGN_FOR=Approval, $XML_DATA_ALL=Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22], $REF_ID=VB0000049, $EDIT_FLAG=, COMP_NAME=ibase.wrkflw.utility.SignTrans, $PRFMR_ROLE_EXPR_TYPE=String:, $USER_INFO=, $PRC_ID=attd_regularize:1454:AR_AP_SIGN:2, METHOD_NAME=insertSignCtx, $PRFMR_ROLE_EXPR=Detail1.emp_code_c:, $REF_SER=AR} ]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$PRFMR_ROLE_CODE]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[0]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:After if exist indexOfKey[AR_AP_SIGN]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$PRFMR_CODE]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$OBJ_NAME]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$ENTITY_CODE]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[APPLN_TYPE]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[EXEC_MODE]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$SIGN_FOR]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$XML_DATA_ALL]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$REF_ID]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$EDIT_FLAG]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[COMP_NAME]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$PRFMR_ROLE_EXPR_TYPE]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$USER_INFO]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$PRC_ID]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[METHOD_NAME]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$PRFMR_ROLE_EXPR]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$REF_SER]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,327 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue[$PRFMR_CODE]
2026-06-01 09:55:32,327 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ actualParamValueBffr : [ $PRFMR_CODE ]
2026-06-01 09:55:32,327 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ paramMap : [ {$PRFMR_ROLE_CODE=AR_AP_SIGN, $PRFMR_CODE=null, $OBJ_NAME=attd_regularize, $ENTITY_CODE=null, APPLN_TYPE=JB, EXEC_MODE=ASYNC, $SIGN_FOR=Approval, $XML_DATA_ALL=Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22], $REF_ID=VB0000049, $EDIT_FLAG=, COMP_NAME=ibase.wrkflw.utility.SignTrans, $PRFMR_ROLE_EXPR_TYPE=String:, $USER_INFO=, $PRC_ID=attd_regularize:1454:AR_AP_SIGN:2, METHOD_NAME=insertSignCtx, $PRFMR_ROLE_EXPR=Detail1.emp_code_c:, $REF_SER=AR} ]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$PRFMR_ROLE_CODE]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$PRFMR_CODE]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[0]
2026-06-01 09:55:32,328 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~$PRFMR_CODE is found null
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
$PRFMR_CODE setAppParamsByRef:actualParamValue:After if exist indexOfKey[]
2026-06-01 09:55:32,328 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ indexOfKey :[ -1 ]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$OBJ_NAME]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$ENTITY_CODE]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[APPLN_TYPE]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[EXEC_MODE]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$SIGN_FOR]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$XML_DATA_ALL]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$REF_ID]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$EDIT_FLAG]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[COMP_NAME]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$PRFMR_ROLE_EXPR_TYPE]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$USER_INFO]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$PRC_ID]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[METHOD_NAME]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$PRFMR_ROLE_EXPR]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:key[$REF_SER]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue:indexOfKey[-1]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue[AR_AP_SIGN]
2026-06-01 09:55:32,328 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ actualParamValueBffr : [ AR_AP_SIGN ]
2026-06-01 09:55:32,328 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ paramMap : [ {$PRFMR_ROLE_CODE=AR_AP_SIGN, $PRFMR_CODE=null, $OBJ_NAME=attd_regularize, $ENTITY_CODE=null, APPLN_TYPE=JB, EXEC_MODE=ASYNC, $SIGN_FOR=Approval, $XML_DATA_ALL=Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22], $REF_ID=VB0000049, $EDIT_FLAG=, COMP_NAME=ibase.wrkflw.utility.SignTrans, $PRFMR_ROLE_EXPR_TYPE=String:, $USER_INFO=, $PRC_ID=attd_regularize:1454:AR_AP_SIGN:2, METHOD_NAME=insertSignCtx, $PRFMR_ROLE_EXPR=Detail1.emp_code_c:, $REF_SER=AR} ]
2026-06-01 09:55:32,328 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue[attd_regularize]
2026-06-01 09:55:32,329 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ actualParamValueBffr : [ attd_regularize ]
2026-06-01 09:55:32,329 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ paramMap : [ {$PRFMR_ROLE_CODE=AR_AP_SIGN, $PRFMR_CODE=null, $OBJ_NAME=attd_regularize, $ENTITY_CODE=null, APPLN_TYPE=JB, EXEC_MODE=ASYNC, $SIGN_FOR=Approval, $XML_DATA_ALL=Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22], $REF_ID=VB0000049, $EDIT_FLAG=, COMP_NAME=ibase.wrkflw.utility.SignTrans, $PRFMR_ROLE_EXPR_TYPE=String:, $USER_INFO=, $PRC_ID=attd_regularize:1454:AR_AP_SIGN:2, METHOD_NAME=insertSignCtx, $PRFMR_ROLE_EXPR=Detail1.emp_code_c:, $REF_SER=AR} ]
2026-06-01 09:55:32,329 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue[]
2026-06-01 09:55:32,329 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ actualParamValueBffr : [ ]
2026-06-01 09:55:32,329 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ paramMap : [ {$PRFMR_ROLE_CODE=AR_AP_SIGN, $PRFMR_CODE=null, $OBJ_NAME=attd_regularize, $ENTITY_CODE=null, APPLN_TYPE=JB, EXEC_MODE=ASYNC, $SIGN_FOR=Approval, $XML_DATA_ALL=Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22], $REF_ID=VB0000049, $EDIT_FLAG=, COMP_NAME=ibase.wrkflw.utility.SignTrans, $PRFMR_ROLE_EXPR_TYPE=String:, $USER_INFO=, $PRC_ID=attd_regularize:1454:AR_AP_SIGN:2, METHOD_NAME=insertSignCtx, $PRFMR_ROLE_EXPR=Detail1.emp_code_c:, $REF_SER=AR} ]
2026-06-01 09:55:32,329 INFO [WorkflowLogger] (pool-16-thread-2)
actualParamValue B4 []
2026-06-01 09:55:32,329 INFO [WorkflowLogger] (pool-16-thread-2)
fieldRequired [signfor_approver] fieldValue [Attendance regularization approval of PRITI for 26-May-2026]
2026-06-01 09:55:32,330 INFO [WorkflowLogger] (pool-16-thread-2)
msgBuff [Attendance regularization approval of PRITI for 26-May-2026]
2026-06-01 09:55:32,330 INFO [WorkflowLogger] (pool-16-thread-2)
actualParamValue After [Attendance regularization approval of PRITI for 26-May-2026]
2026-06-01 09:55:32,330 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue[Attendance Regularization]
2026-06-01 09:55:32,330 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ actualParamValueBffr : [ Attendance Regularization ]
2026-06-01 09:55:32,330 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ paramMap : [ {$PRFMR_ROLE_CODE=AR_AP_SIGN, $PRFMR_CODE=null, $OBJ_NAME=attd_regularize, $ENTITY_CODE=null, APPLN_TYPE=JB, EXEC_MODE=ASYNC, $SIGN_FOR=Approval, $XML_DATA_ALL=Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22], $REF_ID=VB0000049, $EDIT_FLAG=, COMP_NAME=ibase.wrkflw.utility.SignTrans, $PRFMR_ROLE_EXPR_TYPE=String:, $USER_INFO=, $PRC_ID=attd_regularize:1454:AR_AP_SIGN:2, METHOD_NAME=insertSignCtx, $PRFMR_ROLE_EXPR=Detail1.emp_code_c:, $REF_SER=AR} ]
2026-06-01 09:55:32,330 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue[]
2026-06-01 09:55:32,330 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ actualParamValueBffr : [ ]
2026-06-01 09:55:32,330 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ paramMap : [ {$PRFMR_ROLE_CODE=AR_AP_SIGN, $PRFMR_CODE=null, $OBJ_NAME=attd_regularize, $ENTITY_CODE=null, APPLN_TYPE=JB, EXEC_MODE=ASYNC, $SIGN_FOR=Approval, $XML_DATA_ALL=Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22], $REF_ID=VB0000049, $EDIT_FLAG=, COMP_NAME=ibase.wrkflw.utility.SignTrans, $PRFMR_ROLE_EXPR_TYPE=String:, $USER_INFO=, $PRC_ID=attd_regularize:1454:AR_AP_SIGN:2, METHOD_NAME=insertSignCtx, $PRFMR_ROLE_EXPR=Detail1.emp_code_c:, $REF_SER=AR} ]
2026-06-01 09:55:32,330 INFO [WorkflowLogger] (pool-16-thread-2)
actualParamValue B4 []
2026-06-01 09:55:32,330 INFO [WorkflowLogger] (pool-16-thread-2)
fieldRequired [chg_date] fieldValue [01/06/26]
2026-06-01 09:55:32,331 INFO [WorkflowLogger] (pool-16-thread-2)
msgBuff [01/06/26]
2026-06-01 09:55:32,331 INFO [WorkflowLogger] (pool-16-thread-2)
actualParamValue After [01/06/26]
2026-06-01 09:55:32,331 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue[]
2026-06-01 09:55:32,331 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ actualParamValueBffr : [ ]
2026-06-01 09:55:32,331 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ paramMap : [ {$PRFMR_ROLE_CODE=AR_AP_SIGN, $PRFMR_CODE=null, $OBJ_NAME=attd_regularize, $ENTITY_CODE=null, APPLN_TYPE=JB, EXEC_MODE=ASYNC, $SIGN_FOR=Approval, $XML_DATA_ALL=Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22], $REF_ID=VB0000049, $EDIT_FLAG=, COMP_NAME=ibase.wrkflw.utility.SignTrans, $PRFMR_ROLE_EXPR_TYPE=String:, $USER_INFO=, $PRC_ID=attd_regularize:1454:AR_AP_SIGN:2, METHOD_NAME=insertSignCtx, $PRFMR_ROLE_EXPR=Detail1.emp_code_c:, $REF_SER=AR} ]
2026-06-01 09:55:32,331 INFO [WorkflowLogger] (pool-16-thread-2)
actualParamValue B4 []
2026-06-01 09:55:32,331 INFO [WorkflowLogger] (pool-16-thread-2)
fieldRequired [tran_id] fieldValue [VB0000049]
2026-06-01 09:55:32,331 INFO [WorkflowLogger] (pool-16-thread-2)
msgBuff [VB0000049]
2026-06-01 09:55:32,331 INFO [WorkflowLogger] (pool-16-thread-2)
actualParamValue After [VB0000049]
2026-06-01 09:55:32,331 INFO [WorkflowLogger] (pool-16-thread-2)
setAppParamsByRef:actualParamValue[SR]
2026-06-01 09:55:32,332 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ actualParamValueBffr : [ SR ]
2026-06-01 09:55:32,332 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~setAppParamsByRef~@@@@ paramMap : [ {$PRFMR_ROLE_CODE=AR_AP_SIGN, $PRFMR_CODE=null, $OBJ_NAME=attd_regularize, $ENTITY_CODE=null, APPLN_TYPE=JB, EXEC_MODE=ASYNC, $SIGN_FOR=Approval, $XML_DATA_ALL=Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22], $REF_ID=VB0000049, $EDIT_FLAG=, COMP_NAME=ibase.wrkflw.utility.SignTrans, $PRFMR_ROLE_EXPR_TYPE=String:, $USER_INFO=, $PRC_ID=attd_regularize:1454:AR_AP_SIGN:2, METHOD_NAME=insertSignCtx, $PRFMR_ROLE_EXPR=Detail1.emp_code_c:, $REF_SER=AR} ]
2026-06-01 09:55:32,332 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~ApplicationInvoker.java~invokeApplication~Application Invoked..
2026-06-01 09:55:32,332 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~ApplicationInvoker.java~invokeJB~ApplicationInvoker.invokeJB()
2026-06-01 09:55:32,332 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~ApplicationInvoker.java~invokeJB~noOfParams :11
2026-06-01 09:55:32,332 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~ApplicationInvoker.java~invokeJB~paramList length :[11]
2026-06-01 09:55:32,332 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~ApplicationInvoker.java~invokeJB~methodName [insertSignCtx]
2026-06-01 09:55:32,332 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~ApplicationInvoker.java~invokeJB~compName [ibase.wrkflw.utility.SignTrans]
2026-06-01 09:55:32,332 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~ApplicationInvoker.java~invokeJB~comp [ibase.wrkflw.utility.SignTrans@304621bb]
2026-06-01 09:55:32,332 INFO [WorkflowLogger] (pool-16-thread-2)
[SignTransEJB]Inserting sign for processInstanceId with connection 222[attd_regularize:1454:AR_AP_SIGN:2] roleCodeSign :[AR_AP_SIGN] entityCode :[] with context1 [Attendance Regularization] context2 [01/06/26] context1 [VB0000049] signRightsChar [SR]
2026-06-01 09:55:32,332 INFO [WorkflowLogger] (pool-16-thread-2)
Executing Process Id Select Query :[SELECT PRC_INST__WF FROM OBJ_SIGN_TRANS WHERE PRC_INST__WF = ? ] processInstanceId [attd_regularize:1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,332 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PRC_INST__WF FROM OBJ_SIGN_TRANS WHERE PRC_INST__WF = 'attd_regularize:1454:AR_AP_SIGN:2']
2026-06-01 09:55:32,332 INFO [WorkflowLogger] (pool-16-thread-2)
Executing Query .....
2026-06-01 09:55:32,333 INFO [WorkflowLogger] (pool-16-thread-2)
Returning processInstanceIdExists [false]
2026-06-01 09:55:32,333 INFO [WorkflowLogger] (pool-16-thread-2)
processInstanceId [attd_regularize:1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,333 INFO [WorkflowLogger] (pool-16-thread-2)
afterProcessId [1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,333 INFO [WorkflowLogger] (pool-16-thread-2)
afterInstanceId [AR_AP_SIGN:2]
2026-06-01 09:55:32,333 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessDataMangerEJB with connection.getProcessInputData.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,333 INFO [WorkflowLogger] (pool-16-thread-2)
Selecting Process Data :[SELECT WF.ARGUMENT_ID AS ARGUMENT_ID, WF.ARGUMENT_VALUE_XML.getClobval() FROM WF_PRC_DATA WF WHERE PROCESS_ID=? AND INSTANCE_ID=?]
2026-06-01 09:55:32,333 INFO [WorkflowLogger] (pool-16-thread-2)
processId :[attd_regularize] instanceId :[1454]
2026-06-01 09:55:32,333 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT WF.ARGUMENT_ID AS ARGUMENT_ID, WF.ARGUMENT_VALUE_XML.getClobval() FROM WF_PRC_DATA WF WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454]
2026-06-01 09:55:32,334 INFO [WorkflowLogger] (pool-16-thread-2)
CommonConstants.DB_NAME [oracle]
2026-06-01 09:55:32,334 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getProcessInputData~argumentValue ::
2026-06-01 09:55:32,334 INFO [WorkflowLogger] (pool-16-thread-2)
argumentId [:$EDIT_FLAG] Value Length :[0]
2026-06-01 09:55:32,334 INFO [WorkflowLogger] (pool-16-thread-2)
CommonConstants.DB_NAME [oracle]
2026-06-01 09:55:32,334 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getProcessInputData~argumentValue ::Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22]
2026-06-01 09:55:32,334 INFO [WorkflowLogger] (pool-16-thread-2)
argumentId [:$XML_DATA_ALL] Value Length :[5759]
2026-06-01 09:55:32,334 INFO [WorkflowLogger] (pool-16-thread-2)
Selecting Process Status Info
2026-06-01 09:55:32,335 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT OBJ_NAME,REF_SER,REF_ID,ROLE_CODE__PERF,ENTITY_CODE__PERF FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID=2]
2026-06-01 09:55:32,336 INFO [WorkflowLogger] (pool-16-thread-2)
To append lastSignRemark in XML_DATA_ALL
2026-06-01 09:55:32,336 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getPrevSignRemarks~getPrevSignRemarks B4
2026-06-01 09:55:32,336 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT LINE_NO, SIGN_REMARKS, SIGN_STATUS FROM OBJ_SIGN_TRANS WHERE REF_SER = 'AR' AND REF_ID = 'VB0000049' ORDER BY LINE_NO]
2026-06-01 09:55:32,336 INFO [WorkflowLogger] (pool-16-thread-2)
[WorkflowProcessDataMangerEJB] getPrevSignRemarks previous remarks []
2026-06-01 09:55:32,336 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getPrevSignRemarks~WorkflowProcessDataMangerEJB getPrevSignRemarks After
2026-06-01 09:55:32,337 INFO [WorkflowLogger] (pool-16-thread-2)
Process Status Info Obj Name:[attd_regularize] Ref Ser :[AR] Ref Id :[VB0000049] Prfrmr Role Code :[null] Entity Code :[null]
2026-06-01 09:55:32,337 INFO [WorkflowLogger] (pool-16-thread-2)
paramMap {$REF_ID=VB0000049, $EDIT_FLAG=, $PRFMR_ROLE_CODE=null, $OBJ_NAME=attd_regularize, $ENTITY_CODE=null, $XML_DATA_ALL=Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22], $REF_SER=AR}
2026-06-01 09:55:32,338 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~DBAccessEJB.java~getRoleInfoList~[DBAccessEJB] Getting role code info for roleCode :[AR_AP_SIGN]
2026-06-01 09:55:32,338 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BaseStatement.java~executeQuery~BaseStatement sql 71:[SELECT ROLE_TYPE, ROLE_ENTITY, ROLE_ENTITY_SQL, USER_ID, ROLE_SQL_INPUT FROM WF_ROLE WHERE ROLE_CODE = 'AR_AP_SIGN']
2026-06-01 09:55:32,339 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~DBAccessEJB.java~getRoleInfoList~[DBAccessEJB] Returning role code info list : [[]]
2026-06-01 09:55:32,339 INFO [WorkflowLogger] (pool-16-thread-2)
Getting MaxLineNo from OBJ_SIGN_TRANS ...
2026-06-01 09:55:32,339 INFO [WorkflowLogger] (pool-16-thread-2)
sql SELECT MAX(LINE_NO) AS LINE_NO FROM OBJ_SIGN_TRANS WHERE REF_SER='AR' AND REF_ID='VB0000049'
2026-06-01 09:55:32,339 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BaseStatement.java~executeQuery~BaseStatement sql 71:[SELECT MAX(LINE_NO) AS LINE_NO FROM OBJ_SIGN_TRANS WHERE REF_SER='AR' AND REF_ID='VB0000049' ]
2026-06-01 09:55:32,347 INFO [WorkflowLogger] (pool-16-thread-2)
From Obj_sign_trans lineNo [0]
2026-06-01 09:55:32,347 INFO [WorkflowLogger] (pool-16-thread-2)
[SignTransEJB] insertSignCtx entityCode : []
2026-06-01 09:55:32,347 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT USER_TYPE FROM USERS WHERE EMP_CODE = '']
2026-06-01 09:55:32,347 INFO [WorkflowLogger] (pool-16-thread-2)
Sign Trans ..Inserting into OBJ_SIGN_TRANS with context [INSERT INTO OBJ_SIGN_TRANS(REF_SER, REF_ID, LINE_NO, ROLE_CODE__SIGN, CREATE_DATE, SIGN_STATUS, TITLE, ROLE_TYPE, ROLE_ENTITY, ENTITY_CODE, PRC_INST__WF, TRANS_INFO, MSG_FRM_FNAME, SIGN_FOR, CONTEXT_1, CONTEXT_2, CONTEXT_3, RIGHTS_CHAR_SIGN, USER_INPUT,OBJ_NAME ) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, EMPTY_BLOB(),?,?,?,?,?,?,?,?)]
2026-06-01 09:55:32,348 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~sendErrorMail~In WorkflowEngineEJB 2897 conn calling sendErrorMail........!!!!
2026-06-01 09:55:32,348 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~DBAccessEJB.java~getMailDetailList~[DBAccessEJB] :getMailDetails() 3919 for Format Code :WRKFLWERR
2026-06-01 09:55:32,348 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BaseStatement.java~executeQuery~BaseStatement sql 71:[SELECT SEND_TO, COPY_TO, BLIND_COPY, SUBJECT, BODY_TEXT, ATTACH_TYPE FROM MAIL_FORMAT WHERE FORMAT_CODE = 'WRKFLWERR']
2026-06-01 09:55:32,349 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~sendErrorMail~[ITMMailInfo] mailDetailList :[poonam.bhosale@baseinformation.com, null, null, Error Reported in Workflow, null, null]:
2026-06-01 09:55:32,350 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~getWrkflwErrorDir~Returning Directory Name [WERR:attd_regularize:1454:AR_AP_SIGN:2:2026-06-01 09:55:32.349]
2026-06-01 09:55:32,350 INFO [WorkflowLogger] (pool-16-thread-2)
Sending mail ...
2026-06-01 09:55:32,350 INFO [WorkflowLogger] (pool-16-thread-2)
Exception occured : insertSignCtx : [Index 0 out of bounds for length 0]
2026-06-01 09:55:32,350 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~SignTrans.java~insertSignCtx~[insertSign]isLocalConn =false and rollback the changes
2026-06-01 09:55:32,351 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BaseDBConnection.java~rollback~BaseDBConnection.rollback() method called from class [SignTrans.java] method [insertSignCtx] line number [1872]
2026-06-01 09:55:32,351 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~ApplicationInvoker.java~invokeJB~Applicationinvoker : invokeApplication : returnValue []
2026-06-01 09:55:32,351 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.invokeApplication.returnArr []
2026-06-01 09:55:32,351 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.invokeApplication.returnArr [[Ljava.lang.String;@134fa735]
2026-06-01 09:55:32,351 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.Getting value of :[STATUS] from dataString LENGTH :[176]
2026-06-01 09:55:32,352 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value for field name :[STATUS] value :[0]
2026-06-01 09:55:32,352 INFO [WorkflowLogger] (pool-16-thread-2)
111111111111111111Calling workflowProcessInstanceMonitor.updateActivityStatus with 2 from performActivity ::::: [attd_regularize:1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,352 INFO [WorkflowLogger] (pool-16-thread-2)
processInstanceId [attd_regularize:1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,352 INFO [WorkflowLogger] (pool-16-thread-2)
afterProcessId [1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,352 INFO [WorkflowLogger] (pool-16-thread-2)
afterInstanceId [AR_AP_SIGN:2]
2026-06-01 09:55:32,352 INFO [WorkflowLogger] (pool-16-thread-2)
checkActivityStatus:prcStatusSelQry[SELECT PROCESS_STATUS FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID=2 ]
2026-06-01 09:55:32,352 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BaseStatement.java~executeQuery~BaseStatement sql 71:[SELECT PROCESS_STATUS FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID=2 ]
2026-06-01 09:55:32,360 INFO [WorkflowLogger] (pool-16-thread-2)
Returning Process Exists Status :[false]
2026-06-01 09:55:32,360 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~performActivity~performer++++:::null
2026-06-01 09:55:32,360 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.updateActivityStatus with connection.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,360 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.updateActivityStatus with connection.resultXmlStr length :[176]
2026-06-01 09:55:32,360 INFO [WorkflowLogger] (pool-16-thread-2)
processInstanceId [attd_regularize:1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,360 INFO [WorkflowLogger] (pool-16-thread-2)
afterProcessId [1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,360 INFO [WorkflowLogger] (pool-16-thread-2)
afterInstanceId [AR_AP_SIGN:2]
2026-06-01 09:55:32,360 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.Getting value of :[RESULT] from dataString LENGTH :[176]
2026-06-01 09:55:32,361 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value :[Error Occured check in folder WERR:attd_regularize:1454:AR_AP_SIGN:2:2026-06-01 09:55:32.349 for detail]
2026-06-01 09:55:32,361 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.Getting value of :[STATUS] from dataString LENGTH :[176]
2026-06-01 09:55:32,361 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value :[0]
2026-06-01 09:55:32,361 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT (CASE WHEN RETRY_COUNTER IS NULL THEN 0 ELSE RETRY_COUNTER END) AS RETRY_COUNT FROM WF_PRC_STATUS WHERE PROCESS_ID = 'attd_regularize' AND INSTANCE_ID = '1454' AND ACTIVITY_ID = 'AR_AP_SIGN' AND SEQ_ID = 2]
2026-06-01 09:55:32,362 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~checkForRetryCount~retryCount[checkForRetryCount] =[2]
2026-06-01 09:55:32,362 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~sendErrorMail~In WorkflowEngineEJB 2897 conn calling sendErrorMail........!!!!
2026-06-01 09:55:32,363 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~DBAccessEJB.java~getMailDetailList~[DBAccessEJB] :getMailDetails() 3919 for Format Code :WRKFLWERR
2026-06-01 09:55:32,363 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BaseStatement.java~executeQuery~BaseStatement sql 71:[SELECT SEND_TO, COPY_TO, BLIND_COPY, SUBJECT, BODY_TEXT, ATTACH_TYPE FROM MAIL_FORMAT WHERE FORMAT_CODE = 'WRKFLWERR']
2026-06-01 09:55:32,363 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~sendErrorMail~[ITMMailInfo] mailDetailList :[poonam.bhosale@baseinformation.com, null, null, Error Reported in Workflow, null, null]:
2026-06-01 09:55:32,364 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~getWrkflwErrorDir~Returning Directory Name [WERR:attd_regularize:1454:AR_AP_SIGN:2:2026-06-01 09:55:32.363]
2026-06-01 09:55:32,364 INFO [WorkflowLogger] (pool-16-thread-2)
Sending mail ...
2026-06-01 09:55:32,364 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB with connection ::Updating Activity Satus to :[2], Query :[UPDATE WF_PRC_STATUS SET STATUS_DATE= sysdate , ERR_STATUS='0', RETRY_COUNTER = 3, ROLE_CODE__PERF='null' , ENTITY_CODE__PERF='' , STATUS_REMARKS='Error Occured check in folder WERR:attd_regularize:1454:AR_AP_SIGN:2:2026-06-01 09:55:32.349 for detail' WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID=2 AND PROCESS_STATUS != 3]
2026-06-01 09:55:32,364 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeUpdate~BasePreparedStatement Sql update [UPDATE WF_PRC_STATUS SET STATUS_DATE= sysdate , ERR_STATUS='0', RETRY_COUNTER = 3, ROLE_CODE__PERF='null' , ENTITY_CODE__PERF='' , STATUS_REMARKS='Error Occured check in folder WERR:attd_regularize:1454:AR_AP_SIGN:2:2026-06-01 09:55:32.349 for detail' WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID=2 AND PROCESS_STATUS != 3]
2026-06-01 09:55:32,367 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB with connection ::updateActivityStatus.processStatus [2]
2026-06-01 09:55:32,367 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.completeActivity.with connection.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,367 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.completeActivity.resultXmlStr length :[176]
2026-06-01 09:55:32,367 INFO [WorkflowLogger] (pool-16-thread-2)
processInstanceId [attd_regularize:1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,367 INFO [WorkflowLogger] (pool-16-thread-2)
afterProcessId [1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,367 INFO [WorkflowLogger] (pool-16-thread-2)
afterInstanceId [AR_AP_SIGN:2]
2026-06-01 09:55:32,367 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PROCESS_STATUS FROM WF_PRC_STATUS WHERE PROCESS_ID = 'attd_regularize' AND INSTANCE_ID = '1454' AND ACTIVITY_ID = 'AR_AP_SIGN' AND SEQ_ID = '2']
2026-06-01 09:55:32,368 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PROCESS_ID, INSTANCE_ID, ACTIVITY_ID, SEQ_ID, PROCESS_STATUS FROM WF_PRC_STATUS WHERE PROCESS_ID = 'attd_regularize' AND INSTANCE_ID = '1454' AND ACTIVITY_ID = 'AR_AP_SIGN' AND SEQ_ID = '2' AND PROCESS_STATUS = 0 FOR UPDATE NOWAIT]
2026-06-01 09:55:32,368 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.getActivitySpan.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,368 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT STATUS_DATE FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID='1454' AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID = 2]
2026-06-01 09:55:32,369 INFO [WorkflowLogger] (pool-16-thread-2)
hrs Delay [1.0222222E-4]
2026-06-01 09:55:32,369 INFO [WorkflowLogger] (pool-16-thread-2)
days Delay [4.259259E-6]
2026-06-01 09:55:32,369 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.Getting value of :[STATUS] from dataString LENGTH :[176]
2026-06-01 09:55:32,369 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value for field name :[STATUS] value :[0]
2026-06-01 09:55:32,369 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.Getting value of :[RESULT] from dataString LENGTH :[176]
2026-06-01 09:55:32,370 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value for field name :[RESULT] value :[Error Occured check in folder WERR:attd_regularize:1454:AR_AP_SIGN:2:2026-06-01 09:55:32.349 for detail ]
2026-06-01 09:55:32,370 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.Getting value of :[DATA] from dataString LENGTH :[176]
2026-06-01 09:55:32,370 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value for field name :[DATA] value :[null]
2026-06-01 09:55:32,370 INFO [stdout] (pool-16-thread-2) appDataValue is empty.........
2026-06-01 09:55:32,370 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessDataMangerEJB with connection.getProcessInputData.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,370 INFO [WorkflowLogger] (pool-16-thread-2)
Selecting Process Data :[SELECT WF.ARGUMENT_ID AS ARGUMENT_ID, WF.ARGUMENT_VALUE_XML.getClobval() FROM WF_PRC_DATA WF WHERE PROCESS_ID=? AND INSTANCE_ID=?]
2026-06-01 09:55:32,370 INFO [WorkflowLogger] (pool-16-thread-2)
processId :[attd_regularize] instanceId :[1454]
2026-06-01 09:55:32,370 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT WF.ARGUMENT_ID AS ARGUMENT_ID, WF.ARGUMENT_VALUE_XML.getClobval() FROM WF_PRC_DATA WF WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454]
2026-06-01 09:55:32,372 INFO [WorkflowLogger] (pool-16-thread-2)
CommonConstants.DB_NAME [oracle]
2026-06-01 09:55:32,372 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getProcessInputData~argumentValue ::
2026-06-01 09:55:32,372 INFO [WorkflowLogger] (pool-16-thread-2)
argumentId [:$EDIT_FLAG] Value Length :[0]
2026-06-01 09:55:32,372 INFO [WorkflowLogger] (pool-16-thread-2)
CommonConstants.DB_NAME [oracle]
2026-06-01 09:55:32,372 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getProcessInputData~argumentValue ::Datawindow RootGroup0 descriptionHeader0 membersVB0000049EV000128 26/05/26OFFID13:2219:22PURCHASEASSISTANT MANAGER13:2219:22REV000164 *-13:22,null,*-19:22R01/06/26OOFFICIAL DUTYOFFICIAL DUTYTUESDAYGS 3VS002EV000164 09:0018:00 PRITI GIRISH SHETTIGAR [EV000128]PANKAJ SHAH01/06/261PRITI GIRISHSHETTIGARAttendance regularization recommendation of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization approval of PRITI for 26-May-2026Attendance regularization recommendation of PRITI for 26-May-2026ASSISTANT MANAGER, PURCHASEPRITI GIRISH SHETTIGAR [EV000128]System Time: [In: 13:22] [Out: 19:22]
2026-06-01 09:55:32,372 INFO [WorkflowLogger] (pool-16-thread-2)
argumentId [:$XML_DATA_ALL] Value Length :[5759]
2026-06-01 09:55:32,372 INFO [WorkflowLogger] (pool-16-thread-2)
Selecting Process Status Info
2026-06-01 09:55:32,373 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT OBJ_NAME,REF_SER,REF_ID,ROLE_CODE__PERF,ENTITY_CODE__PERF FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID=2]
2026-06-01 09:55:32,374 INFO [WorkflowLogger] (pool-16-thread-2)
To append lastSignRemark in XML_DATA_ALL
2026-06-01 09:55:32,374 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getPrevSignRemarks~getPrevSignRemarks B4
2026-06-01 09:55:32,374 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT LINE_NO, SIGN_REMARKS, SIGN_STATUS FROM OBJ_SIGN_TRANS WHERE REF_SER = 'AR' AND REF_ID = 'VB0000049' ORDER BY LINE_NO]
2026-06-01 09:55:32,374 INFO [WorkflowLogger] (pool-16-thread-2)
[WorkflowProcessDataMangerEJB] getPrevSignRemarks previous remarks []
2026-06-01 09:55:32,374 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessDataMangerEJB.java~getPrevSignRemarks~WorkflowProcessDataMangerEJB getPrevSignRemarks After
2026-06-01 09:55:32,375 INFO [WorkflowLogger] (pool-16-thread-2)
Process Status Info Obj Name:[attd_regularize] Ref Ser :[AR] Ref Id :[VB0000049] Prfrmr Role Code :[null] Entity Code :[null]
2026-06-01 09:55:32,377 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.getActivityStatus.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,377 INFO [WorkflowLogger] (pool-16-thread-2)
Getting Activity Status for Process Id :[attd_regularize] Instance Id :[1454] Activity Id :[attd_regularize]
2026-06-01 09:55:32,377 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PROCESS_STATUS, SEQ_ID FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='attd_regularize' AND SEQ_ID = ( SELECT MAX(SEQ_ID) FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='attd_regularize' )]
2026-06-01 09:55:32,379 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.getActivityStatus.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,379 INFO [WorkflowLogger] (pool-16-thread-2)
Getting Activity Status for Process Id :[attd_regularize] Instance Id :[1454] Activity Id :[AR_APPRV_EMAIL_E]
2026-06-01 09:55:32,379 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PROCESS_STATUS, SEQ_ID FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_APPRV_EMAIL_E' AND SEQ_ID = ( SELECT MAX(SEQ_ID) FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_APPRV_EMAIL_E' )]
2026-06-01 09:55:32,381 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.getActivityStatus.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,381 INFO [WorkflowLogger] (pool-16-thread-2)
Getting Activity Status for Process Id :[attd_regularize] Instance Id :[1454] Activity Id :[AR_REJECT_EMAIL_E]
2026-06-01 09:55:32,381 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PROCESS_STATUS, SEQ_ID FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_REJECT_EMAIL_E' AND SEQ_ID = ( SELECT MAX(SEQ_ID) FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_REJECT_EMAIL_E' )]
2026-06-01 09:55:32,382 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.getActivityStatus.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,383 INFO [WorkflowLogger] (pool-16-thread-2)
Getting Activity Status for Process Id :[attd_regularize] Instance Id :[1454] Activity Id :[AR_REJECT_STATUS_A]
2026-06-01 09:55:32,383 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PROCESS_STATUS, SEQ_ID FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_REJECT_STATUS_A' AND SEQ_ID = ( SELECT MAX(SEQ_ID) FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_REJECT_STATUS_A' )]
2026-06-01 09:55:32,384 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.getActivityStatus.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,384 INFO [WorkflowLogger] (pool-16-thread-2)
Getting Activity Status for Process Id :[attd_regularize] Instance Id :[1454] Activity Id :[AR_APPRV_STATUS_A]
2026-06-01 09:55:32,385 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PROCESS_STATUS, SEQ_ID FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_APPRV_STATUS_A' AND SEQ_ID = ( SELECT MAX(SEQ_ID) FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_APPRV_STATUS_A' )]
2026-06-01 09:55:32,386 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.getActivityStatus.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,386 INFO [WorkflowLogger] (pool-16-thread-2)
Getting Activity Status for Process Id :[attd_regularize] Instance Id :[1454] Activity Id :[AR_AP_SIGN]
2026-06-01 09:55:32,386 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PROCESS_STATUS, SEQ_ID FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID = ( SELECT MAX(SEQ_ID) FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' )]
2026-06-01 09:55:32,388 INFO [WorkflowLogger] (pool-16-thread-2)
activitiesStatusMap [{$AR_APPRV_EMAIL_E_STATUS=-1, $AR_REJECT_STATUS_A_STATUS=-1, $attd_regularize_STATUS=3, $AR_APPRV_STATUS_A_STATUS=-1, $AR_AP_SIGN_STATUS=0, $AR_REJECT_EMAIL_E_STATUS=-1}]
2026-06-01 09:55:32,388 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT PREVIOUS_ACTIVITY FROM WF_PRC_STATUS WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID=2]
2026-06-01 09:55:32,394 INFO [WorkflowLogger] (pool-16-thread-2)
previousActivity [attd_regularize]
2026-06-01 09:55:32,394 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.Getting value of :[RESULT] from dataString LENGTH :[176]
2026-06-01 09:55:32,395 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value for field name :[RESULT] value :[Error Occured check in folder WERR:attd_regularize:1454:AR_AP_SIGN:2:2026-06-01 09:55:32.349 for detail ]
2026-06-01 09:55:32,395 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowEngineEJB.java~completeActivity~transitionList :[[ibase.wrkflw.metadata.impl.TransitionImpl@67f93ec2, ibase.wrkflw.metadata.impl.TransitionImpl@6be8b634]]
2026-06-01 09:55:32,395 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.evaluateTransitionCondition.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,395 INFO [WorkflowLogger] (pool-16-thread-2)
Expr To Eval :[$APP_RESULT=="S"]
2026-06-01 09:55:32,395 INFO [WorkflowLogger] (pool-16-thread-2)
currField [$APP_RESULT]
2026-06-01 09:55:32,395 INFO [WorkflowLogger] (pool-16-thread-2)
Value of $APP_RESULT [Error Occured check in folder WERR:attd_regularize:1454:AR_AP_SIGN:2:2026-06-01 09:55:32.349 for detail ]
2026-06-01 09:55:32,396 INFO [WorkflowLogger] (pool-16-thread-2)
Result of evaluation of expression :[false]
2026-06-01 09:55:32,396 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.evaluateTransitionCondition.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,396 INFO [WorkflowLogger] (pool-16-thread-2)
Expr To Eval :[$APP_RESULT == "R"]
2026-06-01 09:55:32,396 INFO [WorkflowLogger] (pool-16-thread-2)
currField [$APP_RESULT]
2026-06-01 09:55:32,396 INFO [WorkflowLogger] (pool-16-thread-2)
Value of $APP_RESULT [Error Occured check in folder WERR:attd_regularize:1454:AR_AP_SIGN:2:2026-06-01 09:55:32.349 for detail ]
2026-06-01 09:55:32,396 INFO [WorkflowLogger] (pool-16-thread-2)
Result of evaluation of expression :[false]
2026-06-01 09:55:32,396 INFO [WorkflowLogger] (pool-16-thread-2)
activityIdList in connection:[]
2026-06-01 09:55:32,396 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB:updateEvaluationDetails:exprToEval[$APP_RESULT == "R"]
2026-06-01 09:55:32,396 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeUpdate~BasePreparedStatement Sql update [UPDATE WF_PRC_STATUS SET EVAL_DETAIL='Expression To Evaluate = $APP_RESULT == "R" Evaluation Result = falseNext Activity = []' WHERE PROCESS_ID='attd_regularize' AND INSTANCE_ID=1454 AND ACTIVITY_ID='AR_AP_SIGN' AND SEQ_ID=2]
2026-06-01 09:55:32,396 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowEngineEJB.Getting value of :[STATUS] from dataString LENGTH :[176]
2026-06-01 09:55:32,397 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value for field name :[STATUS] value :[0]
2026-06-01 09:55:32,397 INFO [WorkflowLogger] (pool-16-thread-2)
resultXmlStr[]
2026-06-01 09:55:32,397 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.updateActivityStatus with connection.SCHEDULER_INVOCATION_CTR [0]
2026-06-01 09:55:32,397 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.updateActivityStatus with connection.resultXmlStr length :[127]
2026-06-01 09:55:32,397 INFO [WorkflowLogger] (pool-16-thread-2)
processInstanceId [attd_regularize:1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,397 INFO [WorkflowLogger] (pool-16-thread-2)
afterProcessId [1454:AR_AP_SIGN:2]
2026-06-01 09:55:32,397 INFO [WorkflowLogger] (pool-16-thread-2)
afterInstanceId [AR_AP_SIGN:2]
2026-06-01 09:55:32,397 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.Getting value of :[RESULT] from dataString LENGTH :[127]
2026-06-01 09:55:32,398 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value :[Completing :attd_regularize:1454:AR_AP_SIGN:2 Invoked :]
2026-06-01 09:55:32,398 INFO [WorkflowLogger] (pool-16-thread-2)
WorkflowProcessInstanceMonitorEJB.Getting value of :[STATUS] from dataString LENGTH :[127]
2026-06-01 09:55:32,398 INFO [WorkflowLogger] (pool-16-thread-2)
Returning value :[0]
2026-06-01 09:55:32,398 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BasePreparedStatement.java~executeQuery~BasePreparedStatement Sql jca123[SELECT (CASE WHEN RETRY_COUNTER IS NULL THEN 0 ELSE RETRY_COUNTER END) AS RETRY_COUNT FROM WF_PRC_STATUS WHERE PROCESS_ID = 'attd_regularize' AND INSTANCE_ID = '1454' AND ACTIVITY_ID = 'AR_AP_SIGN' AND SEQ_ID = 2]
2026-06-01 09:55:32,399 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~checkForRetryCount~retryCount[checkForRetryCount] =[3]
2026-06-01 09:55:32,399 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~sendErrorMail~In WorkflowEngineEJB 2897 conn calling sendErrorMail........!!!!
2026-06-01 09:55:32,399 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~DBAccessEJB.java~getMailDetailList~[DBAccessEJB] :getMailDetails() 3919 for Format Code :WRKFLWERR
2026-06-01 09:55:32,399 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~BaseStatement.java~executeQuery~BaseStatement sql 71:[SELECT SEND_TO, COPY_TO, BLIND_COPY, SUBJECT, BODY_TEXT, ATTACH_TYPE FROM MAIL_FORMAT WHERE FORMAT_CODE = 'WRKFLWERR']
2026-06-01 09:55:32,400 DEBUG [BaseLogger] (pool-16-thread-2) NA~NA~WorkflowProcessInstanceMonitorEJB.java~sendErrorMail~[ITMMailInfo] mailDetailList :[poonam.bhosale@baseinformation.com, null, null, Error Reported in Workflow, null, null]: