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.
I want to create an inbound interface for the objects Locations and Locoper, using interface tables. Maximo 7.1 MIF.
The object structure has LOCATIONS as primary object and LOCOPER as child with relationship on the attributes Location and Site.
Then I created a Publish Channel & Enterprise Service using this object structure.
When creating a location via the UI I get a record in the outbound interface table. Then I delete that location.
Next I copy the record from the outbound interface table to the inbound interface table (and a corresponding record in the queue table mxin_inter_trans).
The error message in the queue table is:
"psdi.util.MXApplicationException: BMXAA5861E - Mandatory keys are missing - unable to create xml from flat structure.
at psdi.iface.intertables.FlatToXMLConverter.prepareObjectXML(FlatToXMLConverter.java:277)
at psdi.iface.intertables.FlatToXMLConverter.prepareObjectXML(FlatToXMLConverter.java:352)
at psdi.iface.intertables.FlatToXMLConverter.convert(FlatToXMLConverter.java:152)
at psdi.iface.intertables.IfaceTbCronTask.createIfaceRowList(IfaceTbCronTask.java:1059)
at psdi.iface.intertables.IfaceTbCronTask.processJoinedData(IfaceTbCronTask.java:728)
at psdi.iface.intertables.IfaceTbCronTask.cronAction(IfaceTbCronTask.java:523)
at psdi.server.CronTaskManager.callCronMethod(CronTaskManager.java:1556)
at psdi.server.CronTaskManager.access$400(CronTaskManager.java:84)
at psdi.server.CronTaskManager$CronThread.run(CronTaskManager.java:2074)"
The attributes Location and Siteid have a value (as they had in the outbound record).
When testing exactly the same, but using XML files instead of interface tables, all goes fine (the MIF correctly creates a new location).
Anyone has a clue ?
To insert a location the SYSTEMID in the LOCANCESTOR table is required to
INSERT a LOCATION record (there are others). Have a look at the MXOPERLOC
OBJECT in the OBJECT STRUCTURES to see how that is set up. You will also
see that there are a class file that have to be referenced in the set up
of the object.
peter
> I want to create an inbound interface for the objects Locations and
> Locoper, using interface tables. Maximo 7.1 MIF.
> The object structure has LOCATIONS as primary object and LOCOPER as child
> with relationship on the attributes Location and Site.
> Then I created a Publish Channel & Enterprise Service using this object
> structure.
>
> When creating a location via the UI I get a record in the outbound
> interface table. Then I delete that location.
> Next I copy the record from the outbound interface table to the inbound
> interface table (and a corresponding record in the queue table
> mxin_inter_trans).
> The error message in the queue table is:
>
> "psdi.util.MXApplicationException: BMXAA5861E - Mandatory keys are missing
> - unable to create xml from flat structure.
> at
> psdi.iface.intertables.FlatToXMLConverter.prepareObjectXML(FlatToXMLConverter.java:277)
> at
> psdi.iface.intertables.FlatToXMLConverter.prepareObjectXML(FlatToXMLConverter.java:352)
> at
> psdi.iface.intertables.FlatToXMLConverter.convert(FlatToXMLConverter.java:152)
> at
> psdi.iface.intertables.IfaceTbCronTask.createIfaceRowList(IfaceTbCronTask.java:1059)
> at
> psdi.iface.intertables.IfaceTbCronTask.processJoinedData(IfaceTbCronTask.java:728)
> at
> psdi.iface.intertables.IfaceTbCronTask.cronAction(IfaceTbCronTask.java:523)
> at psdi.server.CronTaskManager.callCronMethod(CronTaskManager.java:1556)
> at psdi.server.CronTaskManager.access$400(CronTaskManager.java:84)
> at psdi.server.CronTaskManager$CronThread.run(CronTaskManager.java:2074)"
>
> The attributes Location and Siteid have a value (as they had in the
> outbound record).
>
> When testing exactly the same, but using XML files instead of interface
> tables, all goes fine (the MIF correctly creates a new location).
>
> Anyone has a clue ?
>
>