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

Logger Adapter Problem [1]

  • 1.  Logger Adapter Problem [1]

    Posted Mon December 02, 2002 12:19 PM

    I’m having problems getting the Logger Adapter to work. I’ve installed the Enterprise Adapters (v4.1.1), Adapter Development Kit (Runtime)/
    webMethods Enterprise Adapter Manager and the
    Enterprise Integrator Adapters.

    After going through pages 161-168 in the Enterprise Integrator User’s Guide version 4.6,
    I get a dialog with the following message:

    Could not restart the webMethods Enterprise
    Adapters.

    No configuration for adapter process
    “EntLogger” on broker “Broker #1@system1”

    Also, I don’t have the ent_logtables_mssql_create.sql file.
    What package do I need to download to get this
    file?


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: Logger Adapter Problem [1]

    Posted Thu December 05, 2002 02:35 PM

    Make sure you have an adapter configured named EntLogger. Create this using the Adapter Manager tool. Then execute the sql to create the logging tables. You can usually find them under
    C:\Program Files\webMethods\db\scripts\create\create_dbtables_Oracle.sql. Do a search on “ent_” and you will find what you need.

    HTH, Tom


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 3.  RE: Logger Adapter Problem [1]

    Posted Mon December 16, 2002 09:25 PM

    Hi,

    I m facing the same problem. I configured Logger adapter EntLogger but it gives the same error message. Infact it gives same error for the oracle adapter I configured. I created the table using the sql script provided. Please let me know if you have found any solutions for this.

    thanks in Advance
    rashmi


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 4.  RE: Logger Adapter Problem [1]

    Posted Sat December 21, 2002 12:10 AM

    Hi,

    which version of webMethods do you install? If you install 4.6, you can find script in c:\Program Files\webMethods\db\scripts\create.

    Regards,

    Chirag.


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 5.  RE: Logger Adapter Problem [1]

    Posted Mon December 23, 2002 05:44 AM

    If you are using adapter manager you need to do the following:
    Install the 411 adapter set
    Install the EI adapter set
    Install adapter manager
    Create and start an adapter process monitor
    In Enterprise Manager create a client group for the logger adapter
    In Adapter Manager create a new adapter instance of type logger
    The DDL for MSSQL should be somewhere in your wM directory structure


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 6.  RE: Logger Adapter Problem [1]

    Posted Thu January 23, 2003 02:07 PM
    1. Does webMethods supports Integration Monitor conection using SQL Server 2000 JDBC Drivers?

    I am not able to connect to IM using any JDBCURL and drivers even though JDBC drivers JAR files are in CLASSPATH. Any clues?

    jdbc:sequelink://162.138.118.70:19996;databaseName=loggertest

    com.merant.sequelink.jdbc.SequeLinkDriver

    OR

    jdbc:microsoft:sqlserver:://OS-S46857\TMLOGGERPROD

    com.microsoft.jdbc.sqlserver.SQLServerDriver


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 7.  RE: Logger Adapter Problem [1]

    Posted Thu January 23, 2003 02:10 PM

    I can connect to a deafult instance in SQL Server 2000 but not to a named server instance.
    I have used all possible DBURLs mentione below but it didn’t help.

    jdbc:sequelink://162.138.118.70:19996;databasename=loggerprod

    jdbc:sequelink://162.138.118.70\tmloggerprod:19996;databasename=loggerprod

    jdbc:sequelink://‘162.138.118.70\tmloggerprod’:19996;databasename=loggerprod

    jdbc:sequelink://162.138.118.70:19996;databasename=loggerprod;servername=tmloggerprod

    jdbc:sequelink://162.138.118.70:19996;servername=tmloggerprod

    jdbc:sequelink://162.138.118.70:19996;databasename=tmloggerprod\loggerprod
    I am trying to connect to EntLogger using IS administrator.

    http://localhost:5555


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 8.  RE: Logger Adapter Problem [1]

    Posted Thu January 23, 2003 02:14 PM

    License verification fails for all database tables when connected to the logger database using web URL �http://appsdev1:5555/EntLogger/�

    Service ent_activation:totals
    Error class java.sql.SQLException [MERANT][SequeLink JDBC Driver][SequeLink Server]License verification failed.


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 9.  RE: Logger Adapter Problem [1]

    Posted Fri January 24, 2003 01:02 AM

    Try starting your integration monitor like this:

    D:\webMethods\Ent5\EnterpriseIntegrator4\bin\integration_monitor.exe -classpath D:\webMethods\Ent4\jdbc\classes12.zip

    It’s VERY sensitive about classpath. Also look through the archives, this has been an issue before.

    Hope this helps.

    W


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB