Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

ORA-210000 Oracle error: ORA-01878: specified field not found in datetime or interval

vigneshn9321496
Employee
Employee

Hi,

I have a query in my workflow and I am using an expression

DateOnly(@START_DATE) greater than or equal to DateOnly(DaysAgo(14)).

When the query runs, for a few records which fall on Daylight saving time shift, is throwing an error.

Tried to use ToDate(@START_DATE) as well, and still the same issue.

Can someone assist on how to get rid of this.

Thanks,

Vignesh

2 Replies
florentlb
Level 10
Level 10

Hi Vignesh,

Can you psot a screenshot of your workflow or the activity throwing the error to check how it's configured?

Florent

vigneshn9321496
Employee
Employee

Hi Florent,

Issue was because of a few records which were present in the database which were in the Daylight saving time difference. Deleted those records and now the workflow runs fine without any issue.

Thanks,

Vignesh