My Oracle Support Banner

Application Hangs Indefinitely, Unless Terminated, Making Facility Assignment (Assign Connection) to Channel 1 of a Specific T1 (Doc ID 2692546.1)

Last updated on MAY 17, 2024

Applies to:

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


The Trunk circuit's Connection Design hangs when attempting to make a Facility Assignment (Assign Connection) to channel 1 of a specific T1. The client must be terminated using the Windows Task Manager. The behavior is related to the SQL statements listed below. They run relatively quick, but are executed thousands of times over and over. The data below was captured over an approximate 11 hour period of testing. Note the database activity related to the hanging client session stops after it is terminated on the workstation. 


SQL ID = '8zfrxmgd8az0k'
Executions (1 hr ) = 68,624
Executions (~11 hrs) = 1,076,009




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.