IJ22567: BMXAA4210E - THE DATABASE ERROR 904 HAS OCCURRED GENERATING WORKORDERS FROM PM LIST TAB FILTERED ON MULTILANG ENABLED ATTRIBUTE

APAR status

• Closed as program error.

Error description

• Problem
  When trying to generate PM work orders from the List tab error
  "BMXAA4210E - The database error 904 has occurred." is
  encountered.
  
  Additional error info:
  Sep 2019 08:42:05:681 [ERROR] [axz_server2] [] select count(*)
  from organization where orgid in (select orgid from pm where
  (nvl(upper(l_pm.description), upper(pm.description)) like
  '%TEST%' and siteid = 'SITEA')) java.sql.SQLException:
  ORA-00904: "L_PM"."DESCRIPTION": invalid identifier at
  oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMappi
  ng.java:74)   
  
  1. Make sure the PM table and PM.DESCRIPTION are multi-language
  enabled.
  2. Log in as a user whose language setting is not the base
  language.
  3. Create and make active several PMs. Give each a description
  that includes the same queryable string, for example, MY TEST
  PM1, MY TEST PM2, MY TEST PM3. All PMs need to be in the same
  organization in order to encounter the error.
  4. On the List tab, filter for your new PMs using the common
  string, for example, TEST.
  5. Do not select individual records in the result set. The next
  step should be executed for the entire List tab result set that
  has been filtered on PM.DESCRIPTION.
  6. Select the action menu option Generate Work Orders. You will
  receive the expected warning when executing a List tab action on
  the entire result set: BMXAA2185W - This action affects all 11
  records in this result set. If you would like to select one or
  more records to apply this action to, click Cancel, then: -
  select the desired records using check boxes on the List page -
  select the action you would like to perform on them. If you want
  to proceed with the action on the entire result set, click OK.
  7. Click OK. You will encounter the problem error "BMXAA4210E -
  The database error 904 has occurred. ORA-00904:
  "L_PM"."DESCRIPTION": invalid identifier at
  oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMappi
  ng.java:74)    
  
  The expected behavior is that work order generation will run for
  the PMs on the List tab.
  -------------------
  Reported Version
  Maximo  7.6.1.0
  

Local fix

• If you want to execute PM wogen for all records on the List tab
  using a result set that is filtered on a multilang-enabled
  attribute and you are a user whose language setting is not the
  Maximo base language, do the following:
  
  1. On the List tab, click the 'Select Records' checkbox at the
  bottom of the table window.
  2. Then, at the top of the table window, in the Column Title
  row, click the checkbox that is all the way to the left so that
  all the recods in the table window become selected.
  3. Execute the Generate Work Orders menu action. You should not
  encounter the error.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO users                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When trying to generate PM work orders from the List tab     *
  * error "BMXAA4210E - The database error 904 has occurred."    *
  * (Invalid Identifier/Attribute Name) is encountered if        *
  * PM.DESCRIPTION is multi-language enabled and prior to        *
  * executing Generate Work Orders the PM set on the List tab    *
  * has been filtered on DESCRIPTION.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Steps to Reproduce:
  1. Make sure the PM table and PM.DESCRIPTION are multi-language
  enabled.
  2. Log in as a user whose language setting is not the base
  language.
  3. Create and make active several PMs. Give each a description
  that includes the same queryable string, for example, MY TEST
  PM1, MY TEST PM2, MY TEST PM3. All PMs need to be in the same
  organization in order to encounter the error.
  4. On the List tab, filter for your new PMs using the common
  string, for example, TEST.
  5. Do not select individual records in the result set. The next
  step should be executed for the entire List tab result set that
  has been filtered on PM.DESCRIPTION.
  6. Select the action menu option Generate Work Orders. You will
  receive the expected warning when executing a List tab action on
  the entire result set: BMXAA2185W - This action affects all 11
  records in this result set. If you would like to select one or
  more records to apply this action to, click Cancel, then: -
  select the desired records using check boxes on the List page -
  select the action you would like to perform on them. If you want
  to proceed with the action on the entire result set, click OK.
  7. Click OK. You will encounter the problem error "BMXAA4210E -
  The database error 904 has occurred. ORA-00904:
  "L_PM"."DESCRIPTION": invalid identifier at
  oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMappi
  ng.java:74)    
  
  The expected behavior is that work order generation will run for
  the PMs on the List tab.
  -------------------
  Reported Version
  Maximo  7.6.1.0
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package:
  	| release\fix pack\interim fix for Release 7.6.1.3
  

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 ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels