WFTools Forum Rss Feed

New Post: GenericPersistenceService will run in .NET 4.0?

deanward — Wed, 02 Sep 2009 16:31:26 GMT

Hi there,

I'm not entirely sure to be honest I haven't tried yet! From what I understand the entire workflow runtime model has changed for WF4.0 so I'm guessing probably not... I may look into rewriting for .NET 4.0 once it goes to a more stable release (maybe beta 2).

Cheers,

Dean

2009/9/2 lagear <notifications@codeplex.com>

From: lagear

Hi,

Good job.

GenericPersistenceService will be run for .NET 4.0?

Best.

Read the full discussion online.

To add a post to this discussion, reply to this email (WFTools@discussions.codeplex.com)

To start a new discussion for this project, email WFTools@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe or change your settings on codePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at codeplex.com

--
Dean Ward
E-mail: dean@iprinciples.com
Web: http://www.iprinciples.com/
Mobile: +44 (0)7776 144435

New Post: GenericPersistenceService will run in .NET 4.0?

lagear — Wed, 02 Sep 2009 16:20:42 GMT

Hi,

Good job.

GenericPersistenceService will be run for .NET 4.0?

Best.

New Post: Persistance service exception

gmartelli — Tue, 25 Aug 2009 12:01:17 GMT

I'm running a workflow using wftools as the persistance service, but after it has finished running (I know it has, I can check some tables a local service is writing to and I see them filled) , a couple seconds after it finished running I get an exception. It isn't triggering the WorkflowTerminated event, which makes me think its related to the persistance service.

I´m running change set 15786. Can anyone give me any pointers on where the problem might be? Is WFTool production ready?

Related trace:

System.Workflow.Runtime Information: 0 : Activity Status Change - Activity: PruebaNotificacionInformativa Old:Executing; New:Closed
System.Workflow.Runtime.Tracking Information: 0 : TrackingListener::ActivityStatusChange - Received Activity Status Change Event for activity PruebaNotificacionInformativa
GenericTrackingChannel::Send
System.Workflow.Runtime Information: 0 : pending work hc 7299092 added workItem hc 42112153
GenericTrackingChannel::MustCommit
GenericTrackingChannel::Send
System.Workflow.Runtime Information: 0 : pending work hc 7299092 added workItem hc 14645814
GenericTrackingChannel::InstanceCompletedOrTerminated
GenericTrackingChannel::Send
System.Workflow.Runtime Information: 0 : pending work hc 7299092 added workItem hc 51678514
System.Workflow.Runtime Information: 0 : Workflow Runtime: WorkflowExecutor: Calling SaveWorkflowInstanceState for instance 59722e65-3191-4a0f-82d9-263304f32ed3 hc 721416
GenericPersistenceService::SaveWorkflowInstanceState
System.Workflow.Runtime Information: 0 : pending work hc 33056860 added workItem hc 15144272
GenericTrackingChannel::MustCommit
GenericTrackingChannel::MustCommit
GenericPersistenceService::MustCommit
System.Workflow.Runtime Information: 0 : Workflow Runtime: WorkflowExecutor: Calling CommitTransaction for instance 59722e65-3191-4a0f-82d9-263304f32ed3 hc 721416
GenericWorkBatchService::CommitWorkBatch
AdoWorkBatchService::TransactionCreated
System.Workflow.Runtime Information: 0 : pending work hc 7299092 added workItem hc 4678963

[...]

(A bunch of that repeats with different numbers)

GenericTrackingChannel::Commit
GenericPersistenceService::Commit
'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\ejemplo.userinterfase\81c2b91a\ff384ba7\assembly\dl3\7de02c86\f60c9a75_9721ca01\WFTools.Resources.resources.DLL', No symbols loaded.
A first chance exception of type 'WFTools.Services.Persistence.PersistenceException' occurred in WFTools.Services.DLL
GenericPersistenceService::Commit - An unexpected exception occurred while performing a workflow persistence operation. WFTools.Services.Persistence.PersistenceException: Instance with identifier 59722e65-3191-4a0f-82d9-263304f32ed3 could not be loaded.
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.CheckResult(DbCommand dbCommand, String resultParameter, String instanceParameter) in C:\sources\Cajval.FrameworkComun\Workflow\wftools\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 449
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.InsertInstanceState(PendingWorkItem workItem, Guid ownerId, DateTime ownedUntil) in C:\sources\Cajval.FrameworkComun\Workflow\wftools\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 256
   at WFTools.Services.Persistence.GenericPersistenceService.Commit(Transaction transaction, ICollection items) in C:\sources\Cajval.FrameworkComun\Workflow\wftools\Services\Persistence\GenericPersistenceService.cs:line 688
