Problem - MES is writing the transactions to TRDATA, but XA PMC is not processing the transactions.
Cause/Resolution-
There are several possible causes for this:
- XA uJobs are stuck or not running
- Start the XA uJobs through XA Cross App Support
- DQJUA, DQJUB, DQJUC data queues are corrupt or missing
- Contact Infor for the correction procedure.
- QSNDDTAQ procedure is missing from the MESxy Schema (note: there may be other procedures and possibly functions missing as well)
- If any of the procedures or functions listed below are missing from the MESxy Schema, un-install and re-install the MES subsystem using the PMI_x_x_x will be the required to correct. Please contact the help desk to have this done.
Procedures - BACKFLUSH, CLOSEFILES, CREATEORDER, QSNDDTAQ
Functions - NXTTRNNO, TIMESTAMPCYMDHMS, TKENPACKER
Procedures
Functions
Use the following DB2 SQL to check for the existence of the Stored Procedures (in the example below, the environment is MA)
SELECT cast((PROCSCHEMA) as char(5)) as LIB,
CAST((PROCNAME) as char(11)) as PROCNAME,
CAST((PROC_LOCATION) as char(11)) as LOCATION,
REMARKS FROM qsys2/procedures
WHERE procschema = 'MESMA'
If QSNDDTAQ does not exist, the easiest method is to uninstall and re-install the subsystem.
Add the installation library to the library list. (in the exmample below, it's version 5.4)
ADDLIBLE LIB(PMI_5_4_0)
Uninstall:
TSUNINSTAL ENV(MA) OPTION(*IMMED)
Re-install:
TSCRTALL ENV(MA) LIBI(PMI_5_4_0) LIBO(MESMA)
Alternatively, there is a command (for version 5.4) which just rebuilds the Stored Procedures
PPLMESINST LIB(MESMA)
Find the Functions -
Select ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_TYPE
from sysibm.routines where ROUTINE_SCHEMA = 'MESxy'
Results should show the follwing:
