To return expected results, you can:
Reduce the number of search terms.
Each term you use focuses the search further.
Check your spelling.
A single misspelled or incorrectly typed term can change your result.
Try substituting synonyms for your original terms.
For example, instead of searching for "java classes", try "java training"
Did you search for an IBM acquired or sold product ?
If so, follow the appropriate link below to find the content you need.
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)
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 number
IV75520
Reported component name
MAXIMO SCHEDULE
Reported component ID
5724R46SE
Reported release
752
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-07-28
Closed date
2015-08-07
Last modified date
2015-08-07
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
MAXIMO
Fixed component name
MAXIMO SCHEDULE
Fixed component ID
5724R46SE
Applicable component levels
R752 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9NUN","label":"Maximo Asset Management Scheduler"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"752","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
