IBM Support

IZ25847: FAILED SQL QUERY WHEN QUERYING WITH AN '&' AND NUMBER

Subscribe

You can track all active APARs for this component.

 

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