IZ50664: DATABASE ERROR ON DESCRIPTION SEARCH "BMXAA4210E - DATABASE ERROR NUMBER 7630 HAS OCCURRED."

APAR status

• Closed as program error.

Error description

• Maximo 7.1.1.4, SQL Server 2005, WebSphere 6.1
  
  1. Go to Asset application List Tab
  2. Type things, or stuff, on description and enter
  3. You will receive an error "BMXAA4210E - Database error number
  7630 has occurred.
  [VSQL02]Syntax error near 'FORMSOF' in the full-text search
  condition '
  FORMSOF(INFLECTIONAL,"stuff") | & FORMSOF(INFLECTIONAL,"things")
  '.
  
  This error appears on SQL Server environment an other
  applications like Workorder.
  

Local fix

• No workaround
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users who searches Description/Summary       *
  *                 fields in Oracle and Sql Server.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: Database error occurs if user searches  *
  *                      for phrases with comma in SQL Server.   *
  *                                                              *
  *                      Database error occurs if user searches  *
  *                      for phrases ending with comma in        *
  *                      Oracle.                                 *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  Searching with commas in a description field results in a
  database error
  

Problem conclusion

• Problem is fixed.
  
  
  
  
  
  The fix for this APAR is contained in the following maintenance
  package:
  
    | release\fix pack | REL 7.1.1.5 - BS
  

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

  ASSETS

• Fixed component ID

  5724R46AS

Applicable component levels

• R711 PSY

     UP