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]

1. No need for the THIS unless you're finding another LeaveAssignment (i understand u were just trying stuff)

2. Possible that there's NO LeaveAssignment on this particular run?

3. 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.