Challenge with generating line listing Event Reports

[phil (Philip Larsen Donnelly)]

@maikel

Just a naiive question:

from the first exception in the log posted

@khatman

org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [select count(psi) as value,ax.“uidlevel3” from analytics_event_fxpgw6evdvb as ax where ax.“yearly” in (‘2021’, ‘2022’) and ax.“uidlevel3” in (‘JEhqFsfXxTt’,‘VSxknPhjR6o’,‘M7qFOnwmE3A’,‘Qq4jYe5tHnl’,‘mNzjvxYEHkq’,‘nFPxXeZftGm’,‘eWjt9Zl76FS’,‘HqJwxVQhfyM’,‘uqh2OI3no6W’,‘aeBwvrjdh7m’,‘hfal93WttYV’,‘qnw9ul9mgww’,‘Kts15CHhP3h’,‘Er2eXRYQ5kD’,‘mdpCE7IYau0’,‘HR8JDs4Sae5’,‘GBeQB9YNmP4’,‘L4FwAUd37Wp’,‘KlCB0HQHtbg’,‘dJssgIzIiL4’,‘TBh00t5LnBZ’,‘lpjb08mkXcY’,‘soweCPFSM7L’,‘isI5LRdu80m’) and (coalesce(“IaiCT78oIaU”,‘’) >= ‘2019-07-01’ and coalesce(“IaiCT78oIaU”,‘’) <= ‘2019-07-31’) and ax.“yearly” in (‘2021’, ‘2022’) group by ax.“uidlevel3” ]; ERROR: invalid input syntax for type timestamp: “”
Position: 508; nested exception is org.postgresql.util.PSQLException: ERROR: invalid input syntax for type timestamp: “”

As you said, it seems to be complaining about (coalesce(“IaiCT78oIaU”,‘’) returning an empty timestamp (which it tries to match to a time range).
Would it be useful for @khatman to check the data for that object IaiCT78oIaU to see if there is an issue with the data, and potentially correct it?

Thanks,
Phil