System.Workflow.Runtime.Hosting Critical: 0 : WorkflowRuntime:ServicesExceptionNotHandled event raised for instance Id 00000000-0000-0000-0000-000000000000 WFTools.Services.Persistence.PersistenceException: An unexpected exception occurred while performing a workflow persistence operation. WFTools.Services.Persistence.PersistenceException: Instance with identifier 59722e65-3191-4a0f-82d9-263304f32ed3 could not be loaded.
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.CheckResult(DbCommand dbCommand, String resultParameter, String instanceParameter) in C:\sources\Cajval.FrameworkComun\Workflow\wftools\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 449
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.InsertInstanceState(PendingWorkItem workItem, Guid ownerId, DateTime ownedUntil) in C:\sources\Cajval.FrameworkComun\Workflow\wftools\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 256
   at WFTools.Services.Persistence.GenericPersistenceService.Commit(Transaction transaction, ICollection items) in C:\sources\Cajval.FrameworkComun\Workflow\wftools\Services\Persistence\GenericPersistenceService.cs:line 688 ---> WFTools.Services.Persistence.PersistenceException: Instance with identifier 59722e65-3191-4a0f-82d9-263304f32ed3 could not be loaded.
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.CheckResult(DbCommand dbCommand, String resultParameter, String instanceParameter) in C:\sources\Cajval.FrameworkComun\Workflow\wftools\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 449
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.InsertInstanceState(PendingWorkItem workItem, Guid ownerId, DateTime ownedUntil) in C:\sources\Cajval.FrameworkComun\Workflow\wftools\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 256
   at WFTools.Services.Persistence.GenericPersistenceService.Commit(Transaction transaction, ICollection items) in C:\sources\Cajval.FrameworkComun\Workflow\wftools\Services\Persistence\GenericPersistenceService.cs:line 688
   --- End of inner exception stack trace ---
A first chance exception of type 'WFTools.Services.Persistence.PersistenceException' occurred in WFTools.Services.DLL
AdoWorkBatchService::WorkBatchRolledback
A first chance exception of type 'WFTools.Services.Persistence.PersistenceException' occurred in WFTools.Services.DLL

New Post: GenericTrackingQueryManager - how much functionality is there in ChangeSet 15876?

iamdudley — Fri, 07 Aug 2009 04:41:23 GMT

Hi,

I have a working state machine workflow running with SQL Server 2005 Express which I am trying to swap over to Oracle using WFTools. I have got the included samples working with data being persisted to the database nicely. However, I rely on StateMachineWorkflowInstance.StateHistory to display the workflow as a list of completed and incomplete steps to the user. I have not yet found a way to do this using GenericTrackingQueryManager. Is this functionality in WFTools? And if not, is there another way to create such a list?

Thanks,

James.

New Post: Issue in example Oracle Percistence

iamdudley — Fri, 07 Aug 2009 00:03:16 GMT

Hi Wagner,

did you solve this? I think you want to check the checkbox that says use local transactions. This is based on "No se ha podido inscribir en una transacción distribuida" translating to "Unable to enroll in a distributed transaction"

James.

New Post: Oracle - Peristence - AccessViolationException

renew — Tue, 04 Aug 2009 08:53:51 GMT

Hey guys,

I have a problem persisting a workflow to an Oracle Database. When the workflow should get persisted the connection to the database should get openend, an then an AccessViolationException is thrown.
This only happens in the exact moment where the workflow get's suspended and the runtime calls the service to persist it.

Because I added some code elsewhere and there the connection gets opened as it should. Unfortunately I haven't found any answer in the OTN forums, just one thread were a guy has the same issue as I described.

Thank you very much for your help, kind regards, renew

New Post: Using Persistence service with .config file

jkirsten — Thu, 30 Jul 2009 02:30:41 GMT

I followed exact steps as described above and I'm hitting the following run-time error....does anyone know what this means or how to resolve this one? Any help would be greatly appreciated. Thanks.

