IJ37331: IN THE TICKET TEMPLATES APPLICATION, SQL ERROR CODE 933 WHILE TRYING TO SAVE A NEW(DUPLICATE) RECORD.

APAR status

• Closed as program error.

Error description

• STEPS TO REPRODUCE:
  
  1. Go to Ticket Templates application.
  
  2. Create a new Template associated to a Classification and also
  to an Organization.
  
  3. Save the record.
  
  4. From More Actions menu, select Duplicate Template.
  
  5. Try to save the new(dup) record.
  
  RESULTS:
  At this point, the system throws the error "BMXAA6713E - The MBO
  fetch operation failed in the mboset with the SQL error code
  933. The record could not be retrieved from the database. See
  the log file for more details about the error.".
  
  EXPECTED RESULTS:
  No error while trying to save the new(dup) record.
  
  REPORTED IN VERSION:
  IBM Maximo Asset Management 7.6.1.2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo, ICD                                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * IJ37331 IN THE TICKET TEMPLATES APPLICATION, SQL ERROR CODE  *
  * 933 WHILE TRYING TO SAVE A NEW(DUPLICATE) RECORD AFTER       *
  * ENTERING A CLASSIFICATION AND ORG                            *
  ****************************************************************
  

Problem conclusion

• SQL append was missing a space
  

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

  WORK ORDERS

• Fixed component ID

  5724R46WO

Applicable component levels