TN6 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

Ubiq

make sure the tables are all correct.

If you are facing this after the installation of WmEDI & WmEDIForTN modules and don’t have any data in tables, do the following.

Stop all the servers.

Use any tool for execution of SQLs

Go to WMROOT\common\db\scripts\drop folder

Execute all the drop scripts for your DB (ORacle/SQL Server)

Goto WMROOT\common\db\scripts\create folder

Execute all the create scripts for your DB (ORacle/SQL Server)

Import all the TN Rules.

Try to restart the TN console

Let me know if this works.

HTH
MKR

MKR,

Thanks a lot!!! It really worked. Yippee

VR, http://www.wmusers.com/wmusers/messages/117/1569.shtml?1045857797#POST5674
Thanks to you too

Happy Camper
Ubiq