MSS is Requiring 'Rapid Path Validation' to Find Optical Network Path (Doc ID 2227675.1)

Last updated on JANUARY 27, 2017

Applies to:

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

Symptoms

PROBLEM STATEMENT

On : 6.2.1 version, Engineering - Customer doing tests to upgrade to 621.b1006

Unable to find Optical network path without selecting check box 'Use Rapid Path Validation’

Users are 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.

ERROR

(partial - see complete error in the full error message here: Error Message)

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)
- - -

STEPS

The issue can be reproduced with the following steps:

1. Open Conn Design for a Special Circuit

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:              PTLDORPBOL2                   BVTNORDTOL1
        Network Name:      L78                                  L78
        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