IT01746: CONTROL CENTER WENT DOWN FROM A ORA-00907: MISSING RIGHT PARENTHESIS

APAR status

• Closed as program error.

Error description

• <----------------- executeQuery - Exception Info - Begin
  executeQuery - SQL Exception msg : ORA-00907: missing right
  parenthesis
  executeQuery - SQL State : 42000
  executeQuery - SQL Error Code : 907
  executeQuery - SQL cmd :null
  <-----------------executeQuery - Exception Info - End --------->
  
  ERROR RecoverableDAO - ORA-00907: missing right parenthesis
  
   Stack Trace:
     java.sql.SQLSyntaxErrorException: ORA-00907:
  missing right parenthesis
  

Local fix

• STRRTC - 424136
  SF /SF
  Circumvention: None
  

Problem summary

• Description of issue: Control Center shuts down when executing a
  user defined query/filter criteria for process history.
  

Problem conclusion

• Description of fix: Added code to execute the query only once,
  if its a query that's initiated by the UI.
  

Temporary fix

• In test
  

Comments

• In test
  

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

  STR CONTROL CEN

• Fixed component ID

  5725D0200

Applicable component levels

• R52X PSY

     UP

• R530 PSY

     UP

• R540 PSY

     UP

• R541 PSY

     UP

• R542 PSY

     UP