APAR status
Closed as program error.
Error description
Error when trying to update MATRECTRANS records via the MIF and failing for records where ISSUETYPE is TRANSFER and the associated PO has revisions The error is: BMXAA5598E - Processing of an inbound transaction failed. The processing exception is identified in document 1. BMXAA2599E - Purchase order must have a status of Approved or In Progress. This error is happening because the MX code is not considering the PO Revision when querying for the associated PO/POLINE, so it picks up the revision 0, whose status is REVISD and the data cannot be changed. Below is the query MX runs: (PO) : select * from po where ponum= '1092' (POLINE) : select sum(linecost) from poline where ponum= '1092' and revisionnum= 0 and siteid= 'BEDFORD' Steps to replicate Please, contact L2 ( Marcio C ) if you need assistance on setting up this scenario. The steps below require MAXDEMO. 1) Create a Object Strucuture having MATRECTRANS only as a source MBO Go to > Integration > Object Structures > New Object Structure: MATRECTRANS Click New Row to add a new Source Object Add MATRECTRANS Save 2) Create a new Enterprise Service and associated the Object Structure created in the Step 1) Go to > Integration > Enterprise Services > New Enterprise Service: MATRECTRANS OBject Structure: MATRECTRANS Save 3) Add the MATRECTRANS Service to the External System for the data import Go to > Integration > External Systems > EXTSYS1 Switch to the Enterprise Services tab Click New Row Add the MATRECTRANS Service Enabled = yes Use Continuoues Queue ? = No Save. 4) Import a sample file Sample XML at: https://ecurep.mainz.de.ibm.com/rest/download/66763%2C011%2C724/ 0-all_da ta/66763.011.724.matrectrans_test.xml In the External Systems App > Enterprise Services Tab > Select the MATRECTRANS service added in the step 3) Click the "Data Import" button and browse for the sample XML. Check the Import Preview option. Click OK. This error is shown in the Preview Results: BMXAA5598E - Processing of an inbound transaction failed. The processing exception is identified in document 1. BMXAA2599E - Purchase order must have a status of Approved or In Progress. In the logs, the following error is found: [4/30/15 14:34:59:362 BRT] 000000be SystemOut O 30 Apr 2015 14:34:59:362 [INFO] [MXServer] [CID-UIASYNC-296312] BMXAA6719I - USER = (MXINTADM) SPID = (119) app (null) object (MATRECTRANS) : select * from matrectrans where (matrectransid = 1336104356) [4/30/15 14:34:59:362 BRT] 000000be SystemOut O 30 Apr 2015 14:34:59:362 [INFO] [MXServer] [CID-UIASYNC-296312] BMXAA6719I - USER = (MXINTADM) SPID = (119) app (null) object (MATRECTRANS) : select * from matrectrans where (matrectransid = 1336104356) [4/30/15 14:34:59:377 BRT] 000000be SystemOut O 30 Apr 2015 14:34:59:377 [INFO] [MXServer] [CID-UIASYNC-296312] BMXAA6719I - USER = (MXINTADM) SPID = (148) app (null) object (PO) : select * from po where ponum= '1092' [4/30/15 14:34:59:377 BRT] 000000be SystemOut O 30 Apr 2015 14:34:59:377 [INFO] [MXServer] [CID-UIASYNC-296312] BMXAA6719I - USER = (MXINTADM) SPID = (148) app (null) object (PO) : select * from po where ponum= '1092' [4/30/15 14:34:59:377 BRT] 000000be SystemOut O 30 Apr 2015 14:34:59:377 [INFO] [MXServer] [CID-UIASYNC-296312] BMXAA6719I - USER = (MXINTADM) SPID = (141) app (null) object (POLINE) : select sum(linecost) from poline where ponum= '1092' and revisionnum= 0 and siteid= 'BEDFORD' [4/30/15 14:34:59:377 BRT] 000000be SystemOut O 30 Apr 2015 14:34:59:377 [INFO] [MXServer] [CID-UIASYNC-296312] BMXAA6719I - USER = (MXINTADM) SPID = (141) app (null) object (POLINE) : select sum(linecost) from poline where ponum= '1092' and revisionnum= 0 and siteid= 'BEDFORD' [4/30/15 14:34:59:377 BRT] 000000be SystemOut O 30 Apr 2015 14:34:59:377 [ERROR] [MXServer] [CID-UIASYNC-296312] Processing failed for MATRECTRANS. The object structure is 1. The primary object is MATRECTRANS. The key is 1336104356.BMXAA2599E - Purchase order must have a status of Approved or In Progress. [4/30/15 14:34:59:377 BRT] 000000be SystemOut O 30 Apr 2015 14:34:59:377 [INFO] [MXServer] [CID-UIASYNC-296312] Error processing inbound transaction document/line 1. BMXAA2599E - Purchase order must have a status of Approved or In Progress. psdi.util.MXApplicationException: BMXAA2599E - Purchase order must have a status of Approved or In Progress. at psdi.app.inventory.MatRecTrans.appValidate(MatRecTrans.java:3101 ) at psdi.mbo.Mbo.validate(Mbo.java:4118) at psdi.iface.mos.MosProcessImpl.checkValidateErrors(MosProcessImpl .java:17 03) at psdi.iface.mos.MosProcessImpl.setMainMaximoTable(MosProcessImpl. java:788 ) at psdi.iface.mos.MosProcessImpl.fillMaximoTables(MosProcessImpl.ja va:429) at psdi.iface.mos.MosProcessImpl.processExternalData(MosProcessImpl .java:31 3) at psdi.iface.mic.MicSetIn.processExternalData(MicSetIn.java:147) at psdi.iface.mic.MicService.processDataIn(MicService.java:1546) at psdi.iface.mic.MicService.processExternalData(MicService.java:14 42) at psdi.iface.load.FileLoaderProcess.processData(FileLoaderProcess. java:604 ) at psdi.iface.load.DefaultInboundXMLSplitter.splitPerformed(Default InboundX MLSplitter.java:135)
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * MAXIMO * **************************************************************** * PROBLEM DESCRIPTION: * * BMXAA5598E ERROR WHEN TRYING TO UPDATE MATRECTRANS RECORDS * * VIA THE MIF * **************************************************************** * RECOMMENDATION: * * Apply Release 7.5.0.9 of Base Services or request an interim * * fix * ****************************************************************
Problem conclusion
The fix for this APAR is contained in the following maintenance package: | Release 7.5.0.9 of Base Services
Temporary fix
Comments
APAR Information
APAR number
IV73531
Reported component name
INTEGRATION
Reported component ID
5724R46I1
Reported release
750
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-05-22
Closed date
2015-06-15
Last modified date
2015-06-15
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
MAXIMO
Fix information
Fixed component name
INTEGRATION
Fixed component ID
5724R46I1
Applicable component levels
R750 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"750","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
15 June 2015