MxLoader

 View Only
  • 1.  Unable to extract workorders with the cause/remedy codes

    Posted 03-24-2022 04:27
    Hello guys, I need the help from the gurus once again.

    Whenever I try to extract workorders with the respective cause/remedy codes, those two fields always come back empty.

    Besides other atempts, I've tried these:
    - querying (from WO) PROBLEM.FR1CODE
    - querying (from WO) FAILURELIST.FAILURECODE

    What am I doing wrong?

    ------------------------------
    Silva testes2
    testes
    ------------------------------


  • 2.  RE: Unable to extract workorders with the cause/remedy codes

    Posted 03-30-2022 08:36
    Hi Silva,

    Are you using the correct relationship? Please check whether PROBLEM is the correct relationship between WORKORDER and PROBLEM object. similarly verify FAILURELIST is a valid relationship between the WORKORDER and FAILURELIST object.

    You can check in Database configuration application for parent WORKORDER. 

    If the relationship are existing correctly and still you are getting null , then you may need to check the where clauses of those relationship. Fixing the relationship name and its where clause will fix this issue.

    Let me know if you get any luck.


    ------------------------------
    Subhransu Sekhar Sahoo
    Tata Consultancy Services
    ------------------------------



  • 3.  RE: Unable to extract workorders with the cause/remedy codes

    Posted 04-08-2022 17:32
    Thanks Sahoo. I was able to get the info using FR1CODE.FAILURECODE.

    Now, in one specific workorder I get an error:
    reasonCode":"BMXAA8882E","message":"BMXAA8882E - -1 is not a valid data type for the object/table WORKORDER and the attribute fr2code.","statusCode":"400"​

    But if I query this specific workorder via the WebUI I can get the cause/solution codes correctly.




    ------------------------------
    Silva testes2
    testes
    ------------------------------