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

Getting error in TN Console

  • 1.  Getting error in TN Console

    Posted Thu February 23, 2012 10:21 AM

    ErrorMessage: ErrorDialog TRNCONS.000001.000005 ERROR PingCache refresh Thu Feb 23 15:20:05 IST 2012 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:218) 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:631) at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:40) at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44) at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:241) at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51) at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:228) at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30) at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:624) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:536) 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:631) at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:40) at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44) at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:241) at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51) at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:228) at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30) at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:624) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:536) 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:186) at com.wm.app.b2b.server.Dispatch.run(Dispatch.java:327) at com.wm.util.pool.PooledThread.run(PooledThread.java:118) 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:218) 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:631) at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:40) at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44) at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:241) at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51) at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:228) at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30) at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:624) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:536) 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:631) at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:40) at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44) at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:241) at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51) at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:228) at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30) at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:624) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:536) 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:186) at com.wm.app.b2b.server.Dispatch.run(Dispatch.java:327) at com.wm.util.pool.PooledThread.run(PooledThread.java:118) 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:631) at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:40) at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44) at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:241) at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51) at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:228) at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30) at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:624) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:536) 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:631) at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:40) at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44) at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:241) at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51) at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:228) at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30) at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:624) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:536) 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:186) at com.wm.app.b2b.server.Dispatch.run(Dispatch.java:327) at com.wm.util.pool.PooledThread.run(PooledThread.java:118) at java.lang.Thread.run(Thread.java:595)


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


  • 2.  RE: Getting error in TN Console

    Posted Thu February 23, 2012 04:16 PM

    what is this IS/TN version?Also make sure you ran the TN scripts correctly and tables created and JDBC pool configuration and test TN pool alias before you login TNConsole.

    After you ran all TN db scripts/pool configuration restart IS before login.

    HTH,
    RMG


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