MxLoader

 View Only
  • 1.  Internal Server Error When Querying PM'S

    Posted 04-06-2022 16:36
    Is anyone else getting an error when trying to Query the PM loader sheet? I can query and load from the Assets sheet and the Item sheet. I just get the error on the PM sheet. Thanks for any help or advice.

    Randy

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


  • 2.  RE: Internal Server Error When Querying PM'S

    Posted 04-07-2022 08:36
    Hi Randy,

    Can you provide more information like the text of the error message? Perhaps you can provide a screenshot of your MxLoader sheet so that we may see the object structure and columns you're using.

    Stevie

    ------------------------------
    Stevie Holloway
    Tufts University
    ------------------------------



  • 3.  RE: Internal Server Error When Querying PM'S

    Posted 04-07-2022 09:19

    Thanks for looking at this for me. Here is the screen shot. I just selected the MxLoader New MsSheet and then selected Preventive Maintenance - PM with JP Seq. (custom) and then Selected Run and this is what I got.

     

     

    Thanks,

     

    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

     

     

     






  • 4.  RE: Internal Server Error When Querying PM'S

    Posted 04-07-2022 09:28
    I would first go to the CONFIG tab and click on the Test Connection button to ensure you are hitting the server.

    Next, ensure that PMSEQUENCE is list under the Source Objects for MXL_PM section.

    Stevie

    ------------------------------
    Stevie Holloway
    Tufts University
    ------------------------------



  • 5.  RE: Internal Server Error When Querying PM'S

    Posted 04-07-2022 09:43

    Thanks for the help. I tested the connection anyway but had used it to import some locations for the assets. I clicked on Create Custom Object Structures and it ran for a couple of minutes and said they had been created. I clicked on Run and it brought back records.

     

    For future reference, where can I see the Source Objects for the section?

     

    Thanks again for the help and for responding so quickly.

     

    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

     

     

     






  • 6.  RE: Internal Server Error When Querying PM'S

    Posted 04-07-2022 13:26
    You're welcome. You'll find the Source Objects section on the Object Structure tab.

    Stevie

    ------------------------------
    Stevie Holloway
    Tufts University
    ------------------------------