IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

ORA-00942: table or view does not exist

  • 1.  ORA-00942: table or view does not exist

    Posted Sun May 27, 2018 04:00 AM

    Hi All,

    I am getting below errors in server log, when I started integration server. Could you please suggest the resolution.

    java.sql.SQLSyntaxErrorException: [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

    Using Oracle Express edition.


    #webMethods-General
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: ORA-00942: table or view does not exist

    Posted Mon May 28, 2018 11:44 AM

    Hi,

    as per the error message indicating an older driver version I assume you are running on IS 8.2 or older.

    Can you elaborate which table the error message is referring to?
    Was the DB Configurator used to create the appropriate schema on the database.

    Which version of express edition are you running?

    Regards,
    Holger


    #Integration-Server-and-ESB
    #webMethods
    #webMethods-General