Problem with Trading networks

, ,
1

Hi folks,
I hva my b2bserver,b2bIntegrator and TN running on same box on NT.After installation
of TN server 4.0 and TN Console i also
installed Merant seqelink server for Oracle 8.1.5
as am using external database for my TN.Also
executed the script tablesORA.sql which comes
by default,but when i wna verify that TN
is connecting to Oracle i issued the command
tnquery.bat - sql "select * from partner which
throws an error shown below…

any suggestions i wld appreciate.

cheers,
santosh

C:\PROGRA~1\WEBMET~1\B2BSER~1\packages\WmTN\bin>tnquery.bat -sql “select * from
partner”
java.sql.SQLException: [MERANT][SequeLink JDBC Driver][Oracle]ORA-00942: table or
r view does not exist
at java.lang.Throwable.(Throwable.java:96)
at java.lang.Exception.(Exception.java:44)
at java.sql.SQLException.(SQLException.java:45)
at com.merant.sequelink.ssp.Diagnostic.toSQLException(Unknown Source)
at com.merant.sequelink.ssp.Chain.cnvDiagnostics(Unknown Source)
at com.merant.sequelink.ssp.Chain.decodeDiagnostic(Unknown Source)
at com.merant.sequelink.ssp.Chain.decodeBody(Unknown Source)
at com.merant.sequelink.ssp.Chain.decode(Unknown Source)
at com.merant.sequelink.ssp.Chain.send(Unknown Source)
at com.merant.sequelink.ctxt.stmt.StatementContext.send(Unknown Source)
at com.merant.sequelink.ctxt.stmt.StmtCtxtState._getDescribeInfo(Unknown
Source)
at com.merant.sequelink.ctxt.stmt.OpenStmtCtxt.getDescribeInfo(Unknown S
ource)
at com.merant.sequelink.ctxt.stmt.StatementContext.getDescribeInfo(Unkno
wn Source)
at com.merant.sequelink.ctxt.stmt.StmtCtxtState._execute(Unknown Source)

    at com.merant.sequelink.ctxt.stmt.OpenStmtCtxt.execute(Unknown Source) 
    at com.merant.sequelink.ctxt.stmt.StatementContext.execute(Unknown Sourc

e)
at com.merant.sequelink.jdbc.SequeLinkStatement._execute(Unknown Source)

    at com.merant.sequelink.jdbc.SequeLinkStatement.executeQuery(Unknown Sou

rce)
at com.merant.sequelink.jdbc.SequeLinkPreparedStatement.executeQuery(Unk
nown Source)
at com.wm.app.tn.db.Datastore.init(Datastore.java:259)
at com.wm.app.tn.db.Embedded.init(Embedded.java:112)
at com.wm.app.tn.db.QueryTest.main(QueryTest.java:123)
Exception in thread “main” java.sql.SQLException: [MERANT][SequeLink JDBC Driver
][Oracle]ORA-00942: table or view does not exist
java.sql.SQLException: [MERANT][SequeLink JDBC Driver][Oracle]ORA-00942: table o
r view does not exist
java.sql.SQLException: [MERANT][SequeLink JDBC Driver][Oracle]ORA-00942: table o
r view does not exist
at java.lang.Throwable.(Throwable.java:96)
at java.lang.Exception.(Exception.java:44)
at java.sql.SQLException.(SQLException.java:45)
at com.merant.sequelink.ssp.Diagnostic.toSQLException(Unknown Source)
at com.merant.sequelink.ssp.Chain.cnvDiagnostics(Unknown Source)
at com.merant.sequelink.ssp.Chain.decodeDiagnostic(Unknown Source)
at com.merant.sequelink.ssp.Chain.decodeBody(Unknown Source)
at com.merant.sequelink.ssp.Chain.decode(Unknown Source)
at com.merant.sequelink.ssp.Chain.send(Unknown Source)
at com.merant.sequelink.ctxt.stmt.StatementContext.send(Unknown Source)
at com.merant.sequelink.ctxt.stmt.StmtCtxtState._getDescribeInfo(

2

Let’s start with some basics here and I think we’ll get to the root of the problems.

  1. Your select statement is “select * from partner”
  2. Your error message is a SQL exception: “ORA-00942: table or view does not exist”.

You have successfully connected to a database. Judging by the error message, though, you may have connected to a different database from intended database because the table “partner” does not exist in the external database configured in your integration.

If you are sure that you are connected to the proper database, then double-check the name of the table – it is not “partner”.

Check your database URL, alias and other parameters and good luck!

3

Dan,
Thanks for your response.I hva tested the
same from b2b adminstration and the parametrs
which i defined are:
dburl=jdbc:oracle:merant:@santosh:1521:Ats
dbdriver=com.merant.sequelink.jdbc.sequelinkdriver

which worked out when i executed the same
query “select * from partner”,but when i do
the same ie.when i open a session from
TN console it is throwing an exception table or view not exist.The parameters which i hva
given while opening a session in TN console are
below:

jdbc driver=com.merant.sequelink.jdbc.SequeLinkDriver

database url=jdbc:sequelink://localhost:19996;databaseName=TN_DB

and the username/password correspond to the
one which i hva given while installation of
TN.

i guess i am not missing anything…

Any workaround for this problem…

thanx
santosh

4

Dears,

Can we Install Trading Networks using wM Embedded Database.

Thank You,
Abdullah.P

5

Hi Abdullah,

I dont think that this is supported.

You should choose an external database for this.

Regards,
Holger

1 Like