GenericPersistenceService::Commit - An unexpected exception occurred while performing a workflow persistence operation. System.InvalidCastException: Failed to convert parameter value from a Guid to a Byte[]. ---> System.InvalidCastException: Object must implement IConvertible.
   at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)
   at System.Data.OracleClient.OracleParameter.CoerceValue(Object value, MetaType destinationType)
   --- End of inner exception stack trace ---
   at System.Data.OracleClient.OracleParameter.CoerceValue(Object value, MetaType destinationType)
   at System.Data.OracleClient.OracleParameter.SetCoercedValueInternal(Object value, MetaType metaType)
   at System.Data.OracleClient.OracleParameterBinding.PrepareForBind(OracleConnection connection, Int32& offset)
   at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
   at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
   at System.Data.OracleClient.OracleCommand.ExecuteNonQuery()
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.InsertInstanceState(PendingWorkItem workItem, Guid ownerId, DateTime ownedUntil) in C:\Users\JK\Plus\WF\wftools-jul26\Main\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 254
   at WFTools.Services.Persistence.GenericPersistenceService.Commit(Transaction transaction, ICollection items) in C:\Users\JK\Plus\WF\wftools-jul26\Main\Services\Persistence\GenericPersistenceService.cs:line 692

New Post: Oracle Persistence Questions

jkirsten — Sun, 26 Jul 2009 13:43:14 GMT

I've downloaded the latest patch 15876 and have been struggling to make my workflow persist and load correctly.

1) I don't see a method to load all workflows from persisted store? In SQLServicePersistence, there's a method that loads all persisted workflow instances. How does that get impleted in AdoPersistenceService?

2) I created the Oracle tables/stored procedures as provided in the package. I followed this code-snippet from installation.txt and I get "User transaction is not enlisted" error during peristence. How do I fix this? I looked around all discussion threads and don't see an answer.

Can someone shed some light on this please?

thanks.

New Post: Issue in example Oracle Percistence

wrvasquez — Thu, 23 Jul 2009 21:05:37 GMT

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

New Post: how do i find current stage?

gmartelli — Wed, 08 Jul 2009 12:12:02 GMT

Sorry for bringing this thread back... I'm working with some samples from different books to query the tracking service (in the case of the books, its SQLTrackingService). I´ve been trying to port them over to WFtools tracking with no success...Is there any minimal example I can use as a basis?

New Post: Wftools - Workflows deployed as webservices

gmartelli — Mon, 22 Jun 2009 17:08:52 GMT

Hi there.

I was intending to publish my wf as webservices, using the wizard in Visual Studio. To support persistance and tracking, I think I have to add the services to the .config file. I haven´t found any example, except for code ones that I cannot use as I´m using the default tools.

Any advice on how to proceed? Thanks in advance.

New Post: .NET 4.0 WF...

deanward — Tue, 12 May 2009 20:55:33 GMT

Hi there,

I've not looked into WF4.0 in any detail just yet, but from what I understand it has a similar persistence and tracking model to the previous version. I suspect we'll update the toolset to support WF4.0 if there are any substantial changes...

Cheers,

Dean

New Post: .NET 4.0 WF...

mucster — Fri, 23 Jan 2009 12:36:07 GMT

Will this tool be updated for the new .NET 4.0 WF or will the new WF support using other DB's out of the box?

New Post: MYSQL persistence issue..

deanward — Fri, 05 Dec 2008 09:03:43 GMT

Presumably that stored procedure is there? Can you execute it manually using the same connection details as those in the sample apps configuration file?

Cheers,

Dean

2008/12/5 rajeshaz09 <notifications@codeplex.com>

From: rajeshaz09

Yeah.

I did as specified in "Installation notes.txt". I am seeing all tables , stored procedures through..."Show Tables", "Show Procedure Status" commands.

My mysql server version is 5.1
MySQL .NET connector version is 5.2.5

Read the full discussion online.

To add a post to this discussion, reply to this email (WFTools@discussions.codeplex.com)

To start a new discussion for this project, email WFTools@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe or change your settings on codePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at codeplex.com

--
Dean Ward
E-mail: dean@iprinciples.com
Web: http://www.iprinciples.com/
Mobile: +44 (0)7776 144435

New Post: MYSQL persistence issue..

rajeshaz09 — Fri, 05 Dec 2008 08:43:21 GMT

Yeah.

I did as specified in "Installation notes.txt". I am seeing all tables , stored procedures through..."Show Tables", "Show Procedure Status" commands.

My mysql server version is 5.1
MySQL .NET connector version is 5.2.5

New Post: MYSQL persistence issue..

deanward — Fri, 05 Dec 2008 08:38:53 GMT

Hi Rajesh,

Did you run the MySql installation scripts under Database\Persistence\MySql?

Cheers,

Dean

2008/12/5 rajeshaz09 <notifications@codeplex.com>

From: rajeshaz09

