PI21780: JAVA.SQL.SQLSYNTAXERROREXCEPTION: ORA-01795: MAXIMUM NUMBER OF EXPRESSIONS IN A LIST IS 1000

APAR status

• Closed as program error.

Error description

• Deploy throws this error Caused by:
  java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of
  expressions in a list is 1000  when this API is called
  /rest/security/team/<id>/resourceMappings/Environment is called.
  
  There's a query in the above method that is using a list with
  more than 1000 elements as part of its query.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users of UrbanCode Deploy                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * JAVA.SQL.SQLSYNTAXERROREXCEPTION: ORA-01795: MAXIMUM NUMBER  *
  * OF¶ EXPRESSIONS IN A LIST IS 1000 is seen in environment     *
  * resource mappings.                                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• A fix is available in UrbanCode Deploy 6.1.0.2.
  

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

  UDEPLOY

• Fixed component ID

  5725M7700

Applicable component levels

• R500 PSN

     UP

• R500 PSY

     UP