Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  workorder plane error cant save record

    Posted Tue July 18, 2023 03:21 AM
      |   view attached
    when i add new row in the task for the plan in the workorder i face this error message 

    --

    Mohammad Al-Shaar
    Computer Engineer
    Prozone Middle East for General Trading WLL
    Wafra Real Estate Building, 2nd floor, Ahmed Al-Jaber Street, Al-Sharq
    Cell: +965 69626814


  • 2.  RE: workorder plane error cant save record

    Posted Tue July 18, 2023 03:33 PM

    In Database configuration can you open the WORKORDER & WOACTIVITY objects and make sure that a default value of 0 is set for the NESTEDJPINPROCESS attribute? This should be getting set by that default value.



    ------------------------------
    Steven Shull
    ------------------------------

    Original Message


  • 3.  RE: workorder plane error cant save record

    Posted Tue July 18, 2023 03:58 PM

    Hi Steven ,

    Yes the default value is 0 , This is wearied, I was using workorder

    normally i don't know why this massage start to show up to me 



    ------------------------------
    mohammad alshaar
    ------------------------------

    Original Message


  • 4.  RE: workorder plane error cant save record

    Posted Wed July 19, 2023 10:26 AM

    Hi,

    I have witnessed this kind of error in the past and that was due to some custom script in our environment. someone wrote a script on woactivity initialization and the script was returning a double datatype for a boolean field  resulting in the same error came when we clicked on the new row button.

    Please check if similar kind of customization has been made on your env especially on the woactivity and try deactivating them for debugging purpose??



    ------------------------------
    Subhransu Sekhar Sahoo
    ------------------------------

    Original Message


  • 5.  RE: workorder plane error cant save record

    Posted Wed July 19, 2023 10:51 AM

    Hi @mohammad alshaar @Subhransu Sekhar Sahoo

    In my opinion it's worth to also check how default value is stored in database:

    select DEFAULTVALUE from MAXATTRIBUTE where objectname in ('WOACTIVITY', 'WORKORDER') and attributename = 'NESTEDJPINPROCESS';

select DEFAULTVALUE from MAXATTRIBUTECFG where objectname in ('WOACTIVITY', 'WORKORDER') and attributename = 'NESTEDJPINPROCESS';

    if as a result you @mohammad alshaar will get default value as double (0.00) not integer (0) then I suggest you to execute these two update statement and do Maximo server restart. 

    update MAXATTRIBUTE set DEFAULTVALUE = 0  where objectname in ('WOACTIVITY', 'WORKORDER') and attributename = 'NESTEDJPINPROCESS';

update MAXATTRIBUTECFG set DEFAULTVALUE = 0 where objectname in ('WOACTIVITY', 'WORKORDER') and attributename = 'NESTEDJPINPROCESS';

    Good luck with investigation!



    ------------------------------
    Bartosz Marchewka
    ------------------------------

    Original Message


  • 6.  RE: workorder plane error cant save record

    Posted Wed July 19, 2023 02:24 PM

    Thanks all , I solved the problem that was ( in the workorder object the domain for location attribute i added crossover field (nullasset) to make the default value for the asset null when i create new workorder i removed this crossover field and everything working fine  )



    ------------------------------
    mohammad alshaar
    ------------------------------

    Original Message