1. Home
  2. Support
Article - CS321292

Oracle to SQL Server Migration 11.1 M020 failing with error "The following sequences are not migrated properly: filenameusn_seq,streamId_seq"

Modified: 24-Feb-2020   


Applies To

  • Windchill PDMLink 11.1 M020-CPS01

Description

  • o2s_migration_report.html > Migration Errors - Summary:
Step: dataMigration     
Error Description: migrate_batch_data     
Error during data migration:The following sequences are not migrated properly: filenameusn_seq,streamId_seq,
  • O2S_Migration.log reading:
ERROR Oracle_SQLServer_Dynamic_Mig.Migration.migrateOracleSequence():2524 - Error during reseeding: System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Oracle_SQLServer_Dynamic_Mig.Migration.migrateOracleSequence(String oraSequence, Int64 last_sequence) in n:\SQLMigration\modules\O2S\src_native\Oracle_SQLServer_Dynamic_Mig\migration\Migration.cs:line 2524
This is a printer-friendly version of Article 321292 and may be out of date. For the latest version click CS321292