Telerik Code Library / Data Access Code Library / General and Integration Projects /

No Data from publish ADO.net Data Service

Data Access
Resources Buy Try

Thread is closed for posting

5 posts, 0 answers

D94D2A0F-A5C0-40C5-90FE-AE4FE97F55CE

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

4F1F040D-FCD8-4B04-8102-552AC1A4B288

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.
DF306142-48B5-44E4-8E2D-C52759157F15

581 posts

Member since:
Mar 2017

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
4F1F040D-FCD8-4B04-8102-552AC1A4B288

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.
DF306142-48B5-44E4-8E2D-C52759157F15

581 posts

Member since:
Mar 2017

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

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

No Data from publish ADO.net Data Service

D94D2A0F-A5C0-40C5-90FE-AE4FE97F55CE

4F1F040D-FCD8-4B04-8102-552AC1A4B288

DF306142-48B5-44E4-8E2D-C52759157F15

4F1F040D-FCD8-4B04-8102-552AC1A4B288

DF306142-48B5-44E4-8E2D-C52759157F15