Skip to Content
0

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

Jan 10, 2017 at 03:18 PM

122

avatar image

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

error-ora00942.png (47.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Sateesh Kumar Jan 10, 2017 at 04:12 PM
1

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Denis Konovalov
Jan 10, 2017 at 06:41 PM
0

you should enable IDT trace and look what it says.

Share
10 |10000 characters needed characters left characters exceeded
Manikandan Elumalai Jan 10, 2017 at 07:37 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded