PJ40385: IER Record Search with the '<' or '>' operator in Filtered-by-pa rent criteria runs into a Lexical error of "Encountered: "&" ".

APAR status

• Closed as program error.

Error description

• When running IBM Enterprise Records Record Search with
  filtered-by-parent criteria,
  if any filtered-by-parent criteria contains '<' or '<=' or '>'
  or '>=' operator, the search would fail. For example, Search for
  Record and filter by Record Category, use 'Current Phase
  Execution Date < 01/01/2013' as search criteria. This search
  causes error:
  
  Unable to get the search result based on the search criteria. An
  unexpected exception was detected.
  Caused by: com.filenet.engine.retrieve.parser.TokenMgrError:
  Lexical error at line 1, column 871. Encountered: "&" (38),
  after : ""
  
  In general, the error would occur in IBM Enterprise Records
  4.5.1 patch 6 and
  eariler, although the error was reported in the following
  enviroment configuration.
  IBM Enterprise Records 4.5.1 patch 3 and 4
  CE 4.5.1 SP 7
  PE 4.5.1 sp2
  XT 1.1.5 SP1
  WAS 7.0 Sp21
  Oracle 10
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users who run IBM InfoSphere Enterprise Records prior to     *
  * version 4.5.1 fp 7.                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When running IBM InfoSphere Enterprise Records Record        *
  * Search with filtered-by-parent criteria,                     *
  * if any filtered-by-parent criteria contains '<' or '<=' or   *
  * '>'                                                          *
  * or '>=' operator, the search fails. For example, Search for  *
  * Record and filter by Record Category. Use 'Current Phase     *
  * Execution Date < 01/01/2013' as search criteria.             *
  *                                                              *
  * See Error Description for additional information.            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM InfoSphere Enterprise Records 4.5.1 FP 7.     *
  ****************************************************************
  

Problem conclusion

• The problem is now fixed in IBM InfoSphere Enterprise Records
  4.5.1 FP 7. With the fix, IBM InfoSphere Enterprise Records
  Record Search with filtered-by-parent criteria works correctly.
  There are no other changes to IBM InfoSphere Enterprise
  Records Search behavior.
  

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

  RECORDS MANAGER

• Fixed component ID

  5724S1900

Applicable component levels

• R451 PSY

     UP