My Oracle Support Banner

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

Last updated on FEBRUARY 22, 2017

Applies to:

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

Symptoms

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


Steps

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.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.