IV97584: ASSIGNMENT MANAGER APPLICATION CAN NOT SEE THE WHOLE WORKLIST

APAR status

• Closed as program error.

Error description

• Environment:
  Websphere 8.5.5.11
  Maximo Asset Management 7.6.0.7
  Maximo Asset Management Scheduler 7.6.4.0
  Maximo Asset Management Scheduler Plus 7.6.4.0
  Maximo for Utilities 7.6.0.0
  Linux 3.10.0.514
  DB2 10.5
  
  
  Concerns/Problem:
  Assignment Manager Application can not show the whole worklist
  
  
  Steps to reproduce the issue:
  Login to Maximo Assignment Manager application.
  When try to show all the records by deleting where clause in
  the Advanced Search - Where Clause and click Find button.
  The below error pops up on the screen.
  
  BMXAA6713E - The MBO fetch operation failed in the mboset with
  the SQL error code -4460. The record could not be retrieved
  from the database. See the log file for more details about the
  error.
  com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.11.69]
  Invalid parameter: Unknown column name PLUSDAWORKGROUP.
  ERRORCODE=-4460, SQLSTATE=null
  
  In the log file, I can see the below error message:
  BMXAA6713E - The MBO fetch operation failed in the mboset with
  the SQL error code -4460. The record could not be retrieved
  from the database. See the log file for more details about the
  error.
  com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.11.69]
  Invalid parameter: Unknown column name PLUSDAWORKGROUP.
  ERRORCODE=-4460, SQLSTATE=null
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users that use Maximo for Utilities 7.6.0.0 or high.     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ASSIGNMENT MANAGER APPLICATION CAN NOT SEE THE WHOLE         *
  * WORKLIST                                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The inconsistent attribute was dropped to fix the wrong
  behavior.
  

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

  MAXIMO UTILITIE

• Fixed component ID

  5724R5600

Applicable component levels

• R760 PSY

     UP