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

After Upgrade : Adapter connection is not working

  • 1.  After Upgrade : Adapter connection is not working

    Posted Fri October 01, 2021 04:45 AM

    Hi experts,

    We had done migration from 9.9 to 10.5. One of our adapter connection got failed and throwing an error.
    The confusion part is , we are not sure before migration that adapter is enabled or not. Is it possible to find that adapter is enabled or disabled before migration.

    Error :

    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource com.tele2.dbconnectors.sd.changeMonitor.dbconnectors:CHANGE_MONITOR_STUB.
    [ART.118.5063] Adapter Runtime (Connection): Unable to start connection com.tele2.dbconnectors.sd.changeMonitor.dbconnectors:CHANGE_MONITOR_STUB: after 1 attempt(s).
    [ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleConnectionPoolDataSource”.
    Listener refused the connection with the following error:
    ORA-12505, TNS:listener does not currently know of SID given in connect descriptor


    #webMethods-io-Integration
    #DB
    #adapter
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: After Upgrade : Adapter connection is not working

    Posted Fri October 01, 2021 05:19 AM

    I don’t see a way unless you have a pre-upgrade copy of the package, but here are some indirect ways -

    Namespace - Can you navigate to the folder namespace in the backend and see the timestamp on the internal file for the connection?

    DB Logs - This message usually happens when the Listener is stopped on the DB side (or incorrect SID, which seems unlikely in your case). You can look for a timestamp in the DB logs to see if this Listener was stopped any time recently.

    Connection History - Else if the DB is online, you can get the DBA to check when was the last time the user configured in this connection, actually connected to the DB.

    KM


    #DB
    #webMethods
    #Integration-Server-and-ESB
    #adapter
    #webMethods-io-Integration