My Oracle Support Banner

ORA-01437 Error In MetaSolv Solution Utilities (tbs_util.exe) (Doc ID 1983838.1)

Last updated on MAY 09, 2022

Applies to:

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


MetaSolv Solution Utilities (tbs_util.exe) throws a "ORA-01437: cannot have join with CONNECT BY" error.

NOTE: The DB Health process completes after clicking OK to the error.  The utility properly compiles invalid objects.

Error text


Image of error in GUI


1. Configure the database with _old_connect_by_enabled = true (required per MetaSolv Solution Doc ID 789163.1)

2. Access MetaSolv Solution Utilities (tbs_util.exe)

3. Click the DB Health button and the "ORA-01437: cannot have join with CONNECT BY" error is thrown when the Progress Meter is at 50% and states "Checking system tables - Synonyms"


Business Impact

Minor: The ORA-01437 error causes confusion.




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.