on 01-10-2010 7:38 AM
Dear Gurus,
I am trying to access universe through WEB INTELLIGENCE but the connection is giving me following error
DBDriver failed to load dbd_oci.dll (not a valid Win32) (WIS 10901)
"A database error occured. The database error text is: (CS) "DBDriver failed to load : C:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\dbd_oci.dll (%1 is not a valid Win32 application.
)" . (WIS 10901)"
As per the documentation , web intelligence uses BO server connection while tools like Designer uses local connection.
I am working on BO server only , both tool should use the same connection.
OS : MS WIndows 2003 R2 64 Bit
BO Server : bosmserv
Oracle : Oracle 10.2.0.4 , client 10.2.0.4
Connection to database schema is working through universe designer and System DSN but not through Web Intelligence.
In addition JDBC connection to the same databse schema is giving me following error CS: Java Class not found in classpath : oracle.jdbc.OracleDriver
Please suggest.
Note : I have already applied following note :
1378354 - If we create the webi document, the error occured "The specified module could not bi found(dbd_oci.dll), (WIS 10901)"
Regards
Arif
I followed the steps to create the relational JDBC connection for oracle 10 G
"c:\program files\business objects\businessobjects enteprise dataAccess\connectionServer\jdbc\oracle.sbo" file,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
i had same issue!you need install oracle client in the bo server,and test the connection again.if not available try the command below:
sqplus /nolog
conn user/pass@service name
if the command works the universe should work either,otherwise the user in boe server is not administrator.after you conform the connection make sure restart sia which is the last but not least thing.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
How to register oracle client driver files into Windows 2003 properly ? I installed [oracle client for win x32|http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html] I've tryed to find some setup file but it didn't exist in folder where I've unpacked archive. BO still doesn't see files like ociw32.dll or files for jdbc connection (((
I have BO Server and Oracle DB on two different hosts/
Edited by: antoxic87 on Oct 27, 2011 1:14 PM
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html
you need :
Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (32-bit)
win32_11gR2_client.zip (684,581,290 bytes)
Contains the Oracle Client Libraries. Download if you want the client libraries only.
However, check Supported Platforms guide for the exact version of supported Oracle drivers for your version and patch level of BOE.
You need oci.dll which comes with the Oracle instant client (or the regular Oracle client).
To set path:
1.From the desktop, right-click My Computer and click Properties.
2.In the System Properties window, click on the Advanced tab.
3.In the Advanced section, click the Environment Variables button.
4.Finally, in the Environment Variables window, highlight the Path variable in the Systems Variable section and click the Edit button. Add or modify the path lines with the paths you wish the computer to access. Each different directory is separated with a semicolon.
It might just be easier for you to install the regular Oracle client. If you do use the instant client, I'd suggest using Oracle's documentation as they'd probably explain it better than I can.
Hi All,
I had tried many ways but I still can't solve this error, can anyone tell me how to solve it?
OS of the Server: Windows Server 2008 R2 Enterprise 64 bits
SAP BO : BI 4.0 with SP2
DB: Oracle 11g , 64 bits
Problem: When I create a new relational connection in Information Design Tools, it pop up an error state that:
DBDriver failed to load : ...SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\drivers\lib32\dbd_oci.dll (%1 is not a valid Win32 application.)
So far What I had done are:
1) I checked the PATH windows variable and the D:\app\oracle\product\11.2.0\client_1\bin directory is inside the PATH.
2) Restart SIA and Server
3) I download the Install Client and this do not solve the error also.
I can connect to the Oracle by using SQLPLUS and TNSPING also can ping the oracle database.
Try this1 by 1
1) Restarted the SIA from the CCM
2)Also you could check the PATH variable
Right click on My computer-->Advanced tab. Environment variables in that tab. Check the path in system variables and if the path of your oracle client is not there include it like this C:\Oracle\Ora10_2\BIN ,Also make sure of the tnsentry in your local machine.
3)need the path to your oracle home, not BO's connection server.
I tried second method and it worked like charm
I installed tools clients and BO 4.0 in the same server.
I can't access a universe because error:
"A database error occured. The database error text is: (CS) "DBDriver failed to load : C:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\dbd_oci.dll (%1 is not a valid Win32 application.
)" . (WIS 10901)"
Now probe all this
What additional work do I do?
I installed clients tools in other box and I created universe with a jdbc.
All this is ok but now I have this error:
Error de base de datos: (CS) "DBDriver failed to load : java.lang.ClassNotFoundException: com.businessobjects.connectionserver.java.drivers.jdbc.oracle.OracleDriver [com.businessobjects.connectionserver.java.drivers.jdbc.oracle.OracleDriver]" . (IES 10901) (WIS 10901)
What can I do??
The classpath is ok and I edited jdbc.sbo, oracle.sbo.
For those still facing this problem, I found a solution:
Just add the appropriate ojdbc path to the jdbc.sbo file.
See:
Edited by: Dirk Ewering on Apr 12, 2010 9:06 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
[Problem]
I've got the exactly same error message "server is not responding SBO0001. DBD: java class not found in classpath" when creating a new universe on Universe Designer of BusinessObjcts XI 3.1.
[Solution]
Find "c:\program files\business objects\businessobjects enteprise 12.0[win32_x86\dataAccess\connectionServer\jdbc\jdbc.sbo" file, and add the following line "<path>c:/lib/ojdbc14.jar</path>".
[Problem]
I've got the exactly same error message "java class not found in classpath" when creating a new report in CrystalReports XI.
[Solution]
Find "c:\program files\business objects\common\3.5(or 4.0)\java\crconfig.xml" file, and add the following "c:\lib\ojdbc14.jar;" at the beggining of <classpath>xxx</classpath>.
I had this same error using a version of Business Objects Enterprise for HP Storage Essentials,
the fix was to add the Oracle Client folder into the Path environament variable.
for example the resulting PATH:
Path = C:\Oracle\instantclient_11_1;C:\HP\SRMReportOptimizer\jre\bin;C:\Oracle\Ora10\bin;%SystemRoot%\system32;
%SystemRoot%;%SystemRoot%\System32\Wbem
The folder C:\Oracle\instantclient_11_1 was added on to the front of the variable,
After making that change I restarted the SIA and now we get data in the reports.
User | Count |
---|---|
71 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.