ORA-01437 Error In MetaSolv Solution Utilities (tbs_util.exe)
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.
MetaSolv Solution Utilities (tbs_util.exe) throws a "ORA-01437: cannot have join with CONNECT BY" error.
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"
Minor: The ORA-01437 error causes confusion.
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