Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Issue with Ms.Sync framework 2.0 and odp.net managed driver

3728700Jun 19 2018 — edited Nov 13 2019

Hi,

We have been using Ms.Sync framework 2.0 and ODP.NET Umanaged driver to sync data with Oracle database.

Now, we moved to ODP.NET, Managed driver.

The synchronization fails with this error when we call RelationalSyncProvider.ProcessChangeBatch.

Do you have any ideas?

Thanks very much.

System.ObjectDisposedException was unhandled by user code

  HResult=-2146232798

  Message=Cannot access a disposed object.

Object name: 'OracleCommand'.

  Source=Oracle.ManagedDataAccess

  ObjectName=OracleCommand

  StackTrace:

       at Oracle.ManagedDataAccess.Client.OracleCommand.set_Connection(OracleConnection value)

       at Oracle.ManagedDataAccess.Client.OracleCommand.set_DbConnection(DbConnection value)

       at Microsoft.Synchronization.Data.DbSyncScopeHandler.ReadScope(IDbConnection connection, IDbTransaction transaction, ReadKnowledgeType readType, ReadForgottenKnowledgeType readFKtype)

       at Microsoft.Synchronization.Data.RelationalSyncProvider.InitializeChangeApplicationTransaction()

       at Microsoft.Synchronization.Data.RelationalSyncProvider.SingleTransactionApplyChangesAdapter.PrepareForApplyOrRetry(DataSet ds)

       at Microsoft.Synchronization.Data.RelationalSyncProvider.ApplyChanges(DbSyncScopeMetadata scopeMetadata, DataSet dataSet, DbSyncSession dbSyncSession, Boolean commitTransaction)

       at Microsoft.Synchronization.Data.RelationalSyncProvider.ProcessChangeBatch(ConflictResolutionPolicy resolutionPolicy, ChangeBatch sourceChanges, Object changeDataRetriever, SyncCallbacks syncCallbacks, SyncSessionStatistics sessionStatistics)

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2018
Added on Jun 19 2018
10 comments
924 views