Hi,

I downloaded latest version of WFTools. I ran the sample (WFTools.Samples.Windows)....

But i am getting folowwing exception.

Workflow Runtime: Service Exception - WFTools.Services.Persistence.PersistenceException: An unexpected exception occurred while performing a workflow persistence operation. MySql.Data.MySqlClient.MySqlException: Procedure or function 'RetrieveExpiredTimerIds' cannot be found in database 'WFTOOLS'.
at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName)
at MySql.Data.MySqlClient.StoredProcedure.GetParameters(String procName)
at MySql.Data.MySqlClient.StoredProcedure.Resolve()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.RetrieveExpiredTimerIds(Guid ownerId, DateTime ownedUntil) in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 381
at WFTools.Services.Persistence.GenericPersistenceService.LoadExpiredWorkflowIds() in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\GenericPersistenceService.cs:line 399 ---> MySql.Data.MySqlClient.MySqlException: Procedure or function 'RetrieveExpiredTimerIds' cannot be found in database 'WFTOOLS'.
at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName)
at MySql.Data.MySqlClient.StoredProcedure.GetParameters(String procName)
at MySql.Data.MySqlClient.StoredProcedure.Resolve()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.RetrieveExpiredTimerIds(Guid ownerId, DateTime ownedUntil) in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 381
at WFTools.Services.Persistence.GenericPersistenceService.LoadExpiredWorkflowIds() in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\GenericPersistenceService.cs:line 399
--- End of inner exception stack trace ---
GenericPersistenceService::LoadExpiredWorkflowIds - An unexpected exception occurred while performing a workflow persistence operation. MySql.Data.MySqlClient.MySqlException: Procedure or function 'RetrieveExpiredTimerIds' cannot be found in database 'WFTOOLS'.
at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName)
at MySql.Data.MySqlClient.StoredProcedure.GetParameters(String procName)
at MySql.Data.MySqlClient.StoredProcedure.Resolve()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.RetrieveExpiredTimerIds(Guid ownerId, DateTime ownedUntil) in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 381
at WFTools.Services.Persistence.GenericPersistenceService.LoadExpiredWorkflowIds() in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\GenericPersistenceService.cs:line 399
GenericPersistenceService::LoadExpiredWorkflowIds
Workflow Runtime: Service Exception - WFTools.Services.Persistence.PersistenceException: An unexpected exception occurred while performing a workflow persistence operation. MySql.Data.MySqlClient.MySqlException: Procedure or function 'RetrieveExpiredTimerIds' cannot be found in database 'WFTOOLS'.
at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName)
at MySql.Data.MySqlClient.StoredProcedure.GetParameters(String procName)
at MySql.Data.MySqlClient.StoredProcedure.Resolve()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.RetrieveExpiredTimerIds(Guid ownerId, DateTime ownedUntil) in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 381
at WFTools.Services.Persistence.GenericPersistenceService.LoadExpiredWorkflowIds() in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\GenericPersistenceService.cs:line 399 ---> MySql.Data.MySqlClient.MySqlException: Procedure or function 'RetrieveExpiredTimerIds' cannot be found in database 'WFTOOLS'.
at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName)
at MySql.Data.MySqlClient.StoredProcedure.GetParameters(String procName)
at MySql.Data.MySqlClient.StoredProcedure.Resolve()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.RetrieveExpiredTimerIds(Guid ownerId, DateTime ownedUntil) in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 381
at WFTools.Services.Persistence.GenericPersistenceService.LoadExpiredWorkflowIds() in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\GenericPersistenceService.cs:line 399
--- End of inner exception stack trace ---
GenericPersistenceService::LoadExpiredWorkflowIds - An unexpected exception occurred while performing a workflow persistence operation. MySql.Data.MySqlClient.MySqlException: Procedure or function 'RetrieveExpiredTimerIds' cannot be found in database 'WFTOOLS'.
at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName)
at MySql.Data.MySqlClient.StoredProcedure.GetParameters(String procName)
at MySql.Data.MySqlClient.StoredProcedure.Resolve()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.RetrieveExpiredTimerIds(Guid ownerId, DateTime ownedUntil) in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 381
at WFTools.Services.Persistence.GenericPersistenceService.LoadExpiredWorkflowIds() in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\GenericPersistenceService.cs:line 399
GenericPersistenceService::LoadExpiredWorkflowIds
Workflow Runtime: Service Exception - WFTools.Services.Persistence.PersistenceException: An unexpected exception occurred while performing a workflow persistence operation. MySql.Data.MySqlClient.MySqlException: Procedure or function 'RetrieveExpiredTimerIds' cannot be found in database 'WFTOOLS'.
at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName)
at MySql.Data.MySqlClient.StoredProcedure.GetParameters(String procName)
at MySql.Data.MySqlClient.StoredProcedure.Resolve()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.RetrieveExpiredTimerIds(Guid ownerId, DateTime ownedUntil) in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 381
at WFTools.Services.Persistence.GenericPersistenceService.LoadExpiredWorkflowIds() in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\GenericPersistenceService.cs:line 399 ---> MySql.Data.MySqlClient.MySqlException: Procedure or function 'RetrieveExpiredTimerIds' cannot be found in database 'WFTOOLS'.
at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName)
at MySql.Data.MySqlClient.StoredProcedure.GetParameters

