RDBMS - CAST Storage Service - Error - When using the Oracle to CSS migration tool no action is done and the tool disconnects

Purpose (problem description)

When using the Oracle to CSS migration tool, no action happens and the tool disconnects as shown in the following log lines:

2019-01-14 13: 13: 36.776 - Starting database migration for configuration: G: \ temp \ oracle_css3 \ configuration_ORA_CSS3.castmigration like this : 
2019-01-14 13: 13: 36.823 - Connecting to origin server: jdbc: oracle: thin: @ x.x.x.x: 1521: SID1 user: user1 … 
2019-01-14 13: 13: 37.307 - Connected to: jdbc: oracle: thin: @ x.x.x.x: 1521: SID1 user: user1 
2019-01-14 13: 13: 37.307 - Connected to origin server! 
2019-01-14 13: 13: 37.307 - Connecting to target server: jdbc: postgresql: //x.x.x.x: 2282 / postgres user: operator … 
2019-01-14 13: 13: 37.354 - Connected to: jdbc: postgresql: //x.x.x.x: 2282 / postgres user: operator 
2019-01-14 13: 13: 37.354 - Connected to target server! 
2019-01-14 13: 13: 37.370 - Working folder: C: \ Users \ local_user\ AppData \ Local \ Temp \ CAST \ CAST \ 8.2 \ AIPDatabaseMigrationTool_20190114_131337 
2019-01-14 13: 13: 37.385 - Validating the configuration … 
2019-01-14 13: 13: 37.401 - Configuration validated! 
2019-01-14 13: 13: 37.401 - Disconnected! 
2019-01-14 13: 13: 37.401 - Disconnected! 
2019-01-14 13: 13: 37.401 - Database migration completed in 0 ms

Documentation for the tool can be found here: Migrating CAST AIP schemas from Oracle Server and Microsoft SQL Server

Applicable Platform or

Platform or Yes/No
CAST Storage Service / PostgreSQL✅

Step by Step scenario

  1. Run the migration tool
  2. Examine logs

Action Plan

Perform the below actions

  1. Check whether the value of the host on the CAST Oracle Management Database matches exactly with what is being used in the tool.

    1. Run the following query on the CAST Oracle Management Database

SELECT host FROM cms_inf_store_oracle


      The result may look something like this:

      **Query result example**

      server.domain.com
   2. Make sure that the value returned for the result is EXACTLY what is being used for the value of "originserverurl" in the tool, for example with 'server.domain.com' above, the value should be this for the default port and a sid of ORA:  
      `originServerUrl=``"jdbc:oracle:thin:@server.domain.com:1521:ORA"`
2. If this does not resolve the issue, then report your problem to [CAST Technical Support](https://help.castsoftware.com/hc/en-us/requests/new) and provide the [273612934](#)

 

#### Relevant input

- [CAST Support Tool (CST)](https://help.castsoftware.com/hc/en-us/articles/203751708-CAST-Support-Tool-CST-alias-Sherlock) [-](https://help.castsoftware.com/hc/en-us/articles/203751708-CAST-Support-Tool-CST-alias-Sherlock) [alias Sherlock](https://help.castsoftware.com/hc/en-us/articles/203751708-CAST-Support-Tool-CST-alias-Sherlock) export with the following options **CAST Bases Checker,** **Export Configuration files,** **Export Computer Environment,****Export CAST Bases** with Management Base, Knowledge Base, Central base, Measurement Base
- The log of the migration tool
- Detailed information on the error and the steps done

**Notes/comments**

Ticket # 15863

**Related Pages**