IV75520: ORACLE EXCEPTION "ORA-00920: INVALID RELATIONAL OPERATOR" IS THROWN IN SCHEDULER 7520

APAR status

• Closed as program error.

Error description

• Oracle exception "ORA-00920: invalid relational operator" is
  thrown in Scheduler
  
  Environment :
  
  WAS 8.5.5.2
  TPAE 7.5.0.5 + IFIX20150331
  Scheduler 7.5.2.0 Build 20130903
  Linux 3.0.101-0.15
  Oracle 11.2 (Oracle 11g Enterprise Edition Release 11.2.0.4.0)
  
  
  ACTION TAKEN :
  
  - Problem replicated.
  
  Replication Steps :
  
  
  
  1. Log in as "Maxadmin" user
  
  2. Go to Preventive Maintenance -> Preventive Maintenance and
  click on
  button "Save query" and then on button "Save current query".
  
  3. A create a new public query without any where clause and
  click on OK:
  4. Click on button "Save query" and then on button "View/Manage
  Queries".
  
  5. Edit the above created query with the following Where clause:
  
  status <> 'INACTIVE') order by changedate
  
  6. Click on OK
  
  7. Execute the saved query and make sure it correctly returns an
  ordered
  list of PMs (if the changedate attribute is not available, the
  query
  could be ordered by priority)
  
  8. GoTo Planning and Scheduling -> Scheduler and create a new
  Schedule
  
  
  
  9. From the Work Queries section, click on the "Copy Query"
  button and
  select the PM query created at step 5
  
  
  
  10. Click on the SAVE button. The following error message
  displays:
  
  BMXAT0050E - The project data failed to populate into scheduler
  tables
  for project xxxx. For more information, check the Maximo
  log file (in your application server directory) or contact your
  system
  administrator.
  BMXAT0048E - The activities did not populate. For more
  information,
  check the Maximo log file (in your application server directory)
  or
  contact your system administrator.
  ORA-00920: invalid relational operator.
  
  
  Scheduler L3 has authorized APAR creation.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO USERS                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Oracle exception "ORA-00920: invalid relational operator" is *
  * thrown in Scheduler when copy query has order by clause      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixpack  Release 7.5.0.9 of Base Services or request   *
  * an interim fix                                               *
  ****************************************************************
  

Problem conclusion

• Fix has been made to fix....The fix for this APAR is contained
  in the following maintenance package:
  		 | release\fix pack\interim fix for  Release 7.5.0.9 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:

Modules/Macros

• MAXIMO
  

Fix information

• Fixed component name

  MAXIMO SCHEDULE

• Fixed component ID

  5724R46SE

Applicable component levels

• R752 PSY

     UP