locked
After restoring SharePoint Content Database, Infopath forms got corrupted RRS feed

  • Question

  • My client recently decided to reinstall their Sharepoint Server. This was during the weekends so I didn't have enough time to properly back-up their data. What I did was just copy the physical and log files of the content databases of their web applications. Then with the newly installed MOSS 2007, I created new web applications then added the content databases of the previous installation. I successfully restored the web applications. Most of the libraries in these web applications uses infopath forms. One of the libraries got it's infopath forms corrupted. All the xml files were replaced by this code:

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------
    <HTML dir="ltr">
    <HEAD><meta name="GENERATOR" content="Microsoft SharePoint" /><meta name="progid" content="SharePoint.WebPartPage.Document" /><meta HTTP-EQUIV="Content-Type" content="text/html; charset=utf-8" /><meta HTTP-EQUIV="Expires" content="0" /><meta name="ROBOTS" content="NOHTMLINDEX" /><title>
     
     Error

    </title><link rel="stylesheet" type="text/css" href="/_layouts/1033/styles/core.css?rev=5msmprmeONfN6lJ3wtbAlA%3D%3D"/>
    <script type="text/javascript" language="javascript" src="/_layouts/1033/init.js?rev=yOq8IoAABYCtaZjMVrjxtg%3D%3D"></script>
    <script type="text/javascript" language="javascript" src="/_layouts/1033/core.js?rev=XtdKG9EwDUHSo03sNRdLzQ%3D%3D"></script>

     <meta name="Robots" content="NOINDEX " />
     <meta name="SharePointError" content=""/>
    </HEAD>
    <BODY scroll="yes" onload="javascript:if (typeof(_spBodyOnLoadWrapper) != 'undefined') _spBodyOnLoadWrapper();">
      <form name="aspnetForm" method="post" action="error.aspx?SourceUrl=%2fTravel+Request%2fTRA-01461.xml&amp;Source=http%3a%2f%2fphkmnlsrv610%3a5550%2fTravel%2520Request%2fForms%2fAllItems.aspx&amp;FldUrl=" id="aspnetForm" onsubmit="return _spFormOnSubmitWrapper();">
    <div>
    <input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUKLTU2NjkxODU3M2Rk6PzaNZxI1OwaaXH569wVhAXFaUM=" />
    </div>

      <TABLE class="ms-main" CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH="100%" HEIGHT="100%">
     <tr><td>
        <table CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH="100%">
      <tr>
       <td colspan=4 class="ms-globalbreadcrumb" align="right">
         &nbsp;<a href="javascript:TopHelpButtonClick('NavBarHelpHome')" id="ctl00_PlaceHolderGlobalNavigation_TopHelpLink" AccessKey="6" title="Help (new window)"><img src="/_layouts/images/helpicon.gif" align="absmiddle" border="0" alt="Help (new window)" /></a>
       </td>
      </tr>
        </table>
       </td></tr>
     <tr>
      <td class="ms-globalTitleArea">
       <table width=100% cellpadding=0 cellspacing=0 border=0>
        <tr>
      <td id="GlobalTitleAreaImage" class="ms-titleimagearea"><img id="onetidHeadbnnr0" src="/_layouts/images/titlegraphic.gif"  alt="" /></td>
      <td class="ms-sitetitle" width=100%>
       
       
      </td>
      <td style="padding-top:8px;" valign=top>
       
       
      </td>
        </tr>
       </table>
      </td>
     </tr>
     <TR>
      <TD id="onetIdTopNavBarContainer" WIDTH=100% class="ms-bannerContainer">
     
     
      </TD>
     </TR>
     
     

     
     
     
     <TR height="100%"><TD><TABLE width="100%" height="100%" cellspacing="0" cellpadding="0">
     <tr>
      <td class="ms-titlearealeft" id="TitleAreaImageCell" valign="middle" nowrap><div style="height:100%" class="ms-titleareaframe"></div></td>
      <td class="ms-titleareaframe" id="TitleAreaFrameClass">
      
      <table cellpadding=0 height=100% width=100% cellspacing=0>
       <tr><td class="ms-areaseparatorleft"><IMG SRC="/_layouts/images/blank.gif" width=1 height=1 alt=""></td></tr>
      </table>
      
      </td>
      <td valign=top  id="onetidPageTitleAreaFrame" class='ms-areaseparator' nowrap width="100%">
       <table id="onetidPageTitleAreaTable" cellpadding=0 cellspacing=0 width=100% border="0">
        <tr>
      <td valign="top" class="ms-titlearea">
      
        <a href=http://serverURL id="ctl00_PlaceHolderTitleBreadcrumb_idSimpleGoBackToHome">Go back to site</a>
      
      </td>
        </tr>
        <tr>
      <td height=100% valign=top ID=onetidPageTitle class="ms-pagetitle">
        <h2 class="ms-pagetitle">
      
     Error

        </h2>
      </td>
        </tr>
       </table>
      </td>
      <td class="ms-titlearearight">
     
     
    <div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div>
    </td>
     </tr>

     <TR>
       <TD class="ms-leftareacell" valign=top height=100% id="LeftNavigationAreaCell">
        <table class=ms-nav width=100% height=100% cellpadding=0 cellspacing=0>
      <tr>
       <td>
        <TABLE height="100%" class=ms-navframe CELLPADDING=0 CELLSPACING=0 border="0">
         <tr valign="top">
       <td width="4px"><IMG SRC="/_layouts/images/blank.gif" width=4 height=1 alt=""></td>
       <td valign="top" width="100%">
        
        
        
        
        &nbsp;
        
        
       </td>
         </tr>
         <tr><td colspan=2><IMG SRC="/_layouts/images/blank.gif" width=138 height=1 alt=""></td></tr>
        </TABLE>
       </td>
       <td></td>
      </tr>
        </table>
       </TD>
       <td>
    <div class='ms-areaseparatorleft'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div>
    </td>
       <td class='ms-formareaframe' valign="top">
      <TABLE width="100%" border="0" cellspacing="0" cellpadding="0" class="ms-propertysheet">
       <TR valign="top"  >
       <TD class="ms-descriptiontext" width="100%">
        
       </TD>
          <TD ID=onetidYPadding width="10px"><IMG SRC="/_layouts/images/blank.gif" width=10 height=1 alt=""></TD>
        </TR>
        <TR >
       <TD ID=onetidMainBodyPadding height="8px"><IMG SRC="/_layouts/images/blank.gif" width=1 height=8 alt=""></TD>
        </TR>
        <tr>
        <td valign="top" height="100%">
          <A name="mainContent"></A>
       
     <table width=100% border=0 class="ms-titleareaframe" cellpadding=0>
     <TR>
     <TD valign=top width="100%" style="padding-top: 10px" class="ms-descriptiontext">
        <span id="ctl00_PlaceHolderMain_LabelMessage">Specified argument was out of the range of valid values. <br>Parameter name: offset&nbsp;&nbsp; at System.Web.HttpResponseStream.Write(Byte[] buffer, Int32 offset, Int32 count) <br>&nbsp;&nbsp;&nbsp;at System.Web.HttpResponse.BinaryWrite(Byte[] buffer) <br>&nbsp;&nbsp;&nbsp;at Microsoft.SharePoint.ApplicationPages.Download.WriteFile(String sourceUrl) <br>&nbsp;&nbsp;&nbsp;at Microsoft.SharePoint.ApplicationPages.Download.OnLoad(EventArgs e) <br>&nbsp;&nbsp;&nbsp;at System.Web.UI.Control.LoadRecursive() <br>&nbsp;&nbsp;&nbsp;at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)</span>
        <P><span class="ms-descriptiontext">
      <span id="ctl00_PlaceHolderMain_helptopic_troubleshooting"><A Title="Troubleshoot issues with Windows SharePoint Services. - Opens in new window" HREF="javascript:HelpWindowKey('troubleshooting')">Troubleshoot issues with Windows SharePoint Services.</A></span>
     
      </span>
     </TD>
     </TR>
     </table>
    <script type="text/javascript" language="JavaScript">
      var gearPage = document.getElementById('GearPage');
      if(null != gearPage)
      {
       gearPage.parentNode.removeChild(gearPage);
       document.title = "Error";
      }
    </script>

        </td>
        </tr>
      </table>
       </td>
       <td class="ms-rightareacell">
    <div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div>
    </td>
     </TR>
    <tr>
     <td class="ms-pagebottommarginleft"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
     <td class="ms-pagebottommargin"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
     <td class="ms-bodyareapagemargin"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
     <td class="ms-pagebottommarginright"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
    </tr>
     </TABLE></TD></TR>
      </TABLE>
     
     
       <input type="text" name="__spDummyText1" style="display:none;" size=1/>
       <input type="text" name="__spDummyText2" style="display:none;" size=1/>
     
    </form>
     
    </BODY>
    </HTML>
    --------------------------------------------------------------------------------------------------------------------------------------------------------------

    I already tried opening the forms on SharePoint designer but when I open the forms its just blank. Downloading and opening it with an Infopath client doesn't work either. Please help me because this is already on live production and they are already down for three days.

    Thanks much!


    The impossibility of doing things depends on your will to do it.
    Wednesday, February 23, 2011 2:03 AM

All replies

  • Hi Tim,

    Have you tried to create a new page in SharePoint designer and paste this code to the page?
    Is it possible a web page convert from InfoPath form?

    If the forms were corrupted, could you be able to get the old database server and attach to the new MOSS site to get the forms back?

    Best regards,
    Emir

    Thursday, February 24, 2011 12:10 PM
  • Emir,

    I haven't tried creating a new page but when I try opening it on a browser, It returns  an error message.

    The XML page cannot be displayed

    Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.


    A string literal was expected, but no opening quote character was found. Error processing resource 'file:///C:/Users/tmislo...

     <TABLE class="ms-main" CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH="100%" HEIGHT="100%">
    ---------------------------...

     

    I already attached the content database to a new website. The weird thing is this happened only to one library in one web application. I cannot retrieve the infopath forms using SharePoint API nor with SPD.

    I downloaded a SharePoint extractor on  this link: http://blog.dreamdevil.com/index.php/2007/03/13/sharepoint_2003_database_exporter/
    and i was able to extract all the infopath forms i need. But when I go back to the site, the xml is still the one I posted above.


    The impossibility of doing things depends on your will to do it.
    Thursday, February 24, 2011 12:28 PM