Error occured when deleting temporary VFP files: ODBC error (2)

by ·0 Comments

Product:
Cognos Controller 10.3
Oracle 12c database
Microsoft Windows 2008 R2 server

Problem:
Got error in Cognos Controller client when doing a database optimization or run a Reconcile – Intercompany Balances.

Error message:
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……

Solution:
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.

More information:
http://www-01.ibm.com/support/docview.wss?uid=swg21365329
http://www-01.ibm.com/support/docview.wss?uid=swg21677791
http://www-01.ibm.com/support/docview.wss?uid=swg21676449