AI OnAI Off
Where is Xform data stored?
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.
Aug 04, 2010 11:24
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.
Aug 04, 2010 13:02
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.
Aug 04, 2010 13:23
What kind of ID is it you get then (I thought it was the guid)? Can you post the full message?
Aug 04, 2010 14:17
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)
Aug 04, 2010 14:26
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 :)
Aug 04, 2010 14:54
I get "Object reference is not set to an instance...." when I try to do that... :/
Aug 04, 2010 15:26
Weird, that seems to indicate that it is already removed (CreateInstance returns null). I have no further suggestions then.
Aug 05, 2010 10:51
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.
Aug 05, 2010 10:56
I gave up and upgraded the site last night and everything is "fine and dandy". :)
Thanks for your effort! Appreciate it!
Aug 05, 2010 11:01
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.