BOE using Oracle 32 and 64 bit drivers side-by-side (Windows 2008)
Baseline 4.0 (FP3)
We have installed BOTH the 32 and 64 bit Oracle Clients on the Windows 2008 (64 bit) servers that host our BO BI 4.0 (FP3) environment.
Had to install BOTH because the 64-bit CMS service (and others) need the 64-bit Oracle driver, but the 32-bit CrystalReports2011Processing service still needs the 32-bit Oracle driver.
Environment variable on Test servers:
The content is all in the Crystal Reports XI (R2) / 2008 / 2011 format - NOT the new CR for Enterprise 4.0 format.
CMS/AUDIT starts OK connecting to Oracle. (CMS is 64-bit service)
Crystal Reports can be run and viewed OK when SCHEDULE and View INSTANCE is used. (AdaptiveJobServer is 64-bit service)
Reports FAIL with the errors below when run as VIEW-ON-DEMAND...or when REFRESHING a Successful Crystal Report INSTANCE from within the Crystal Viewer in CMC or Launchpad. (CrystalReports2011Processing service is 32 bit)
The viewer could not process an event. Error in File ApplicationRoles:
Failed to load database information. 
---- Error code:0 [CRWEB00000119]
We have been around-and-around on this for a couple of weeks with SAP support (both "off-shore" and Vancouver) - and have worked with following SAP NOTES...
1674528 - Unable to start the CMS in BI 4.0
In BI 4.0, in order to connect with CMS database it is required to have64-bit client installed on the server.
If you have also installed 32-bit Oracle client for Crystal reports 2011 along with the 64-bit Oracle client, Check if the following Environment variables are set properly:
ORACLE_HOME=<64-bit version of the Oracle client>
If the problem still persists, remove ORACLE_HOME and ORACLE_HOME32 and restart the Server machine.
Start the SIA, the CMS.exe will come up
1679341 - Unable to View Crystal Reports after migration from BO XI R2
We appear to have completed all of these suggestions OK - but without any change of state.
Anyone else having this issue...? Anyone got other suggestions for us to try...?
Thanks in advance.