Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.


Re: Maximo 7.1 > MIF MXINVISSUE error "...unknown error ..."

From: Nunya (2012-09-07 19:49)

I wish you would share what you found---I am getting unknown error on the same type of load.
--- In MAXIMO@yahoogroups.com, Tobin Harsono <itobinh@...> wrote:
>
> Problem solved. Try and Error.
>
> Able to use and build Oracle APEX as front-end for Maximo....via MIF.
>
>
>
>
>
> ________________________________
> From: Tobin Harsono <itobinh@...>
> To: MAXIMO@yahoogroups.com
> Sent: Mon, November 22, 2010 6:08:18 PM
> Subject: [MAXIMO List] Maximo 7.1 > MIF MXINVISSUE error "...unknown error ..."
>
> I tried as much as possible to fill-in the data into the interface table, but I
> keep getting the error " ..unknown error..." (see below).
>
> Any one can help please....
>
> <?xml version="1.0" encoding="UTF-8"?>
> <ERROR>
> <ERRORMESSAGE>The following error occurred while processing MATUSETRANS. The
> object structure number is 1.BMXAA4214E - An unknown error has occurred.
> Please contact your system administrator for assistance.
> null</ERRORMESSAGE>
> <ER>
>
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> creationDateTime="2010-11-22T18:06:15+01:00" transLanguage="EN"
> baseLanguage="EN" messageID="1290445576286651344">
> <MXINVISSUESet>
> <MATUSETRANS action="Add">
> <ACTUALCOST>55.0</ACTUALCOST>
> <ACTUALDATE>2010-11-22T18:05:51+01:00</ACTUALDATE>
> <COMMODITYGROUP>PPSPARES</COMMODITYGROUP>
> <CONDRATE>100</CONDRATE>
> <CONVERSION>1.0</CONVERSION>
> <CURBAL>2.0</CURBAL>
> <CURRENCYCODE>EUR</CURRENCYCODE>
> <CURRENCYLINECOST>55.0</CURRENCYLINECOST>
> <CURRENCYUNITCOST>55.0</CURRENCYUNITCOST>
> <DESCRIPTION>COMPRESSION SPRING</DESCRIPTION>
> <ENTERBY>MAXADMIN</ENTERBY>
> <ENTEREDASTASK>0</ENTEREDASTASK>
> <EXCHANGERATE>1.0</EXCHANGERATE>
> <GLCREDITACCT>
> <VALUE>IGL-YITMO</VALUE>
> </GLCREDITACCT>
> <GLDEBITACCT>
> <VALUE>???-?????-?????-422000</VALUE>
> </GLDEBITACCT>
> <ISSUETYPE>ISSUE</ISSUETYPE>
> <ITEMNUM>HTCT408845P0001</ITEMNUM>
> <ITEMSETID>YIT_ITEM</ITEMSETID>
> <ITEMTYPE>ITEM</ITEMTYPE>
> <LANGCODE>EN</LANGCODE>
> <LINECOST>55.0</LINECOST>
> <LINETYPE>ITEM</LINETYPE>
> <MATUSETRANSID />
> <ORGID>YIT</ORGID>
> <OUTSIDE>0</OUTSIDE>
> <PHYSCNT>2.0</PHYSCNT>
> <QTYREQUESTED>1.0</QTYREQUESTED>
> <QUANTITY>-1.0</QUANTITY>
> <ROLLUP>0</ROLLUP>
> <SITEID>YITMO</SITEID>
> <SPAREPARTADDED>0</SPAREPARTADDED>
> <STORELOC>MO-CLIENT-INI</STORELOC>
> <TOSITEID>YITMO</TOSITEID>
> <TRANSDATE>2010-11-22T18:05:51+01:00</TRANSDATE>
> <UNITCOST>55.0</UNITCOST>
> </MATUSETRANS>
> </MXINVISSUESet>
> </SyncMXINVISSUE>
> </ER>
> <IR>
> <SyncMXINVISSUE xmlns="http://www.ibm.com/maximo"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> creationDateTime="2010-11-22T18:06:15+01:00" transLanguage="EN"
> baseLanguage="EN" messageID="1290445576286651344">
> <MXINVISSUESet>
> <MATUSETRANS action="Add">
> <ACTUALCOST>55.0</ACTUALCOST>
> <ACTUALDATE>2010-11-22T18:05:51+01:00</ACTUALDATE>
> <COMMODITYGROUP>PPSPARES</COMMODITYGROUP>
> <CONDRATE>100</CONDRATE>
> <CONVERSION>1.0</CONVERSION>
> <CURBAL>2.0</CURBAL>
> <CURRENCYCODE>EUR</CURRENCYCODE>
> <CURRENCYLINECOST>55.0</CURRENCYLINECOST>
> <CURRENCYUNITCOST>55.0</CURRENCYUNITCOST>
> <DESCRIPTION>COMPRESSION SPRING</DESCRIPTION>
> <ENTERBY>MAXADMIN</ENTERBY>
> <ENTEREDASTASK>0</ENTEREDASTASK>
> <EXCHANGERATE>1.0</EXCHANGERATE>
> <GLCREDITACCT>
> <VALUE>IGL-YITMO</VALUE>
> </GLCREDITACCT>
> <GLDEBITACCT>
> <VALUE>???-?????-?????-422000</VALUE>
> </GLDEBITACCT>
> <ISSUETYPE>ISSUE</ISSUETYPE>
> <ITEMNUM>HTCT408845P0001</ITEMNUM>
> <ITEMSETID>YIT_ITEM</ITEMSETID>
> <ITEMTYPE>ITEM</ITEMTYPE>
> <LANGCODE>EN</LANGCODE>
> <LINECOST>55.0</LINECOST>
> <LINETYPE>ITEM</LINETYPE>
> <MATUSETRANSID />
> <ORGID>YIT</ORGID>
> <OUTSIDE>0</OUTSIDE>
> <PHYSCNT>2.0</PHYSCNT>
> <QTYREQUESTED>1.0</QTYREQUESTED>
> <QUANTITY>-1.0</QUANTITY>
> <ROLLUP>0</ROLLUP>
> <SITEID>YITMO</SITEID>
> <SPAREPARTADDED>0</SPAREPARTADDED>
> <STORELOC>MO-CLIENT-INI</STORELOC>
> <TOSITEID>YITMO</TOSITEID>
> <TRANSDATE>2010-11-22T18:05:51+01:00</TRANSDATE>
> <UNITCOST>55.0</UNITCOST>
> </MATUSETRANS>
> </MXINVISSUESet>
> </SyncMXINVISSUE>
> </IR>
> </ERROR>
>
>
>
>
>
>
>
> ________________________________
> From: Tobin Harsono <itobinh@...>
> To: MAXIMO@yahoogroups.com
> Sent: Mon, November 22, 2010 4:08:10 PM
> Subject: Re: [MAXIMO List] Maximo 7.1 > MIF MXINVISSUE error > The Issues
> transaction only supports the Add action
>
> Hi Jim,
>
> Thanks, problem solved.
>
> Do you know what minimum attributes should be used inside MXINVISSUE for issue
> transaction using MIF (via interface table) ?
>
> Rgds,
> /tobinh
>
>
>
>
> ________________________________
> From: Jim Mullan <jim.mullan@...>
> To: MAXIMO@yahoogroups.com
> Sent: Mon, November 22, 2010 3:52:07 PM
> Subject: RE: [MAXIMO List] Maximo 7.1 > MIF MXINVISSUE error > The Issues
> transaction only supports the Add action
>
> The action is case sensitive.
>
> It must be 'Add' rather than 'ADD'
>
>
>
> Rgds
>
>
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
> Tobin Harsono
> Sent: 22 November 2010 13:20
> To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] Maximo 7.1 > MIF MXINVISSUE error > The Issues
> transaction only supports the Add action
>
>
>
>
>
> I tried to setup the MIF to use MXINVISSUE using Interface table.
>
> The interface table name is: MXINVISSUE_IFACE.
>
> I did some test by inserting into the MXINVISSUE_IFACE following:
>
> insert into MXINVISSUE_IFACE (transid, transseq, itemnum, itemsetid, siteid,
>
> tositeid, location, binnum, quantity, transdate, glcreditacct,
> issuetype) values (104, 1, 'RS_10394P001', 'YIT_ITEM', 'YITMO', 'YITMO',
> 'MO-CLIENT-INI', '', 1, sysdate, 'IGL-YITMO', 'ISSUE');
>
> Then I wrote to the MXIN_INTER_TRANS table following:
>
> INSERT INTO MXIN_INTER_TRANS (EXTSYSNAME, IFACENAME, TRANSID, ACTION,
> IMPORTMESSAGE, TRANSLANGUAGE)
> VALUES ('EXTSYS3', 'MXINVISSUEInterface', 104, 'ADD', NULL, 'EN') ;
>
> The MIF pickup the message via interface table but it give following error
> (from
> the Message Reprocessing application):
>
> BMXAA1324E - The Issues transaction only supports the Add action.
>
> Any idea how to solve this problem?
>
> Many thanks!
>
>
>
>
>
>
>
>
>
>
>
> ------------------------------------
>
> Email addresses you might need:
> Posting: MAXIMO@yahoogroups.com
> Join : MAXIMO-subscribe@yahoogroups.com
> Leave : MAXIMO-unsubscribe@yahoogroups.com
> Cry : MAXIMO-owner@yahoogroups.com
> Group : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
> ------------------------------------
>
> Email addresses you might need:
> Posting: MAXIMO@yahoogroups.com
> Join : MAXIMO-subscribe@yahoogroups.com
> Leave : MAXIMO-unsubscribe@yahoogroups.com
> Cry : MAXIMO-owner@yahoogroups.com
> Group : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
> ------------------------------------
>
> Email addresses you might need:
> Posting: MAXIMO@yahoogroups.com
> Join : MAXIMO-subscribe@yahoogroups.com
> Leave : MAXIMO-unsubscribe@yahoogroups.com
> Cry : MAXIMO-owner@yahoogroups.com
> Group : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
>
>
>
>
>
>
>
>

