Bulk fetch failed. (HY000)

Summary

While casting date in the filter criteria getting error for BulK Fetch Failed - OTBI

Content

Requirement - Service Anniversary report (Need to get the Employees details, whose service anniversary are coming in next 30 days)

Approach - We are taking Employee Hire Date and doing casting (Current year and month and date from hire date) and checking this date between current day and next 30 days.

The error doesn't come when we run it for specific employees or locations.

Filter - 

CAST(CAST((cast (@{YEAR}{VALUEOF("CURRENT_YEAR")} as INT)) as CHAR(4)) || '/' || CAST(MONTH("Worker"."Employee Hire Date") AS CHAR) || '/' || CAST(DAY("Worker"."Employee Hire Date") AS CHAR) AS DATE)