MxLoader

 View Only

  • 1.  Using MxLoader to Create New Tables in MAS 9 ?

    Posted 14 days ago

    I am struggling to get MxLoader to create new tables in MAS 9. I know I did it with 76 in past but feel like maybe it will not work any longer in MxLoader with REST API? In fact I am simply trying to move tables from one MAS environment to another, unable to use Migration Manager.

    I have fought with trying the MXOBJECTCFG starting with the MxLoader choice of  "System - Database Objects" and this will create a table with no columns/attributes. However once I add all the MAXATTRIBUTECFG columns to the sheet and try to load with that data filled in will hang for a while (quite a while) I get the following in the log file:

    2025-05-29 18:31:15 [INFO]  HTTP response received in 100.13 seconds, status=524, len=15 bytes
2025-05-29 18:31:15 [DEBUG] HTTP statusText  : 
2025-05-29 18:31:15 [INFO]  HTTP responseText: error code: 524
2025-05-29 18:31:16 [INFO]  Error message dialog
2025-05-29 18:31:16 [DEBUG] Error code        : 524 (524)
2025-05-29 18:31:16 [DEBUG] Error source      : DoHttpCall
2025-05-29 18:31:16 [DEBUG] Error description : 
error code: 524
2025-05-29 18:31:16 [DEBUG] Remedy            :


    No clue what it is that is breaking it.

    I have also created a cone of the DMMAXOBJECTCFG and made it Consumed by Integration instead of MM.

    I can get this to actually create new columns/attributes on tables but yet again I cannot get it to create a new table with columns. This one has some issues like it needs a TRIGROOT column populated as it says required but I am SQL Server and don't need that. I think this is an IBM BUG.. Anyway, I fill that in and it gets me to another 

    2025-05-29 17:49:56 [INFO]  HTTP response received in 0.31 seconds, status=200, len=454 bytes
2025-05-29 17:49:56 [DEBUG] HTTP statusText  : OK
2025-05-29 17:49:56 [DEBUG] HTTP responseText: [{"_responsedata":{"Error":{"extendedError":{"moreInfo":{"href":"https:\/\/main.manage.k-test.suite.maximo.com\/maximo\/api\/error\/messages\/BMXAA4214E"}},"reasonCode":"BMXAA4214E","message":"BMXAA4214E - An unknown error has occurred. Please contact your system administrator for assistance. Gather the logs from the <HOME> directory and determine where and why the error occurred.\n\tnull","statusCode":"400"}},"_responsemeta":{"status":"400"}}]
2025-05-29 17:49:56 [INFO]  Parsing JSON
2025-05-29 17:49:56 [DEBUG] Parsing JSON: 
2025-05-29 17:49:56 [DEBUG] Parsing JSON: 
2025-05-29 17:49:56 [INFO]  Error message dialog
2025-05-29 17:49:56 [DEBUG] Error code        : 500 (500)
2025-05-29 17:49:56 [DEBUG] Error source      : MxRunSync
2025-05-29 17:49:56 [DEBUG] Error description : BMXAA4214E - An unknown error has occurred. Please contact your system administrator for assistance. Gather the logs from the <HOME> directory and determine where and why the error occurred.
	null
2025-05-29 17:49:56 [DEBUG] Remedy            :


    Anyone have any suggestion and has anybody got MxLoader moving new tables in???


    Thanks in advance,
    Miller



    ------------------------------
    David Miller
    Enterprise Integration Partners
    ------------------------------


  • 2.  RE: Using MxLoader to Create New Tables in MAS 9 ?

    Posted 13 days ago

    I finally resolved the issue. I modified the OS that I created as a clone on the DMMAXOBJECTCFG and removed the classes used on IN/OUT and I removed the L_ objects and VIEWS so that I only have 4 objects left on it: 
    MAXOBJECTCFG
    MAXTABLECFG
    MAXATTRIBUTECFG
    AUTOKEY

    Not sure I even need the autokey but left it anyway for future needs. But this is now able to both create new TABALES and to add columns to existing tables all with the same OS.

    Thanks,



    ------------------------------
    David Miller
    Enterprise Integration Partners
    ------------------------------

    Original Message


Related Content