IV83124: UNABLE TO SEE THE DOMAIN DESCRIPTION OF A DOMAIN VALUE THAT IS BEING USED TO DISPLAY DATA IN A PORTLET CHART

APAR status

• Closed as program error.

Error description

• Unable to see the Domain description of a domain value that is
  being used to display data in a Portlet Chart, in the Start
  Center.
  
  Customer trying to create a start center with a result set
  portlet
  where they have to create a bar chart using a relationship
  instead of
  just main table.
  
  Imagine this scenario :
  
  You need to display a bar chart in the result set portlet of a
  start
  center. This bar chart has to display all the transportation
  assets by
  fleet type.
  
  This query is created in the 'ASSET (TR) application as follows
  (upper(maintresp) = 'TRANSPORTATION') and eq9 is not null
  Where eq9 is the customized field that displays the fleet type
  for e.g.
  'AM' for 'Ambulance'
  
  In the result set portlet, you select the this query and the
  columns
  'Assetnum, and 'Eq' and then select display by 'EQ' and you get
  the chart
  displayed that groups the number of assets by 'EQ9'.
  
  But you are supposed to display this chart by fleet type
  description i.e.
  by 'AMBULANCE' and not by ''AM", so you created a relationship
  with the
  ALNDOAMIN table that joins to the asset table by field 'EQ9'
  and gives
  the description for each asset.
  
  Now when you try to display the assets by the related field,
  this related
  field does not display on the 'Display By" field.
  
  You followed following link to implement this
  http://www-01.ibm.com/support/docview.wss?uid=swg21409330
  
  This implementation worked alright in Maximo 71, but in Maximo
  75, it broke and does not work
  
  
  These are the steps to replicate :
  
  Go to Application Designer and make ASSET.EQ9 field visible in
  the
  Assets (Tr) app
  
  Go to Assets (Tr) and insert values for EQ9, for about 4
  assets...
  GC, CR, CV, AM
  
  Asset status should be set to Operating
  
  Create a query like this :
  EQ9 is not null and status = 'OPERATING' and (siteid =
  'BEDFORD')
  
  Save this query
  
  Add a Result Set to Start Center, and on the result set, use
  the query
  created and show the columns ASSETNUM, EQ9
  
  *However, no description is displayed when you use the Set
  chart options
  and set a BAR chart by EQ9.  The customer wants to have the
  Description
  displayed in the Legend, not the EQ9 info.
  
  
  But they tried to following workaround that used to work in
  previous
  versions.
  They decided to try using a DOMAIN for this case.
  
  Workaround Steps :
  
  Create an ALN domain with the values GC, CR, CV, AM   (mine is
  called
  'EQ9_DOM')
  
  Create a relationship on Asset table for child object ALNDOMAIN
  with
  the following where clause... (PMR68048_RELATIONSHIP).  see
  below:
  
  DOMAINID = 'EQ9_DOM' and value = :EQ9
  
  
  Using a SQL Tool, they ran this :
  
  insert into resultsetcols ( app, attribute, maintable,
  resultsetcolsid
  ,rowstamp)
  values ('PLUSTASSET', 'PMR68048_RELATIONSHIP.DESCRIPTION',
  'ASSET',
  resultsetcolsseq.nextval, maxseq.nextval);
  
  NOTE:  PMR68048_RELATIONSHIP is the relationship name between
  ASSET and
  ALNDOMAIN objects that we created.
  
  Again, in previous version Maximo 7.1, customer was able to
  workaround
  this case by inserting the following into the RESULTSETCOLS
  table
  
  However, this does not seem to work anymore in Maximo 7.5
  
  All the customer wants is to be able to see the Domain
  description of a
  domain value that is being used to display data in a Portlet
  Chart
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * N/A                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * UNABLE TO SEE THE DOMAIN DESCRIPTION OF A DOMAIN VALUE THAT  *
  * ISBEING USED TO DISPLAY DATA IN A PORTLET CHART              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Fixed in Tpae 7.5.0.11 fix pack.                             *
  ****************************************************************
  

Problem conclusion

• Removed code that stripped out related fields from the Display
  By results set.
  

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

  ADMIN & SECURIT

• Fixed component ID

  TIVOADMIN

Applicable component levels

• R750 PSY

     UP