IJ28861: "BMXAT0048E CANNOT INSERT DUPLICATE KEY ROW IN OBJECT 'DBO.SKDCOSTTEMP'" ERROR WHEN USING CALCULATE COST

APAR status

• Closed as program error.

Error description

• When trying to calculate cost for a Work schedule, the
  following error is displayed:
  
  BMXAT0048E - The activities did
  not populate. For more information, check the Maximo log file
  (in your application server directory) or contact your system
  administrator.
  Cannot insert duplicate key row in object
  'dbo.skdcosttemp' with unique index 'skdcosttemp_ndx1'. The
  duplicate key value is (503187333_WEEK_WAPPR_CEST).
  
  STEPS TO
  REPRODUCE:
  1. Go to Graphical Scheduling
  2. Open a Work
  schedule
  3. Move to: Cost and Usage
  4. Click Calculate
  Cost
  
  
  RESULT:
  Error BMXAT0048E is displayed
  
  EXPEDTED
  RESULT:
  Cost to be calculated
  
  REPORTED IN VERSION:
  Tivoli's
  process automation engine 7.6.1.2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of the Graphical Scheduling application in Maximo      *
  * 7.6.1.0.                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * BMXAT0048E CANNOT INSERT DUPLICATE KEY ROW IN OBJECT         *
  * 'DBO.SKDCOSTTEMP' ERROR WHEN USING CALCULATE COST            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• A code fix has been made.
  

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

  MAXIMO SCHEDULE

• Fixed component ID

  5724R46SE

Applicable component levels