Receipt Routing (P43250) is taking an extremely long time to process. This issue is specific to EnterpriseOne (E1) Applications Release 9.2 and above in AS400/DB2 platform.
A. JDE_*.log
108/2 WRK:MDSCHAC_80000000_P43250 Thu May 3 10:31:53.150584
dbdrv_log.c196 OS400QL016 - ExecuteSQLRequest: QSQLMSG *LIBL - SQL0913 - Row or object &1 in &2 type *&3 in use
108/2 WRK:MDSCHAC_80000000_P43250 Thu May 3 10:31:53.150856
jdb_exet.c3173 JDB3600011 - Failed to perform Update for F4108
: Above message implies that the F4108 (Lot Master) is in use (or in transaction processing boundaries) and another routine/process tries to access the same table F4108.
B. Call Stack
The reason for this suggestion is that the error OS400QL016 - ExecuteSQLRequest: QSQLMSG *LIBL - SQL0913 - Row or object &1 in &2 type *&3 in use
P43250
|--- F43092EndDoc **** this gets called with transaction processing on - so database blocking takes place. This is 9.2 specific ***
|--- F4312EndDoc
|--- F4111EndDocument
|--- LotMasterUpdate
sql> UPDATE CRPDTA/F4108
|--- dcLINKLotStatusUpdate
sql> UPDATE CRPDTA/F4108
OS400QL016 - ExecuteSQLRequest: QSQLMSG *LIBL - SQL0913 - Row or object &1 in &2 type *&3 in use
: the second update ends in error. For the given log, dcLINKLotStatusUpdate does not perform any - it tries to update the same row of data from F4108 (which appears to be releasing the lot status which is not necessary)
C. Resolution