From: Ian Wright (2012-09-10 08:31)

This is generally caused by a missing field
Check the object structure record and not which fields are required and then make sure you have all these fields in your inbound message if that doesn't work
I normally export a record using the same interface but in the published channel then you can see all the fields that have data.
Start chopping fields out which have no data or data you don't have and import the record repeatedly until it fails then you find out which field causes the issue
Rgds Ian
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Nunya
Sent: 07 September 2012 20:49
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Re: Maximo 7.1 > MIF MXINVISSUE error "...unknown error ..."
I wish you would share what you found---I am getting unknown error on the same type of load.
--- In MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>, Tobin Harsono <itobinh@...<mailto:itobinh@...>> wrote:
>
> Problem solved. Try and Error.
>
> Able to use and build Oracle APEX as front-end for Maximo....via MIF.
>
>
>
>
>
> ________________________________
> From: Tobin Harsono <itobinh@...<mailto:itobinh@...>>
> To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
> Sent: Mon, November 22, 2010 6:08:18 PM
> Subject: [MAXIMO List] Maximo 7.1 > MIF MXINVISSUE error "...unknown error ..."
>
> I tried as much as possible to fill-in the data into the interface table, but I
> keep getting the error " ..unknown error..." (see below).
>
> Any one can help please....
>
> <?xml version="1.0" encoding="UTF-8"?>
> <ERROR>
> <ERRORMESSAGE>The following error occurred while processing MATUSETRANS. The
> object structure number is 1.BMXAA4214E - An unknown error has occurred.
> Please contact your system administrator for assistance.
> null</ERRORMESSAGE>
> <ER>
>
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> creationDateTime="2010-11-22T18:06:15+01:00" transLanguage="EN"
> baseLanguage="EN" messageID="1290445576286651344">
> <MXINVISSUESet>
> <MATUSETRANS action="Add">
> <ACTUALCOST>55.0</ACTUALCOST>
> <ACTUALDATE>2010-11-22T18:05:51+01:00</ACTUALDATE>
> <COMMODITYGROUP>PPSPARES</COMMODITYGROUP>
> <CONDRATE>100</CONDRATE>
> <CONVERSION>1.0</CONVERSION>
> <CURBAL>2.0</CURBAL>
> <CURRENCYCODE>EUR</CURRENCYCODE>
> <CURRENCYLINECOST>55.0</CURRENCYLINECOST>
> <CURRENCYUNITCOST>55.0</CURRENCYUNITCOST>
> <DESCRIPTION>COMPRESSION SPRING</DESCRIPTION>
> <ENTERBY>MAXADMIN</ENTERBY>
> <ENTEREDASTASK>0</ENTEREDASTASK>
> <EXCHANGERATE>1.0</EXCHANGERATE>
> <GLCREDITACCT>
> <VALUE>IGL-YITMO</VALUE>
> </GLCREDITACCT>
> <GLDEBITACCT>
> <VALUE>???-?????-?????-422000</VALUE>
> </GLDEBITACCT>
> <ISSUETYPE>ISSUE</ISSUETYPE>
> <ITEMNUM>HTCT408845P0001</ITEMNUM>
> <ITEMSETID>YIT_ITEM</ITEMSETID>
> <ITEMTYPE>ITEM</ITEMTYPE>
> <LANGCODE>EN</LANGCODE>
> <LINECOST>55.0</LINECOST>
> <LINETYPE>ITEM</LINETYPE>
> <MATUSETRANSID />
> <ORGID>YIT</ORGID>
> <OUTSIDE>0</OUTSIDE>
> <PHYSCNT>2.0</PHYSCNT>
> <QTYREQUESTED>1.0</QTYREQUESTED>
> <QUANTITY>-1.0</QUANTITY>
> <ROLLUP>0</ROLLUP>
> <SITEID>YITMO</SITEID>
> <SPAREPARTADDED>0</SPAREPARTADDED>
> <STORELOC>MO-CLIENT-INI</STORELOC>
> <TOSITEID>YITMO</TOSITEID>
> <TRANSDATE>2010-11-22T18:05:51+01:00</TRANSDATE>
> <UNITCOST>55.0</UNITCOST>
> </MATUSETRANS>
> </MXINVISSUESet>
> </SyncMXINVISSUE>
> </ER>
> <IR>
> <SyncMXINVISSUE xmlns="http://www.ibm.com/maximo"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> creationDateTime="2010-11-22T18:06:15+01:00" transLanguage="EN"
> baseLanguage="EN" messageID="1290445576286651344">
> <MXINVISSUESet>
> <MATUSETRANS action="Add">
> <ACTUALCOST>55.0</ACTUALCOST>
> <ACTUALDATE>2010-11-22T18:05:51+01:00</ACTUALDATE>
> <COMMODITYGROUP>PPSPARES</COMMODITYGROUP>
> <CONDRATE>100</CONDRATE>
> <CONVERSION>1.0</CONVERSION>
> <CURBAL>2.0</CURBAL>
> <CURRENCYCODE>EUR</CURRENCYCODE>
> <CURRENCYLINECOST>55.0</CURRENCYLINECOST>
> <CURRENCYUNITCOST>55.0</CURRENCYUNITCOST>
> <DESCRIPTION>COMPRESSION SPRING</DESCRIPTION>
> <ENTERBY>MAXADMIN</ENTERBY>
> <ENTEREDASTASK>0</ENTEREDASTASK>
> <EXCHANGERATE>1.0</EXCHANGERATE>
> <GLCREDITACCT>
> <VALUE>IGL-YITMO</VALUE>
> </GLCREDITACCT>
> <GLDEBITACCT>
> <VALUE>???-?????-?????-422000</VALUE>
> </GLDEBITACCT>
> <ISSUETYPE>ISSUE</ISSUETYPE>
> <ITEMNUM>HTCT408845P0001</ITEMNUM>
> <ITEMSETID>YIT_ITEM</ITEMSETID>
> <ITEMTYPE>ITEM</ITEMTYPE>
> <LANGCODE>EN</LANGCODE>
> <LINECOST>55.0</LINECOST>
> <LINETYPE>ITEM</LINETYPE>
> <MATUSETRANSID />
> <ORGID>YIT</ORGID>
> <OUTSIDE>0</OUTSIDE>
> <PHYSCNT>2.0</PHYSCNT>
> <QTYREQUESTED>1.0</QTYREQUESTED>
> <QUANTITY>-1.0</QUANTITY>
> <ROLLUP>0</ROLLUP>
> <SITEID>YITMO</SITEID>
> <SPAREPARTADDED>0</SPAREPARTADDED>
> <STORELOC>MO-CLIENT-INI</STORELOC>
> <TOSITEID>YITMO</TOSITEID>
> <TRANSDATE>2010-11-22T18:05:51+01:00</TRANSDATE>
> <UNITCOST>55.0</UNITCOST>
> </MATUSETRANS>
> </MXINVISSUESet>
> </SyncMXINVISSUE>
> </IR>
> </ERROR>
>
>
>
>
>
>
>
> ________________________________
> From: Tobin Harsono <itobinh@...<mailto:itobinh@...>>
> To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
> Sent: Mon, November 22, 2010 4:08:10 PM
> Subject: Re: [MAXIMO List] Maximo 7.1 > MIF MXINVISSUE error > The Issues
> transaction only supports the Add action
>
> Hi Jim,
>
> Thanks, problem solved.
>
> Do you know what minimum attributes should be used inside MXINVISSUE for issue
> transaction using MIF (via interface table) ?
>
> Rgds,
> /tobinh
>
>
>
>
> ________________________________
> From: Jim Mullan <jim.mullan@...<mailto:jim.mullan@...>>
> To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
> Sent: Mon, November 22, 2010 3:52:07 PM
> Subject: RE: [MAXIMO List] Maximo 7.1 > MIF MXINVISSUE error > The Issues
> transaction only supports the Add action
>
> The action is case sensitive.
>
> It must be 'Add' rather than 'ADD'
>
>
>
> Rgds
>
>
>
> From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of
> Tobin Harsono
> Sent: 22 November 2010 13:20
> To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
> Subject: [MAXIMO List] Maximo 7.1 > MIF MXINVISSUE error > The Issues
> transaction only supports the Add action
>
>
>
>
>
> I tried to setup the MIF to use MXINVISSUE using Interface table.
>
> The interface table name is: MXINVISSUE_IFACE.
>
> I did some test by inserting into the MXINVISSUE_IFACE following:
>
> insert into MXINVISSUE_IFACE (transid, transseq, itemnum, itemsetid, siteid,
>
> tositeid, location, binnum, quantity, transdate, glcreditacct,
> issuetype) values (104, 1, 'RS_10394P001', 'YIT_ITEM', 'YITMO', 'YITMO',
> 'MO-CLIENT-INI', '', 1, sysdate, 'IGL-YITMO', 'ISSUE');
>
> Then I wrote to the MXIN_INTER_TRANS table following:
>
> INSERT INTO MXIN_INTER_TRANS (EXTSYSNAME, IFACENAME, TRANSID, ACTION,
> IMPORTMESSAGE, TRANSLANGUAGE)
> VALUES ('EXTSYS3', 'MXINVISSUEInterface', 104, 'ADD', NULL, 'EN') ;
>
> The MIF pickup the message via interface table but it give following error
> (from
> the Message Reprocessing application):
>
> BMXAA1324E - The Issues transaction only supports the Add action.
>
> Any idea how to solve this problem?
>
> Many thanks!
>
>
>
>
>
>
>
>
>
>
>
> ------------------------------------
>
> Email addresses you might need:
> Posting: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
> Join : MAXIMO-subscribe@yahoogroups.com<mailto:MAXIMO-subscribe%40yahoogroups.com>
> Leave : MAXIMO-unsubscribe@yahoogroups.com<mailto:MAXIMO-unsubscribe%40yahoogroups.com>
> Cry : MAXIMO-owner@yahoogroups.com<mailto:MAXIMO-owner%40yahoogroups.com>
> Group : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
> ------------------------------------
>
> Email addresses you might need:
> Posting: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
> Join : MAXIMO-subscribe@yahoogroups.com<mailto:MAXIMO-subscribe%40yahoogroups.com>
> Leave : MAXIMO-unsubscribe@yahoogroups.com<mailto:MAXIMO-unsubscribe%40yahoogroups.com>
> Cry : MAXIMO-owner@yahoogroups.com<mailto:MAXIMO-owner%40yahoogroups.com>
> Group : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
> ------------------------------------
>
> Email addresses you might need:
> Posting: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
> Join : MAXIMO-subscribe@yahoogroups.com<mailto:MAXIMO-subscribe%40yahoogroups.com>
> Leave : MAXIMO-unsubscribe@yahoogroups.com<mailto:MAXIMO-unsubscribe%40yahoogroups.com>
> Cry : MAXIMO-owner@yahoogroups.com<mailto:MAXIMO-owner%40yahoogroups.com>
> Group : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
>
>
>
>
>
>
>
>
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************