IJ04236: UPDATED ORGID LENGTH AND RAN INTO SOME ISSUE WHERE THE ORGID LENGTHS DIDN'T EXTEND IN THE ASSET APPLICATION.

APAR status

• Closed as program error.

Error description

• Updated  ORGID length and ran into some issue where the ORGID
  lengths didn't extend in the asset application. It means that
  some "same as" relationships that seem to be missing. Attached
  the results from client  environment and included the query
  They used to identify them below.
  
  select * from maxattribute where attributename like '%ORGID%'
  and sameasobject is null and objectname != 'ORGANIZATION'
  
  As results, The attributes below was not updated in
  sameasobject and sameasattributecollunms:
   ASSETMOVEDFLT, INSPECTIONFORM,INSPECTIONFORMSTATUS,
  INSPECTIONRESULT, INSPFIELD, INSPFIELDOPTION,
  INSPFIELDRESULT, INSPQUESTION, INSPRESULTSTATUS
  
  ACTION TAKEN:
  Replicated behavior in TPAE 7608 and TPAE 7609
  
  
  This APAR was created   against core TPAE to correct the
  same-as details for AssetMovedFlt.OrgID.
  
  STEPS TO REPLICATE:
  1 - Go to database Configuration Application
  2 -  Search for ORGANIZATION tabble.
  3 - Go to Attributes tab and search for ORGID field.
  4 - Change the lenght to 9, save the record.
  5 - Turn on the Admin mode.
  6 - Apply Configuration changes. After the end of Configuration
  changes
  proccess, back  Admin mode to OFF.
  7 - Open a database consol tool, connect to a Maximo database,
  then run
  the script below;
  select * from maxattribute where attributename like '%ORGID%'
  and
  sameasobject is null and objectname != 'ORGANIZATION'
  
  The result will be same objects where the field ORGID was nor
  changed
  to lenght = 9, and the fileld SAMEASATTRIBUTE and SAMEASOBJECT
  IS NULL,
  This is the  reason of the field ORGID in this objects was not
  changed.
  
  Client figured  that the ORGID Sameas Relationship was missing.
  
  ENVIRONMENT:
  App Server
  IBM WebSphere Application Server 8.5.5.10
  Tivolli's process automation engine 7.6.0.9 Build 20171127-0100
  DB uild
  V7609-45
  IBM TPAE Integration Framework 7.6.0.9 Build 20171126-2330 DB
  Build
  V7609-32
  IBM Maximo for Service providers 7.6.3.1 Build 20170905-1206 DB
  Build
  V7631-17
  IBM Maximo Health, Safety and environment Manager 7.6.1.0 BUild
  20161020-0816 DB Build V7610-01
  IBM Maximo Asst managemant Scheduler 7.6.7.0 Build 20171127-0100
  DBBuild V7670-56
  IBM Maximo Asset Management work Centers 7.6.0.3 BUild
  20171121-0723 DB
  Build V7603-175
  IBM Maximo Asset management 7.6.0.9 BUild 20171127-0100 DB Build
  v7604-01
  Serve OS - Windows Server 2012 R2 6.3
  Server DB Microsoft SQL Server 12.0 (12.00.5000)
  (c) Copyright IBM Corp. 2017
  
  PRODUCT VERSION:
  Tivolli's process automation engine 7.6.0.9 Build 20171127-0100
  DB uild
  V7609-45
  
  IBM Maximo Asset management 7.6.0.9 BUild 20171127-0100 DB Build
  v7604-01
  
  AFFECTED APPLICATION (for Maximo Only): database Configuration
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The inspection table attributes do not have appropriate      *
  * same-as fields set.                                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is included in the following package:
                          | Release 7.6.1.0 of Base Services.
  

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:

Fix information

• Fixed component name

  ADMINISTRATION

• Fixed component ID

  5724R46A1

Applicable component levels

• R760 PSY

     UP