Where is Xform data stored?

Vote:
 

I've got some posts causing problems when I try to upgrade our site to CMS 6.0. The ID's are printed so I thought I'd just delete the posts but I can't find them. Where are they stored?

The site is fully functional even if these causes exceptions but I'd like to sort these out once and for all.

#41931
Aug 04, 2010 10:41
Vote:
 

They are stored in tblItem, but if you plan to delete dem straight out of the table make sure you do it on a test database first. Have you tried using the API to delete the xform data? I wouldn't recommend deleting directly in the database.

#41932
Aug 04, 2010 11:24
Vote:
 

Yes, this is a test database. How do I use the API to do this?

#41934
Aug 04, 2010 11:48
Vote:
 

The simplest is probably if you can just list the xform data from edit mode and remove any form data you want. Otherwise you can use the XFormData.CreateInstance method to get the posting (you need to know it's guid) and then call the Delete method on the returned instance.

#41940
Aug 04, 2010 13:02
Vote:
 

Just opening the form would of course be the easiest way to go but the exception in the installation leaves me with the ID, that's it. I have no idea in what form to find this.

I'll probably end up just upgrading and never mind about the Xforms. They are disposable anyways.

#41941
Aug 04, 2010 13:23
Vote:
 

What kind of ID is it you get then (I thought it was the guid)? Can you post the full message?

#41942
Aug 04, 2010 14:17
Vote:
 

Upgrading XForm Post - 1 of 17 with Id ce3d1eb6-89ea-4f3b-b40a-8b748925f9c7

An error occurred upgrading an XForm post

A store has not been created for posts of XForm with Id 2e2246a1-971e-4756-b077-30e244b66967. Is this an orphan post?

Upgrading XForm Post - 2 of 17 with Id f83b7d47-a2e8-4ac5-b28b-4f6073a49cb7

An error occurred upgrading an XForm post

A store has not been created for posts of XForm with Id 2e2246a1-971e-4756-b077-30e244b66967. Is this an orphan post?

Upgrading XForm Post - 3 of 17 with Id a3ed0f0e-8fad-4c14-b0ba-920d39b71ff4

An error occurred upgrading an XForm post

A store has not been created for posts of XForm with Id 2e2246a1-971e-4756-b077-30e244b66967. Is this an orphan post?

Upgrading XForm Post - 4 of 17 with Id 7ffc6c98-c000-4f19-b98e-49bcd6f11b88

An error occurred upgrading an XForm post

A store has not been created for posts of XForm with Id 52c04029-3d1a-43e4-90cc-953792a92df8. Is this an orphan post?

Upgrading XForm Post - 5 of 17 with Id ae4105a6-dda3-4a1a-a1e7-8c6d42bc41e8

An error occurred upgrading an XForm post

A store has not been created for posts of XForm with Id 52c04029-3d1a-43e4-90cc-953792a92df8. Is this an orphan post?

Upgrading XForm Post - 6 of 17 with Id 439a35a1-afae-4606-8116-fbbcfe8d150d

An error occurred upgrading an XForm post

A store has not been created for posts of XForm with Id 52c04029-3d1a-43e4-90cc-953792a92df8. Is this an orphan post?

Upgrading XForm Post - 7 of 17 with Id 0f20c271-7ffe-4207-b975-eb356fd4ce5c

An error occurred upgrading an XForm post

A store has not been created for posts of XForm with Id be7afb55-0443-4f53-b54e-214e8a79b8c0. Is this an orphan post?

Upgrading XForm Post - 8 of 17 with Id 214070cb-f333-43ba-acfc-7badce41b7a5

An error occurred upgrading an XForm post

A store has not been created for posts of XForm with Id be7afb55-0443-4f53-b54e-214e8a79b8c0. Is this an orphan post?

Upgrading XForm Post - 9 of 17 with Id dce84477-ad5a-442d-986f-ea8440c4ac6f

An error occurred upgrading an XForm post

A store has not been created for posts of XForm with Id be7afb55-0443-4f53-b54e-214e8a79b8c0. Is this an orphan post?

Upgrading XForm Post - 10 of 17 with Id 27f4b44e-7f07-462b-bce6-841299e378fa

An error occurred upgrading an XForm post

A store has not been created for posts of XForm with Id be7afb55-0443-4f53-b54e-214e8a79b8c0. Is this an orphan post?

Upgrading XForm Post - 11 of 17 with Id 2fa2a4dd-58b2-41d3-a815-821287f7fa1e

An error occurred upgrading an XForm post

A store has not been created for posts of XForm with Id 2e2246a1-971e-4756-b077-30e244b66967. Is this an orphan post?

Upgrading XForm Post - 12 of 17 with Id 3cf1c431-312b-4d5d-9754-f7f4dd4274a6

An error occurred upgrading an XForm post

A store has not been created for posts of XForm with Id be7afb55-0443-4f53-b54e-214e8a79b8c0. Is this an orphan post?

Upgrading XForm Post - 13 of 17 with Id baffbbee-b2ac-42d9-aadf-976ca1c89f81

An error occurred upgrading an XForm post

A store has not been created for posts of XForm with Id 52c04029-3d1a-43e4-90cc-953792a92df8. Is this an orphan post?

Upgrading XForm Post - 14 of 17 with Id 098e4a66-3eed-4b8b-b28d-0a3751d16283

An error occurred upgrading an XForm post

A store has not been created for posts of XForm with Id 2e2246a1-971e-4756-b077-30e244b66967. Is this an orphan post?

Upgrading XForm Post - 15 of 17 with Id b7be37a8-605b-4d97-819f-2b5cc9c2a261

An error occurred upgrading an XForm post

A store has not been created for posts of XForm with Id be7afb55-0443-4f53-b54e-214e8a79b8c0. Is this an orphan post?

Upgrading XForm Post - 16 of 17 with Id 9fe286a1-c5e7-426a-a305-fbb1a88b8e16

An error occurred upgrading an XForm post

A store has not been created for posts of XForm with Id be7afb55-0443-4f53-b54e-214e8a79b8c0. Is this an orphan post?

Upgrading XForm Post - 17 of 17 with Id e919384f-934e-4d0b-b0fc-ad99ebb726cb

An error occurred upgrading an XForm post

A store has not been created for posts of XForm with Id 52c04029-3d1a-43e4-90cc-953792a92df8. Is this an orphan post?

 

An unhandled error has occured:

Completed with errors - see Additional Information window

When executing

 

At C:\Program Files\EPiServer\CMS\6.0.530.0\Upgrade\System Scripts\Migrate Data

 (SqlServer).ps1:100 char:19

+                           Upgrade-EPiXForms <<<<  -SelectedSite $wizard.SelectedApplication

 

=

Get-EPiIsBulkInstalling

Error - System.Management.Automation.CmdletInvocationException: Completed with errors - see Additional Information window ---> System.ApplicationException: Completed with errors - see Additional Information window

   at EPiServer.Upgrade.CMS5.XFormUpgrader.Upgrade(String connectionString, String dbProviderName, Boolean oracle)

   at EPiServer.Upgrade.CMS5.XFormUpgrader.Upgrade(String connectionString, String dbProviderName, Boolean oracle)

   at EPiServer.Upgrade.CMS5.UpgradeXFormsCmdlet.ProcessRecord()

   at System.Management.Automation.Cmdlet.DoProcessRecord()

   at System.Management.Automation.CommandProcessor.ProcessRecord()

   --- End of inner exception stack trace ---

   at System.Management.Automation.Internal.PipelineProcessor.SynchronousExecuteEnumerate(Object input, Hashtable errorResults, Boolean enumerate)

   at System.Management.Automation.PipelineNode.Execute(Array input, Pipe outputPipe, ArrayList& resultList, ExecutionContext context)

   at System.Management.Automation.StatementListNode.ExecuteStatement(ParseTreeNode statement, Array input, Pipe outputPipe, ArrayList& resultList, ExecutionContext context)

 

#41943
Aug 04, 2010 14:26
Vote:
 

Those are indeed the guids of the posts. If you do XFormData.CreateInstance(new Guid("guid from error message goes here")).Delete() you should get rid of them. Then hope there are no more orphans than those 17 :)

#41946
Aug 04, 2010 14:54
Vote:
 

I get "Object reference is not set to an instance...." when I try to do that... :/

#41947
Aug 04, 2010 15:26
Vote:
 
#41948
Aug 04, 2010 15:27
Vote:
 

Weird, that seems to indicate that it is already removed (CreateInstance returns null). I have no further suggestions then.

#41964
Aug 05, 2010 10:51
Vote:
 

Did you solve it Magnus? If you didn't I think it's because you are using EPiServer CMS 6 and I think it stores XForms in a different way than how the 5 did it.  Use Reflector to look at the XFormData Delete() method in a CMS 5 dll, to see how they do it there and copy that code.

#41965
Aug 05, 2010 10:56
Vote:
 

I gave up and upgraded the site last night and everything is "fine and dandy". :)

Thanks for your effort! Appreciate it!

#41967
Aug 05, 2010 11:01
Vote:
 

Great :)

#41969
Aug 05, 2010 11:14