Annoying Unable to FIND Issue.

customaware

I have a Process as follows.....

Inputs are: Employee, NP_Enquiry_Date, LeaveAssignment

ThisLeaveAssignment.UsedToENQUIRY_DATE=
SUM AbsenceApplicationEvent.EventDays_Temp WHERE 
(
	AbsenceApplicationEvent.ob_Application.ob_Employee = Employee AND 
	AbsenceApplicationEvent.ob_Application.Status <> 'CANCELLED' AND 
	AbsenceApplicationEvent.ps_LeaveType = ThisLeaveAssignment.ps_LeaveType AND 
	AbsenceApplicationEvent.DateTempEnd <= NP_Enquiry_Date.Enquiry_Date AND 
	(
	    (ThisLeaveAssignment.EndDateDefined = 'Yes' AND ThisLeaveAssignment.SaldoMode='Yes')
        OR
		(ThisLeaveAssignment.EndDateDefined <> 'Yes' AND AbsenceApplicationEvent.DateTempEnd>=ThisLeaveAssignment.StartDate)
        OR
		(ThisLeaveAssignment.EndDateDefined = 'Yes' AND AbsenceApplicationEvent.DateTempEnd < ThisLeaveAssignment.EndDate) 
	)
)

For some weird reason I am continually seeing this error in the Aware Logs...

Unable to find ThisLeaveAssignment.EndDate in aggregate operation SUM

I have spent hours testing and have pinned it down to this part.....the last OR

(ThisLeaveAssignment.EndDateDefined = 'Yes' AND AbsenceApplicationEvent.DateTempEnd < ThisLeaveAssignment.EndDate)

I have tried changing the order of the ORs and the order of testing. I even added the This just in case.....

But still gives the error.

Maybe I am to close to it and cannot see the forest for the trees.

Any ideas or suggestions would be welcomed.... 🙏🏼

Jaymer

No need for the THIS unless you're finding another LeaveAssignment (i understand u were just trying stuff)
Possible that there's NO LeaveAssignment on this particular run?
Insert a LOG2 CONTEXT to see what all is in context. make sure there's only 1 LeaveAssignment

customaware

Thanx Jaymer,

I only added the This just in case it made any difference.

there is Definitely a LeaveAssignment being passed to the process

I will check out the LOG2 CONTEXT suggestion.

ACDC

Unable to find ThisLeaveAssignment.EndDate in aggregate operation SUM

I had something similar going on and solved it by creating a new EndDate attribute.(delete the existing one or create EndDate2)

There must have been something lurking in the upgrade process to the new V9 version, maybe it's related.