Work Item Manager-JAS Database Failure

ceyhanf

ceyhanf

Member
Hi all,
I have a problem with P012503 on AS400,ERP8,SP21.
I can send the first message successfully after Websphere start. Then I try to second one I get an Jas Database Failure error. I check out the jasdebug.log and i find related lines below.

2003-05-05 16:11:38.370 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@e12abcc3] NONE : Prepared Statement obtained from pool : INSERT INTO TESTDTA.F01131 (ZZSERK, ZZAN8, ZZALPH, ZZSFRM, ZZCCO, ZZCPH, ZZMBDS, ZZDTI, ZZUPMJ, ZZUPMT, ZZJOBN, ZZDSS5, ZZMSGP, ZZPA8, ZZMB01, ZZMB02, ZZTCNT, ZZCMPR, ZZMSG, ZZUSER, ZZPID, ZZMSGA, ZZENTT, ZZSTSM, ZZPXT1, ZZBASE, ZZSY, ZZDOCO, ZZSFXO, ZZDCTO, ZZLNID, ZZKCOO, ZZTMPI, ZZAB3, ZZLV, ZZPSRK, ZZVERS, ZZTSV, ZZEAP, ZZFRMI) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2003-05-05 16:11:38.370 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@e12abcc3] NONE : class com.jdedwards.jas.sql.UpdateStatement@55f127e6 >*trace*> UpdateStmt----> TableTrigger ----> F01131, type: 16
2003-05-05 16:11:38.402 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@e12abcc3] JDBC : UpdateStatement->execute:
com.ibm.db2.jdbc.app.DB2DBException: F01131 in TESTDTA not valid for operation.

Thank you fornow,
Ceyhan
 
It is working when we added journal entry to AS/400 with:
STRJRNPF FILE(TESTDTA/F01131) JRN(OWJRNL/OW_JRNL)
STRJRNPF FILE(TESTDTA/F00165) JRN(OWJRNL/OW_JRNL)

Ceyhan
 
Back
Top