Maximo

Maximo-ICON.png

Maximo

Learn how to increase the operational efficiency of the assets you manage, and improve overall equipment effectiveness by using IoT data and AI.

Maximo-ICON.png

TRIRIGA

Reduce the operational costs of the facilities you manage, and create more engaging occupant experiences through the application of IoT data and AI.

Maximo-ICON.png

Engineering

Learn how IoT data and AI are being applied to transform the end-to-end engineering lifecycle.

Expand all | Collapse all

Stocked Tools data upload

  • 1.  Stocked Tools data upload

    Posted 27 days ago
    Edited by K Kunnuthara 26 days ago
    Hi guys,


    As a first step, tools and the associated specifications have been created in 'Tools' application.

    As a second step we are trying to add these tools to inventory storerooms via data upload/Application Import.
    Using out-of-box Object structure  (consisting of TOOLINV and INVBALANCES),
    is throwing the following error

    BMXAA5598E - Processing of an inbound transaction failed. The processing exception is identified in document 1.
    BMXAA4130E - Record already exists in base table ITEM for Tool=2009385, Storeroom=3006, Site=GSM, Item Set=ITEMSET1. Ensure that a unique value is used as the key to the new record.


    The above message does not make sense as the ITEM table do not have a Storeroom field.
    Has anyone tried Application Import for adding tools to storerooms?


    @Steven Shull  @Jason Uppenborn  @Alex Walter
    Do you guys have any thoughts?


    Thanks,

    ------------------------------
    K Kunnuthara
    ------------------------------​​​​​​


  • 2.  RE: Stocked Tools data upload

    Posted 22 days ago
    You are right, "The above message does not make sense as the ITEM table do not have a Storeroom field." But given the key the system claims is being duplicated, and given that we are loading against an extension of the INVENTORY object, let's assume that the reference to "ITEM" is a bug and that the error really means to say "INVENTORY".

    Does that key already exist in INVENTORY? Do you get data back from the following query?

    select * from inventory where ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1';

    And what Action are you choosing in Application Import?

    ------------------------------
    Blessings,
    Jason Uppenborn
    Sr. Technical Maximo Consultant
    Ontracks Consulting
    ------------------------------



  • 3.  RE: Stocked Tools data upload

    Posted 22 days ago
    @Jason Uppenborn

    Thanks for the inputs.

    select * from inventory where ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1';
    This does not return any results.

    I am using 'Sync' in Application Import.

    It appears to me that there might be a bug in adding Tools to Storerooms via Application Import?


    ------------------------------
    K Kunnuthara
    ------------------------------



  • 4.  RE: Stocked Tools data upload

    Posted 22 days ago
    "Sync" is a value in the "Operation" field. Are you loading XML, JSON or Flat data?
    • If Flat, what are you choosing in the "Action" field?
    • If not Flat, what action are you specifying in your XML or JSON? E.g. in XML you might have action="AddChange"
    Have you tried loading just one line of data (e.g. for ItemNum='2009385' and Location='3006' and SiteId='GSM' and ItemSetId='ITEMSET1')?

    ------------------------------
    Blessings,
    Jason Uppenborn
    Sr. Technical Maximo Consultant
    Ontracks Consulting
    ------------------------------



  • 5.  RE: Stocked Tools data upload

    Posted 21 days ago
      |   view attached
    Hi Jason,

    This is a flat file import via the Object Structure enabled for Application Import on 'Stocked Tools' application.
    I believe 'Action' field is only required if we use Flatfile consumer cron task?

    Attached is a sample file that I am using, it has only one line of data.
    (haven't really excluded much fields here)

    ------------------------------
    K Kunnuthara
    ------------------------------

    Attachment(s)

    csv
    STKall.csv   1K 1 version


  • 6.  RE: Stocked Tools data upload

    Posted 21 days ago
    Maximo is going to do some action with your data. If you don't specify which one, it will choose one for you. Rather than take the default, try choosing AddChange.

    ------------------------------
    Blessings,
    Jason Uppenborn
    Sr. Technical Maximo Consultant
    Ontracks Consulting
    ------------------------------



  • 7.  RE: Stocked Tools data upload

    Posted 21 days ago
    Hi Jason,

    Tried with AddChange, and it seems to have brought up a little bit more details in the error:

    [ERROR] [maxuatui05] [] Processing failed for STK99. The object structure is 1. The primary object is TOOLINV. The key is 2009385~3006~GSM~ITEMSET1.
    BMXAA4134E - ITEMNUM3 did not validate. Gather the logs from the <HOME> directory and determine the problem by looking at the message that is appended to this message.
    psdi.app.inventory.ToolInv incompatible with psdi.app.item.Item



    There might be a bug?

    ------------------------------
    K Kunnuthara
    ------------------------------



  • 8.  RE: Stocked Tools data upload

    Posted 20 days ago
    Yes, you should probably raise a Support Case for this.

    ------------------------------
    Blessings,
    Jason Uppenborn
    Sr. Technical Maximo Consultant
    Ontracks Consulting
    ------------------------------