IT32807: CODELISTCODES REST API RETURNS SQL ERROR WHEN DEFAULT VERSION IS PART OF THE READCODELISTCODES QUERY

APAR status

• Closed as program error.

Error description

• ReadCodeListCodes REST API throws a SQL error "API000002:
  java.sql.SQLSyntaxErrorException: ORA-00936: missing
  expression" when listVersion is set to default version.
  

Local fix

• STRRTC - B2BISFG-52298
  MRC/MRC
  Circumvention: None
  

Problem summary

• Users Affected:
  
  All
  
  Problem Description:
  
  
  
         When the ReadCodeListCodes Service is invoked and part of
  the query it includes listVersion=-1 (searching for the default
  version).An SQL error is returned:
  
  
  
  Oracle DB - { "errorCode": 400, "errorDescription": "API000002:
  java.sql.SQLSyntaxErrorException: ORA-00936: missing expression"
  }
  
  
  
  SQL Server DB -
  
  { "errorCode": 400, "errorDescription": "API000002:
  com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect
  syntax near the keyword 'and'." }
  
  
  
        Platforms Affected:
  
         All
  

Problem conclusion

•   Resolution Summary:
  A code fix is provided.
      A Java class was updated that was creating incorrect SQL
  statement that caused the SQLSyntaxErrorException.
  
  
  
        Delivered in:
  
      6000203
  

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

  STR B2B INTEGRA

• Fixed component ID

  5725D0600

Applicable component levels