Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 10, 2017 at 04:12 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 10, 2017 at 06:41 PM

    you should enable IDT trace and look what it says.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 10, 2017 at 07:37 PM

    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

    Add comment
    10|10000 characters needed characters exceeded