webMethods

webMethods

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

problem between webmethods 4.1.1 and oracle 8i! Need help!!!

  • 1.  problem between webmethods 4.1.1 and oracle 8i! Need help!!!

    Posted Fri August 22, 2003 01:21 AM

    hi, guy. we met a very serious problem. We installed oracle 8i, and webMethods 4.1.1 in one machine. We found that no oracle intelligent adapters could run properly if we connect the adapter to the database. We found that the adapter is all right if it connected to a remote database. All the configuration are following:
    HARDWARE:Petium 4. 1.8GH.
    Software:Windows 2000. Oracle 8i, webMethods 4.1.1
    Problems get when we started the oracle intelligent adapter in testing mode:

    1:53:42 PM [Debug] 0 println exec SQL SELECT USER FROM DUAL
    1:53:42 PM [Debug] 0 println SQL: COMMIT
    1:53:42 PM Note: could not read list of integration component names from broker. This can happen if no integrations have been created for this adapter yet.
    1:53:42 PM Unknown Infoset (227-1500): There is no infoset named ‘Tracking’ defined on document type ‘AdapterConfig::SouceTestApp’ in the broker.
    1:53:42 PM [Debug] 0 println exec SQL SELECT value, valueNo FROM awo_dbadapter WHERE valueNo > 0 AND broker = ‘test@tcsch114’ AND adapter = ‘SouceTestApp’ AND timeStamp != 1061531621 ORDER BY valueNo
    1:53:42 PM [Debug] 0 println SQL: COMMIT
    1:53:42 PM [Debug] 0 println exec SQL DELETE FROM awo_dbadapter WHERE broker = ‘test@tcsch114’ and adapter = ‘SouceTestApp’ AND timeStamp != 1061531621
    1:53:42 PM [Debug] 0 println SQL: COMMIT

    I build a broker named ‘test@tcsch114’ , and did nothing about it any further.what did it mean :"could not read list of integration component names from broker. This can happen if no integrations have been created for this adapter yet.
    "???
    it is strange that if we connect the adapater to remote oracle 8i , everything went fine. And remote oracle adapter could also connect to my orcacle database. What happened?
    Any help will be appreciated!!!Thanks in advance.


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


  • 2.  RE: problem between webmethods 4.1.1 and oracle 8i! Need help!!!

    Posted Mon August 25, 2003 10:51 AM

    Two things come to mind that may uncover something (i.e. wild guesses):

    1. check to see if the Oracle install modified the machine’s CLASSPATH and or replaced other shared jars or DLLs.

    2. check to see what ports are in use in both situations. I like the TCPView tool from www.sysinternals.com because it will relate port to owning processes.

    HTH,
    Fred


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