No Data from publish ADO.net Data Service

5 posts, 0 answers
  1. Nick Wood
    Nick Wood avatar
    126 posts
    Member since:
    Feb 2010

    Posted 14 Mar 2010 Link to this post

    Requirements

    RadControls version

    2010
    .NET version

    3.5 sp1
    Visual Studio version

    2008
    programming language

    c#
    browser support

    all browsers supported by RadControls


    PROJECT DESCRIPTION
    Have been using the data services wizard with a Telerik ORM DAL library and its working well in my local environment. I have managed to host the service on our webserver, but when I connect to the end point I dont get any of the object listed.

    Here is a copy of the xml I get from the hosted version:
    <service xml:base="http://pmsdash.apn.au/DataService/PMSDSR1.svc/"
    − 
    <workspace> 
    <atom:title>Default</atom:title> 
    </workspace> 
    </service> 

    Here is what I get from the same service but hosted localhost:
    <service xml:base="http://localhost:62037/PMSDSR1.svc/"
    − 
    <workspace> 
    <atom:title>Default</atom:title> 
    − 
    <collection href="TblDepartments"
    <atom:title>TblDepartments</atom:title> 
    </collection> 
    − 
    <collection href="TblEmployees"
    <atom:title>TblEmployees</atom:title> 
    </collection> 
    − 
    <collection href="TblFlatDataCaptureProductProcesses"
    <atom:title>TblFlatDataCaptureProductProcesses</atom:title> 
    </collection> 
    − 
    <collection href="TblFlatLiveScheduleProductProcesses"
    <atom:title>TblFlatLiveScheduleProductProcesses</atom:title> 
    </collection> 
    − 
    <collection href="TblFlatLiveScheduleProductProcessActuals"
    <atom:title>TblFlatLiveScheduleProductProcessActuals</atom:title> 
    </collection> 
    − 
    <collection href="TblLiveScheduleProductsProcesses"
    <atom:title>TblLiveScheduleProductsProcesses</atom:title> 
    </collection> 
    − 
    <collection href="TblPrintSites"
    <atom:title>TblPrintSites</atom:title> 
    </collection> 
    − 
    <collection href="TblStartDates"
    <atom:title>TblStartDates</atom:title> 
    </collection> 
    − 
    <collection href="TblUsers"
    <atom:title>TblUsers</atom:title> 
    </collection> 
    </workspace> 
    </service> 

    I am not getting any errors and even the service log file shows no errors. Below is the web.config file:
    <?xml version="1.0"?> 
     
    <configuration> 
     
     
        <configSections> 
          <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"
            <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"
              <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/> 
              <sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"
                <section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere" /> 
                <section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" /> 
                <section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" /> 
                <section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" /> 
              </sectionGroup> 
            </sectionGroup> 
          </sectionGroup> 
        </configSections>   
     
       
        <appSettings/> 
        <connectionStrings/> 
       
        <system.web> 
            <!--  
                Set compilation debug="true" to insert debugging  
                symbols into the compiled page. Because this  
                affects performance, set this value to true only  
                during development. 
            --> 
            <compilation debug="false"
     
              <assemblies> 
                <add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/> 
                <add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/> 
                <add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> 
                <add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/> 
              </assemblies> 
     
            </compilation> 
            <!-- 
                The <authentication> section enables configuration  
                of the security authentication mode used by  
                ASP.NET to identify an incoming user.  
            --> 
            <authentication mode="Windows" /> 
            <!-- 
                The <customErrors> section enables configuration  
                of what to do if/when an unhandled error occurs  
                during the execution of a request. Specifically,  
                it enables developers to configure html error pages  
                to be displayed in place of a error stack trace. 
     
            <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm"
                <error statusCode="403" redirect="NoAccess.htm" /> 
                <error statusCode="404" redirect="FileNotFound.htm" /> 
            </customErrors> 
            --> 
     
          <pages> 
            <controls> 
              <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> 
              <add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> 
            </controls> 
          </pages> 
     
          <httpHandlers> 
            <remove verb="*" path="*.asmx"/> 
            <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> 
            <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> 
            <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/> 
          </httpHandlers> 
          <httpModules> 
            <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> 
          </httpModules> 
     
        </system.web> 
     
        <system.codedom> 
          <compilers> 
            <compiler language="c#;cs;csharp" extension=".cs" warningLevel="4" 
                      type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
              <providerOption name="CompilerVersion" value="v3.5"/> 
              <providerOption name="WarnAsError" value="false"/> 
            </compiler> 
         </compilers> 
        </system.codedom> 
         
        <!--  
            The system.webServer section is required for running ASP.NET AJAX under Internet 
            Information Services 7.0.  It is not necessary for previous version of IIS. 
        --> 
        <system.webServer> 
          <validation validateIntegratedModeConfiguration="false"/> 
          <modules> 
            <remove name="ScriptModule" /> 
            <add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> 
          </modules> 
          <handlers> 
            <remove name="WebServiceHandlerFactory-Integrated"/> 
            <remove name="ScriptHandlerFactory" /> 
            <remove name="ScriptHandlerFactoryAppServices" /> 
            <remove name="ScriptResource" /> 
            <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" 
                 type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> 
            <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" 
                 type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> 
            <add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" /> 
          </handlers> 
        </system.webServer> 
     
        <runtime> 
          <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"
            <dependentAssembly> 
              <assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/> 
              <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/> 
            </dependentAssembly> 
            <dependentAssembly> 
              <assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/> 
              <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/> 
            </dependentAssembly> 
          </assemblyBinding> 
        </runtime> 
    <system.serviceModel> 
        <serviceHostingEnvironment aspNetCompatibilityEnabled="true">   
        <baseAddressPrefixFilters>  
        <add prefix="http://pmsdash.apn.au/DataService"/>   
        </baseAddressPrefixFilters>  
        </serviceHostingEnvironment>  
    </system.serviceModel> 
    <system.diagnostics> 
    <trace autoflush="true" /> 
    <sources> 
    <source name="System.ServiceModel" switchValue="Information, ActivityTracing" propagateActivity="true"
    <listeners> 
    <add name="sdt" type="System.Diagnostics.XmlWriterTraceListener" initializeData="wcfTrace2.svclog" /> 
    </listeners> 
    </source> 
    </sources> 
    </system.diagnostics> 
    </configuration> 
     

    I am not even sure where to start looking as nothing seems to be wrong.

    Any help would be fantastic.

    Nick



  2. jon
    jon avatar
    33 posts
    Member since:
    Dec 2008

    Posted 13 Aug 2010 Link to this post

    We are having this same trouble here.
    I am using the lastest version of the RadGrid with OpenAccess, and it works fine locally, but when I moved the websites to our test server, ASPX pages load, but any page that uses OpenAccess returns a 404 error.  The 404 error is very odd, it seems you could somehow throw a more helpful message.  And this website on our Test server worked fine when I was using the Q1 version of OpenAccess, so the upgraded seems to have broken it.

    I searched the Telerik support forums a lot for combinations of "OpenAccess" "404" and "deployment" and have not found a solution. 

    Might it be a missing DLL?  I tried moving up all of the possible DLLs including the new "Microsoft.Data.Services.Client.dll" but that does not fix it.  Please advise what I might have done wrong when deploying. 

    Thanks.
  3. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 18 Aug 2010 Link to this post

    Hello jon,

    It seems that the error appears because of an incorrect endpoint specified within the web.config file. Please check the endpoint’s address under the system.serviceModel | services section from the deployed application’s configuration file.
    Hope that helps.


    Kind regards,
    Damyan Bogoev
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  4. jon
    jon avatar
    33 posts
    Member since:
    Dec 2008

    Posted 18 Aug 2010 Link to this post

    The source of the problem ended up being this missing DLL from our TEST server:
    Telerik.OpenAccess.Adonet2.dll

    FYI, The 404 error in this scenario is odd and with no error message, time-consuming to track down.
  5. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 20 Aug 2010 Link to this post

    Hi jon,

    We are happy to see that you managed to resolve the problem.
    In fact, this is the list with Telerik OpenAccess dlls that should be deployed in a website scenario:

    - Telerik.OpenAccess.35.Extensions.dll;
    - Telerik.OpenAccess.Adonet2.dll;
    - Telerik.OpenAccess.Config.dll;
    - Telerik.OpenAccess.dll;
    - Telerik.OpenAccess.Runtime.dll;
    - Telerik.OpenAccess.Web.dll(if you use the OpenAccessDataSource);

    If any other problems arise please contact us back.


    All the best,
    Damyan Bogoev
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Back to Top