Information Design Tool : Error ORA-00942: table or view does not exist

[Former Member]

Hi,

I am trying to connect to the Oracle DB using Oracle Client, but always end up with this error. The connection tests successful but fails to pull up the tables or views. However, with the same user, I am able to log in to TOAD and see the tables. So definitely not an access issue but then where does it fail..?

I am on SAP BI 4.1 SP7

Request your views on this, if you have got a solution to this earlier.

error-ora00942.png

[sateesh_kumar1]

Hi Krishanu ,

we should have 32 and 64-bit drivers to connect to BOBJ 4.x tools . Make sure these drivers installed in server also .

Regards

Sateesh

[former_member187093]

if you are DSN then create one 32bit and one for 64bit with same name.

[former_member182521]

In most of the cases the issue is something to do with your User credentials. Also I would also suggest you to take a look at Oracle SBO file if you missed to enable synonyms for the tables.

SBO file Location : <Install Dir>\dataAccess\connectionServer\oracle\oracle.sbo

Parameter : <Parameter Name="Include Synonyms">

Value : True

Thanks

Mani

[denis_konovalov]

you should enable IDT trace and look what it says.