I have question regarding case insensitivity with Oracle database. I can't log into Console or Web Desk using 'sa' username, but I have to use 'SA' instead. With SQL there wasn't such problem.
The second problem is case insensitivity in query criteria. I've added key:
<add key="ClobCaseInsensitivity" value="true" /> to C:\ProgramData\LANDESK\ServiceDesk\ServiceDesk.Framework\tps.config and C:\ProgramData\LANDESK\ServiceDesk\ServiceDesk.WebAccess\tps.config. Then when I created test query with "contains" criteria on Title it's not working, but it's working with same criteria on Description field. Please help!