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.  TN Console Error

    Posted Thu August 19, 2010 04:03 PM

    Hi Experts,

    Please help in resolving the error:

    ErrorMessage:
    TRNCONS.000001.000005
    ERROR






    PingCache
    refresh
    Thu Aug 19 19:57:47 GMT+05:30 2010

    0003.4114
    Could not get profile summary (username=Administrator).

    com.wm.app.tn.profile.ProfileStoreException
    Could not get partners for user (username=Administrator).
    (0) java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
    (1) java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist


    Check that the server is running and accessible. Check that the current user has ACLs to access wm.tn:ping.
    com.wm.ui2.UiException: wm.tn:ping
    com.wm.app.tn.err.EXMLException
    0003.4114
    Could not get profile summary (username=Administrator).

    com.wm.app.tn.profile.ProfileStoreException
    Could not get partners for user (username=Administrator).
    (0) java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
    (1) java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

    null
    wm.tn:ping
    com.wm.app.tn.err.EXMLException
    0003.4114
    Could not get profile summary (username=Administrator).

    com.wm.app.tn.profile.ProfileStoreException
    Could not get partners for user (username=Administrator).
    (0) java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
    (1) java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

    null
    null

    com.wm.ui2.UiException: wm.tn:ping
    com.wm.app.tn.err.EXMLException
    0003.4114
    Could not get profile summary (username=Administrator).

    com.wm.app.tn.profile.ProfileStoreException
    Could not get partners for user (username=Administrator).
    (0) java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
    (1) java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

    at com.wm.ui2.UiException.handle(UiException.java:215)
    at com.wm.ui2.UiException.handle(UiException.java:184)
    at com.wm.app.tn.ui.Server.invoke(Server.java:379)
    at com.wm.app.tn.ui.cache.PingCache.refresh(PingCache.java:100)
    at com.wm.app.tn.ui.TNMainFrame.doConnect(TNMainFrame.java:1266)
    at com.wm.app.tn.ui.TradingNetworks$1.run(TradingNetworks.java:147)
    at java.lang.Thread.run(Thread.java:595)
    at com.wm.ui2.UiFrame$5.run(UiFrame.java:340)



    wm.tn:ping

    com.wm.app.tn.err.EXMLException

    0003.4114
    Could not get profile summary (username=Administrator).

    com.wm.app.tn.profile.ProfileStoreException
    Could not get partners for user (username=Administrator).
    (0) java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
    (1) java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

    java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
    java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
    java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
    at com.wm.dd.jdbc.base.BaseExceptions.createException(Unknown Source)
    at com.wm.dd.jdbc.base.BaseExceptions.getException(Unknown Source)
    at com.wm.dd.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
    at com.wm.dd.jdbc.base.BaseStatement.commonExecute(Unknown Source)
    at com.wm.dd.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
    at com.wm.dd.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
    at com.wm.app.tn.db.ProfileUserOps.getPartnersForUser(ProfileUserOps.java:186)
    at com.wm.app.tn.profile.ProfileStore.getIDsForUsername(ProfileStore.java:415)
    at wm.tn.profileimpl.getUserProfileSummary(profileimpl.java:269)
    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:585)
    at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:403)
    at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:630)
    at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:46)
    at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
    at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:232)
    at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
    at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:220)
    at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30)
    at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:618)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:535)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:381)
    at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:237)
    at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:104)
    at com.wm.app.b2b.server.Service.doInvoke(Service.java:639)
    at com.wm.app.b2b.server.Service.doInvoke(Service.java:536)
    at wm.tnimpl.getPartnerIDForUser(tnimpl.java:225)
    at wm.tnimpl.ping(tnimpl.java:84)
    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:585)
    at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:403)
    at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:630)
    at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:46)
    at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
    at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:232)
    at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
    at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:220)
    at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30)
    at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:618)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:535)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:381)
    at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:237)
    at com.wm.app.b2b.server.comm.DefaultServerRequestHandler.handleMessage(DefaultServerRequestHandler.java:119)
    at com.wm.app.b2b.server.HTTPMessageHandler.process(HTTPMessageHandler.java:151)
    at com.wm.app.b2b.server.HTTPDispatch.handleRequest(HTTPDispatch.java:176)
    at com.wm.app.b2b.server.Dispatch.run(Dispatch.java:307)
    at com.wm.util.pool.PooledThread.run(PooledThread.java:112)
    at java.lang.Thread.run(Thread.java:595)





    com.wm.app.tn.err.EXMLException:
    0003.4114
    Could not get profile summary (username=Administrator).

    com.wm.app.tn.profile.ProfileStoreException
    Could not get partners for user (username=Administrator).
    (0) java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
    (1) java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

    java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
    java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
    java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
    at com.wm.dd.jdbc.base.BaseExceptions.createException(Unknown Source)
    at com.wm.dd.jdbc.base.BaseExceptions.getException(Unknown Source)
    at com.wm.dd.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
    at com.wm.dd.jdbc.base.BaseStatement.commonExecute(Unknown Source)
    at com.wm.dd.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
    at com.wm.dd.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
    at com.wm.app.tn.db.ProfileUserOps.getPartnersForUser(ProfileUserOps.java:186)
    at com.wm.app.tn.profile.ProfileStore.getIDsForUsername(ProfileStore.java:415)
    at wm.tn.profileimpl.getUserProfileSummary(profileimpl.java:269)
    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:585)
    at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:403)
    at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:630)
    at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:46)
    at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
    at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:232)
    at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
    at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:220)
    at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30)
    at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:618)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:535)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:381)
    at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:237)
    at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:104)
    at com.wm.app.b2b.server.Service.doInvoke(Service.java:639)
    at com.wm.app.b2b.server.Service.doInvoke(Service.java:536)
    at wm.tnimpl.getPartnerIDForUser(tnimpl.java:225)
    at wm.tnimpl.ping(tnimpl.java:84)
    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:585)
    at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:403)
    at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:630)
    at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:46)
    at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
    at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:232)
    at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
    at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:220)
    at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30)
    at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:618)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:535)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:381)
    at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:237)
    at com.wm.app.b2b.server.comm.DefaultServerRequestHandler.handleMessage(DefaultServerRequestHandler.java:119)
    at com.wm.app.b2b.server.HTTPMessageHandler.process(HTTPMessageHandler.java:151)
    at com.wm.app.b2b.server.HTTPDispatch.handleRequest(HTTPDispatch.java:176)
    at com.wm.app.b2b.server.Dispatch.run(Dispatch.java:307)
    at com.wm.util.pool.PooledThread.run(PooledThread.java:112)
    at java.lang.Thread.run(Thread.java:595)





    at com.wm.app.tn.err.EXMLException.fromResource(EXMLException.java:63)
    at wm.tn.profileimpl.getUserProfileSummary(profileimpl.java:283)
    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:585)
    at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:403)
    at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:630)
    at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:46)
    at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
    at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:232)
    at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
    at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:220)
    at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30)
    at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:618)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:535)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:381)
    at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:237)
    at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:104)
    at com.wm.app.b2b.server.Service.doInvoke(Service.java:639)
    at com.wm.app.b2b.server.Service.doInvoke(Service.java:536)
    at wm.tnimpl.getPartnerIDForUser(tnimpl.java:225)
    at wm.tnimpl.ping(tnimpl.java:84)
    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:585)
    at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:403)
    at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:630)
    at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:46)
    at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
    at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:232)
    at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
    at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:220)
    at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30)
    at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:618)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:535)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:381)
    at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:237)
    at com.wm.app.b2b.server.comm.DefaultServerRequestHandler.handleMessage(DefaultServerRequestHandler.java:119)
    at com.wm.app.b2b.server.HTTPMessageHandler.process(HTTPMessageHandler.java:151)
    at com.wm.app.b2b.server.HTTPDispatch.handleRequest(HTTPDispatch.java:176)
    at com.wm.app.b2b.server.Dispatch.run(Dispatch.java:307)
    at com.wm.util.pool.PooledThread.run(PooledThread.java:112)
    at java.lang.Thread.run(Thread.java:595)





    #Integration-Server-and-ESB
    #B2B-Integration
    #webMethods


  • 2.  RE: TN Console Error

    Posted Thu August 19, 2010 04:27 PM

    You need to install TN database components (tablespace) you can run DBconfigrator tool if running on 7.x or later else execute db scripts in older versions which can be found in webMethods/common/db/scripts directory, then configure jdbc pool to use the same databse… please refer to webMethods documentation for the same.

    cheers!
    nD


    #B2B-Integration
    #webMethods
    #Integration-Server-and-ESB


  • 3.  RE: TN Console Error

    Posted Fri August 27, 2010 01:54 PM

    Hi To all
    I am tryingto connect with “oracle10g” using “webmethods7”. its showing “Unable to configure the connection manager”
    my issues are:
    1> how can create databaseName in oracle bcozconnectin properties asking this field or Any default databaseName it(oracle10g) will have?

    Please Respond any one…


    #webMethods
    #Integration-Server-and-ESB
    #B2B-Integration


  • 4.  RE: TN Console Error

    Posted Fri August 27, 2010 08:52 PM

    Who ever installed and configured they would be able to give you databaseName…Is your IS configured JDBC Pools for Trading Networks and other functional alias?

    HTH,
    RMG


    #webMethods
    #Integration-Server-and-ESB
    #B2B-Integration


  • 5.  RE: TN Console Error

    Posted Thu September 02, 2010 05:48 PM

    Hi I Have installed webMethods 7.1.2 on 1 machine want it to connect to database to other machine …Is it possible that for TN and MWS we can have remote db ?? i am unable to tart my TN and MWS …Please help


    #webMethods
    #Integration-Server-and-ESB
    #B2B-Integration


  • 6.  RE: TN Console Error

    Posted Thu September 02, 2010 07:03 PM

    oh yea, its pretty much possible… jsut provide the parameters in connection url under JDBC pool and associate it to TN pool alias, restart the server and you should be good to go :slight_smile:


    #webMethods
    #B2B-Integration
    #Integration-Server-and-ESB


Related Content