TN Console Error

Sasanka · August 19, 2010, 8:02pm

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)

devexpert · August 19, 2010, 8:27pm

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

Sreepati · August 27, 2010, 5:53pm

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…

gupta_r.17495 · August 28, 2010, 12:51am

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

Rohit_Gupta1 · September 2, 2010, 9:47pm

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

devexpert · September 2, 2010, 11:03pm

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