Possibly the wrong forum for this - but it’s where I get the error…
I can run webi reports with no problem on our live R3 environment. When a universe is migrated from dev using the import wizard, everything is fine. But when the universe is migrated with life cycle manager, webi reports stop running and I get:
A database error occured. The database error text is: (CS) "DBDriver failed to load : D:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\dbd_oci.dll (%1 is not a valid Win32 application.
)" . (WIS 10901)
for oracle universes or else a DSN error for SQL Server universes.
The DSNs exist on the servers and everything is fine when import wizard is used. Clearly LCM is overwriting something, but not sure what or where.
The reason I say probably is that the connections on universes over the data warehouse point to different databases depending on where the universe is (saves having to repoint the universe after migration). The idea behind this was so that a bob universe in DEV points to the test warehouse and the same Bob universe in PROD points to the live warehouse. The connection does something all by itself with oracle to apply the relevant oracle security (using @BOUSER, I think).
But I don’t really know what I’m talking about (no change there, then), so will go and grab my tech support and point him to this thread.
Maybe. But having gone back and checked - I also get the same error message on another oracle database that has a simple connection (connects to the same copy database in both DEV and PROD environments), so there must be something more to it.
My amazingly wonderful tech support who does all the migration, CMC & security stuff has wandered off. Hopefully he’ll be along by here at some point. (Flattery gets me everywhere…)
I hate to even stick my foot in because of my ignorance in LCM, but I’ve seen similar errors with oracle due to Path problems to Oracle home. I had to set that on the client machines in Designer, on my server for Webi.
Also, if there is anyting custom in any oracle configuration (the .SBO file, for example) - if that’s not consistent, you may see something similar.
Just putting that out, in case it’s that simple. If not, disregard : )
When I’ve discussed with Debbie, I’ve pointed out that I think its my lack of experience with LCM (which as a tool, is fairly easy to use) and best practise with regards to migration etc.
When I’ve moved back to the Import Wizard, thats moved the Universes fine.
I’m on the look out for some kind of tutorial or best practise for the LCM tool! So if you know of one, please let me know!
We tried migrating all the universe again using the wizard. But still nothing works in prod. Looks like LCM has definitely reset something somewhere!
On my pc, I checked the connections in dev & prod. All work OK. Then I remembered that they’d be using DSNs and settings on my hard disk, so I logged onto Designer on the actual servers. And sure enough - the connections on the dev server are fine, but all the connections on the prod server are broken with the same dll/dsn errors.
I don’t want to rebuild connections in prod since they get overwritten from dev on every migration. But the ones in dev are fine - yet migrating them doesn’t fix the issue.
Any clues? We’re in the dark here, though fortunately the R3 system isn’t yet live!
Andreas - thanks for that guide. That all makes sense, but I’m still unsure in what circumstances to migrate what using the LCM. :?
With regards to the:
CS: DBDriver failed to load : D:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\dbd_oci.dll (%1 is not a valid Win32 application.
)
Error, I’ve searched and found a thread on the SAP forums here:
…and I found that the path listed in the above error message wasn’t in the PATH system variable, so I’ve added it, but it doesnt seem to have made much of a difference.
Do you have a reference to the oracle path in your PATH variable?
It’s pure voodoo, but look for references on that - don’t waste a lot of time on it, but at least eliminate it as an issue… I think you need a path down to oracle home\bin.
When I try to create a webi report in 4. I am getting DB driver failed to load. DBD_oci.dll is not a valid 32 bit application. I reinstalled the Oracle database in my system. Still facing the same issue.
I have installed only one oracle 64 bit in my system. At first I have installed oracle 10g. But after some research in google I have uninstalled oracle 10g and installed oracle 11g.But still Iam facing the same issue. The system details are:
OS: Windows server 2008
SAP BO: BOBI 4.0
DB: Oracle 11g