server log

WHY DO I GET THIS KIND OF LOG … ANY HELP PLS

[93]2012-02-13 11:39:47 GMT+05:30 [ISU.0000.9999C] TRANET: Starting webMethods for Trading Networks
[94]2012-02-13 11:39:47 GMT+05:30 [ISU.0000.9999D] TRANET: Loading system configuration
[95]2012-02-13 11:39:47 GMT+05:30 [ISC.0063.0001D] Create 0ag0b40016lql9kok00000000
[96]2012-02-13 11:39:49 GMT+05:30 [ISS.0028.0012C] WmEDIINT: Startup service (wm.EDIINT.util:init)
[97]2012-02-13 11:39:50 GMT+05:30 [ISC.0063.0001D] Create 0ag0b40016lql9mtg00000001
[98]2012-02-13 11:39:51 GMT+05:30 [ISU.0000.9999D] Error defining type 0ag0b40016lql9mtg00000001 (EDIINT) [TRNSERV.000016.000069]
[99]2012-02-13 11:39:51 GMT+05:30 [ISU.0000.9999D] java.sql.SQLException: [wm-cjdbc31-0006][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column
[100]
[101]java.sql.SQLException: [wm-cjdbc31-0006][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column
[102]
[103]java.sql.SQLException: [wm-cjdbc31-0006][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column
[104]
[105] at com.wm.dd.jdbc.base.BaseExceptions.createException(Unknown Source)
[106] at com.wm.dd.jdbc.base.BaseExceptions.getException(Unknown Source)
[107] at com.wm.dd.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
[108] at com.wm.dd.jdbc.base.BaseStatement.commonExecute(Unknown Source)
[109] at com.wm.dd.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
[110] at com.wm.dd.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
[111] at com.wm.app.tn.db.BDTypeOperations.insert(BDTypeOperations.java:116)
[112] at com.wm.app.tn.db.BizDocTypeStore.insert(BizDocTypeStore.java:246)
[113] at wm.tn.doctype.add(doctype.java:206)
[114] at java.lang.reflect.Method.invoke(Native Method)
[115] at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:287)
[116] at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:339)
[117] at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:104)
[118] at com.wm.app.b2b.server.Service.doInvoke(Service.java:605)
[119] at com.wm.app.b2b.server.Service.doInvoke(Service.java:554)
[120] at wm.EDIINT.doc.createEDIINTDocType(doc.java:89)
[121] at wm.EDIINT.util.init(util.java:644)
[122] at java.lang.reflect.Method.invoke(Native Method)
[123] at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:287)
[124] at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:339)
[125] at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:119)
[126] at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:91)
[127] at com.wm.app.b2b.server.SessionInvoke.run(Session.java:652)
[128] at com.wm.util.pool.PooledThread.run(PooledThread.java:105)
[129] at java.lang.Thread.run(Thread.java:498)
[130]
[131]2012-02-13 11:39:51 GMT+05:30 [ISC.0063.0001D] Create 0ag0b40016lql9onj00000002
[132]2012-02-13 11:39:51 GMT+05:30 [ISU.0000.9999D] Error defining type 0ag0b40016lql9onj00000002 (EDIINT MDN) [TRNSERV.000016.000069]
[133]2012-02-13 11:39:51 GMT+05:30 [ISU.0000.9999D] java.sql.SQLException: [wm-cjdbc31-0006][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column
[134]
[135]java.sql.SQLException: [wm-cjdbc31-0006][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column
[136]
[137]java.sql.SQLException: [wm-cjdbc31-0006][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column
[138]
[139] at com.wm.dd.jdbc.base.BaseExceptions.createException(Unknown Source)
[140] at com.wm.dd.jdbc.base.BaseExceptions.getException(Unknown Source)
[141] at com.wm.dd.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
[142] at com.wm.dd.jdbc.base.BaseStatement.commonExecute(Unknown Source)
[143] at com.wm.dd.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
[144] at com.wm.dd.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
[145] at com.wm.app.tn.db.BDTypeOperations.insert(BDTypeOperations.java:116)
[146] at com.wm.app.tn.db.BizDocTypeStore.insert(BizDocTypeStore.java:246)
[147] at wm.tn.doctype.add(doctype.java:206)
[148] at java.lang.reflect.Method.invoke(Native Method)
[149] at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:287)
[150] at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:339)
[151] at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:104)
[152] at com.wm.app.b2b.server.Service.doInvoke(Service.java:605)
[153] at com.wm.app.b2b.server.Service.doInvoke(Service.java:554)
[154] at wm.EDIINT.doc.createEDIINTMDNDocType(doc.java:186)
[155] at wm.EDIINT.util.init(util.java:648)
[156] at java.lang.reflect.Method.invoke(Native Method)
[157] at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:287)
[158] at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:339)
[159] at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:119)
[160] at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:91)
[161] at com.wm.app.b2b.server.SessionInvoke.run(Session.java:652)
[162] at com.wm.util.pool.PooledThread.run(PooledThread.java:105)
[163] at java.lang.Thread.run(Thread.java:498)
[164]
log.txt (5.06 KB)

Hi
The actual issue is IS trying to insert some data in TN Schema… but since the Table column length is less than the actual content length its throwing the error
U might want to check the scripts present in WM\common\db\scripts\oracle\tradingnetworks\migrate.
to see if you will need to run any migrate scripts… once u run it it should be taken care… we faced similar issue in the PE Schema… but once we run the migrate scripts we never got this error.

H
Chakri

But which of the scripts to run… I am not migrating to 6.0.1 from the previous version … I am currently running 6.0.1

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.