MSS is Allowing Recursive Circuit Position Assignment Between Facility and Riding Circuits (Doc ID 2105828.1)

Last updated on FEBRUARY 11, 2016

Applies to:

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

Symptoms

PROBLEM DESCRIPTION

User getting errors and is booted out of MSS when printing circuit 1/HC%028998%

When printing out the CLR for a circuit, HC/ 028998, users are getting the following errors and the system finally shuts down and boots them out.
This has been happening for several days, and it’s only on this one particular CLR.

Cause: MSS is allowing recursive assignment between positions in a facility and its riders: a rider is assigned to a facility position and MSS is allowing the facility to be assigned to a rider circuit position.

STEPS

a. Created a new CKT-1: Special Connection Type HC, with one Connection Position N/A - 99/HC--/161966%
b. Created a new CKT-2: Special Connection Type HC, with one Connection Position N/A - 99/HC--/161967%

c. Assigned CKT-2 to ride CKT-1
d. Assigned CKT-1 to ride CKT-2

   »» MSS did not detect the assignment in loop

e. Outputs » Preview CLR prints normally the CLR
f.  Outputs » Print CLR/DLR
  »» MSS crashes with the messages below.

CKT-1 can be Special or Facility type.

BUSINESS IMPACT

This behavior should not be allowed.
If done by mistake, it will error in some features and need additional work to undo the assignment.

ERROR MESSAGES

1. A database error has occurred. The error message is: ORA-01436: CONNECT BY loop in user data. The SQL statement that caused the error is:
SELECT COUNT(DISTINCT CP.CIRCUIT_DESIGN_ID_3) FROM ASAP.CIRCUIT_POSITION CP, ASAP.CIRCUIT C
  WHERE C.CIRCUIT_DESIGN_ID = CP.CIRCUIT_DESIGN_ID_3
  AND C.ECCKT_TYPE IN ('CLM', 'OTM')
  AND CP.CIRCUIT_DESIGN_ID_3 IN
  ( SELECT DISTINCT CIRCUIT_POSITION.CIRCUIT_DESIGN_ID_3
  FROM ASAP.CIRCUIT_POSITION
  START WITH CIRCUIT_POSITION.CIRCUIT_DESIGN_ID = ?
  CONNECT BY PRIOR CIRCUIT_POSITION.CIRCUIT_DESIGN_ID_3 = CIRCUIT_POSITION.CIRCUIT_DESIGN_ID)

2. Could not retrieve circuit count for circuit design id: 17799788.

3. Error number 6.
  Error text = Invalid DataWindow row/column specified.
  Window/Menu/Object = w_circuitdesignprint.
  Error Object/Control = w_circuitdesignprint.
  Script = oe_resetcontrols.
  Line in Script = 11.

4. Error Number 2. «« error was displayed 4 times
  Error text = Null object reference.
  Window/Menu/Object = w_circuitdesignprint.
  Error Object/Control = w_circuitdesignprint.
  Script = oe_resetcontrols.
  Line in Script = 11.
- - -
8. Error Number 2.
  Error text = Null object reference.
  Window/Menu/Object = pf_w_master.
  Error Object/Control = pf_w_master.
  Script = oe_resetcontrols.
  Line in Script = 39.

9. Error Number 21.
  Error text = Bad runtime function reference.
  Window/Menu/Object = pf_w_response.
  Error Object/Control = pf_w_response.
  Script = open.
  Line in Script = 1.

10. Error Number 21.
  Error text = Bad runtime function reference.
  Window/Menu/Object = w_circuitdesignprint.
  Error Object/Control = w_circuitdesignprint.
  Script = open.
  Line in Script = 1.
.

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