APAR status
Closed as user error.
Error description
Steps: 1. Create 4 work orders with the following descriptions 25&testing testing&25 testing&testing 25&25 2. Query for all 4 in different scenarios example: 25&testing = no records found 25&25 = no records found testing&testing = record was found testing&25 = record was found 25 = record was found testing = record was found Results: Only appears to be a problem with the NUMBER is first in the description query and with an amperstan &. MORE INFORMATION: Steps to reproduce 1. Login Maximo as wilson 2. Go to Workorder app ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: DRG-50901: text query parser syntax error on line 1, column 8
Local fix
n/a
Problem summary
Problem conclusion
Temporary fix
Comments
Not a bug. & is AND operator, So need a space before and after.
APAR Information
APAR number
IZ25847
Reported component name
WORK ORDER TRAC
Reported component ID
5724R46WO
Reported release
621
Status
CLOSED USE
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2008-06-27
Closed date
2008-06-30
Last modified date
2008-06-30
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
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHPPU","label":"Work Order Tracking"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"621","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
30 June 2008