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

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

    Posted Fri February 09, 2024 02:11 AM

    imagehttps://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/7b5e63353907d2e639517e937210590075445d90_2_1035x460.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/7b5e63353907d2e639517e937210590075445d90_2_1380x614.png 2x" data-dominant-color="E9EDF1">
    image1910×852 96.4 KB

    Hi everyone,
    when i started the integration server the below error is popping up and also i could not configure the my webMethods server while configuring the database component configuration the same error is occurring .

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

    currently I’m using webMethods 10.15 and oracle sql developer.

    Thanks in advance,
    ArunaSri.


    #webMethods
    #webMethods-io-Integration
    #API-Management
    #Developer-Portal
    #webMethods-cloud


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

    Posted Fri February 09, 2024 03:02 AM

    Well, without a lot more information about your setup, I can only tell the obvious. Which is that a table or view is missing.

    Please try to look at this from the outside to get the best possible help here. Without knowing what you have done so far (e.g. did you run the DB configurator?) and what your setup looks like, there is no way to help you.

    Also, what documentation did you use to setup your environment?


    #webMethods-cloud
    #webMethods-io-Integration
    #Developer-Portal
    #API-Management
    #webMethods


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

    Posted Fri February 09, 2024 10:27 AM

    Without more information all I can recommend is to update your DB configurator and your integration server to latest fix level and run DB scripts again. Don’t skip pre-installation and after installation steps though. That’s what usually causes these kind of missing table errors.


    #webMethods
    #webMethods-io-Integration
    #Developer-Portal
    #webMethods-cloud
    #API-Management


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

    Posted Mon May 06, 2024 11:16 AM

    Hi Arunasri,

    did you resolve the issue, I am facing the same and I see in scheduler’s it is not able to connect to the DB and throwing an exception as attached.
    Let me know if you get the solution for this.

    FYI… I used to connect when I installed initially after some time it has started throwing exception.

    imagehttps://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/c84993a1963da38acb70784e10e9e4014550ca36.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/c84993a1963da38acb70784e10e9e4014550ca36.png 2x" data-dominant-color="CDD6DD">
    image815×523 36.2 KB


    #webMethods-cloud
    #webMethods-io-Integration
    #Developer-Portal
    #webMethods
    #API-Management


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

    Posted Mon May 06, 2024 11:50 AM

    to update the thread, the issue has been resolved.
    I have run the DB scripts and used different schema for this JDBC pools.


    #webMethods-io-Integration
    #webMethods-cloud
    #API-Management
    #Developer-Portal
    #webMethods


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

    Posted Mon May 06, 2024 11:50 AM

    Hi Madhava,

    is there anything in the logs, which table or view cannot be found?

    Did anything change to your installation, when the exception started to occur?

    Regards,
    Holger


    #webMethods-io-Integration
    #webMethods-cloud
    #API-Management
    #Developer-Portal
    #webMethods


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

    Posted Mon May 06, 2024 11:51 AM

    sorry, its my bad, unfortunately I have used wrong schema (some how it got updated since installed :frowning: ).


    #API-Management
    #webMethods-cloud
    #webMethods-io-Integration
    #Developer-Portal
    #webMethods


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

    Posted Mon May 06, 2024 11:59 AM

    Hi Aruna,

    referring to Engin´s replies, please check for latest DataDirect fixes, as error message indicates a DataDirect Driver version 4.2, which is quite old.
    SAG has introduced DataDirect Driver version 5.x some time ago during the wM 9.x stream already.

    Regards,
    Holger


    #Developer-Portal
    #webMethods-io-Integration
    #webMethods-cloud
    #webMethods
    #API-Management


Related Content