Oracle Error Adding Hard Connection on the Connection Design Schematic Design - java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000 (Doc ID 1952897.1)

Last updated on FEBRUARY 22, 2017

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.

Symptoms

The application throws a "java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000" error when a user attempts to add a hard connection on the Connection Design's Schematic Design. Below is the error displayed in the application.

Error Text

 

Image of First Error Thrown

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms