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.
yeah, came out to be a table column issue which RSA creates dynamically in data collection process and is limited to 256 char limit. As you see here, these cache roles are complex, logical and quite lengthy, hence the reason they are not being read in collection.
Raised another question here - varchar limit for Entitlements in data-collection but there is nothing we can do for this application apart from asking app team to suggest some alternative column representing roles, if they can or else I dont see automation option for it.