TN Error

Hi All,

I am getting this error when I start Trading Networks.

Any suggestions…??

Title : Error filling BizDocTypeStore cache

Message : Database error fetching all types: [wm-cjdbc30][Oracle JDBC Driver]Value can not be converted to requested type.
(0) java.sql.SQLException: [wm-cjdbc30][Oracle JDBC Driver]Value can not be converted to requested type.
(1) java.sql.SQLException: [wm-cjdbc30][Oracle JDBC Driver]Value can not be converted to requested type.

Class : com.wm.app.tn.db.DatastoreException

Stack Trace : java.sql.SQLException: [wm-cjdbc30][Oracle JDBC Driver]Value can not be converted to requested type.

java.sql.SQLException: [wm-cjdbc30][Oracle JDBC Driver]Value can not be converted to requested type.

java.sql.SQLException: [wm-cjdbc30][Oracle JDBC Driver]Value can not be converted to requested type.

at java.sql.SQLException.(SQLException.java:66)

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.base.BaseData.getBytes(Unknown Source)

at com.wm.dd.jdbc.base.BaseResultSet.getBytes(Unknown Source)

at com.wm.app.tn.db.BDTypeOperations.getAllTypes(BDTypeOperations.java:59)

at com.wm.app.tn.db.BDTypeOperations.getAll(BDTypeOperations.java:30)

at com.wm.app.tn.db.BizDocTypeStore.fillCache(BizDocTypeStore.java:46)

at wm.tn.doctype.init(doctype.java:53)

at wm.tn.admin.startup(admin.java:640)

at java.lang.reflect.Method.invoke(Native Method)

at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:287)

at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:336)

at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:116)

at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:88)

at com.wm.app.b2b.server.SessionInvoke.run(Session.java:652)

at com.wm.util.pool.PooledThread.run(PooledThread.java:105)

at java.lang.Thread.run(Thread.java:498)

TKS
Ubiq

Check whether the database tables you created are good. Check the documentation.
Try not to worry, you will get your answer soon.
Good Luck!

Check this link, it will give you some idea:

[url=“http://advantage.webmethods.com/cgi-bin/advantage/main.jsp?w=0&s=3223573953&targChanId=-536880653&faqId=1610635779”]http://advantage.webmethods.com/cgi-bin/advantage/main.jsp?w=0&s=3223573953&targChanId=-536880653&faqId=1610635779[/url]

anyway, i will just cut and paste here what it says:

Q What would cause the following error:
“Error filling BizDocTypeStore cache” in Trading Networks?

A Often times during Server startup, user will see the following error: receiving the
“Title: Error filling BizDocTypeStore cache
Message: com.wm.data.BasicIDataCodable
class: java.lang.ClassCastException”

Users will see this either during server startup, when Trading Networks is attempting to initialize, or when attempting to connect a TN Console to the Server.

The problem is caused by TN not being able to load a particular docType which is defined in the database.

In order to see specifically which docType is causing the problem, from the Developer (or Integrator) client, run the service ‘wm.tn.doctype:list’ with the ‘refresh’ parameter set to True. This will attempt to load all docTypes one-by-one. Check your error.log or server.log for a specific
error message. This is usually indicative of which docType is causing a problem.

A “problematic” docType is usually one which TN needs some external class to resolve.

Once you’ve determined the specific docType, you can either:

(1) add the appropriate libraries or classes back to the server’s classpath;

(2) or manually remove the docType and any related entries from the TN database. (see another FAQ for these steps)

For example, when using the WmEDIINT package, users are instructed to copy a jar file containing docType classes to the Server’s classpath. If a user did this, then later removed the .jar from the classpath, he likely would experience these problems.

HTH,
Faith

Hi ,
I am also getting the same error at server startup and TN console start.I could get into TN by deleting all documents from the table BizDocTypeDef. but the same error is being thrown while importing profiles.Any suggestions are highly appreciated

Thanks
Ravi

This was a life saver!!!
Thanks everyone!