Error when connection to Oracle 11 "Host cannot be reached " (Bussiness Objects Enterprise XI 4.0)

[Former Member]

Hi Gurus

I am facing a problem when trying to create data foundation on Information Design Tool. I got an error as "Host cannot be reached".

I have a connection to Oracle 11 and the connection was successfully connected (when create connection on IDT).

SAP BOBI server is WindowsServer 2008R2 Standard .

I have Oracle Client installed on both server and my pc.

When I check the conection on Data Federation Administration Tools I got an error message as : DBDriver failed to load : C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\drivers\lib64\dbd_oci

The strange thing is; I can only see a table on oracle database when insert derived table and it is only when I create data foundation on a local connection. But I always get an error "Host cannot be reached" when try to create data foundation on a connection published in repository. Plus the on derived table doesn't have any data in it even there is data on Oracle database

Has anyone experienced this issue and how you fixed it?

Your help is highly appreaciated

[denis_konovalov · Accepted solution]

Do you use IDT on server or client ?

Does server has both 64bit and 32 bit Oracle drivers ?

Does your client has 32bit Oracle drivers ?

[former_member184594]

Install Oracle 64 bit client on the server and then do the following:

1. If 64 bit Oracle client is not installed on the machine, install 64 bit client on the server. The client can be downloaded from the link below.

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

2. Go to Computer > Properties > Advanced System Settings.

3. Advanced Tab > Environment Variables

4. Check Path. If Oracle client path is not defined. Enter path here.

E:\app\localadmin\product\11.1.0\bin

E:\app\localadmin\product\11.1.0\client_1\BIN

5. Check also ORACLE_HOME variable if it is not defined, enter the path.

E:\app\localadmin\product\11.1.0\client_1

Check also SAP notes 1578731, 1619829.

[Former Member]

Hi Denis and Zahid,

Thank you very much for your helpful comments. Now I can see list of tables! . However when I tried to creat data foundation and add tables I got an error message as : ora-00936 missing expression.

Do I miss something?

[former_member184594]

Honestly this one I don't know. It seems that you have database problem because the error you are getting is Oracle error not a BusinessObjects error. Check your DB user rights if you have sufficient access to the DB and search for ORA-00936 error in Oracle.

http://www.dba-oracle.com/sf_ora_00936_missing_expression.htm

[Former Member]

It seems that the issue is with queries generated while creating the data foundation, there might be some links which are missing. can you check if the tables are linked appropriately. Additionally as suggested by zahid ensure the user has appropriate rights at DB level as well.

[Former Member]

Hi,

Was the issue of ORA 00936 resolved??? I am facing the same issue.

Thanks.

Purav

[former_member202789]

Hi,

Check your Oracle client version. Two things, either it could be a know issue in this version of Oracle client or a known issue with IDT with this version of oracle client that you are using.

ORA-00936:	missing expression
Cause:	A required part of a clause or expression has been omitted. For example, a SELECT statement may have been entered without a list of columns or expressions or with an incomplete expression. This message is also issued in cases where a reserved word is misused, as in SELECT TABLE.
Action:	Check the statement syntax and specify the missing component.

Regards,

Animesh Kumar

[former_member202789]

Check this SAP Note : 1725557 - IDT ORA-00936 Over Clause Error

[Former Member]

Issue is resolved.

Solution: Don't mention Oracle path of 32bit on BI 4.0 server. We need to have Oracle Client (64bit) installed on server and path for same should be mentioned in ORACLE_HOME in environmental variables.

Thanks,

Purav

[Former Member]

Hi Denis

I tried IDT on both client and sever. Results are the same. I have 32 bit Oracle Driver installed on my client. The server has also 32 bit Oracle driver installed. This mean I have to install both Orcale Clients 32 and 64 bit on both client and server?

[denis_konovalov]

Only on the server.