1
Vote

Windows Workflow Foundation persistence service for Oracle

description

Hi,   I want to use WFT for percistence ORACLE, but I have a problem with de example. The track that show is the following:   GenericPersistenceService::LoadExpiredWorkflowIds GenericPersistenceService::LoadExpiredWorkflowIds Workflow 22074fdb-0dd3-44c8-85c6-05a73408752d: Aborted GenericPersistenceService::Complete AdoWorkBatchService::WorkBatchRolledback Workflow Runtime: Service Exception - WFTools.Services.Persistence.PersistenceException: An unexpected exception occurred while performing a workflow persistence operation. System.InvalidOperationException: No se ha podido inscribir en una transacción distribuida en Oracle.DataAccess.Client.OracleConnection.EnlistTransaction(Transaction transaction) en WFTools.Services.Common.Ado.DefaultAdoResourceProvider.CreateEnlistedConnection(Transaction transaction, Boolean& shouldClose) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Common\Ado\DefaultAdoResourceProvider.cs:línea 107 en WFTools.Services.Batching.Ado.AdoWorkBatchService.AdoResourceProviderWrapper.CreateEnlistedConnection(Transaction transaction, Boolean& shouldClose) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Batching\Ado\AdoWorkBatchService.cs:línea 445 en WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor..ctor(IAdoResourceProvider resourceProvider, IPersistenceNameResolver nameResolver, IAdoValueReader valueReader, Transaction transaction) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:línea 85 en WFTools.Services.Persistence.Ado.AdoPersistenceService.CreateAccessor(IResourceProvider resourceProvider, Transaction transaction) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceService.cs:línea 162 en WFTools.Services.Persistence.GenericPersistenceService.Commit(Transaction transaction, ICollection items) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Persistence\GenericPersistenceService.cs:línea 680 ---> System.InvalidOperationException: No se ha podido inscribir en una transacción distribuida en Oracle.DataAccess.Client.OracleConnection.EnlistTransaction(Transaction transaction) en WFTools.Services.Common.Ado.DefaultAdoResourceProvider.CreateEnlistedConnection(Transaction transaction, Boolean& shouldClose) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Common\Ado\DefaultAdoResourceProvider.cs:línea 107 en WFTools.Services.Batching.Ado.AdoWorkBatchService.AdoResourceProviderWrapper.CreateEnlistedConnection(Transaction transaction, Boolean& shouldClose) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Batching\Ado\AdoWorkBatchService.cs:línea 445 en WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor..ctor(IAdoResourceProvider resourceProvider, IPersistenceNameResolver nameResolver, IAdoValueReader valueReader, Transaction transaction) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:línea 85 en WFTools.Services.Persistence.Ado.AdoPersistenceService.CreateAccessor(IResourceProvider resourceProvider, Transaction transaction) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceService.cs:línea 162 en WFTools.Services.Persistence.GenericPersistenceService.Commit(Transaction transaction, ICollection items) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Persistence\GenericPersistenceService.cs:línea 680 --- Fin del seguimiento de la pila de la excepción interna --- GenericPersistenceService::Commit - An unexpected exception occurred while performing a workflow persistence operation. System.InvalidOperationException: No se ha podido inscribir en una transacción distribuida en Oracle.DataAccess.Client.OracleConnection.EnlistTransaction(Transaction transaction) en WFTools.Services.Common.Ado.DefaultAdoResourceProvider.CreateEnlistedConnection(Transaction transaction, Boolean& shouldClose) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Common\Ado\DefaultAdoResourceProvider.cs:línea 107 en WFTools.Services.Batching.Ado.AdoWorkBatchService.AdoResourceProviderWrapper.CreateEnlistedConnection(Transaction transaction, Boolean& shouldClose) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Batching\Ado\AdoWorkBatchService.cs:línea 445 en WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor..ctor(IAdoResourceProvider resourceProvider, IPersistenceNameResolver nameResolver, IAdoValueReader valueReader, Transaction transaction) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:línea 85 en WFTools.Services.Persistence.Ado.AdoPersistenceService.CreateAccessor(IResourceProvider resourceProvider, Transaction transaction) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceService.cs:línea 162 en WFTools.Services.Persistence.GenericPersistenceService.Commit(Transaction transaction, ICollection items) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Persistence\GenericPersistenceService.cs:línea 680 GenericPersistenceService::Commit AdoWorkBatchService::TransactionCreated GenericWorkBatchService::CommitWorkBatch GenericPersistenceService::UnlockWorkflowInstanceState GenericPersistenceService::Complete AdoWorkBatchService::WorkBatchRolledback Workflow Runtime: Service Exception - WFTools.Services.Persistence.PersistenceException: An unexpected exception occurred while performing a workflow persistence operation. System.InvalidOperationException: No se ha podido inscribir en una transacción distribuida en Oracle.DataAccess.Client.OracleConnection.EnlistTransaction(Transaction transaction) en WFTools.Services.Common.Ado.DefaultAdoResourceProvider.CreateEnlistedConnection(Transaction transaction, Boolean& shouldClose) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Common\Ado\DefaultAdoResourceProvider.cs:línea 107 en WFTools.Services.Batching.Ado.AdoWorkBatchService.AdoResourceProviderWrapper.CreateEnlistedConnection(Transaction transaction, Boolean& shouldClose) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Batching\Ado\AdoWorkBatchService.cs:línea 445 en WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor..ctor(IAdoResourceProvider resourceProvider, IPersistenceNameResolver nameResolver, IAdoValueReader valueReader, Transaction transaction) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:línea 85 en WFTools.Services.Persistence.Ado.AdoPersistenceService.CreateAccessor(IResourceProvider resourceProvider, Transaction transaction) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceService.cs:línea 162 en WFTools.Services.Persistence.GenericPersistenceService.Commit(Transaction transaction, ICollection items) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Persistence\GenericPersistenceService.cs:línea 680 ---> System.InvalidOperationException: No se ha podido inscribir en una transacción distribuida en Oracle.DataAccess.Client.OracleConnection.EnlistTransaction(Transaction transaction) en WFTools.Services.Common.Ado.DefaultAdoResourceProvider.CreateEnlistedConnection(Transaction transaction, Boolean& shouldClose) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Common\Ado\DefaultAdoResourceProvider.cs:línea 107 en WFTools.Services.Batching.Ado.AdoWorkBatchService.AdoResourceProviderWrapper.CreateEnlistedConnection(Transaction transaction, Boolean& shouldClose) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Batching\Ado\AdoWorkBatchService.cs:línea 445 en WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor..ctor(IAdoResourceProvider resourceProvider, IPersistenceNameResolver nameResolver, IAdoValueReader valueReader, Transaction transaction) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:línea 85 en WFTools.Services.Persistence.Ado.AdoPersistenceService.CreateAccessor(IResourceProvider resourceProvider, Transaction transaction) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceService.cs:línea 162 en WFTools.Services.Persistence.GenericPersistenceService.Commit(Transaction transaction, ICollection items) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Persistence\GenericPersistenceService.cs:línea 680 --- Fin del seguimiento de la pila de la excepción interna --- GenericPersistenceService::Commit - An unexpected exception occurred while performing a workflow persistence operation. System.InvalidOperationException: No se ha podido inscribir en una transacción distribuida en Oracle.DataAccess.Client.OracleConnection.EnlistTransaction(Transaction transaction) en WFTools.Services.Common.Ado.DefaultAdoResourceProvider.CreateEnlistedConnection(Transaction transaction, Boolean& shouldClose) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Common\Ado\DefaultAdoResourceProvider.cs:línea 107 en WFTools.Services.Batching.Ado.AdoWorkBatchService.AdoResourceProviderWrapper.CreateEnlistedConnection(Transaction transaction, Boolean& shouldClose) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Batching\Ado\AdoWorkBatchService.cs:línea 445 en WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor..ctor(IAdoResourceProvider resourceProvider, IPersistenceNameResolver nameResolver, IAdoValueReader valueReader, Transaction transaction) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:línea 85 en WFTools.Services.Persistence.Ado.AdoPersistenceService.CreateAccessor(IResourceProvider resourceProvider, Transaction transaction) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceService.cs:línea 162 en WFTools.Services.Persistence.GenericPersistenceService.Commit(Transaction transaction, ICollection items) en C:\Users\Usuario\Downloads\WFTools-v0.3.0.0\Services\Pe   Please, I need your help.     Regrats   Wagner

file attachments

comments