Issue while connecting to Sharepoint

Home Page Forums BizTalk 2004 – BizTalk 2010 Issue while connecting to Sharepoint

Viewing 2 reply threads
  • Author
    Posts
    • #19176

      I have sharepoint configured on one machine and biztalk on another machine. I am just trying the walkthrough in MSDN to send an xml file from one sharepoint document library to another sharepoint document library using biztalk. I am getting the below exception the moment I Enabled Receive location which is trying to read file from one of sharepoint document libraries.

      Client found response content type of ‘text/html; charset=utf-8’, but expected ‘text/xml’

      Can any one please help me to resolve this?

    • #19178

      Sounds like there’s an error in the SP config you are listening for…check Event Viewer and if you can, please post the entire error kicked out and that should give you some idea of what BizTalk is seeing.

      -Rich

      • #19198

        Thanks Rich, Please go through the below exception 

        The adapter “Windows SharePoint Services” raised an error message. Details “Client found response content type of ‘text/html; charset=utf-8’, but expected ‘text/xml’.

        The request failed with the error message:

        <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=VhAxGc3rkK79RM90tibDzw%%3D%%3D”></script>

        <script type=”text/javascript” language=”javascript” src=”/_layouts/1033/core.js?rev=F8pbQQxa4zefcW%%2BW9E5g8w%%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=”../_layouts/error.aspx” id=”aspnetForm” onsubmit=”return _spFormOnSubmitWrapper();”>

        <div>

        <input type=”hidden” name=”__VIEWSTATE” id=”__VIEWSTATE” value=”/wEPDwUKLTU2NjkxODU3M2RkY8kbpcGzP+znD+PdUl3eKk+uGzI=” />

        </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”>

         <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://usdevspps01&#8243; 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%”>

         

         

         

         

         

         

         

        </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”>The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators.</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>

    • #19200

      So out of that mess, here’s the root error:

      The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators.

      You’ll want to go into your admin console and work some magic there…here’s a post from MS on the error that may get you started in the right direction:
      http://support.microsoft.com/kb/920785.

      I ran into this before and I had set the Office Integration drop down to InfoPath….should have been set to None.

      Good luck, and let us know if you still run into issues, I’ll still help where I can.

      -Rich

      • #19201

        Rich,

         I have Office Integration dropdown option configured set to “No” while configuring Receive location, send port and I have verified that the document I am trying to retrieve is not there in blocked file types list but still I am getting this exception.

         Is there any other issue which may cause this exception?

         Thanks

        • #19202

          Another area you should check is the configuration of the source and destination Document Libraries…make sure that the “Document Template” drop-downs are also set to ‘none’.

          -Rich

          • #19206

            Rich,

            I found the problem and it is that I am working with “WSS adapter Web Service” installed on biztalk machine but which should have been done on machine where WSS is installed. Now I installed that adapter on WSS machine and it is working fine now.

             Thanks for all your help.

             

            • #19207

              Oops…that will do it!  Guess we should have started with the requirements first.  Well I’m glad that you found it, good deal and have fun!  You’re welcome as well!

              -Rich

              • #23206

                I had installed WSS & Biztalk in same machine.

                iam 🙁 getting error as follows.

                The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators

                Please help me out of this errors

                • #25018

                  steps to send file on sharepoint site from Biztalk Server 2006 R2 output using Windows sharepoint service Adapter

                  –> configure biztalk server with sharepoint adapter from biztalk server configuration.

                  –> in Biztalk server Configuration Select Sharepoint Adapter and Select the default website on which adapter should be installed. this will be the only site where msgs will be transferred. I have added it on Sharepoint Central Administration.

                  –> After completing confuguration of sharepoint adapter copy folder BTSharePointAdapterWS from the path C:\Program Files\Microsoft BizTalk Server 2006\Business Activity Services to the folder in IIS for Central administrator websites in where the sharepoint adapter has been installed paste there. here i had paste it at SharePoint Central Administrator v3 website.

                  –> Now create a pool via right clicking –> Properties –> Virtual Directory –> Create and select adapter as an application pool.

                  –> now give create a document library with full control permission to all the users so that  any error cant occure. and create it.

                  –> in biztalk select message type in send port select windows sharepoint service instead of FILE. and click on configure.

                  –> now provide sharepoint document library folder name and url and other things are not mendatory. give port number as same as in the site-URL is given.

                  –> save the configuration and start the applicaton. move the file on Receive location and get the result on Sharepoint document library.

                  if this is the answer then plz let me know.

                   

                   

                  -Mansuri Mohammedisteyaq ([email protected])

Viewing 2 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.