Devart Forums

cfuehrmann

Hi, it works on an empty instance store, but it fails even when the store contains only one workflow. The script gives an error. Worse, after running the script, *no* workflow can be created or continued. Here is the result of running the script:

@"c:/u45.sql";
Tabelle wurde erstellt.
Index wurde erstellt.
Sequence wurde erstellt.
1 Zeile wurde erstellt.
Tabelle wurde erstellt.
Tabelle wurde geõndert.
1 Zeile wurde aktualisiert.

ALTER TABLE InstancesTable MODIFY SurrogateIdentityId INTEGER NOT NULL
*
FEHLER in Zeile 1:
ORA-02296: (CFU1U.) kann nicht aktiviert werden. Null-Werte gefunden.

Tabelle wurde geõndert.
0 Zeilen wurden aktualisiert.
Tabelle wurde geõndert.
Tabelle wurde geõndert.
1 Zeile wurde aktualisiert.
Tabelle wurde geõndert.

cfuehrmann

So, suppose a workflow instance has been created a while ago and resides in the old instance store, waiting in a bookmark caused by a "Receive" activity. Then we apply "OracleInstanceStoreSchemaUpdateTo45.sql". Will we be able to continue the workflow after that?

cfuehrmann

Thanks! By the way, one detail that surprises me is the small size of the script compared to its Microsoft counterpart, which has 78kB. Do you know the reason for the extreme size difference?

cfuehrmann

Hello, on 30 Jan 2014, I sent the question below through the Devart contact form. But I received no ticket number or other kind of acknowledgment, so I must ask in this forum:

From .Net4 to .Net4.5, the workflow instance store schema changes. Accordingly, you provided a new storage schema: "OracleInstanceStoreSchema45.sql". However, I cannot find an upgrade script from 4.0 to 4.5: Microsoft has such a script, "SqlWorkflowInstanceStoreSchemaUpgrade.sql", for Sql Server. It is critical for my company (...) that running workflow instances keep running when the instance store is updated... Can you help us?”

cfuehrmann

Since the above release, the instance store works for us - thanks!

cfuehrmann

Done.

cfuehrmann

The bug we mentioned in our last forum post has been fixed with
version 6.70.293 - thanks! Alas, we have found another issue where
hosting with a configuration file fails while hosting in code
works. We have a very simple workflow that consists of a
Receive/SendReply followed by a Delay activity. (The xamlx follows at
the end of the email, but you may just create it by yourselves with a
a small number of clicks. Alternatively, we could send you a tiny
solution file that contains it.)

Now on the one hand we host this workflow with by using the following code:

var serviceDefinition =
(WorkflowService)XamlServices.Load("Service1.xamlx");
var host = new WorkflowServiceHost(serviceDefinition, new Uri("http://localhost:8888/"));
host.Description.Behaviors.Add(new OracleInstanceStoreBehavior
{
ConnectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=re0482)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=spex)));User Id=rkl;Password=rkl",
InstanceEncodingOption = InstanceEncodingOption.None,
InstanceCompletionAction = InstanceCompletionAction.DeleteAll,
InstanceLockedExceptionAction = InstanceLockedExceptionAction.BasicRetry,
HostLockRenewalPeriod = new TimeSpan(00, 00, 30),
RunnableInstancesDetectionPeriod = new TimeSpan(00, 00, 05)
});

The resulting workflow instance behaves as expected: when called via
WCF, it works its way through the Delay activity and then quits. On
the other hand, we host the same workflow in the IIS with the
following configuration file:

In this second case, the workflow gets stuck in the Delay activity
forever. In both cases, the workflow invocation leads to a new entry
in the INSTANCESTABLE of the Oracle instance store. In the first case,
that entry is updated soon with new data in the formally empty colums
COMPLEXDATAPROPERTIES, METADATAPROPERTIES, and more. In the second
case, the INSTANCESTABLE entry is never updated again.

So apparently, workflow instances hosted with a configuration file
have the wrong database behavior, even though the DevArt backend is
essentially capable of correct execution.

Any ideas?

---

And here is our little workflow:

Code: Select all

<WorkflowService mc:Ignorable="sap" ConfigurationName="Service1" sap:VirtualizedContainerService.HintSize="307,428" Name="Service1" mva:VisualBasic.Settings="Assembly references and imported namespaces serialized as XML namespaces" xmlns="http://schemas.microsoft.com/netfx/2009/xaml/servicemodel" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:mv="clr-namespace:Microsoft.VisualBasic;assembly=System" xmlns:mva="clr-namespace:Microsoft.VisualBasic.Activities;assembly=System.Activities" xmlns:p="http://tempuri.org/" xmlns:p1="http://schemas.microsoft.com/netfx/2009/xaml/activities" xmlns:s="clr-namespace:System;assembly=mscorlib" xmlns:s1="clr-namespace:System;assembly=System" xmlns:s2="clr-namespace:System;assembly=System.Xml" xmlns:s3="clr-namespace:System;assembly=System.Core" xmlns:s4="clr-namespace:System;assembly=System.ServiceModel" xmlns:sad="clr-namespace:System.Activities.Debugger;assembly=System.Activities" xmlns:sap="http://schemas.microsoft.com/netfx/2009/xaml/activities/presentation" xmlns:scg="clr-namespace:System.Collections.Generic;assembly=System" xmlns:scg1="clr-namespace:System.Collections.Generic;assembly=System.ServiceModel" xmlns:scg2="clr-namespace:System.Collections.Generic;assembly=System.Core" xmlns:scg3="clr-namespace:System.Collections.Generic;assembly=mscorlib" xmlns:sd="clr-namespace:System.Data;assembly=System.Data" xmlns:sl="clr-namespace:System.Linq;assembly=System.Core" xmlns:st="clr-namespace:System.Text;assembly=mscorlib" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml">
<p1:Sequence DisplayName="Sequential Service" sad:XamlDebuggerXmlReader.FileName="c:\dokumente und einstellungen\rkleinhempel\eigene dateien\visual studio 2010\Projects\OrackeTestWorkflowService\OrackeTestWorkflowService\Service1.xamlx" sap:VirtualizedContainerService.HintSize="277,398" mva:VisualBasic.Settings="Assembly references and imported namespaces serialized as XML namespaces">
<p1:Sequence.Variables>
<p1:Variable x:TypeArguments="CorrelationHandle" Name="handle" />
<p1:Variable x:TypeArguments="x:Int32" Name="data" />
<p1:Variable x:TypeArguments="x:String" Default="test" Name="test" />
</p1:Sequence.Variables>
<sap:WorkflowViewStateService.ViewState>
<scg3:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg3:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<Receive x:Name="__ReferenceID0" CanCreateInstance="True" DisplayName="ReceiveRequest" sap:VirtualizedContainerService.HintSize="255,86" OperationName="GetData" ServiceContractName="p:IService">
<Receive.CorrelationInitializers>
<RequestReplyCorrelationInitializer CorrelationHandle="[handle]" />
</Receive.CorrelationInitializers>
<ReceiveMessageContent>
<p1:OutArgument x:TypeArguments="x:Int32">[data]</p1:OutArgument>
</ReceiveMessageContent>
</Receive>
<SendReply Request="{x:Reference __ReferenceID0}" DisplayName="SendResponse" sap:VirtualizedContainerService.HintSize="255,86">
<SendMessageContent>
<p1:InArgument x:TypeArguments="x:String">[data.ToString()]</p1:InArgument>
</SendMessageContent>
</SendReply>
<p1:Delay Duration="[New TimeSpan(0, 4, 0)]" sap:VirtualizedContainerService.HintSize="255,22" />
</p1:Sequence>
</WorkflowService>

cfuehrmann

kmoren wrote:Since this is a WCF workflow service hosted in IIS, we don't have a non-config file option of enabling the extensions and behaviors for the instance store and tracking.

A colleague of mine may have found the reason for the bug and I just sent Shalex an email about it.

cfuehrmann

Dear Devart folks, could it be that the problem exists because of the use of an obfuscator tool? Reflector shows me that certain Enum members in your dll seem to have their member names obfuscated, e.g.:

public enum InstanceCompletionAction
{
a,
b
}

Is that how it should be?

Shalex wrote:We are investigating the problem.

cfuehrmann

I have precisely the same problem. (Btw., being able to run my company's WF4-based software with an Oracle backend is required by many potential customers, so having the DotConnect instance store work would make many people happy

)

Beziel wrote:Hi,
I tried the version 6.60 but it doesn't work yet.
I receive back the following error:

The default value for the property 'instanceCompletionAction' has different type than the one of the property itself.

here my web.config file:

Code: Select all


<system.serviceModel>
<extensions>
<behaviorExtensions>
<add name="oracleInstanceStore" type="Devart.Data.Oracle.DurableInstancing.Configuration.OracleInstanceStoreElement, Devart.Data.Oracle.WorkflowFoundation, Version=6.60.258.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
</behaviorExtensions>
</extensions>

....


<serviceBehaviors>
<behavior>
<!-- To avoid disclosing metadata information, set the value below to false and remove the metadata endpoint above before deployment -->
<serviceMetadata httpGetEnabled="true" />
<!-- To receive exception details in faults for debugging purposes, set the value below to true. Set to false before deployment to avoid disclosing exception information -->
<serviceDebug includeExceptionDetailInFaults="false" />
<workflowUnhandledException action="Terminate" />
<workflowIdle timeToUnload="0"/>
<oracleInstanceStore connectionString="InstanceStoreConnectionString" instanceEncodingOption="GZip" instanceLockedExceptionAction="AggressiveRetry" hostLockRenewalPeriod="00:00:30" instanceCompletionAction="DeleteAll" runnableInstancesDetectionPeriod="00:00:05"/>
</behavior>
</serviceBehaviors>
</behaviors>
</system.serviceModel>

Regards

Devart Forums

Search found 10 matches

Re: Workflow instance store migration to .Net 4.5

Re: Workflow instance store migration to .Net 4.5

Re: Workflow instance store migration to .Net 4.5

Workflow instance store migration to .Net 4.5

Concerning our instance-store problems

One more issue when hosting with a configuration file

Re: Documentation on Workflow Instance Store

Possible cause

I have precisely the same problem. Leaving away the instance