Cognos Controller 10.3
Oracle 12c database
Microsoft Windows 2008 R2 server
Got error in Cognos Controller client when doing a database optimization or run a Reconcile – Intercompany Balances.
An unexpected error has occurred
System.ArgumentException: System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.Exception: fgsql c:\program files\ibm\cognos\ccr_64\server\progs\fgsql.prg Error in line 324 Connection handle is invalid. 1466……
Only the 64 bit oracle drivers are installed. Install the 32 bit oracle drivers on the Cognos Controller server.
The small calculations component is still 32 bit in the 64 bit version of Cognos Controller. Therefor you must have both 64 bit and 32 bit database drivers installed on the Controller servers.