. IThere is no problem, if i conected to SQL server. Any ideas?

Thanks
--
Rajesh A

Read the full discussion online.

To add a post to this discussion, reply to this email (WFTools@discussions.codeplex.com)

To start a new discussion for this project, email WFTools@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe or change your settings on codePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at codeplex.com

--
Dean Ward
E-mail: dean@iprinciples.com
Web: http://www.iprinciples.com/
Mobile: +44 (0)7776 144435

New Post: MYSQL persistence issue..

rajeshaz09 — Fri, 05 Dec 2008 07:31:03 GMT

Hi,

I downloaded latest version of WFTools. I ran the sample (WFTools.Samples.Windows)....

But i am getting folowwing exception.

Workflow Runtime: Service Exception - WFTools.Services.Persistence.PersistenceException: An unexpected exception occurred while performing a workflow persistence operation. MySql.Data.MySqlClient.MySqlException: Procedure or function 'RetrieveExpiredTimerIds' cannot be found in database 'WFTOOLS'.
   at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
   at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
   at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName)
   at MySql.Data.MySqlClient.StoredProcedure.GetParameters(String procName)
   at MySql.Data.MySqlClient.StoredProcedure.Resolve()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.RetrieveExpiredTimerIds(Guid ownerId, DateTime ownedUntil) in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 381
   at WFTools.Services.Persistence.GenericPersistenceService.LoadExpiredWorkflowIds() in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\GenericPersistenceService.cs:line 399 ---> MySql.Data.MySqlClient.MySqlException: Procedure or function 'RetrieveExpiredTimerIds' cannot be found in database 'WFTOOLS'.
   at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
   at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
   at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName)
   at MySql.Data.MySqlClient.StoredProcedure.GetParameters(String procName)
   at MySql.Data.MySqlClient.StoredProcedure.Resolve()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.RetrieveExpiredTimerIds(Guid ownerId, DateTime ownedUntil) in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 381
   at WFTools.Services.Persistence.GenericPersistenceService.LoadExpiredWorkflowIds() in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\GenericPersistenceService.cs:line 399
   --- End of inner exception stack trace ---
GenericPersistenceService::LoadExpiredWorkflowIds - An unexpected exception occurred while performing a workflow persistence operation. MySql.Data.MySqlClient.MySqlException: Procedure or function 'RetrieveExpiredTimerIds' cannot be found in database 'WFTOOLS'.
   at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
   at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
   at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName)
   at MySql.Data.MySqlClient.StoredProcedure.GetParameters(String procName)
   at MySql.Data.MySqlClient.StoredProcedure.Resolve()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.RetrieveExpiredTimerIds(Guid ownerId, DateTime ownedUntil) in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 381
   at WFTools.Services.Persistence.GenericPersistenceService.LoadExpiredWorkflowIds() in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\GenericPersistenceService.cs:line 399
GenericPersistenceService::LoadExpiredWorkflowIds
Workflow Runtime: Service Exception - WFTools.Services.Persistence.PersistenceException: An unexpected exception occurred while performing a workflow persistence operation. MySql.Data.MySqlClient.MySqlException: Procedure or function 'RetrieveExpiredTimerIds' cannot be found in database 'WFTOOLS'.
   at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
   at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
   at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName)
   at MySql.Data.MySqlClient.StoredProcedure.GetParameters(String procName)
   at MySql.Data.MySqlClient.StoredProcedure.Resolve()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.RetrieveExpiredTimerIds(Guid ownerId, DateTime ownedUntil) in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 381
   at WFTools.Services.Persistence.GenericPersistenceService.LoadExpiredWorkflowIds() in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\GenericPersistenceService.cs:line 399 ---> MySql.Data.MySqlClient.MySqlException: Procedure or function 'RetrieveExpiredTimerIds' cannot be found in database 'WFTOOLS'.
   at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
   at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
   at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName)
   at MySql.Data.MySqlClient.StoredProcedure.GetParameters(String procName)
   at MySql.Data.MySqlClient.StoredProcedure.Resolve()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.RetrieveExpiredTimerIds(Guid ownerId, DateTime ownedUntil) in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 381
   at WFTools.Services.Persistence.GenericPersistenceService.LoadExpiredWorkflowIds() in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\GenericPersistenceService.cs:line 399
   --- End of inner exception stack trace ---
