MxLoader

 View Only
  • 1.  Getting Error when trying to Import records into the Synonymdomain table

    Posted 04-22-2022 10:51
    I am trying to import some asset types into the synonym domain table and I get an error. Her is an example of the MxLoader sheet I am using:

    MXDOMAIN MAXDOMAIN Add    
    DOMAINID SYNONYMDOMAIN.
    MAXVALUE
    SYNONYMDOMAIN.
    VALUE
    SYNONYMDOMAIN.
    DESCRIPTION
    SYNONYMDOMAIN.
    DEFAULTS
    ASSETTYPE AIRDRY AIRDRY AIRDRY 1


    When I try to Add them I get:

    Internal Server Error
    Error 500: BMXAA4129E - The record for Domain=ASSETTYPE already exists. Ensure that the key value for the given record is unique.


    When I try to Add/Change them I get:

    Internal Server Error
    Error 500: BMXAA4051E - AIRDRY is not a valid value. The synonym for an existing value must be a new value. Use the Domains application to change the internal value.


    Any help on this would be appreciated.

    Thanks,
    Randy

    ------------------------------
    Randy Prosser
    Thiele Kaolin Company
    ------------------------------


  • 2.  RE: Getting Error when trying to Import records into the Synonymdomain table

    Posted 04-25-2022 10:43
    Hey Randy,

    Both are good errors. When you use a synonym domain you must use the out of the box values for the MAXVALUE (Internal Value from the UI). In the case of the ASSETTYPE domain you must use a a MAXVALUE of FACILITIES, FLEET, IT or PRODUCTION.

    Thanks,

    ------------------------------
    Matt McGuire
    Aquitas Solutions
    https://www.aquitas-solutions.com/
    ------------------------------



  • 3.  RE: Getting Error when trying to Import records into the Synonymdomain table

    Posted 04-25-2022 11:08

    Thanks Matt!!

     

    Randy Prosser

     

    Maximo Administrator | Thiele Kaolin Company

    P.O. Box 1056 | Sandersville, GA 31082 | Phone: 478-552-3951 ext. 1166

    Email: randy.prosser@thielekaolin.com

     

    image001.jpg@01D73210.1F0732F0