IV86891: PROBLEM WITH CREWS APPLICATION AND MIF

APAR status

• Closed as program error.

Error description

• Environment:
  App Server IBM WebSphere Application Server 7.0.0.25
  
  Version IBM Maximo Asset Management 7.5.0.7 Build 201410271545
  DB Build
  V7507-00
  IBM Maximo Linear Management 7.5.0.0 Build 20130129-2023 DB
  Build
  V7500-01
  Tivoli's process automation engine 7.5.0.7-IFIX20141219-2325
  Build
  20141017-1600 DB Build V7507-40 HFDB Build HF7507-02
  IBM Maximo for Utilities 7.5.0.1-20150624-1038 Build
  20120710-0136 DB
  Build V7501-14 HFDB Build HF7501-11
  IBM Maximo Asset Management Scheduler 7.5.2.0 Build
  20141017-1600 DB
  Build V7520-174
  IBM Maximo Calibration 7.5.0.0 Build 20130129-2023 DB Build
  V7501-03
  IBM TPAE Integration Framework
  7.5.1.2-MIF_7512_IFIX.20141001-1136
  Build 20140730-1950 DB Build V7512-08 HFDB Build HF7512-02
  IBM Maximo for Oil And Gas 7.5.1.0-20141224-0637 Build
  20130227-1708 DB
  Build V7510-67 HFDB Build HF7510-05
  
  Server OS Windows Server 2008 R2 6.1 build 7601 Service Pack 1
  
  Server DB Oracle 11.2 (Oracle Database 11g Release 11.2.0.3.0 -
  64bit
  Production)
  
  STEPS TO REPRODUCE:
  
  For all steps below I am using the MAXDEMO as example:
  Labor Contract: 1008
  Laborcode: ADAMS
  CRAFT: TIER2
  
  1) The customer is able to create a crew using a contract and
  a labor that does not belong to the contract.
  
  a. Go to Administration => Organizations (T&D).
  Search for EAGLENA. Click on Select Action => T&D options =>
  Configure Crafts.
  Search for TIER2. Check the checkbox "Use with CU?".
  b. Go to Administration => Resources => Crafts.
  Search for TIER2.
  Check the checkbox "Crew?".
  Save.
  c. Go to Administration => Resources => Crew Types.
  Create a new Crew Type: CTPF.
  On the section Required Crafts click on New Row. Fill in the
  fields as the values below:
  Position: LEADER
  Craft: TIER2
  Save.
  d. Go to Administration => Resources => Crews
  Create a new Crew. Fill in the fields as the values below:
  Crew: CWPF
  Crew Type: CTPF
  Save.
  Click on the tab "Labor Assignments".
  On Assigned Labor section click New Row. Fill in the fields as
  the values below:
  Position: LEADER
  LABOR: ADAMS
  CRAFT:TIER2
  Labor Contract: 1008
  Vendor: EMI
  Save.
  e. After you save Maximo does not pop up any error Message.
  This is wrong, because the Labor ADAMS does not belong to the
  labor contract 1008.
  
  2) Error when create crews through MIF. BMXAT0781E - ADAMS
  default craft (TIER2) is not enabled for crews.
  
  a. Go to Contracts => Labor Rate Contracts.
  Search for 1008.
  Click on Select Action=> Revise Contract. Fill in the fields as
  the values below:
  Revision Description: Revi1.
  Click OK.
  Change the field End Date to a future date.
  Click on Rate Schedule tab.
  Click on New Row. Fill in the fields as the values below:
  Craft: TIER2.
  Save.
  Click on Associated Labor tab.
  Click on New Row. Fill in the fields as the values below:
  Labor: ADAMS
  CRAFT: TIER2
  Save.
  Change the Status of the contract to Approved.
  b.Import the XML below:
  <max:AMCREW action="AddChange">
                 <max:AMCREW>CWPF2</max:AMCREW>
                <max:AMCREWTYPE>CTPF</max:AMCREWTYPE>
                 <max:ORGID>EAGLENA</max:ORGID>
                 <max:AMCREWLABOR>
                        <max:CRAFT>TIER2</max:CRAFT>
                        <max:LABORCODE>ADAMS</max:LABORCODE>
                        <max:POSITION>LEADER</max:POSITION>
                        <max:SKILLLEVEL></max:SKILLLEVEL>
                        <max:VENDOR>EMI</max:VENDOR>
                        <max:CONTRACTNUM>1008</max:CONTRACTNUM>
                 </max:AMCREWLABOR>
                             </max:AMCREW>
  c.The error below will return as response:
  nested exception is: psdi.util.MXApplicationException:
  BMXAT0781E - ADAMS default craft (TIER2) is not enabled for
  crews.</faultstring>
           <detail>
  
  Caused by: javax.ejb.EJBException: nested exception is:
  psdi.util.MXApplicationException: BMXAT0781E - ADAMS default
  craft (TIER2) is not enabled for crews.
   at
  psdi.iface.mos.MOSServiceBean.processMOS(MOSServiceBean.java:84)
   at
  psdi.iface.mos.EJSLocalStatelessmosservice_43551b5c.processMOS(U
  nknown Source)
   at psdi.iface.util.WebUtil.invokeMosEJB(WebUtil.java:451)
   at
  psdi.iface.webservices.MOSWebService.processDocument(MOSWebServi
  ce.java:153)
   ... 42 more
  Caused by: psdi.util.MXApplicationException: BMXAT0781E - ADAMS
  default craft (TIER2) is not enabled for crews.
   at
  com.ibm.tivoli.maximo.amcrew.app.FldAMCrewLaborCraft.action(FldA
  MCrewLaborCraft.java:110)
   at psdi.mbo.MboValue.validate(MboValue.java:1722)
   at psdi.mbo.MboValue.validate(MboValue.java:1599)
   at psdi.mbo.Mbo.validateAttributes(Mbo.java:4491)
   at psdi.mbo.Mbo.validate(Mbo.java:4076)
   at
  
  The exception occurs in the class
  com.ibm.tivoli.maximo.amcrew.app.FldAMCrewLaborCraft line 110.
  This class validate if the craft is valid through the query
  below:
  
  select * from laborcraftrate  where 1=1 and laborcode= 'ADAMS'
  and craft= 'TIER2'  and vendor= 'EMI'   and orgid= 'EAGLENA'
  and contractnum =  '1008'   and ((contractnum is not null and
  contractnum in (select contractnum from contract where status
  in ( 'DRAFT' , 'WAPPR' , 'PNDREV' ) and orgid =  'EAGLENA' ))
  or contractnum is null)and craft in (select craft from craft
  where iscrew=1)
  
  This query is not valid just because of one validation; the
  correct should be the query below:
  
  select * from laborcraftrate  where 1=1 and laborcode= 'ADAMS'
  and craft= 'TIER2'  and vendor= 'EMI'   and orgid= 'EAGLENA'
  and contractnum =  '1008'   and ((contractnum is not null and
  contractnum NOT in (select contractnum from contract where
  status in ( 'DRAFT' , 'WAPPR' , 'PNDREV' ) and orgid =
  'EAGLENA' )) or contractnum is null)and craft in (select craft
  from craft where iscrew=1)
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users using Crews application.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * PROBLEM WITH CREWS APPLICATION AND MIF                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply Release 7.5.0.11 of Base Services or request an        *
  * Interim Fix.                                                 *
  ****************************************************************
  

Problem conclusion

• The validation for labor and contract fields were not working
  correctly.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• MAXIMO
  

Fix information

• Fixed component name

  INTEGRATION

• Fixed component ID

  5724R46I1

Applicable component levels

• R750 PSY

     UP