I have configured a cache DB based application in IGL through custom connection. I have deployed the driver and did connection, which worked. Although, when I am collecting entitlements in EDC, I am getting error when using distinct keyword in query. The entitlements look complex as you see in below screenshot which I am guessing is the reason. The exception in query test page is below. Please let me know how can i fix this error.
FYI: It works fine without distinct keyword but that will reject if two or more users have access to same entitlements.