Maximo Open Forum

 View Only

  • 1.  Error when loading crafts on Job Plans

    Posted 11 days ago

    I am trying to populate the Craft field on my Job Plans, but I keep getting the following error:

    However, when I try to associate this exact data manually directly in Maximo, it works. Has anyone experienced this before or any tips to fix this?

    Thanks in advance!


    #Administration
    #Integrations
    #MaximoApplicationSuite
    #MaximoForAviation
    #MaximoUserGroups

    ------------------------------
    Noah van P
    Brussels Airport Company
    ------------------------------


  • 2.  RE: Error when loading crafts on Job Plans

    Posted 10 days ago

    Hi @Noah van P 

    We ran into the exact same issue in our non-prod environment when trying to setup Job Plans and couldn't figure out what was causing it. What version of Maximo are you on? We are on 7.6.1.3. 

    For now I resorted to inserting in joblabor record using a sql script.  

    Thanks

    Vandna



    ------------------------------
    Vandna Patel
    G
    ------------------------------

    Original Message


  • 3.  RE: Error when loading crafts on Job Plans

    Posted 9 days ago

    Hi Vadna,

    Thanks for the reply! We are currently using 9.1.214. Could you tell me something more on how you do it via sql scriping? 



    ------------------------------
    Noah van P
    Brussels Airport Company
    ------------------------------

    Original Message


  • 4.  RE: Error when loading crafts on Job Plans

    Posted 9 days ago

    Hi all,

    Here is a fun, but annoying fact.  The ORGID on the JP needs to be defined.  Once defined, you don't need to do the same on the JOBLABOR as all labor is then assumed to be from that same ORGID.  Meaning, using this tool, you cannot just set the ORGID on the JOBLABOR without also having it on the JOBPLAN.

    I just don't know why, when you can do the same from the UI, just not via the data load tool.

    The side effect is that this then makes the JOBPLAN specific to that ORGID.  This is a problem where you have a JOBPLAN that can and should be used across multiple organizations.  My only solution is then to go and execute some SQL to null out the JOBPLAN.ORGID afterwards.



    ------------------------------
    Craig Kokay
    Principal Consultant
    COSOL

    email: craig.kokay@cosol.global
    #IBMChampion
    ------------------------------

    Original Message


Related Content