Tuesday, August 21, 2012 12:49 AMHi,
I have just downloaded the latest VS 2012 and was eager to test the new versioning features in AppFabric + WF services.
However, when I create a small test app from VS 2012 and try to run it in IIS configured with my original persistence store, I get the following exception:
The SqlWorkflowInstanceStore has a database version of '22.214.171.124'. InstancePersistenceCommand 'System.Activities.DurableInstancing.CreateWorkflowOwnerWithIdentityCommand' cannot be run against this database version. Please upgrade the database to '126.96.36.199'.
Pretty self explanatory, rigth!? The problem is I am unable to find any resource online about upgrading the database to 4.5.
I saw that App Fabric 1.1 was upgraded back in March but doesn't seem to make any difference when I install this.
Is there a script/wizard to be run? Is it just coming later?
Wednesday, August 22, 2012 4:25 PMModerator
I have not heard about the plans to upgrade a database to 4.5 yet but based on the error I would expect that this may be coming out eventually. Thanks for posting your issue, it is intriguing.
If this answers your question, please use the "Answer" button to say so | Ben Cline
Tuesday, August 28, 2012 4:23 PM
I was experiencing the same problem. I've been using Workflow 4.0 and now, while creating a spike to see if makes sense to update to Workflow 4.5, I found the same problem as you. I was able to fix it by running an upgrade script.
In the folder:
You will find a SQL script called "SqlWorkflowInstanceStoreSchemaUpgrade".
Run it!! and that should fix the problem!!!