IJ01361: WONUM SAME AS RELATIONSHIPS NOT AFFECTED WHEN DB CONFIG OCCURRS

APAR status

• Closed as program error.

Error description

• STEPS TO REPRODUCE:
  
  1.  Go to Database Configuration
  2.  Go to Work Order Object
  3.  Go to Attributes, Filter for WONUM
  4. Click on WONUM, change the "Length" from default value of
  12, to new
  value of 20.   then Save.
  5.  Perform Admin Mode, Apply Configuration Changes, Turn off
  Admin Mode
  6.  Go back into DB Config, but go to other applications that
  use the
  Same as Relationship of WONUM, such as the following:
  SKDEDITCONSTRAINT, SKDEDITCONSTRAINT, PLUSGRELATEDREC, PLUSGBYP.
  7.  Each of these objects, you can go to the WONUM, or
  Attributes of
  RELATEDRECWONUM, PARENTPREDWONUM, or PARENTSUCCWONUM, and will
  notice
  that the value had not changed.   It remains at the default
  value, in
  this instance was 12.
  
  When performing the DB Config, it should have changed all of
  these Same
  As Relationship object/attributes.
  
  
  CURRENT ERRONEOUS RESULT:
  See Steps to reproduce
  
  EXPECTED RESULT:
  See Steps to reproduce
  
  ENVIRONMENT:
  App Server IBM WebSphere Application Server 8.5.5.7
  Version
  Tivoli's process automation engine 7.6.0.8 Build 20170512-0100
  DB Build
  V7608-63
  IBM TPAE Integration Framework 7.6.0.8 Build 20170510-2330 DB
  Build
  V7608-43
  IBM Maximo Asset Management Scheduler 7.6.5.0 Build
  20170512-0100 DB
  Build V7650-98
  IBM Maximo Asset Management Work Centers 7.6.0.2 Build
  20170509-0906 DB
  Build V7602-57
  IBM Maximo Asset Management 7.6.0.8 Build 20170512-0100 DB
  Build V7604-
  01
  Server OS Windows Server 2012 R2 6.3
  Server DB Microsoft SQL Server 11.0 (11.00.6020)
  
  IS THIS A SECURITY VULNERABILITY QUESTION:
  No
  
  LOCAL FIX:
  (N/A)
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of the Database Configuration application in Maximo    *
  * 7.6                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * WONUM SAME AS RELATIONSHIPS NOT AFFECTED WHEN DB CONFIG      *
  * OCCURRS                                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• A database script has been created to fix relationship links.
  

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

  ADMINISTRATION

• Fixed component ID

  5724R46A1

Applicable component levels

• R760 PSY

     UP