IV34499: NO WORK LOGS CREATED FOR USERS WITH ACCESS TO MULTIPLE SITES

APAR status

• Closed as fixed if next.

Error description

• We have an issue where a Mobile user that has access to multiple
  sites and receives Work Orders to Mobile for these sites has
  Work Logs go 'missing'.
  
  The scenario is:
  
  User's default insert site = MCLEAN
  
  Site of Work Order adding Work Log to = BEDFORD
  
  When the user adds a Work Log to the Work Order with site
  BEDFORD it is not saved on the PDA, nor does it appear in Core
  Maximo when the job is sent back.
  
  
  It appears that all Work Logs are given the site from the user's
  default insert site rather than the site of the Work Order that
  the Work Log is going against.
  
  
  This affects Mobile users serving multiple sites that are unable
  to record work logs correctly without having to change their
  default insert site in Preferences to the site of the work order
  they are updating.  Even WORKLOG database is not updated for
  SITEID field to reflect the original site where workorder was
  created.
  
  Steps to reproduce in MAXDEMO 7.1.1.7:
  
  
  Update the user:  kathyb prior toreproducing in MAXDEMO
  environment
  
  Logged in as MAXADMIN user.
  
  Updated kathyb in User application.
  
  Click Groups tab
  
  Update so that only the following groups are displayed:
  
  EVERYONE
  CONTRACTMGR
  
  Save changes.
  
  Open Security Groups application
  
  Filter for CONTRACTMGR group and click on Sites tab
  
  Changed from Authorise All Sites to specific Sites:
  
  MCLEAN
  BEDFORD
  
  Save changes.
  
  Click Applications tab
  
  Setup to ensure she has access to Workorder app and Assets app.
  Read/Write/Save/ Grant All
  
  Save changes.
  
  
  Login as kathyb Maximo user.
  
  Clicked Default Profile from Start Centre and configured kathyb
  to be on Default Site: MCLEAN
  
  Use Default Insert Site as a Display Filter is ticked enabled
  
  Logout kathyb.
  
  
  Actual Steps of reported issue:
  
  Login as MAXADMIN user or any other user that is on Default site
  BEDFORD.
  
  
  Create a new Workorder
  
  Under the Workorder tab enter KATHYB in the Lead field, this
  field is found further down screen.
  
  
  Change status from WAPPR to INPRG
  
  Go to Log tab and create a new Summary and make it Viewable
  
  i.e. Worklog Description
  
  "WO test bedford"
  
  Make note of work order number.
  
  Save record.
  
  Login to PDA as KATHYB  (Default insert site is
  MCLEAN)
  
  Click worklist refresh
  
  The new workorder is incremented in Work List total workorders
  displayed on Mobile homepage.
  
  Click on Work List Items
  
  Click binoculars and enter in the workorder number in the
  Ticket/Work Order #: field and click Find to bring up record.
  
  Click on the workorder record displayed
  
  Click on the View(Workorder) menu option
  
  Select History from available options.
  
  This will show one existing entry  ("WO test bedford")
  
  Click New Row button
  
  "WO test Mclean"
  
  Click OK and then Send from Actions menu -> send or from Mobile
  homepage to upload changes to Maximo core.
  
  Click the Work List data refresh icon.
  
  Login to Maximo as any user Kathyb or other...
  
  Bring up workorder number in Wotrack app.
  
  Click on Log tab.
  
  Only the first Worklog that was created by the first user
  (MAXADMIN) in BEDFORD site is displayed.
  
  If you query the database WORKLOG table, the entry is visible
  
  select createby, createdate, description, siteid orgid, modifyby
  from worklog where createby ='KATHYB' order by CREATEDATE
  
  You will see the Kathyb entry under Description
  
  "WO test Mclean"  is listed with SITEID: MCLEAN.
  
  changing SQL query to MAXADMIN and you will see the original
  Maximo Core created Worklog entry is listed with SITEID: BEDFORD
  
  
  Shouldn't the Mobile PDA worklog entry be listed under SITEID:
  BEDFORD too?
  
  Customer believes their work logs are missing because somewhere
  in the Maximo Mobile system, the SQL query being run is
  wrong and not correctly filtering work logs.
  

Local fix

• Developer to provide fix
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Mobile 7.1.1.0                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * NO WORK LOGS CREATED FOR USERS WITH ACCESS TO MULTIPLE SITES *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * No                                                           *
  ****************************************************************
  

Problem conclusion

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

Applicable component levels

• R711 PSY

     UP