GenericPersistenceService::LoadExpiredWorkflowIds - An unexpected exception occurred while performing a workflow persistence operation. MySql.Data.MySqlClient.MySqlException: Procedure or function 'RetrieveExpiredTimerIds' cannot be found in database 'WFTOOLS'.
   at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
   at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
   at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName)
   at MySql.Data.MySqlClient.StoredProcedure.GetParameters(String procName)
   at MySql.Data.MySqlClient.StoredProcedure.Resolve()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.RetrieveExpiredTimerIds(Guid ownerId, DateTime ownedUntil) in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 381
   at WFTools.Services.Persistence.GenericPersistenceService.LoadExpiredWorkflowIds() in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\GenericPersistenceService.cs:line 399
GenericPersistenceService::LoadExpiredWorkflowIds
Workflow Runtime: Service Exception - WFTools.Services.Persistence.PersistenceException: An unexpected exception occurred while performing a workflow persistence operation. MySql.Data.MySqlClient.MySqlException: Procedure or function 'RetrieveExpiredTimerIds' cannot be found in database 'WFTOOLS'.
   at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
   at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
   at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName)
   at MySql.Data.MySqlClient.StoredProcedure.GetParameters(String procName)
   at MySql.Data.MySqlClient.StoredProcedure.Resolve()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.RetrieveExpiredTimerIds(Guid ownerId, DateTime ownedUntil) in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 381
   at WFTools.Services.Persistence.GenericPersistenceService.LoadExpiredWorkflowIds() in F:\Users\rajesh\Desktop\MySQL\WFTools-v0.3.0.0\Services\Persistence\GenericPersistenceService.cs:line 399 ---> MySql.Data.MySqlClient.MySqlException: Procedure or function 'RetrieveExpiredTimerIds' cannot be found in database 'WFTOOLS'.
   at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
   at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
   at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName)
   at MySql.Data.MySqlClient.StoredProcedure.GetParameters

. IThere is no problem, if i conected to SQL server. Any ideas?

Thanks
--
Rajesh A

New Post: WFTools persistence and delay activities.

rupurt — Fri, 28 Nov 2008 00:27:33 GMT

MySQL 5.1

New Post: WFTools persistence and delay activities.

deanward — Thu, 27 Nov 2008 13:07:43 GMT

Hi rupurt,

What database are you targetting?

Thanks,

Dean

2008/11/27 rupurt <notifications@codeplex.com>

From: rupurt

I've tried this with a sequential workflow on the 15876 build but it still looks like the workflow isn't getting removed from the INSTANCE_STATE table. It leaves it in there and throws

An unexpected exception occurred while performing a workflow persistence operation. WFTools.Services.Persistence.PersistenceException: Instance with identifier 639cda61-107c-4240-84ee-216ffdb8b7d1 could not be loaded.\r\n at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.CheckResult(DbCommand dbCommand, String resultParameter, String instanceParameter)

Read the full discussion online.

To add a post to this discussion, reply to this email (WFTools@discussions.codeplex.com)

To start a new discussion for this project, email WFTools@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe or change your settings on codePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at codeplex.com

--
Dean Ward
E-mail: dean@iprinciples.com
Web: http://www.iprinciples.com/
Mobile: +44 (0)7776 144435

New Post: WFTools persistence and delay activities.

rupurt — Thu, 27 Nov 2008 02:40:04 GMT

I've tried this with a sequential workflow on the 15876 build but it still looks like the workflow isn't getting removed from the INSTANCE_STATE table. It leaves it in there and throws

An unexpected exception occurred while performing a workflow persistence operation. WFTools.Services.Persistence.PersistenceException: Instance with identifier 639cda61-107c-4240-84ee-216ffdb8b7d1 could not be loaded.\r\n at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.CheckResult(DbCommand dbCommand, String resultParameter, String instanceParameter)