R3482/R3483 MRP Falls into Zombie for a Certain Item

Purpose of Document

Information Center: Overview of JD Edwards EnterpriseOne Requirements Planning > Information Center: Troubleshooting JD Edwards EnterpriseOne Requirements Planning > Note 1068635.1

In running R3483 Master Planning Schedule - Multiple Plant it falls into Zombie on a specific item.

Note: This issue is specific to iSeries (AS400, DB2 OS400) environment. In Oracle and SQL database will accept illegal value so long as it is numeric value

This issue is data specific, so to reflect actual planning, remove all the testing data if any.

1.  Check for call stack from jde.log

Level Program Library Module Statement Procedure
0 JDELIB E812BSYS JDEDEBUG 0000000022(unrecognizable characters) jdelogCallStack
1 JDENET E812BSYS NETSIG 0000000002Stack krnlCatchall
2 QC2UTIL1 QSYS QC2MI1 0000000001ll QXXDTOP
3 DBDR E812BSYS DBDRV_DT 0000000073ll ConvertToBulkInsertBuffer
4 DBDR E812BSYS DBDRV_DT 0000000089ulkInsertBuffer UpdateInputDataMap
5 DBDR E812BSYS DBDRV 0000000014tDataMap DBResetRequest
6 JDEKRNL E812BSYS JDB_DRVM 0000000005uest JDB_DBResetRequest
7 JDEKRNL E812BSYS JTP_CM 0000000064tRequest CM_FindDriverHandle
8 JDEKRNL E812BSYS JTP_TM 0000000025verHandle TM_DBPerformRequest
9 JDEKRNL E812BSYS JDB_EXET 0000000324rmRequest InsertTable
10 JDEKRNL E812BSYS JDB_EXET 0000000003e JDB_InsertTable
11 CMFG DV812 B3400590 0000000032Table I3400590_WriteArrayData
12 CMFG DV812 B3400590 0000000040riteArrayData MRPWriteTimeSeriesData
13 JDEKRNL E812BSYS JDEOBJ 0000001477meSeriesData jdeCallObjectV2
14 JDEKRNL E812BSYS JDEOBJ 0000000001ectV2 jdeCallObject
15 CMFG DV812 N3500110 0000004099ect MRPMultiplePlantLoadAndPlan
16 JDEKRNL E812BSYS JDEOBJ 0000001477ePlantLoadAndPlan jdeCallObjectV2
17 JDEKRNL E812BSYS JDEOBJ 0000000001ectV2 jdeCallObject
18 JDEKRNL E812BSYS K2ER 0000000125ect K2ExecuteER
19 JDEKRNL E812BSYS K2SECEND 0000000015R K2ProcessEndSection
20 JDEKRNL E812BSYS K2ENGINE 0000000057ndSection K2ProcessMessages
21 JDEKRNL E812BSYS K2ENGINE 0000000026essages UBEReport_StartProcessing
22 JDEKRNL E812BSYS K2ENTRYPNT 0000000053StartProcessing UBEReport_Start
23 JDEKRNL E812BSYS K2ENTRYPNT 0000000148Start ubeReport_EntryPoint
24 PRINTUBE E812BSYS RUNBATCH 0000000324EntryPoint main
25 PRINTUBE E812BSYS RUNBATCH _C_pep
26 QCMD QSYS


For this example,

1.  R3483 is calling BSFN N3500110 MRPMultiplePlantLoadAndPlan through JDE API jdeCallObject
2.  jdeCallObject is calling jdeCallObjectV2
3.  jdeCallObjectV2 is calling MRPMultiplePlantLoadAndPlan
4.  MRPMultiplePlantLoadAndPlan is calling another BSFN B3400590 MRPWriteTimeSeriesData
5.  MRPWriteTimeSeriesData is calling internal BSFN I3400590_WriteArrayData
6.  Internal BSFN I3400590_WriteArrayData is calling JDE API JDB_InsertTable


Then, jdedebug.log will contains actual DML statement issued as below (for example),
SQL> INSERT INTO TESTDTA/F3413 (MRITM, MRMCU, MRQT, MRSTRT, MRTRQT)?
ROWS VALUES (34581.000000,' 10','15',110364,1499957173799999.000000)
  : For this example, actual parameter 1499957173799999.000000 is illegal in size for F3413.MRTRQT

This type of error may come when a certain supply/demand related transaction table contain huge figure (for this case quantity ordered for that specific item value is entered maximum value in it).

To resolve this issue, correct transaction data or cancel those transactions.

Note:  This issue is specific to iSeries (AS400, DB2 OS400) environment.  In Oracle and SQL database will accept illegal value so long as it is numeric value

 

To discuss this information further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the E1 Manufacturing Community.   To look at upcoming or archived Advisor Webcasts please see Advisor Webcast Details Document 1450327.1.  If your topic is not currently scheduled please suggest it.