Tibero

Tibero

When registering a database connection, when clicking the "Test" button, 'Specified schema object was not found at: SELECT value FROM V$VERSION WHERE NAME = 'PRODUCT_MAJOR' OR NAME = 'TB_MAJOR' Please review your settings and correct any errors.' is displayed.

Cause

This error occurs because the database user account used to connect to the Migration Center does not have the necessary privilege to query the DICTIONARY for checking the DB version.

Solution

Grant the required DICTIONARY query privileges to the database user account.

• For Tibero 4 or below:
  Tibero version 4 or below does not have system privileges for DICTIONARY, so grant the SELECT ANY TABLE privilege. This privilege allows querying objects in any schema.

  GRANT SELECT ANY TABLE TO user_name;
  

• For Tibero 5 or above:
  Grant the SELECT ANY DICTIONARY privilege. This privilege allows querying objects in the DICTIONARY owned by SYS, SYSCAT, and SYSGIS.

  GRANT SELECT ANY DICTIONARY TO user_name;
  

Reference

• https://www.tmaxtibero.com/img/service/pdf/manual/Tibero_4_SP1_Administrator's_Guide_v2.1.4.pdf
• https://technet.tmaxsoft.com/upload/download/online/tibero/pver-20220224-000002/tibero_admin/chapter_security.html#sect_so_privilege

Object Migration Failure Due to Missing Dependency Information in Tibero 7.2.2

Cause

In Tibero version 7.2.2, a known issue exists where dependency information for functions is missing from the metadata views that manage object dependencies. As a result, object migrations involving dependencies may fail to complete successfully.

Solution

Manually review object dependencies during migration. Any objects that fail to migrate due to missing dependency information must be identified and migrated manually.