My Oracle Support Banner

Migration Process Timeout With Dev Database on OnPremise and Target Database on Azure (Doc ID 2538548.1)

Last updated on MAY 05, 2019

Applies to:

Siebel CRM - Version 17.5 [IP2017] and later
Information in this document applies to any platform.

Symptoms

Migration process is failing when source database is on Onpremise and target database is on Azure cloud. Details are 

1. Dev is on-premise
2. Other environments are in cloud (Azure)
3. Migration execution from dev(on-premise) to any other (cloud) is stuck and backend it is reported with error

We are trying to migrate the code from source to target using migration application, but it is just hanging at the step "Runtime Repository Data Service" - Export.


ERROR
-----------------------
2018-07-27 22:53:09,682 [DEBUG] - com.siebel.migration.server.MigrationDataComp:updateMigrationPlanTransactionResources Migration Plan Transaction Resources Update SQL Stmt :UPDATE dbo.S_DP_MP_RSRCTXN set STATUS_CODE = 'Success' , END_TS = ? WHERE ROW_ID  = '1-96B7YF'
2018-07-27 22:53:09,682 [ERROR] - com.siebel.migration.server.MigrationDataComp:updateMigrationPlanTransactionResources Exception while updating MigrationPlan Transaction Resources com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset by peer: socket write error
UPDATE dbo.S_DP_MP_RSRCTXN set STATUS_CODE = 'Success' , END_TS = ? WHERE ROW_ID  = '1-96B7YF'
2018-07-27 22:53:09,682 [ERROR] - com.siebel.migration.server.MigrationExecution:run Exception while Migration Plan Execution The connection is closed.
2018-07-27 22:53:09,682 [TRACE] - com.siebel.migration.server.MigrationExecution:run Updating Migration Plan Transaction With Status Error
2018-07-27 22:53:09,682 [TRACE] - com.siebel.migration.server.MigrationDataComp:updateMigrationPlanTransaction Entering in Method to update Migration Plan Transaction
2018-07-27 22:53:09,682 [ERROR] - com.siebel.migration.server.MigrationDataComp:updateMigrationPlanTransaction Exception in updateMigrationPlanTransaction com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
UPDATE dbo.S_DP_MP_TXN set STATUS_CODE = 'Error' WHERE ROW_ID  = '1-96B7YC'
2018-07-27 22:53:09,682 [ERROR] - com.siebel.migration.server.MigrationExecution:run Exception while Migration Plan Execution com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.