Unable To Find Optical Network Path Without Selecting Check Box 'Use Rapid Path Validation’ - MSS throwing Exception: java.sql.SQLSyntaxErrorException: ORA-01795 Error

(Doc ID 2285372.1)

Last updated on JULY 11, 2017

Applies to:

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

Symptoms

PROBLEM STATEMENT

Users are unable to find Optical network path without selecting check box 'Use Rapid Path Validation’

Unable to find Optical network path after selecting Entry and Exit Network Elements and without selecting the check box 'Use Rapid Path Validation’ in Provisioning Assistant window.

If said check box is not checked, MSS throws an Exception: java.sql.SQLSyntaxErrorException: ORA-01795 Error as following.

User in MSS 621.b1106 release.

 

ERROR

The server encountered the following Exception: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:128)
at com.metasolv.jdbc.MSVPreparedStatement.executeQuery(MSVPreparedStatement.java:75)
at MetaSolv.persistent.jdbc.JDSC.issueSelect(JDSC.java:937)
at com.mslv.core.api.internal.NetProv.ConnDesign.query.AvailableChannelQuery.getFirstPendingDisconnect(AvailableChannelQuery.java:900)
- - -

( see full error message in the attached screen shot: Java Exception error message)

STEPS

The issue can be reproduced with the following steps:

1. Open Conn Design for Special CKT PL/KGLD/NNNNNN/ /XXXX/

2. Go to the CLR/DLR Design page and click the Network Action link

3. Enter the Entry and Exit Network Elements as shown below.

Provisioning Assistant: Select Entry and Exit Network Elements:

Entry Network Element Exit Network Element:
=================================
Location: PTLDORXXXXX BVTNORYYYYY
Network Name: L78X
Limits: 10 paths - 7 hops

3. Uncheck the ‘Use Rapid Path Validation’ checkbox

4. Click on Next then got the above error.

5. I the ‘Use Rapid Path Validation’ checkbox is selected:

    ===> No working paths were found.

6. Increasing Limits to All Available Paths give the same message.

BUSINESS IMPACT

Users are unable to provision the affected connection.

Changes

 

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