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

JDBC Pool Alias & TN tables

  • 1.  JDBC Pool Alias & TN tables

    Posted Thu June 19, 2008 05:39 PM

    Hi,

    I am using wm6.1 IS . I have installed the JDBC adapter 6.0.3.

    JDBC Adapter: I could successfully create the connection and connect.

    JDBC Functional Alias: Also successfully connect.

    Oracle DB Version : 9.2

    I have installed the gien TN DB Scripts
    create_TN_6-1_Oracle.sql
    create_prt_6-1_Oracle.sql
    create_iscoreaudit_6-1_Oracle.sql

    With out any error, script executed successfully.

    I tried to open wm TN Console. It is throwing the below error.

    Title:
    wm.tn.admin:startup
    Message:
    Error when reading database cofiguration. The exception message is : [BAJ.0001.0006] JDBCConnMgr: Invalid functional alias argument, found …
    (0) com.wm.util.BasisSQLException: [BAJ.0001.0006] JDBCConnMgr: Invalid functional alias argument, found .
    (1) com.wm.util.BasisSQLException: [BAJ.0001.0006] JDBCConnMgr: Invalid functional alias argument, found .
    Class:
    com.wm.app.tn.db.DatastoreException

    Stack Trace:
    com.wm.util.BasisSQLException: [BAJ.0001.0006] JDBCConnMgr: Invalid functional alias argument, found .
    com.wm.util.BasisSQLException: [BAJ.0001.0006] JDBCConnMgr: Invalid functional alias argument, found .
    com.wm.util.BasisException: [BAJ.0001.0006] JDBCConnMgr: Invalid functional alias argument, found .
    at com.wm.util.BasisSQLException.(BasisSQLException.java:95)
    at com.wm.app.jdbc.JDBCConnPoolAdmin.checkAlias(JDBCConnPoolAdmin.java:97)
    at com.wm.app.jdbc.JDBCConnPoolAdmin.getConnPoolConfig(JDBCConnPoolAdmin.java:697)
    at com.wm.app.tn.db.Datastore.init(Datastore.java:114)
    at wm.tn.admin.startup(admin.java:689)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:324)
    at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:287)
    at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:554)
    at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
    at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:221)
    at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49)
    at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:194)
    at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:39)
    at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:384)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:486)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:359)
    at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:246)
    at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:128)
    at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:100)
    at com.wm.app.b2b.server.SessionInvoke.run(Session.java:705)
    at com.wm.util.pool.PooledThread.run(PooledThread.java:105)
    at java.lang.Thread.run(Thread.java:534)

    Note:-

    I tried to connect for 10g Oracle server also same error.

    Please suggest how to solve this issues.

    Warm Regards,
    Gopinath K.M


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


  • 2.  RE: JDBC Pool Alias & TN tables

    Posted Thu June 19, 2008 05:56 PM

    Do you have any fix or service pack for TN ?


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