type "dateand" does not exist

Darji Yogenkumar shared this question 2 months ago
Completed

I am using yellowfin-app-only-interim:9.11.0.2-20240430 version

Please suggest solution for the same.


while calling REST API api/user-groups/15991/flat-users we are getting error

<div>org.postgresql.util.PSQLException: ERROR: type "dateand" does not exist</div>

Info log generate below query, I think which is wrong see dateAND, there should be space between date and AND


<div>SELECT DISTINCT f.AccessGroupId, f.IpPerson, f.IpOrg FROM AccessGroupFlat f, Person p, IpClass c WHERE f.AccessGroupId = 15991 AND f.IpPerson = p.IpPerson AND f.IpPerson = c.IpId AND c.StartDate <= '2024-08-07'::dateAND (c.EndDate IS NULL OR c.EndDate > '2024-08-07'::date)
</div>

Replies (1)

photo
1

Hello Darji Yogenkumar,

It appears that a duplicate ticket has been generated for the same issue. Therefore, I will be closing this ticket, and we will proceed with the discussion in the active ticket. (https://community.yellowfinbi.com/agent/report/5/object/30026).

Regards

Siddhartha

Leave a Comment
 
Attach a file