Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Horst Sterr 171 posts 133 karma points
    Nov 05, 2009 @ 18:58
    Horst Sterr
    0

    migration from vistadb to sqlserver ALMOST successful - one problem left

    General

    Hi,
    we achieved to import vistadb data into a clean umbraco sql server db.
    Though it was a lot of work to alter some script parts to do this it finally worked.

    Everything is possible to do (alter/create doctypes, mediatypes, nodes etc).

    The only thing what goes wrong is that if i use "Republish entire site" the "umbraco.config" file in the data folder gets deleted and not rewritten/updated again.
    Checked folder permissions - everything perfect.

    If i switch back to vistdb "Republish entire site" works and "umbraco.config" gets updated.
    Is there a hidden switch in the sql server database or somewhere in some umbraco config file?

    thank you for any hints
    /horst

     

    Copy Link
  • Immo Wache 69 posts 224 karma points
    Nov 05, 2009 @ 20:51
    Immo Wache
    0

    Hi Horst,

    only one idea to this: may it be you have any data content in your documents which break XML e.g. '<' or '![CDATA[' or something like this?

    This could produce an internal exception while generation of "umbraco.config". Take a look into your table "umbracoLog". Some exceptions are logged there, with a little luck you get an hint in column logComment.

    HTH, Immo

    Copy Link
  • Horst Sterr 171 posts 133 karma points
    Nov 09, 2009 @ 16:25
    Horst Sterr
    0

    i have the following entries in the logTable

    Error Republishing: System.Xml.XmlException: There is an unclosed literal string. Line 53, position 796.
       at System.Xml.XmlTextReaderImpl.Throw(Exception e)
       at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
       at System.Xml.XmlTextReaderImpl.ParseAttributeValueSlow(Int32 curPos, Char quoteChar, NodeData attr)
       at System.Xml.XmlTextReaderImpl.ParseAttributes()
       at System.Xml.XmlTextReaderImpl.ParseElement()
       at System.Xml.XmlTextReaderImpl.ParseElementContent()
       at System.Xml.XmlTextReaderImpl.Read()
       at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)
       at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
       at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
       at System.Xml.XmlDocument.Load(XmlReader reader)
       at System.Xml.XmlDocument.LoadXml(String xml)
       at umbraco.content.LoadContentFromDatabase()
       Xml wasn't saved: System.Xml.XmlException: Invalid XML document, The document does not have a root element..
       at System.Xml.XmlDocument.Save(String filename)
       at umbraco.content.SaveContentToDisk(XmlDocument xmlDoc)

    Hm, really no idea whts missing or going wrong

    happy for any idea fixing this
    thank you
    /horst

    Copy Link

  • Comment author was deleted

    Nov 09, 2009 @ 16:42

    If you publish all pages (right click level 1 node, publish, include children). Does that fix it ?

    Copy Link
  • Horst Sterr 171 posts 133 karma points
    Nov 09, 2009 @ 18:30
    Horst Sterr
    0

    Hi Tim,
    looks like yout tipp fixed the problem.
    Deleted all content ot the "cmsContentXML" table in the database and published like you proposed.

    Hope this was was the last hurdle to take during the migration process.

    thank you
    /horst

    Copy Link

  • Comment author was deleted

    Nov 09, 2009 @ 18:59

    Super! would be great if you could share the vistadb to sql server migration process

    Copy Link
  • Horst Sterr 171 posts 133 karma points
    Nov 09, 2009 @ 21:14
    Horst Sterr
    0

    yes, try to write a small "how to" soon.

    There where a lot of impassibilies.
    But for sure it was very different than "out of the box"

    /horst

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft