ODAC version incompatibility
Changed from ODAC122010Xcopy_32bit to ODAC112040copy_32bit to get this working
Release : 8.35
Component : CA Business Service Insight
Windows 2016 OS
If the environment that you are running on single tier and Windows 2016 OS. Please do follow below steps and let me know the behavior if still facing the issue.
1.Uninstall existing odac and reInstall odac112040 attached to the case. i.e. ODAC112040Xcopy_32bit.zip
2. Steps to install odac
a.Extract the zip file to any directory (in this case c:\ODAC112040) and install it by running it's batch file as below:
b."install.bat all c:\ODAC112040 myhome true"
3.Update the odac path in environment variables and add the mentioned paths ODAC ,followed by 'bin' path
example: c:\ODAC112040 and then c:\ODAC112040\bin
4.Check and Add ORACLE_HOME if not exists(example:C:\app\Administrator\virtual\product\12.2.0\dbhome_1)
5.Check and Add TNS_ADMIN if not exists(example:C:\app\Administrator\virtual\product\12.2.0\dbhome_1\network\admin)
6.Remove the ORACLE Client path from the path variables if exist unless if you have multi Tier environment i.e. "C:\app\client\Administrator\product\12.2.0\client_1\bin"
7.Shutdown oblicore component services
8.Comment out requireSSL in the web.config(C:\inetpub\wwwroot\Oblicore)
"<!--<httpCookies httpOnlyCookies="true" requireSSL="true"></httpCookies>-->"