The server method...failed. SPRadGridDesigner Data binding

23 posts, 0 answers
  1. Dave
    Dave avatar
    29 posts
    Member since:
    Aug 2010

    Posted 24 Jul 2013 Link to this post

    I am have been unable to set up data binding for a SPRadGrid Web Part on a SharePoint 2013 site.  After adding the Web Part, I open 'SPRadGrid Designer'.  The upper treeview shows TelerikSPRadGrid1>MasterTable.  In the lowertree view, MasterTable offers General Settings and Data Binding.  General Settings are all selected.  Under databinding>SQL is SQL Server Instances.  When I click to expand the node, it tells me "the server method 'GetData' failed".  The Excel tab is blank.  Under SharePoint lists, attempting to expand the node (SP Lists) returns the similar error "the server method 'GetSPListData' failed.  

    I suspect there is a rather simple explanation for why I cannot bind to data, but I am lost.  Anyone assist?  

  2. Tsvetoslav
    Admin
    Tsvetoslav avatar
    1823 posts

    Posted 29 Jul 2013 Link to this post

    Hello Dave,

    Could you open IIS, expand the node of your SharePoint application web site,then the _vti_bin folder and see if Anonymous Authentication is enabled for the Telerik.Ajax.SharePoint that's inside the latter.
     
    Regards,
    Tsvetoslav
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.

  3. Vamsi
    Vamsi avatar
    3 posts
    Member since:
    Mar 2012

    Posted 06 Sep 2013 Link to this post

    I am having the same issue and Anonymous authentication is enabled in IIS web application for Telerik.Ajax.SharePoint inside _vti_bin folder. Please advise. Its happening on SharePoint 2013 environment. This is the first time we are using Telerik in SharePoint.
  4. Tsvetoslav
    Admin
    Tsvetoslav avatar
    1823 posts

    Posted 09 Sep 2013 Link to this post

    Hi Vamsi,

    Does disabling forms authentication make any difference?
     
    Regards,
    Tsvetoslav
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  5. Vamsi
    Vamsi avatar
    3 posts
    Member since:
    Mar 2012

    Posted 09 Sep 2013 Link to this post

    Its not allowing me to disable Forms Based Authentication from IIS web application for Telerik.Ajax.SharePoint inside _vti_bin folder. How do I disable it. Should I make a change on web.config.
  6. Vamsi
    Vamsi avatar
    3 posts
    Member since:
    Mar 2012

    Posted 09 Sep 2013 Link to this post

    Hi Tsvetoslav ,

    I am getting ‘Cannot import webpart’ error when trying to add Telerik SPRad Grid Webpart in one of my other sites. I checked the log and this is the error message I see:

     

    “8l4f       Monitorable       Error importing WebPart. Assembly       Telerik.Ajax.SharePoint,      Version=2013.2.612.45, Culture=neutral,      PublicKeyToken=aa9e5f693af67c7b    , TypeName. Telerik.Ajax.SharePoint.TelerikSPRadGridWebPart. Cannot import this Web Part.”

     

    If you look at the version, it says 2013.2.612.45. It should have been 2013.2.717.45. Could you please let me know why this is happening.

    Thanks,
    Vamsi
  7. Tsvetoslav
    Admin
    Tsvetoslav avatar
    1823 posts

    Posted 12 Sep 2013 Link to this post

    Hello Dave,

    Please, try uninstalling the telerik controls for sharepoint on that site, remove any telerik dlls from the GAC and bin folder of the SP application and reinstall the package. 
     
    Regards,
    Tsvetoslav
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  8. Ilya
    Ilya avatar
    1 posts
    Member since:
    Sep 2013

    Posted 24 Sep 2013 Link to this post

    Hi,
    I have the same problem.
    I installed SPRagGrid and when i open the Designer, i receive this message.

    If i user WebPart - edit webpart, the grid doesnot show any rows, when i connect it to some list.

    Additional question, Do you have any log, where i check my problems?
  9. Tsvetoslav
    Admin
    Tsvetoslav avatar
    1823 posts

    Posted 25 Sep 2013 Link to this post

    Hi Ilya,

    Our development team further investigated the issue and it proved to be an error in the build scripts for the installer. It is expected to be fixed for the official release that's coming out very soon - around the middle of October. Meanwhile, please, open the

    SPRadGridWebPartDesignerService.asmx

    file that should be looked under:
    Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\ISAPI\Telerik.Ajax.SharePoint

    and change its version number to the version number of the Telerik.Ajax.SharePoint.dll that's in your GAC.

    It should be: 2013.2.717.45
     
    Regards,
    Tsvetoslav
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  10. BoGreece
    BoGreece avatar
    8 posts
    Member since:
    May 2007

    Posted 24 Oct 2013 Link to this post

    I have the same problem - the server method getsplistdata failed.
    I've done the authentication (proposed at Posted on Jul 29, 2013 )but with no luck.
    I've included the prinscreen.
    I've downloaded yesterday.
  11. Marin
    Admin
    Marin avatar
    1045 posts

    Posted 29 Oct 2013 Link to this post

    Hello,

     Please verify that you are using and referencing the latest version of the assemblies everywhere in the project (in GAC, Bin folder, and web.config should point to the same version). The issue with the designer should have been fixed in the latest version.

    Kind Regards,
    Marin
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  12. Elizabeth
    Elizabeth avatar
    1 posts
    Member since:
    Nov 2013

    Posted 21 Nov 2013 Link to this post

    I am now having the exact same issue in SP2010.

    I have tried all suggested remedies in this thread and nothing has fixed it. I am running version 2013.3.1114.35.

    Are there any other options?
  13. Centaur
    Centaur avatar
    1 posts
    Member since:
    Feb 2013

    Posted 25 Nov 2013 Link to this post

    Hello,

    Iam having the same problem on Sharepoint Server 2010, tried all the above but nothing worked. The two issues Iam having are:

    1. In General Settings (SPRadGrid Designed - MasterTable), 5 out of 9 options are disabled, I cannot check/uncheck, they are selected (Enable Insert, Enable Update, Enable Delete, Enable Client Row Selection, Enable Columns Reorder).
    2. By select Data Binding - SharePoint Lists, on trying to expand SP Lists I also get the message "The served method 'GetSPListData' failed".

    Will this problem be fixed? Would like to know if there is anything else I can try for it to work, or try another solution.

    Thank you.
  14. Marin
    Admin
    Marin avatar
    1045 posts

    Posted 25 Nov 2013 Link to this post

    Hello,

    We are aware of the problem, it has been forwarded to our development team and we will try to resolve it as soon as possible.

    Kind Regards,
    Marin
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  15. Charles
    Charles avatar
    2 posts
    Member since:
    May 2012

    Posted 29 Nov 2013 Link to this post

    Hi,

    I have had the same problem although I am using the latest build. I have tried all the tricks suggested but have not succeed.
  16. Marin
    Admin
    Marin avatar
    1045 posts

    Posted 02 Dec 2013 Link to this post

    Hello,

    The issue has been logged here:
    http://feedback.telerik.com/Project/108/Feedback/Details/66612-spradgridwebpart-desginer-does-work-correctly-in-some-cases
    We will try to resolve for future versions of the controls. Meanwhile you have use the default editor of the web part to databind and configure it.

    Regards,
    Marin
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  17. Marin
    Admin
    Marin avatar
    1045 posts

    Posted 14 Dec 2013 Link to this post

    Hi,

    A temporary workaround about the problem with the SPRadGridDesigner can also be applied in the following way:
    open the ISAPI folder of the 15 hive of your SharePoint installation - it is located at:
    ...Program Files\Common Files\microsoft shared\Web Server Extensions\15\ISAPI
    and edit the SPRadGridWebPartDesignerService.asmx file changing the version number within to be the same the version of the Telerik.Web.UI you are referencing everywhere else (e.g. 2013.3.1114.35 - for the latest version)
    An official fix will be available in the next service pack of the controls.

    Kind Regards,
    Marin
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  18. Sambathraj
    Sambathraj avatar
    16 posts
    Member since:
    Jan 2011

    Posted 16 Dec 2013 Link to this post

    Thanks for posting this workaround. It worked. When I try to connect to the SQL Instance, it gives me Login Failed error. What is the correct way to configure the SQL Instance?
  19. Marin
    Admin
    Marin avatar
    1045 posts

    Posted 17 Dec 2013 Link to this post

    Hello,

    This is a general SQL error and no specific configuration in the Sharepoint environment is required. Make sure your login credentials are valid in the current SQL instance and whether Windows Authentication is enabled on the SQL server if necessary.

    Regards,
    Marin
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  20. Sambathraj
    Sambathraj avatar
    16 posts
    Member since:
    Jan 2011

    Posted 17 Dec 2013 Link to this post

    I am sysadmin on the SQL Server and have full access. I am using windows authentication in the SQL server. I am still getting this error.

    Thanks,

    Sambath

  21. Marin
    Admin
    Marin avatar
    1045 posts

    Posted 18 Dec 2013 Link to this post

    Hi,

    You can check in the error logs (for SQL or Sharepoint) what credentials exactly are used when the error happens and then try to log in with them through the SQL management studio to verify they work as expected.
    Additionally please verify that you have anonymous authentication enabled in the vti_bin folder in the IIS Sharepoint application (Sharepoint-80).
    You should also have administrator rights in the current site collection in Sharepoint when configuring the web part.

    Regards,
    Marin
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  22. Charles
    Charles avatar
    2 posts
    Member since:
    May 2012

    Posted 18 Dec 2013 Link to this post

    Thanks for this. It does work. However, wouldn't be nice if one can have the ability of binding to an SQL Server View?  Your thoughts please.
  23. Marin
    Admin
    Marin avatar
    1045 posts

    Posted 18 Dec 2013 Link to this post

    Hi,

    Indeed it seems like a nice suggestion although CRUD operations in the control in this case might present some challenges since not all SQL Views are updateable by default.
    You can also suggest new features and improvements in our feedback portal: http://feedback.telerik.com/Project/108

    Regards,
    Marin
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Back to Top