Universe Migration Tool fails with Invalid object name 'TMS_REGISTRY'

Products

• CA Identity Suite

Issue/Introduction

When running the universe migration utility, like this for example,

eurekify-universemigration.jar" 0 "C:\ExportSQL" "0" IG-TEST 1433 eurekify_sdb sa Password@test eurekify_ticketdb sa Password@test AD

it processes a lot of data but fails when it gets to TMS_REGISTRY.

INFO: SAGE_PREFERENCES3
Oct 13, 2023 9:48:36 AM com.eurekify.util.universemigration.Export export
INFO: SAGE_PREFERENCES4
Oct 13, 2023 9:48:36 AM com.eurekify.util.universemigration.Export export
INFO: TMS_REGISTRY
Oct 13, 2023 9:48:36 AM com.eurekify.util.universemigration.Export export
SEVERE: Something wrong while exporting the universe - com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'TMS_REGISTRY'.

 

Environment

IG 14.5 migration utility running on IG 14.4.x, 14.5 GA

Resolution

First, ensure encryption is set correctly in the migration tool's GUI:

14.5 GUI - database connection wrong

    Add ";encrypt=false" after each database name (ie. dCAIDM_IGSDB;encrypt=false & dCAIDM_IGTKT;encrypt=false)

If the problem persists, download and use the revised version of the migration tool, universemigration-jar-with-dependencies.jar, that is attached to this knowledge document.

Additional Information

The new jar for the IG migration utility is expected to be delivered with the IG 14.5 CP1 tools.